APPS.PVX_PARTY_MERGE_PKG dependencies on PV_PARTNER_ACCESSES

Line 1080: -- Purpose : Merges partner_id in PV_PARTNER_ACCESSES table

1076: -- *******************************************************
1077: -- Start of Comments
1078: -- *******************************************************
1079: -- API Name: MERGE_PARTNER_ACCESSES
1080: -- Purpose : Merges partner_id in PV_PARTNER_ACCESSES table
1081: -- Type : Private
1082: -- Pre-Req : None.
1083: -- Parameters:
1084: -- IN - All IN parameters are REQUIRED.

Line 1116: select partner_access_id from pv_partner_accesses a

1112: )
1113: IS
1114:
1115: CURSOR c_get_pm_access_id (c_from_fk_id NUMBER, c_to_fk_id NUMBER) IS
1116: select partner_access_id from pv_partner_accesses a
1117: where partner_id= c_from_fk_id
1118: and exists (select null from pv_partner_accesses b
1119: where partner_id = c_to_fk_id
1120: and b.resource_id = a.resource_id );

Line 1118: and exists (select null from pv_partner_accesses b

1114:
1115: CURSOR c_get_pm_access_id (c_from_fk_id NUMBER, c_to_fk_id NUMBER) IS
1116: select partner_access_id from pv_partner_accesses a
1117: where partner_id= c_from_fk_id
1118: and exists (select null from pv_partner_accesses b
1119: where partner_id = c_to_fk_id
1120: and b.resource_id = a.resource_id );
1121:
1122: -- Cursor l_chng_partner_exist_csr.

Line 1190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing PV_PARTNER_ACCESSES Table');

1186: -- Merged To Id
1187: -- ************************************************************************
1188: IF p_from_fk_id <> p_to_fk_id THEN
1189: BEGIN
1190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing PV_PARTNER_ACCESSES Table');
1191: IF p_parent_entity_name = 'HZ_PARTIES' THEN
1192: FOR I in c_get_pm_access_id (p_from_fk_id, p_to_fk_id) LOOP
1193: FND_FILE.PUT_LINE(FND_FILE.LOG,
1194: 'Deleting PARTY partner_access_id: '||I.partner_access_id);

Line 1198: DELETE FROM pv_partner_accesses

1194: 'Deleting PARTY partner_access_id: '||I.partner_access_id);
1195: DELETE FROM pv_tap_access_terrs
1196: WHERE partner_access_id = I.partner_access_id;
1197:
1198: DELETE FROM pv_partner_accesses
1199: WHERE partner_access_id = I.partner_access_id;
1200: END LOOP;
1201:
1202: -- merge party

Line 1203: UPDATE PV_PARTNER_ACCESSES

1199: WHERE partner_access_id = I.partner_access_id;
1200: END LOOP;
1201:
1202: -- merge party
1203: UPDATE PV_PARTNER_ACCESSES
1204: set object_version_number = nvl(object_version_number,0) + 1,
1205: partner_id = p_to_fk_id,
1206: last_update_date = SYSDATE,
1207: last_updated_by = G_USER_ID,