APPS.PA_RES_MERGE_PKG dependencies on PA_RESOURCE_TXN_ATTRIBUTES

Line 24: -- This API merges the resource records in PA_RESOURCE_TXN_ATTRIBUTES.

20: begin
21:
22: x_return_status := fnd_api.g_ret_sts_success;
23:
24: -- This API merges the resource records in PA_RESOURCE_TXN_ATTRIBUTES.
25: -- We will merge the resource record *ONLY* if it is not referenced in
26: -- any PA tables. The only exception is if there is a reference in
27: -- PA_PROJECT_PARTIES for a key member. We do allow merging party records
28: -- for external key members, so we will allow merging the resource records for

Line 36: FROM PA_RESOURCE_TXN_ATTRIBUTES

32: -- Select the resource_id corresponding to the old party id
33: BEGIN
34: SELECT resource_id
35: INTO l_from_resource_id
36: FROM PA_RESOURCE_TXN_ATTRIBUTES
37: WHERE PARTY_ID = p_from_fk_id
38: AND ROWNUM=1;
39: EXCEPTION
40: WHEN NO_DATA_FOUND THEN

Line 51: FROM PA_RESOURCE_TXN_ATTRIBUTES

47:
48: BEGIN
49: SELECT resource_id
50: INTO l_to_resource_id
51: FROM PA_RESOURCE_TXN_ATTRIBUTES
52: WHERE PARTY_ID = p_to_fk_id
53: AND ROWNUM=1;
54: EXCEPTION
55: WHEN NO_DATA_FOUND THEN

Line 65: UPDATE PA_RESOURCE_TXN_ATTRIBUTES

61: THEN
62: -- No record exists for new party id. Simply update
63: -- the resource record for the old party id.
64:
65: UPDATE PA_RESOURCE_TXN_ATTRIBUTES
66: SET PARTY_ID = P_TO_FK_ID,
67: last_update_date = hz_utility_pub.last_update_date,
68: last_updated_by = hz_utility_pub.user_id,
69: last_update_login = hz_utility_pub.last_update_login,

Line 135: delete from pa_resource_txn_attributes

131:
132: delete from pa_resources
133: where resource_id = l_from_resource_id;
134:
135: delete from pa_resource_txn_attributes
136: where resource_id = l_from_resource_id;
137:
138: END IF; /* IF p_from_fk_id <> p_to_fk_id */
139: