APPS.PNP_CMERGE dependencies on PN_PAYMENT_TERMS

Line 59: FROM pn_payment_terms

55: FOR UPDATE NOWAIT;
56: /* Lock Terms */
57: CURSOR pmt_terms IS
58: SELECT payment_term_id
59: FROM pn_payment_terms
60: WHERE customer_id IN (SELECT racm.duplicate_id
61: FROM ra_customer_merges racm
62: WHERE racm.process_flag = 'N'
63: AND racm.request_id = req_id

Line 174: arp_message.set_token( 'TABLE_NAME', 'PN_PAYMENT_TERMS', FALSE );

170: CLOSE term_templates;
171:
172: /* Lock Terms */
173: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
174: arp_message.set_token( 'TABLE_NAME', 'PN_PAYMENT_TERMS', FALSE );
175:
176: OPEN pmt_terms;
177: CLOSE pmt_terms;
178:

Line 973: | Account merge procedure for the table, pn_payment_terms_all

969: | PROCEDURE
970: | update_payment_terms
971: |
972: | DESCRIPTION
973: | Account merge procedure for the table, pn_payment_terms_all
974: | Column updated Corresponding HZ table.column
975: | -------------------- -----------------------------
976: | customer_id HZ_CUST_ACCOUNTS.cust_account_id
977: | customer_site_use_id HZ_CUST_SITE_USES.site_use_id

Line 1007: PN_PAYMENT_TERMS.PAYMENT_TERM_ID%TYPE

1003: INDEX BY BINARY_INTEGER;
1004: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1005:
1006: TYPE PAYMENT_TERM_ID_LIST_TYPE IS TABLE OF
1007: PN_PAYMENT_TERMS.PAYMENT_TERM_ID%TYPE
1008: INDEX BY BINARY_INTEGER;
1009: PRIMARY_KEY_ID_LIST PAYMENT_TERM_ID_LIST_TYPE;
1010:
1011: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 1012: PN_PAYMENT_TERMS.CUSTOMER_ID%TYPE

1008: INDEX BY BINARY_INTEGER;
1009: PRIMARY_KEY_ID_LIST PAYMENT_TERM_ID_LIST_TYPE;
1010:
1011: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
1012: PN_PAYMENT_TERMS.CUSTOMER_ID%TYPE
1013: INDEX BY BINARY_INTEGER;
1014: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
1015: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
1016:

Line 1018: PN_PAYMENT_TERMS.CUSTOMER_SITE_USE_ID%TYPE

1014: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
1015: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
1016:
1017: TYPE CUSTOMER_SITE_USE_ID_LIST_TYPE IS TABLE OF
1018: PN_PAYMENT_TERMS.CUSTOMER_SITE_USE_ID%TYPE
1019: INDEX BY BINARY_INTEGER;
1020: NUM_COL2_ORIG_LIST CUSTOMER_SITE_USE_ID_LIST_TYPE;
1021: NUM_COL2_NEW_LIST CUSTOMER_SITE_USE_ID_LIST_TYPE;
1022:

Line 1024: PN_PAYMENT_TERMS.CUST_SHIP_SITE_ID%TYPE

1020: NUM_COL2_ORIG_LIST CUSTOMER_SITE_USE_ID_LIST_TYPE;
1021: NUM_COL2_NEW_LIST CUSTOMER_SITE_USE_ID_LIST_TYPE;
1022:
1023: TYPE CUST_SHIP_SITE_ID_LIST_TYPE IS TABLE OF
1024: PN_PAYMENT_TERMS.CUST_SHIP_SITE_ID%TYPE
1025: INDEX BY BINARY_INTEGER;
1026: NUM_COL3_ORIG_LIST CUST_SHIP_SITE_ID_LIST_TYPE;
1027: NUM_COL3_NEW_LIST CUST_SHIP_SITE_ID_LIST_TYPE;
1028:

Line 1037: FROM PN_PAYMENT_TERMS yt,

1033: ,yt.PAYMENT_TERM_ID
1034: ,yt.CUSTOMER_ID
1035: ,yt.CUSTOMER_SITE_USE_ID
1036: ,yt.CUST_SHIP_SITE_ID
1037: FROM PN_PAYMENT_TERMS yt,
1038: RA_CUSTOMER_MERGES m
1039: WHERE ( yt.CUSTOMER_ID = m.DUPLICATE_ID
1040: OR yt.CUSTOMER_SITE_USE_ID = m.DUPLICATE_SITE_ID
1041: OR yt.CUST_SHIP_SITE_ID = m.DUPLICATE_SITE_ID)

Line 1057: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_PAYMENT_TERMS',FALSE);

1053: IF process_mode='LOCK' THEN
1054: NULL;
1055: ELSE
1056: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1057: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_PAYMENT_TERMS',FALSE);
1058: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1059: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1060:
1061: OPEN merged_records;

Line 1108: 'PN_PAYMENT_TERMS',

1104: LAST_UPDATE_DATE,
1105: LAST_UPDATED_BY
1106: ) VALUES (
1107: HZ_CUSTOMER_MERGE_LOG_s.NEXTVAL,
1108: 'PN_PAYMENT_TERMS',
1109: MERGE_HEADER_ID_LIST(I),
1110: PRIMARY_KEY_ID_LIST(I),
1111: NUM_COL1_ORIG_LIST(I),
1112: NUM_COL1_NEW_LIST(I),

Line 1129: UPDATE PN_PAYMENT_TERMS yt SET

1125:
1126: END IF;
1127:
1128: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1129: UPDATE PN_PAYMENT_TERMS yt SET
1130: CUSTOMER_ID = NUM_COL1_NEW_LIST(I)
1131: , CUSTOMER_SITE_USE_ID= NUM_COL2_NEW_LIST(I)
1132: , CUST_SHIP_SITE_ID = NUM_COL3_NEW_LIST(I)
1133: , LAST_UPDATE_DATE = SYSDATE