APPS.PA_PROJECT_PUB dependencies on PA_PROJECT_PARTIES

Line 4060: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

4056: CLOSE l_check_org_csr;
4057:
4058: if l_party_id is not null then
4059:
4060: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
4061: p_validate_only => FND_API.G_FALSE
4062: , p_object_id => l_project_id
4063: , p_OBJECT_TYPE => 'PA_PROJECTS'
4064: , p_project_role_id => 100

Line 4150: pa_project_parties_pub.create_project_party when a null value is passed*/

4146:
4147: WHILE i IS NOT NULL LOOP
4148:
4149: /*Commented the below code for the bug 2910972 since the defaulting is handled in the
4150: pa_project_parties_pub.create_project_party when a null value is passed*/
4151:
4152: /*IF l_key_members(i).start_date IS NULL
4153: OR l_key_members(i).start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4154: THEN IF l_project_rec.start_date IS NULL

Line 9459: -- added the call to PA_PROJECT_PARTIES_PUB.UPDATE_PROJECT_PARTY

9455: -- for workflow.
9456: -- 03-MAY-2000 Rakesh Raghavan - Fixed Bug # 1289156.
9457: -- 12-JUL-2000 Mohnish
9458: -- added code for ROLE BASED SECURITY:
9459: -- added the call to PA_PROJECT_PARTIES_PUB.UPDATE_PROJECT_PARTY
9460: -- 19-JUL-2000 Mohnish incorporated PA_PROJECT_PARTIES_PUB API changes
9461: -- 23-MAY-2002 MAansari Added call to create_default_task_structure
9462: -- 15-MAR-2003 SRAMESH - Added an OR condition for the bug 2846478
9463: -- in the before the update_project_party call in

Line 9460: -- 19-JUL-2000 Mohnish incorporated PA_PROJECT_PARTIES_PUB API changes

9456: -- 03-MAY-2000 Rakesh Raghavan - Fixed Bug # 1289156.
9457: -- 12-JUL-2000 Mohnish
9458: -- added code for ROLE BASED SECURITY:
9459: -- added the call to PA_PROJECT_PARTIES_PUB.UPDATE_PROJECT_PARTY
9460: -- 19-JUL-2000 Mohnish incorporated PA_PROJECT_PARTIES_PUB API changes
9461: -- 23-MAY-2002 MAansari Added call to create_default_task_structure
9462: -- 15-MAR-2003 SRAMESH - Added an OR condition for the bug 2846478
9463: -- in the before the update_project_party call in
9464: -- the procedure CHECK_FOR_ONE_MANAGER_PVT.

Line 9718: FROM pa_project_parties_v

9714: CURSOR l_org_role_csr (l_project_id NUMBER,l_resource_source_id NUMBER,
9715: l_role_type VARCHAR2 )
9716: IS
9717: SELECT *
9718: FROM pa_project_parties_v
9719: WHERE project_id = l_project_id
9720: AND resource_source_id = l_resource_source_id
9721: AND project_role_type = l_role_type
9722: AND party_type = 'ORGANIZATION';

Line 9760: PA_PROJECT_PARTIES_UTILS.ACTIVE_PARTY(PPP.START_DATE_ACTIVE,PPP.END_DATE_ACTIVE) ACTIVE,

9756: hzcp.phone_area_code || decode(hzcp.phone_number,NULL,NULL,decode(hzcp.phone_area_code,NULL,hzcp.phone_number,'-' || hzcp.phone_number) ) || decode(hzcp.phone_extension,NULL,NULL,'+' || hzcp.phone_extension) PHONE_NUMBER,
9757: hzo.email_address EMAIL_ADDRESS,
9758: NULL JOB_TITLE,
9759: 'ORGANIZATION' PARTY_TYPE,
9760: PA_PROJECT_PARTIES_UTILS.ACTIVE_PARTY(PPP.START_DATE_ACTIVE,PPP.END_DATE_ACTIVE) ACTIVE,
9761: NULL USER_NAME,
9762: -999 USER_ID,
9763: ppp.resource_source_id RESOURCE_PARTY_ID
9764: FROM pa_project_parties ppp,

Line 9764: FROM pa_project_parties ppp,

9760: PA_PROJECT_PARTIES_UTILS.ACTIVE_PARTY(PPP.START_DATE_ACTIVE,PPP.END_DATE_ACTIVE) ACTIVE,
9761: NULL USER_NAME,
9762: -999 USER_ID,
9763: ppp.resource_source_id RESOURCE_PARTY_ID
9764: FROM pa_project_parties ppp,
9765: pa_projects_all ppa,
9766: pa_project_role_types_vl pprt,
9767: hz_parties hzo,
9768: hz_contact_points hzcp

Line 9822: PA_PROJECT_PARTIES_UTILS.ACTIVE_PARTY(PPP.START_DATE_ACTIVE,PPP.END_DATE_ACTIVE) ACTIVE,

9818: || decode(hzo.primary_phone_extension,NULL,NULL,'+' || hzo.primary_phone_extension) PHONE_NUMBER,
9819: hzo.email_address EMAIL_ADDRESS,
9820: NULL JOB_TITLE,
9821: 'ORGANIZATION' PARTY_TYPE,
9822: PA_PROJECT_PARTIES_UTILS.ACTIVE_PARTY(PPP.START_DATE_ACTIVE,PPP.END_DATE_ACTIVE) ACTIVE,
9823: NULL USER_NAME,
9824: -999 USER_ID,
9825: ppp.resource_source_id RESOURCE_PARTY_ID
9826: FROM pa_project_parties ppp,

Line 9826: FROM pa_project_parties ppp,

9822: PA_PROJECT_PARTIES_UTILS.ACTIVE_PARTY(PPP.START_DATE_ACTIVE,PPP.END_DATE_ACTIVE) ACTIVE,
9823: NULL USER_NAME,
9824: -999 USER_ID,
9825: ppp.resource_source_id RESOURCE_PARTY_ID
9826: FROM pa_project_parties ppp,
9827: pa_projects_all ppa,
9828: pa_project_role_types_vl pprt,
9829: hz_parties hzo
9830: WHERE ppp.resource_type_id = 112

Line 18488: value for the start date is handled in the pa_project_parties_pub.create_project_party*/

18484: END IF;
18485: l_key_members_tbl(l_count) := p_key_members(i);
18486:
18487: /*Commented the below code for the bug 2910972 since the null
18488: value for the start date is handled in the pa_project_parties_pub.create_project_party*/
18489:
18490: /*IF l_key_members_tbl(l_count).start_date =
18491: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
18492: l_key_members_tbl(l_count).start_date IS NULL THEN

Line 18594: PA_PROJECT_PARTIES_PUB.UPDATE_PROJECT_PARTY(

18590: WHERE p.project_id = l_key_members_rec.project_id;
18591: /*Added the OR condition in the below statement for the bug 2846478*/
18592: if l_key_members_rec.scheduled_flag = 'N' OR l_key_members_rec.scheduled_flag IS NULL
18593: then
18594: PA_PROJECT_PARTIES_PUB.UPDATE_PROJECT_PARTY(
18595: p_api_version => 1.0 -- p_api_version
18596: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
18597: , p_commit => FND_API.G_FALSE -- p_commit
18598: , p_validate_only => FND_API.G_FALSE -- p_validate_only

Line 18809: PA_PROJECT_PARTIES_PUB.UPDATE_PROJECT_PARTY(

18805: FROM pa_projects p
18806: WHERE p.project_id = l_org_roles_rec.project_id;
18807: if l_org_roles_rec.scheduled_flag = 'N'
18808: then
18809: PA_PROJECT_PARTIES_PUB.UPDATE_PROJECT_PARTY(
18810: p_api_version => 1.0 -- p_api_version
18811: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
18812: , p_commit => FND_API.G_FALSE -- p_commit
18813: , p_validate_only => FND_API.G_FALSE -- p_validate_only