APPS.PNP_CMERGE dependencies on PN_REC_ARCL_DTLLN

Line 92: FROM pn_rec_arcl_dtlln

88: FOR UPDATE NOWAIT;
89: /* Lock Area Class Line Details */
90: CURSOR rec_arcl_dtlln IS
91: SELECT area_class_dtl_id
92: FROM pn_rec_arcl_dtlln
93: WHERE cust_account_id IN
94: (SELECT racm.duplicate_id
95: FROM ra_customer_merges racm
96: WHERE racm.process_flag = 'N'

Line 195: arp_message.set_token( 'TABLE_NAME', 'PN_REC_ARCL_DTLLN', FALSE );

191: CLOSE rec_agreements;
192:
193: /* Lock Area Class Line Details */
194: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
195: arp_message.set_token( 'TABLE_NAME', 'PN_REC_ARCL_DTLLN', FALSE );
196:
197: OPEN rec_arcl_dtlln;
198: CLOSE rec_arcl_dtlln;
199:

Line 1542: PN_REC_ARCL_DTLLN.AREA_CLASS_DTL_ID%TYPE

1538: INDEX BY BINARY_INTEGER;
1539: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1540:
1541: TYPE AREA_CLASS_DTL_ID_LIST_TYPE IS TABLE OF
1542: PN_REC_ARCL_DTLLN.AREA_CLASS_DTL_ID%TYPE
1543: INDEX BY BINARY_INTEGER;
1544: PRIMARY_KEY_ID_LIST AREA_CLASS_DTL_ID_LIST_TYPE;
1545:
1546: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 1547: PN_REC_ARCL_DTLLN.CUST_ACCOUNT_ID%TYPE

1543: INDEX BY BINARY_INTEGER;
1544: PRIMARY_KEY_ID_LIST AREA_CLASS_DTL_ID_LIST_TYPE;
1545:
1546: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
1547: PN_REC_ARCL_DTLLN.CUST_ACCOUNT_ID%TYPE
1548: INDEX BY BINARY_INTEGER;
1549: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
1550: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
1551:

Line 1558: FROM PN_REC_ARCL_DTLLN yt

1554: CURSOR merged_records IS
1555: SELECT DISTINCT m.CUSTOMER_MERGE_HEADER_ID
1556: ,yt.AREA_CLASS_DTL_ID
1557: ,yt.CUST_ACCOUNT_ID
1558: FROM PN_REC_ARCL_DTLLN yt
1559: ,RA_CUSTOMER_MERGES m
1560: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
1561: AND m.process_flag = 'N'
1562: AND m.request_id = req_id

Line 1576: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_ARCL_DTLLN',FALSE);

1572: IF process_mode='LOCK' THEN
1573: NULL;
1574: ELSE
1575: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1576: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_ARCL_DTLLN',FALSE);
1577: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1578: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1579:
1580: OPEN merged_records;

Line 1620: 'PN_REC_ARCL_DTLLN',

1616: LAST_UPDATE_DATE,
1617: LAST_UPDATED_BY
1618: ) VALUES (
1619: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1620: 'PN_REC_ARCL_DTLLN',
1621: MERGE_HEADER_ID_LIST(I),
1622: PRIMARY_KEY_ID_LIST(I),
1623: NUM_COL1_ORIG_LIST(I),
1624: NUM_COL1_NEW_LIST(I),

Line 1637: UPDATE PN_REC_ARCL_DTLLN yt SET

1633:
1634: END IF;
1635:
1636: FORALL I IN 1..MERGE_HEADER_ID_LIST.COUNT
1637: UPDATE PN_REC_ARCL_DTLLN yt SET
1638: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
1639: , LAST_UPDATE_DATE=SYSDATE
1640: , last_updated_by=arp_standard.profile.user_id
1641: , last_update_login=arp_standard.profile.last_update_login