APPS.PNP_CMERGE dependencies on PN_LEASES

Line 15: FROM pn_leases

11:
12: /* Lock leases */
13: CURSOR leases IS
14: SELECT lease_id
15: FROM pn_leases
16: WHERE customer_id IN (SELECT racm.duplicate_id
17: FROM ra_customer_merges racm
18: WHERE racm.process_flag = 'N'
19: AND racm.request_id = req_id

Line 146: arp_message.set_token( 'TABLE_NAME', 'PN_LEASES', FALSE );

142: IF( process_mode = 'LOCK' ) THEN
143:
144: /* Lock leases */
145: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
146: arp_message.set_token( 'TABLE_NAME', 'PN_LEASES', FALSE );
147:
148: OPEN leases;
149: CLOSE leases;
150:

Line 294: | Account merge procedure for the table, pn_leases

290: | PROCEDURE
291: | update_leases
292: |
293: | DESCRIPTION
294: | Account merge procedure for the table, pn_leases
295: | Column updated Corresponding HZ table.column
296: | -------------- --------------------------------
297: | customer_id HZ_CUST_ACCOUNTS.cust_account_id
298: |

Line 323: PN_LEASES.LEASE_ID%TYPE

319: INDEX BY BINARY_INTEGER;
320: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
321:
322: TYPE LEASE_ID_LIST_TYPE IS TABLE OF
323: PN_LEASES.LEASE_ID%TYPE
324: INDEX BY BINARY_INTEGER;
325: PRIMARY_KEY_ID_LIST LEASE_ID_LIST_TYPE;
326:
327: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 328: PN_LEASES.CUSTOMER_ID%TYPE

324: INDEX BY BINARY_INTEGER;
325: PRIMARY_KEY_ID_LIST LEASE_ID_LIST_TYPE;
326:
327: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
328: PN_LEASES.CUSTOMER_ID%TYPE
329: INDEX BY BINARY_INTEGER;
330: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
331: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
332:

Line 338: FROM PN_LEASES yt

334: CURSOR merged_records IS
335: SELECT DISTINCT m.CUSTOMER_MERGE_HEADER_ID
336: ,yt.LEASE_ID
337: ,yt.CUSTOMER_ID
338: FROM PN_LEASES yt
339: , RA_CUSTOMER_MERGES m
340: WHERE yt.CUSTOMER_ID = m.DUPLICATE_ID
341: AND m.process_flag = 'N'
342: AND m.request_id = req_id

Line 357: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_LEASES',FALSE);

353: IF process_mode='LOCK' THEN
354: NULL;
355: ELSE
356: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
357: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_LEASES',FALSE);
358: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
359: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
360:
361: OPEN merged_records;

Line 401: 'PN_LEASES',

397: LAST_UPDATE_DATE,
398: LAST_UPDATED_BY
399: ) VALUES (
400: HZ_CUSTOMER_MERGE_LOG_s.NEXTVAL,
401: 'PN_LEASES',
402: MERGE_HEADER_ID_LIST(I),
403: PRIMARY_KEY_ID_LIST(I),
404: NUM_COL1_ORIG_LIST(I),
405: NUM_COL1_NEW_LIST(I),

Line 418: UPDATE PN_LEASES yt SET

414:
415: END IF;
416:
417: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
418: UPDATE PN_LEASES yt SET
419: CUSTOMER_ID = NUM_COL1_NEW_LIST(I)
420: , LAST_UPDATE_DATE = SYSDATE
421: , last_updated_by = arp_standard.profile.user_id
422: , last_update_login= arp_standard.profile.last_update_login