APPS.PA_PROJECT_PUB dependencies on PA_PROJECT_PARTIES

Line 4146: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

4142: CLOSE l_check_org_csr;
4143:
4144: if l_party_id is not null then
4145:
4146: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
4147: p_validate_only => FND_API.G_FALSE
4148: , p_object_id => l_project_id
4149: , p_OBJECT_TYPE => 'PA_PROJECTS'
4150: , p_project_role_id => 100

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

4232:
4233: WHILE i IS NOT NULL LOOP
4234:
4235: /*Commented the below code for the bug 2910972 since the defaulting is handled in the
4236: pa_project_parties_pub.create_project_party when a null value is passed*/
4237:
4238: /*IF l_key_members(i).start_date IS NULL
4239: OR l_key_members(i).start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4240: THEN IF l_project_rec.start_date IS NULL

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

9707: -- for workflow.
9708: -- 03-MAY-2000 Rakesh Raghavan - Fixed Bug # 1289156.
9709: -- 12-JUL-2000 Mohnish
9710: -- added code for ROLE BASED SECURITY:
9711: -- added the call to PA_PROJECT_PARTIES_PUB.UPDATE_PROJECT_PARTY
9712: -- 19-JUL-2000 Mohnish incorporated PA_PROJECT_PARTIES_PUB API changes
9713: -- 23-MAY-2002 MAansari Added call to create_default_task_structure
9714: -- 15-MAR-2003 SRAMESH - Added an OR condition for the bug 2846478
9715: -- in the before the update_project_party call in

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

9708: -- 03-MAY-2000 Rakesh Raghavan - Fixed Bug # 1289156.
9709: -- 12-JUL-2000 Mohnish
9710: -- added code for ROLE BASED SECURITY:
9711: -- added the call to PA_PROJECT_PARTIES_PUB.UPDATE_PROJECT_PARTY
9712: -- 19-JUL-2000 Mohnish incorporated PA_PROJECT_PARTIES_PUB API changes
9713: -- 23-MAY-2002 MAansari Added call to create_default_task_structure
9714: -- 15-MAR-2003 SRAMESH - Added an OR condition for the bug 2846478
9715: -- in the before the update_project_party call in
9716: -- the procedure CHECK_FOR_ONE_MANAGER_PVT.

Line 9970: FROM pa_project_parties_v

9966: CURSOR l_org_role_csr (l_project_id NUMBER,l_resource_source_id NUMBER,
9967: l_role_type VARCHAR2 )
9968: IS
9969: SELECT *
9970: FROM pa_project_parties_v
9971: WHERE project_id = l_project_id
9972: AND resource_source_id = l_resource_source_id
9973: AND project_role_type = l_role_type
9974: AND party_type = 'ORGANIZATION';

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

10008: 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,
10009: hzo.email_address EMAIL_ADDRESS,
10010: NULL JOB_TITLE,
10011: 'ORGANIZATION' PARTY_TYPE,
10012: PA_PROJECT_PARTIES_UTILS.ACTIVE_PARTY(PPP.START_DATE_ACTIVE,PPP.END_DATE_ACTIVE) ACTIVE,
10013: NULL USER_NAME,
10014: -999 USER_ID,
10015: ppp.resource_source_id RESOURCE_PARTY_ID
10016: FROM pa_project_parties ppp,

Line 10016: FROM pa_project_parties ppp,

10012: PA_PROJECT_PARTIES_UTILS.ACTIVE_PARTY(PPP.START_DATE_ACTIVE,PPP.END_DATE_ACTIVE) ACTIVE,
10013: NULL USER_NAME,
10014: -999 USER_ID,
10015: ppp.resource_source_id RESOURCE_PARTY_ID
10016: FROM pa_project_parties ppp,
10017: pa_projects_all ppa,
10018: pa_project_role_types_vl pprt,
10019: hz_parties hzo,
10020: hz_contact_points hzcp

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

10070: || decode(hzo.primary_phone_extension,NULL,NULL,'+' || hzo.primary_phone_extension) PHONE_NUMBER,
10071: hzo.email_address EMAIL_ADDRESS,
10072: NULL JOB_TITLE,
10073: 'ORGANIZATION' PARTY_TYPE,
10074: PA_PROJECT_PARTIES_UTILS.ACTIVE_PARTY(PPP.START_DATE_ACTIVE,PPP.END_DATE_ACTIVE) ACTIVE,
10075: NULL USER_NAME,
10076: -999 USER_ID,
10077: ppp.resource_source_id RESOURCE_PARTY_ID
10078: FROM pa_project_parties ppp,

Line 10078: FROM pa_project_parties ppp,

10074: PA_PROJECT_PARTIES_UTILS.ACTIVE_PARTY(PPP.START_DATE_ACTIVE,PPP.END_DATE_ACTIVE) ACTIVE,
10075: NULL USER_NAME,
10076: -999 USER_ID,
10077: ppp.resource_source_id RESOURCE_PARTY_ID
10078: FROM pa_project_parties ppp,
10079: pa_projects_all ppa,
10080: pa_project_role_types_vl pprt,
10081: hz_parties hzo
10082: WHERE ppp.resource_type_id = 112

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

18882: END IF;
18883: l_key_members_tbl(l_count) := p_key_members(i);
18884:
18885: /*Commented the below code for the bug 2910972 since the null
18886: value for the start date is handled in the pa_project_parties_pub.create_project_party*/
18887:
18888: /*IF l_key_members_tbl(l_count).start_date =
18889: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR
18890: l_key_members_tbl(l_count).start_date IS NULL THEN

Line 18992: PA_PROJECT_PARTIES_PUB.UPDATE_PROJECT_PARTY(

18988: WHERE p.project_id = l_key_members_rec.project_id;
18989: /*Added the OR condition in the below statement for the bug 2846478*/
18990: if l_key_members_rec.scheduled_flag = 'N' OR l_key_members_rec.scheduled_flag IS NULL
18991: then
18992: PA_PROJECT_PARTIES_PUB.UPDATE_PROJECT_PARTY(
18993: p_api_version => 1.0 -- p_api_version
18994: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
18995: , p_commit => FND_API.G_FALSE -- p_commit
18996: , p_validate_only => FND_API.G_FALSE -- p_validate_only

Line 19207: PA_PROJECT_PARTIES_PUB.UPDATE_PROJECT_PARTY(

19203: FROM pa_projects p
19204: WHERE p.project_id = l_org_roles_rec.project_id;
19205: if l_org_roles_rec.scheduled_flag = 'N'
19206: then
19207: PA_PROJECT_PARTIES_PUB.UPDATE_PROJECT_PARTY(
19208: p_api_version => 1.0 -- p_api_version
19209: , p_init_msg_list => FND_API.G_TRUE -- p_init_msg_list
19210: , p_commit => FND_API.G_FALSE -- p_commit
19211: , p_validate_only => FND_API.G_FALSE -- p_validate_only