APPS.PNP_CMERGE dependencies on PN_REC_EXPCL_DTLLN

Line 104: FROM pn_rec_expcl_dtlln

100: FOR UPDATE NOWAIT;
101: /* Lock Expense Class Line Details */
102: CURSOR rec_expcl_dtlln IS
103: SELECT expense_class_dtl_id
104: FROM pn_rec_expcl_dtlln
105: WHERE cust_account_id IN
106: (SELECT racm.duplicate_id
107: FROM ra_customer_merges racm
108: WHERE racm.process_flag = 'N'

Line 202: arp_message.set_token( 'TABLE_NAME', 'PN_REC_EXPCL_DTLLN', FALSE );

198: CLOSE rec_arcl_dtlln;
199:
200: /* Lock Expense Class Line Details */
201: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
202: arp_message.set_token( 'TABLE_NAME', 'PN_REC_EXPCL_DTLLN', FALSE );
203:
204: OPEN rec_expcl_dtlln;
205: CLOSE rec_expcl_dtlln;
206:

Line 1694: PN_REC_EXPCL_DTLLN.EXPENSE_CLASS_LINE_ID%TYPE

1690: INDEX BY BINARY_INTEGER;
1691: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1692:
1693: TYPE EXP_CLS_LINE_ID_LIST_TYPE IS TABLE OF
1694: PN_REC_EXPCL_DTLLN.EXPENSE_CLASS_LINE_ID%TYPE
1695: INDEX BY BINARY_INTEGER;
1696: PRIMARY_KEY_ID_LIST EXP_CLS_LINE_ID_LIST_TYPE;
1697:
1698: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 1699: PN_REC_EXPCL_DTLLN.CUST_ACCOUNT_ID%TYPE

1695: INDEX BY BINARY_INTEGER;
1696: PRIMARY_KEY_ID_LIST EXP_CLS_LINE_ID_LIST_TYPE;
1697:
1698: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
1699: PN_REC_EXPCL_DTLLN.CUST_ACCOUNT_ID%TYPE
1700: INDEX BY BINARY_INTEGER;
1701: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
1702: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
1703:

Line 1709: FROM PN_REC_EXPCL_DTLLN yt

1705: CURSOR merged_records IS
1706: SELECT DISTINCT m.CUSTOMER_MERGE_HEADER_ID
1707: ,yt.EXPENSE_CLASS_LINE_ID
1708: ,yt.CUST_ACCOUNT_ID
1709: FROM PN_REC_EXPCL_DTLLN yt
1710: ,RA_CUSTOMER_MERGES M
1711: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
1712: AND m.process_flag = 'N'
1713: AND m.request_id = req_id

Line 1727: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_EXPCL_DTLLN',FALSE);

1723: IF process_mode='LOCK' THEN
1724: NULL;
1725: ELSE
1726: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1727: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_EXPCL_DTLLN',FALSE);
1728: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1729: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1730:
1731: OPEN merged_records;

Line 1771: 'PN_REC_EXPCL_DTLLN',

1767: LAST_UPDATE_DATE,
1768: LAST_UPDATED_BY
1769: ) VALUES (
1770: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1771: 'PN_REC_EXPCL_DTLLN',
1772: MERGE_HEADER_ID_LIST(I),
1773: PRIMARY_KEY_ID_LIST(I),
1774: NUM_COL1_ORIG_LIST(I),
1775: NUM_COL1_NEW_LIST(I),

Line 1788: UPDATE PN_REC_EXPCL_DTLLN yt SET

1784:
1785: END IF;
1786:
1787: FORALL I IN 1..MERGE_HEADER_ID_LIST.COUNT
1788: UPDATE PN_REC_EXPCL_DTLLN yt SET
1789: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
1790: , LAST_UPDATE_DATE=SYSDATE
1791: , last_updated_by=arp_standard.profile.user_id
1792: , last_update_login=arp_standard.profile.last_update_login