APPS.PA_SCHEDULE_PVT dependencies on PA_PROJECT_PARTIES

Line 1040: from pa_project_parties

1036: IF ( p_source_type = 'PA_PROJECT_PARTY_ID') THEN
1037: BEGIN
1038: select distinct NVL(resource_id,-99)
1039: into l_resource_id
1040: from pa_project_parties
1041: where project_party_id = p_source_id;
1042: EXCEPTION WHEN NO_DATA_FOUND THEN
1043: l_resource_id := -99;
1044: END;

Line 1088: from pa_project_parties

1084: -- Find the start date for the first HR assignment.
1085: IF ( p_source_type = 'PA_PROJECT_PARTY_ID') THEN
1086: select resource_id
1087: into l_prm_resource_id
1088: from pa_project_parties
1089: where project_party_id = p_source_id;
1090: ELSIF ( p_source_type = 'PA_RESOURCE_ID') THEN
1091: l_prm_resource_id := p_source_id;
1092: END IF;

Line 3520: -- If assignment record is successfully updated then call procedure to update pa project parties.

3516: PA_SCHEDULE_UTILS.log_message(1,'20: ' || l_x_return_status ||
3517: ' ' || x_msg_count ||
3518: ' ' || x_msg_data);
3519:
3520: -- If assignment record is successfully updated then call procedure to update pa project parties.
3521: --
3522: -- jmarques (1590046): Added STAFFED_ADMIN_ASSIGNMENT check to if statement.
3523: IF ( ( l_x_return_status = FND_API.G_RET_STS_SUCCESS ) AND
3524: ( (chg_tr_sch_rec_tab(l_J).schedule_type_code = 'STAFFED_ASSIGNMENT') OR

Line 3544: FROM pa_project_parties proj_part,

3540: l_t_resource_id,
3541: l_t_record_version_number,
3542: l_t_asgn_start_date,
3543: l_t_asgn_end_date
3544: FROM pa_project_parties proj_part,
3545: pa_project_assignments proj_asgn
3546: WHERE proj_asgn.PROJECT_PARTY_ID = proj_part.PROJECT_PARTY_ID
3547: AND proj_asgn.ASSIGNMENT_ID = l_t_assignment_id;
3548:

Line 3561: pa_project_parties_pvt.UPDATE_PROJECT_PARTY(

3557: PA_SCHEDULE_UTILS.log_message(1,'21: ' || l_x_return_status ||
3558: ' ' || x_msg_count ||
3559: ' ' || x_msg_data);
3560:
3561: pa_project_parties_pvt.UPDATE_PROJECT_PARTY(
3562: P_VALIDATE_ONLY => 'F',
3563: P_OBJECT_ID => chg_tr_sch_rec_tab(l_J).project_id,
3564: P_OBJECT_TYPE => 'PA_PROJECTS',
3565: P_PROJECT_ROLE_ID => l_t_project_role_id,

Line 7130: l_source_proj_mgr_name := PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER_NAME(v_c1.project_id);

7126: l_source_proj_customer := v_c1.customer_name;
7127: */
7128:
7129: /* Added for bug 3115273 */
7130: l_source_proj_mgr_name := PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER_NAME(v_c1.project_id);
7131:
7132: OPEN get_organization_name(v_c1.carrying_out_organization_id);
7133: Fetch get_organization_name into l_source_proj_organization;
7134: CLOSE get_organization_name;