APPS.PNP_CMERGE dependencies on PN_TENANCIES_HISTORY

Line 37: FROM pn_tenancies_history

33: FOR UPDATE NOWAIT;
34: /* Lock Tenancies History */
35: CURSOR tenencies_history IS
36: SELECT tenancy_history_id
37: FROM pn_tenancies_history
38: WHERE customer_id IN (SELECT racm.duplicate_id
39: FROM ra_customer_merges racm
40: WHERE racm.process_flag = 'N'
41: AND racm.request_id = req_id

Line 160: arp_message.set_token( 'TABLE_NAME', 'PN_TENANCIES_HISTORY', FALSE );

156: CLOSE tenencies;
157:
158: /* Lock Tenancies History */
159: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
160: arp_message.set_token( 'TABLE_NAME', 'PN_TENANCIES_HISTORY', FALSE );
161:
162: OPEN tenencies_history;
163: CLOSE tenencies_history;
164:

Line 619: | Account merge procedure for the table, pn_tenancies_history

615: | PROCEDURE
616: | update_tenancies_history
617: |
618: | DESCRIPTION
619: | Account merge procedure for the table, pn_tenancies_history
620: | Column updated Corresponding HZ table.column
621: | -------------------- -----------------------------
622: | customer_id HZ_CUST_ACCOUNTS.cust_account_id
623: | customer_site_use_id HZ_CUST_SITE_USES.site_use_id

Line 649: PN_TENANCIES_HISTORY.TENANCY_HISTORY_ID%TYPE

645: INDEX BY BINARY_INTEGER;
646: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
647:
648: TYPE TENANCY_HISTORY_ID_LIST_TYPE IS TABLE OF
649: PN_TENANCIES_HISTORY.TENANCY_HISTORY_ID%TYPE
650: INDEX BY BINARY_INTEGER;
651: PRIMARY_KEY_ID_LIST TENANCY_HISTORY_ID_LIST_TYPE;
652:
653: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 654: PN_TENANCIES_HISTORY.CUSTOMER_ID%TYPE

650: INDEX BY BINARY_INTEGER;
651: PRIMARY_KEY_ID_LIST TENANCY_HISTORY_ID_LIST_TYPE;
652:
653: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
654: PN_TENANCIES_HISTORY.CUSTOMER_ID%TYPE
655: INDEX BY BINARY_INTEGER;
656: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
657: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
658:

Line 660: PN_TENANCIES_HISTORY.CUSTOMER_SITE_USE_ID%TYPE

656: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
657: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
658:
659: TYPE CUSTOMER_SITE_USE_ID_LIST_TYPE IS TABLE OF
660: PN_TENANCIES_HISTORY.CUSTOMER_SITE_USE_ID%TYPE
661: INDEX BY BINARY_INTEGER;
662: NUM_COL2_ORIG_LIST CUSTOMER_SITE_USE_ID_LIST_TYPE;
663: NUM_COL2_NEW_LIST CUSTOMER_SITE_USE_ID_LIST_TYPE;
664:

Line 671: FROM PN_TENANCIES_HISTORY yt,

667: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
668: ,yt.TENANCY_HISTORY_ID
669: ,yt.CUSTOMER_ID
670: ,yt.CUSTOMER_SITE_USE_ID
671: FROM PN_TENANCIES_HISTORY yt,
672: RA_CUSTOMER_MERGES m
673: WHERE ( yt.CUSTOMER_ID = m.DUPLICATE_ID
674: OR yt.CUSTOMER_SITE_USE_ID = m.DUPLICATE_SITE_ID)
675: AND m.process_flag = 'N'

Line 691: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_TENANCIES_HISTORY',FALSE);

687: IF process_mode='LOCK' THEN
688: NULL;
689: ELSE
690: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
691: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_TENANCIES_HISTORY',FALSE);
692: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
693: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
694:
695: OPEN merged_records;

Line 739: 'PN_TENANCIES_HISTORY',

735: LAST_UPDATE_DATE,
736: LAST_UPDATED_BY
737: ) VALUES (
738: HZ_CUSTOMER_MERGE_LOG_s.NEXTVAL,
739: 'PN_TENANCIES_HISTORY',
740: MERGE_HEADER_ID_LIST(I),
741: PRIMARY_KEY_ID_LIST(I),
742: NUM_COL1_ORIG_LIST(I),
743: NUM_COL1_NEW_LIST(I),

Line 758: UPDATE PN_TENANCIES_HISTORY yt SET

754:
755: END IF;
756:
757: FORALL I IN 1..MERGE_HEADER_ID_LIST.COUNT
758: UPDATE PN_TENANCIES_HISTORY yt SET
759: CUSTOMER_ID = NUM_COL1_NEW_LIST(I)
760: , CUSTOMER_SITE_USE_ID= NUM_COL2_NEW_LIST(I)
761: , LAST_UPDATE_DATE = SYSDATE
762: , last_updated_by = arp_standard.profile.user_id