APPS.PA_SCHEDULE_PVT dependencies on PA_PROJECT_PARTIES

Line 1210: from pa_project_parties

1206: IF ( p_source_type = 'PA_PROJECT_PARTY_ID') THEN
1207: BEGIN
1208: select distinct NVL(resource_id,-99)
1209: into l_resource_id
1210: from pa_project_parties
1211: where project_party_id = p_source_id;
1212: EXCEPTION WHEN NO_DATA_FOUND THEN
1213: l_resource_id := -99;
1214: END;

Line 1258: from pa_project_parties

1254: -- Find the start date for the first HR assignment.
1255: IF ( p_source_type = 'PA_PROJECT_PARTY_ID') THEN
1256: select resource_id
1257: into l_prm_resource_id
1258: from pa_project_parties
1259: where project_party_id = p_source_id;
1260: ELSIF ( p_source_type = 'PA_RESOURCE_ID') THEN
1261: l_prm_resource_id := p_source_id;
1262: END IF;

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

3798: PA_SCHEDULE_UTILS.log_message(1,'20: ' || l_x_return_status ||
3799: ' ' || x_msg_count ||
3800: ' ' || x_msg_data);
3801:
3802: -- If assignment record is successfully updated then call procedure to update pa project parties.
3803: --
3804: -- jmarques (1590046): Added STAFFED_ADMIN_ASSIGNMENT check to if statement.
3805: IF ( ( l_x_return_status = FND_API.G_RET_STS_SUCCESS ) AND
3806: ( (chg_tr_sch_rec_tab(l_J).schedule_type_code = 'STAFFED_ASSIGNMENT') OR

Line 3826: FROM pa_project_parties proj_part,

3822: l_t_resource_id,
3823: l_t_record_version_number,
3824: l_t_asgn_start_date,
3825: l_t_asgn_end_date
3826: FROM pa_project_parties proj_part,
3827: pa_project_assignments proj_asgn
3828: WHERE proj_asgn.PROJECT_PARTY_ID = proj_part.PROJECT_PARTY_ID
3829: AND proj_asgn.ASSIGNMENT_ID = l_t_assignment_id;
3830:

Line 3845: pa_project_parties_pvt.UPDATE_PROJECT_PARTY(

3841: ' ' || x_msg_data);
3842:
3843: IF p_called_by_proj_party = 'N' then -- Bug 6631033
3844:
3845: pa_project_parties_pvt.UPDATE_PROJECT_PARTY(
3846: P_VALIDATE_ONLY => 'F',
3847: P_OBJECT_ID => chg_tr_sch_rec_tab(l_J).project_id,
3848: P_OBJECT_TYPE => 'PA_PROJECTS',
3849: P_PROJECT_ROLE_ID => l_t_project_role_id,

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

7419: l_source_proj_customer := v_c1.customer_name;
7420: */
7421:
7422: /* Added for bug 3115273 */
7423: l_source_proj_mgr_name := PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER_NAME(v_c1.project_id);
7424:
7425: OPEN get_organization_name(v_c1.carrying_out_organization_id);
7426: Fetch get_organization_name into l_source_proj_organization;
7427: CLOSE get_organization_name;