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 214: UPDATE pa_project_parties

210:
211: ELSE
212: --For non organizational parties
213: BEGIN
214: UPDATE pa_project_parties
215: SET resource_source_id = p_to_fk_id
216: WHERE resource_type_id = 112
217: AND resource_source_id = p_from_fk_id;
218: -- added exception block for bug 14593440

Line 221: DELETE pa_project_parties

217: AND resource_source_id = p_from_fk_id;
218: -- added exception block for bug 14593440
219: EXCEPTION
220: When DUP_VAL_ON_INDEX then
221: DELETE pa_project_parties
222: WHERE resource_type_id = 112
223: AND resource_source_id = p_from_fk_id;
224: END;
225: END IF;

Line 241: UPDATE pa_project_parties

237: BEGIN
238: x_return_status := FND_API.G_RET_STS_SUCCESS;
239:
240: IF (p_from_resource_id <> p_to_resource_id) THEN
241: UPDATE pa_project_parties
242: SET resource_id = p_to_resource_id
243: WHERE resource_id = p_from_resource_id;
244: END IF;
245: END update_project_parties_res_id;