APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on PA_PROJECT_SUBTEAM_PARTIES

Line 1047: PA_PROJECT_SUBTEAM_PARTIES_PVT.Update_SPT_Assgn

1043:
1044: --
1045: --Revert the Project Subteam
1046: --
1047: PA_PROJECT_SUBTEAM_PARTIES_PVT.Update_SPT_Assgn
1048: ( p_validate_only => p_validate_only
1049: ,p_get_subteam_party_id_flag => 'Y'
1050: ,p_project_subteam_id => l_project_subteam_id
1051: ,p_object_type => 'PA_PROJECT_ASSIGNMENTS'

Line 1182: l_project_subteam_id pa_project_subteam_parties.project_subteam_id%TYPE;

1178: l_new_work_type pa_work_types_vl.name%TYPE;
1179: l_old_work_type pa_work_types_vl.name%TYPE;
1180: l_new_subteam_name pa_project_subteams.name%TYPE;
1181: l_old_subteam_name pa_project_subteams.name%TYPE;
1182: l_project_subteam_id pa_project_subteam_parties.project_subteam_id%TYPE;
1183: l_his_project_subteam_id pa_assignments_history.project_subteam_id%TYPE;
1184: l_msg_index_out NUMBER;
1185: l_change_id NUMBER;
1186: l_return_status VARCHAR2(1);

Line 1211: FROM pa_project_subteam_parties

1207: WHERE project_subteam_id in (new_project_subteam_id, old_project_subteam_id);
1208:
1209: CURSOR get_project_subteam_id IS
1210: SELECT project_subteam_id
1211: FROM pa_project_subteam_parties
1212: WHERE object_type = 'PA_PROJECT_ASSIGNMENTS'
1213: AND object_id = p_assignment_id
1214: AND primary_subteam_flag = 'Y';
1215:

Line 1403: -- get project_subteam_id from pa_project_subteam_parties

1399:
1400: -- Compare project Subteam
1401: l_changed_item := PA_ASSIGNMENT_APPROVAL_PVT.get_lookup_meaning('PA_CHANGED_ITEMS', 'SUB_TEAM');
1402:
1403: -- get project_subteam_id from pa_project_subteam_parties
1404: OPEN get_project_subteam_id;
1405: FETCH get_project_subteam_id INTO l_project_subteam_id;
1406: IF get_project_subteam_id%NOTFOUND THEN
1407: l_project_subteam_id := NULL;