DBA Data[Home] [Help]

APPS.PA_MERGE_PKG dependencies on PA_PROJECT_PARTIES

Line 187: UPDATE pa_project_parties

183: FND_MSG_PUB.add;
184:
185: EXCEPTION
186: WHEN NO_DATA_FOUND THEN
187: UPDATE pa_project_parties
188: SET resource_source_id = p_to_fk_id
189: WHERE resource_source_id = p_from_fk_id
190: AND resource_type_id = 112;
191:

Line 207: UPDATE pa_project_parties

203: BEGIN
204: x_return_status := FND_API.G_RET_STS_SUCCESS;
205:
206: IF (p_from_resource_id <> p_to_resource_id) THEN
207: UPDATE pa_project_parties
208: SET resource_id = p_to_resource_id
209: WHERE resource_id = p_from_resource_id;
210: END IF;
211: END update_project_parties_res_id;