APPS.PNP_CMERGE dependencies on PN_REC_AGREEMENTS

Line 81: FROM pn_rec_agreements

77: FOR UPDATE NOWAIT;
78: /* Lock Recovery Agreements */
79: CURSOR rec_agreements IS
80: SELECT rec_agreement_id
81: FROM pn_rec_agreements
82: WHERE customer_id IN (SELECT racm.duplicate_id
83: FROM ra_customer_merges racm
84: WHERE racm.process_flag = 'N'
85: AND racm.request_id = req_id

Line 188: arp_message.set_token( 'TABLE_NAME', 'PN_REC_AGREEMENTS', FALSE );

184: CLOSE pmt_items;
185:
186: /* Lock Recovery Agreements */
187: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
188: arp_message.set_token( 'TABLE_NAME', 'PN_REC_AGREEMENTS', FALSE );
189:
190: OPEN rec_agreements;
191: CLOSE rec_agreements;
192:

Line 1346: | Account merge procedure for the table, pn_rec_agreements

1342: | PROCEDURE
1343: | update_rec_agreements
1344: |
1345: | DESCRIPTION
1346: | Account merge procedure for the table, pn_rec_agreements
1347: | Column updated Corresponding HZ table.column
1348: | -------------------- -----------------------------
1349: | customer_id HZ_CUST_ACCOUNTS.cust_account_id
1350: | cust_site_id HZ_CUST_SITE_USES.site_use_id

Line 1376: PN_REC_AGREEMENTS.REC_AGREEMENT_ID%TYPE

1372: INDEX BY BINARY_INTEGER;
1373: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1374:
1375: TYPE REC_AGREEMENT_ID_LIST_TYPE IS TABLE OF
1376: PN_REC_AGREEMENTS.REC_AGREEMENT_ID%TYPE
1377: INDEX BY BINARY_INTEGER;
1378: PRIMARY_KEY_ID_LIST REC_AGREEMENT_ID_LIST_TYPE;
1379:
1380: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 1381: PN_REC_AGREEMENTS.CUSTOMER_ID%TYPE

1377: INDEX BY BINARY_INTEGER;
1378: PRIMARY_KEY_ID_LIST REC_AGREEMENT_ID_LIST_TYPE;
1379:
1380: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
1381: PN_REC_AGREEMENTS.CUSTOMER_ID%TYPE
1382: INDEX BY BINARY_INTEGER;
1383: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
1384: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
1385:

Line 1387: PN_REC_AGREEMENTS.CUST_SITE_ID%TYPE

1383: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
1384: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
1385:
1386: TYPE CUST_SITE_ID_LIST_TYPE IS TABLE OF
1387: PN_REC_AGREEMENTS.CUST_SITE_ID%TYPE
1388: INDEX BY BINARY_INTEGER;
1389: NUM_COL2_ORIG_LIST CUST_SITE_ID_LIST_TYPE;
1390: NUM_COL2_NEW_LIST CUST_SITE_ID_LIST_TYPE;
1391:

Line 1398: FROM PN_REC_AGREEMENTS yt

1394: SELECT DISTINCT m.CUSTOMER_MERGE_HEADER_ID
1395: ,yt.REC_AGREEMENT_ID
1396: ,yt.CUSTOMER_ID
1397: ,yt.CUST_SITE_ID
1398: FROM PN_REC_AGREEMENTS yt
1399: ,RA_CUSTOMER_MERGES m
1400: WHERE ( yt.CUSTOMER_ID = m.DUPLICATE_ID
1401: OR yt.CUST_SITE_ID = m.DUPLICATE_SITE_ID)
1402: AND m.process_flag = 'N'

Line 1417: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_AGREEMENTS',FALSE);

1413: IF process_mode='LOCK' THEN
1414: NULL;
1415: ELSE
1416: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1417: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_AGREEMENTS',FALSE);
1418: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1419: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1420:
1421: OPEN merged_records;

Line 1464: 'PN_REC_AGREEMENTS',

1460: LAST_UPDATE_DATE,
1461: LAST_UPDATED_BY
1462: ) VALUES (
1463: HZ_CUSTOMER_MERGE_LOG_s.NEXTVAL,
1464: 'PN_REC_AGREEMENTS',
1465: MERGE_HEADER_ID_LIST(I),
1466: PRIMARY_KEY_ID_LIST(I),
1467: NUM_COL1_ORIG_LIST(I),
1468: NUM_COL1_NEW_LIST(I),

Line 1483: UPDATE PN_REC_AGREEMENTS yt SET

1479:
1480: END IF;
1481:
1482: FORALL I IN 1..MERGE_HEADER_ID_LIST.COUNT
1483: UPDATE PN_REC_AGREEMENTS yt SET
1484: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
1485: , CUST_SITE_ID=NUM_COL2_NEW_LIST(I)
1486: , LAST_UPDATE_DATE=SYSDATE
1487: , last_updated_by=arp_standard.profile.user_id