APPS.PA_CI_MERGE_PKG dependencies on PA_PROJECT_PARTIES

Line 145: FROM pa_project_parties

141: object_type,
142: project_role_id,
143: start_date_active,
144: end_date_active
145: FROM pa_project_parties
146: WHERE resource_source_id=p_from_fk_id
147: AND resource_type_id=112;
148:
149: cp_party c_parties%ROWTYPE;

Line 186: FROM pa_project_parties

182: BEGIN
183: --Detecting duplicate assignment for a given organization, regardless of effective dates
184: SELECT project_party_id
185: INTO l_dummy
186: FROM pa_project_parties
187: WHERE object_id = cp_party.object_id
188: AND object_type = cp_party.object_type
189: AND project_role_id = cp_party.project_role_id
190: AND resource_type_id = 112

Line 199: DELETE FROM pa_project_parties

195: UPDATE pa_project_customers
196: SET project_party_id = l_dummy
197: WHERE project_party_id = cp_party.project_party_id;
198:
199: DELETE FROM pa_project_parties
200: WHERE project_party_id = cp_party.project_party_id;
201:
202: EXCEPTION
203: WHEN NO_DATA_FOUND THEN

Line 205: UPDATE pa_project_parties

201:
202: EXCEPTION
203: WHEN NO_DATA_FOUND THEN
204: --Update party_id if no duplicates
205: UPDATE pa_project_parties
206: SET resource_source_id = p_to_fk_id
207: WHERE project_party_id = cp_party.project_party_id;
208: END;
209: END LOOP;

Line 213: UPDATE pa_project_parties

209: END LOOP;
210:
211: ELSE
212: --For non organizational parties
213: UPDATE pa_project_parties
214: SET resource_source_id = p_to_fk_id
215: WHERE resource_type_id = 112
216: AND resource_source_id = p_from_fk_id;
217: END IF;

Line 233: UPDATE pa_project_parties

229: BEGIN
230: x_return_status := FND_API.G_RET_STS_SUCCESS;
231:
232: IF (p_from_resource_id <> p_to_resource_id) THEN
233: UPDATE pa_project_parties
234: SET resource_id = p_to_resource_id
235: WHERE resource_id = p_from_resource_id;
236: END IF;
237: END update_project_parties_res_id;