Introduction
This Post illustrates the steps required to Create Project party in oracle projects accounting using the API PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY in oracle EBS.
Script
DECLARE
l_project_id_prem pa_project_parties.project_id%TYPE := NULL;
l_project_role VARCHAR2 (240) := NULL;
l_resource_name per_all_people_f.full_name%TYPE := NULL;
l_start_date_active DATE := NULL;
l_end_date_active DATE := NULL;
l_project_role_id pa_project_role_types.project_role_id%TYPE
:= NULL;
l_project_role_type pa_project_role_types.project_role_type%TYPE
:= NULL;
l_resource_source_id pa_project_parties.resource_source_id%TYPE
:= NULL;
l_project_party_id pa_project_parties.project_party_id%TYPE := NULL;
l_object_id pa_project_parties.object_id%TYPE := NULL;
l_resource_id pa_project_parties.resource_id%TYPE := NULL;
l_record_version_number pa_project_parties.record_version_number%TYPE
:= NULL;
l_project_end_date DATE;
l_return_status VARCHAR2 (20) := NULL;
l_assignment_id NUMBER := NULL;
l_wf_type VARCHAR2 (240) := NULL;
l_wf_item_type VARCHAR2 (240) := NULL;
l_wf_process VARCHAR2 (240) := NULL;
l_msg_count NUMBER := NULL;
l_msg_data VARCHAR2 (240) := NULL;
BEGIN
mo_globa.set_policy_context (‘S’, 204);
—Input Parameters—-
l_project_id_prem := ‘3631’;
l_project_role := ‘Project Manager’;
l_resource_name := ‘Holt, Mr. Henry’;
l_start_date_active := ’01-NOV-2007′;
l_end_date_active := ’31-DEC-2007′;
SELECT project_role_id, project_role_type
INTO l_project_role_id, l_project_role_type
FROM pa_project_role_types
WHERE UPPER (meaning) = UPPER (l_project_role);
SELECT DISTINCT person_id
INTO l_resource_source_id
FROM per_all_people_f
WHERE UPPER (full_name) = UPPER (l_resource_name);
l_project_end_date :=
pa_project_dates_utils.get_project_finish_date (l_project_id_prem);
pa_project_parties_pub.create_project_party
(p_api_version => 1.0,
p_init_msg_list => fnd_api.g_true,
p_commit => fnd_api.g_false,
p_validate_only => fnd_api.g_false,
p_validation_level => fnd_api.g_valid_level_full,
p_debug_mode => ‘N’,
p_object_id => l_project_id_prem,
p_object_type => ‘PA_PROJECTS’,
p_project_role_id => l_project_role_id,
p_project_role_type => l_project_role_type,
p_resource_type_id => 101,
p_resource_source_id => l_resource_source_id,
p_resource_name => l_resource_name,
p_start_date_active => l_start_date_active,
p_scheduled_flag => ‘N’,
p_calling_module => NULL,
p_project_id => l_project_id_prem,
p_project_end_date => l_project_end_date,
p_mgr_validation_type => ‘FORM’,
p_end_date_active => l_end_date_active,
x_project_party_id => l_project_party_id,
x_resource_id => l_resource_id,
x_assignment_id => l_assignment_id,
x_wf_type => l_wf_type,
x_wf_item_type => l_wf_item_type,
x_wf_process => l_wf_process,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
COMMIT;
DBMS_OUTPUT.put_line (‘Status:’ || l_return_status);
DBMS_OUTPUT.put_line (‘Message:’ || l_msg_data);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line
(‘Process Erred Out, please check and reprocess it.’);
END;
Summary
This Post described the script to create a project party in oracle projects accounting using PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY in Oracle EBS.
Got any queries?
Do drop a note by writing us at venkatesh.b@doyensys.com or use the comment section below to ask your questions.
