APPS.PNP_CMERGE dependencies on PN_TERM_TEMPLATES

Line 48: FROM pn_term_templates

44: FOR UPDATE NOWAIT;
45: /* Lock Term Templates */
46: CURSOR term_templates IS
47: SELECT term_template_id
48: FROM pn_term_templates
49: WHERE customer_id IN (SELECT racm.duplicate_id
50: FROM ra_customer_merges racm
51: WHERE racm.process_flag = 'N'
52: AND racm.request_id = req_id

Line 167: arp_message.set_token( 'TABLE_NAME', 'PN_TERM_TEMPLATES', FALSE );

163: CLOSE tenencies_history;
164:
165: /* Lock Term Templates */
166: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
167: arp_message.set_token( 'TABLE_NAME', 'PN_TERM_TEMPLATES', FALSE );
168:
169: OPEN term_templates;
170: CLOSE term_templates;
171:

Line 788: | Account merge procedure for the table, pn_term_templates

784: | PROCEDURE
785: | update_term_templates
786: |
787: | DESCRIPTION
788: | Account merge procedure for the table, pn_term_templates
789: | Column updated Corresponding HZ table.column
790: | -------------------- -----------------------------
791: | customer_id HZ_CUST_ACCOUNTS.cust_account_id
792: | customer_site_use_id HZ_CUST_SITE_USES.site_use_id

Line 819: PN_TERM_TEMPLATES.TERM_TEMPLATE_ID%TYPE

815: INDEX BY BINARY_INTEGER;
816: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
817:
818: TYPE TERM_TEMPLATE_ID_LIST_TYPE IS TABLE OF
819: PN_TERM_TEMPLATES.TERM_TEMPLATE_ID%TYPE
820: INDEX BY BINARY_INTEGER;
821: PRIMARY_KEY_ID_LIST TERM_TEMPLATE_ID_LIST_TYPE;
822:
823: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 824: PN_TERM_TEMPLATES.CUSTOMER_ID%TYPE

820: INDEX BY BINARY_INTEGER;
821: PRIMARY_KEY_ID_LIST TERM_TEMPLATE_ID_LIST_TYPE;
822:
823: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
824: PN_TERM_TEMPLATES.CUSTOMER_ID%TYPE
825: INDEX BY BINARY_INTEGER;
826: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
827: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
828:

Line 830: PN_TERM_TEMPLATES.CUSTOMER_SITE_USE_ID%TYPE

826: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
827: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
828:
829: TYPE CUSTOMER_SITE_USE_ID_LIST_TYPE IS TABLE OF
830: PN_TERM_TEMPLATES.CUSTOMER_SITE_USE_ID%TYPE
831: INDEX BY BINARY_INTEGER;
832: NUM_COL2_ORIG_LIST CUSTOMER_SITE_USE_ID_LIST_TYPE;
833: NUM_COL2_NEW_LIST CUSTOMER_SITE_USE_ID_LIST_TYPE;
834:

Line 836: PN_TERM_TEMPLATES.CUST_SHIP_SITE_ID%TYPE

832: NUM_COL2_ORIG_LIST CUSTOMER_SITE_USE_ID_LIST_TYPE;
833: NUM_COL2_NEW_LIST CUSTOMER_SITE_USE_ID_LIST_TYPE;
834:
835: TYPE CUST_SHIP_SITE_ID_LIST_TYPE IS TABLE OF
836: PN_TERM_TEMPLATES.CUST_SHIP_SITE_ID%TYPE
837: INDEX BY BINARY_INTEGER;
838: NUM_COL3_ORIG_LIST CUST_SHIP_SITE_ID_LIST_TYPE;
839: NUM_COL3_NEW_LIST CUST_SHIP_SITE_ID_LIST_TYPE;
840:

Line 849: FROM PN_TERM_TEMPLATES yt,

845: ,yt.TERM_TEMPLATE_ID
846: ,yt.CUSTOMER_ID
847: ,yt.CUSTOMER_SITE_USE_ID
848: ,yt.CUST_SHIP_SITE_ID
849: FROM PN_TERM_TEMPLATES yt,
850: RA_CUSTOMER_MERGES m
851: WHERE ( yt.CUSTOMER_ID = m.DUPLICATE_ID
852: OR yt.CUSTOMER_SITE_USE_ID = m.DUPLICATE_SITE_ID
853: OR yt.CUST_SHIP_SITE_ID = m.DUPLICATE_SITE_ID)

Line 870: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_TERM_TEMPLATES',FALSE);

866: IF process_mode='LOCK' THEN
867: NULL;
868: ELSE
869: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
870: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_TERM_TEMPLATES',FALSE);
871: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
872: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
873:
874: OPEN merged_records;

Line 921: 'PN_TERM_TEMPLATES',

917: LAST_UPDATE_DATE,
918: LAST_UPDATED_BY
919: ) VALUES (
920: HZ_CUSTOMER_MERGE_LOG_s.NEXTVAL,
921: 'PN_TERM_TEMPLATES',
922: MERGE_HEADER_ID_LIST(I),
923: PRIMARY_KEY_ID_LIST(I),
924: NUM_COL1_ORIG_LIST(I),
925: NUM_COL1_NEW_LIST(I),

Line 942: UPDATE PN_TERM_TEMPLATES yt SET

938:
939: END IF;
940:
941: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
942: UPDATE PN_TERM_TEMPLATES yt SET
943: CUSTOMER_ID = NUM_COL1_NEW_LIST(I)
944: , CUSTOMER_SITE_USE_ID= NUM_COL2_NEW_LIST(I)
945: , CUST_SHIP_SITE_ID = NUM_COL3_NEW_LIST(I)
946: , LAST_UPDATE_DATE = SYSDATE