APPS.PNP_CMERGE dependencies on PN_REC_PERIOD_LINES

Line 116: FROM pn_rec_period_lines

112: FOR UPDATE NOWAIT;
113: /* Lock Recovery Period Lines */
114: CURSOR rec_period_lines IS
115: SELECT rec_period_lines_id
116: FROM pn_rec_period_lines
117: WHERE cust_account_id IN
118: (SELECT racm.duplicate_id
119: FROM ra_customer_merges racm
120: WHERE racm.process_flag = 'N'

Line 209: arp_message.set_token( 'TABLE_NAME', 'PN_REC_PERIOD_LINES', FALSE );

205: CLOSE rec_expcl_dtlln;
206:
207: /* Lock Recovery Period Lines */
208: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
209: arp_message.set_token( 'TABLE_NAME', 'PN_REC_PERIOD_LINES', FALSE );
210:
211: OPEN rec_period_lines;
212: CLOSE rec_period_lines;
213:

Line 1815: | Account merge procedure for the table, pn_rec_period_lines

1811: | PROCEDURE
1812: | update_rec_period_lines
1813: |
1814: | DESCRIPTION
1815: | Account merge procedure for the table, pn_rec_period_lines
1816: | Column updated Corresponding HZ table.column
1817: | -------------------- -----------------------------
1818: | cust_account_id HZ_CUST_ACCOUNTS.cust_account_id
1819: |

Line 1844: PN_REC_PERIOD_LINES.REC_PERIOD_LINES_ID%TYPE

1840: INDEX BY BINARY_INTEGER;
1841: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1842:
1843: TYPE REC_PERIOD_LINES_ID_LIST_TYPE IS TABLE OF
1844: PN_REC_PERIOD_LINES.REC_PERIOD_LINES_ID%TYPE
1845: INDEX BY BINARY_INTEGER;
1846: PRIMARY_KEY_ID_LIST REC_PERIOD_LINES_ID_LIST_TYPE;
1847:
1848: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 1849: PN_REC_PERIOD_LINES.CUST_ACCOUNT_ID%TYPE

1845: INDEX BY BINARY_INTEGER;
1846: PRIMARY_KEY_ID_LIST REC_PERIOD_LINES_ID_LIST_TYPE;
1847:
1848: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
1849: PN_REC_PERIOD_LINES.CUST_ACCOUNT_ID%TYPE
1850: INDEX BY BINARY_INTEGER;
1851: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
1852: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
1853:

Line 1859: FROM PN_REC_PERIOD_LINES yt

1855: CURSOR merged_records IS
1856: SELECT DISTINCT m.CUSTOMER_MERGE_HEADER_ID
1857: ,yt.REC_PERIOD_LINES_ID
1858: ,yt.CUST_ACCOUNT_ID
1859: FROM PN_REC_PERIOD_LINES yt
1860: ,RA_CUSTOMER_MERGES m
1861: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
1862: AND m.process_flag = 'N'
1863: AND m.request_id = req_id

Line 1877: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_PERIOD_LINES',FALSE);

1873: IF process_mode='LOCK' THEN
1874: NULL;
1875: ELSE
1876: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1877: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_REC_PERIOD_LINES',FALSE);
1878: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1879: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1880:
1881: OPEN merged_records;

Line 1920: 'PN_REC_PERIOD_LINES',

1916: LAST_UPDATE_DATE,
1917: LAST_UPDATED_BY
1918: ) VALUES (
1919: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1920: 'PN_REC_PERIOD_LINES',
1921: MERGE_HEADER_ID_LIST(I),
1922: PRIMARY_KEY_ID_LIST(I),
1923: NUM_COL1_ORIG_LIST(I),
1924: NUM_COL1_NEW_LIST(I),

Line 1937: UPDATE PN_REC_PERIOD_LINES yt SET

1933:
1934: END IF;
1935:
1936: FORALL I IN 1..MERGE_HEADER_ID_LIST.COUNT
1937: UPDATE PN_REC_PERIOD_LINES yt SET
1938: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
1939: , LAST_UPDATE_DATE=SYSDATE
1940: , last_updated_by=arp_standard.profile.user_id
1941: , last_update_login=arp_standard.profile.last_update_login