APPS.PNP_CMERGE dependencies on PN_PAYMENT_ITEMS

Line 70: FROM pn_payment_items

66: FOR UPDATE NOWAIT;
67: /* Lock Items */
68: CURSOR pmt_items IS
69: SELECT payment_item_id
70: FROM pn_payment_items
71: WHERE customer_id IN (SELECT racm.duplicate_id
72: FROM ra_customer_merges racm
73: WHERE racm.process_flag = 'N'
74: AND racm.request_id = req_id

Line 181: arp_message.set_token( 'TABLE_NAME', 'PN_PAYMENT_ITEMS', FALSE );

177: CLOSE pmt_terms;
178:
179: /* Lock Items */
180: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
181: arp_message.set_token( 'TABLE_NAME', 'PN_PAYMENT_ITEMS', FALSE );
182:
183: OPEN pmt_items;
184: CLOSE pmt_items;
185:

Line 1160: | Account merge procedure for the table, pn_payment_items_all

1156: | PROCEDURE
1157: | update_payment_items
1158: |
1159: | DESCRIPTION
1160: | Account merge procedure for the table, pn_payment_items_all
1161: | Column updated Corresponding HZ table.column
1162: | -------------------- -----------------------------
1163: | customer_id HZ_CUST_ACCOUNTS.cust_account_id
1164: | customer_site_use_id HZ_CUST_SITE_USES.site_use_id

Line 1192: PN_PAYMENT_ITEMS.PAYMENT_ITEM_ID%TYPE

1188: INDEX BY BINARY_INTEGER;
1189: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1190:
1191: TYPE PAYMENT_ITEM_ID_LIST_TYPE IS TABLE OF
1192: PN_PAYMENT_ITEMS.PAYMENT_ITEM_ID%TYPE
1193: INDEX BY BINARY_INTEGER;
1194: PRIMARY_KEY_ID_LIST PAYMENT_ITEM_ID_LIST_TYPE;
1195:
1196: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 1197: PN_PAYMENT_ITEMS.CUSTOMER_ID%TYPE

1193: INDEX BY BINARY_INTEGER;
1194: PRIMARY_KEY_ID_LIST PAYMENT_ITEM_ID_LIST_TYPE;
1195:
1196: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
1197: PN_PAYMENT_ITEMS.CUSTOMER_ID%TYPE
1198: INDEX BY BINARY_INTEGER;
1199: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
1200: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
1201:

Line 1203: PN_PAYMENT_ITEMS.CUSTOMER_SITE_USE_ID%TYPE

1199: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
1200: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
1201:
1202: TYPE CUSTOMER_SITE_USE_ID_LIST_TYPE IS TABLE OF
1203: PN_PAYMENT_ITEMS.CUSTOMER_SITE_USE_ID%TYPE
1204: INDEX BY BINARY_INTEGER;
1205: NUM_COL2_ORIG_LIST CUSTOMER_SITE_USE_ID_LIST_TYPE;
1206: NUM_COL2_NEW_LIST CUSTOMER_SITE_USE_ID_LIST_TYPE;
1207:

Line 1209: PN_PAYMENT_ITEMS.CUST_SHIP_SITE_ID%TYPE

1205: NUM_COL2_ORIG_LIST CUSTOMER_SITE_USE_ID_LIST_TYPE;
1206: NUM_COL2_NEW_LIST CUSTOMER_SITE_USE_ID_LIST_TYPE;
1207:
1208: TYPE CUST_SHIP_SITE_ID_LIST_TYPE IS TABLE OF
1209: PN_PAYMENT_ITEMS.CUST_SHIP_SITE_ID%TYPE
1210: INDEX BY BINARY_INTEGER;
1211: NUM_COL3_ORIG_LIST CUST_SHIP_SITE_ID_LIST_TYPE;
1212: NUM_COL3_NEW_LIST CUST_SHIP_SITE_ID_LIST_TYPE;
1213:

Line 1221: FROM PN_PAYMENT_ITEMS yt

1217: ,yt.PAYMENT_ITEM_ID
1218: ,yt.CUSTOMER_ID
1219: ,yt.CUSTOMER_SITE_USE_ID
1220: ,yt.CUST_SHIP_SITE_ID
1221: FROM PN_PAYMENT_ITEMS yt
1222: ,RA_CUSTOMER_MERGES m
1223: WHERE ( yt.CUSTOMER_ID = m.DUPLICATE_ID
1224: OR yt.CUSTOMER_SITE_USE_ID = m.DUPLICATE_SITE_ID
1225: OR yt.CUST_SHIP_SITE_ID = m.DUPLICATE_SITE_ID )

Line 1242: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_PAYMENT_ITEMS',FALSE);

1238: IF process_mode='LOCK' THEN
1239: NULL;
1240: ELSE
1241: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1242: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PN_PAYMENT_ITEMS',FALSE);
1243: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1244: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1245:
1246: OPEN merged_records;

Line 1294: 'PN_PAYMENT_ITEMS',

1290: LAST_UPDATE_DATE,
1291: LAST_UPDATED_BY
1292: ) VALUES (
1293: HZ_CUSTOMER_MERGE_LOG_s.NEXTVAL,
1294: 'PN_PAYMENT_ITEMS',
1295: MERGE_HEADER_ID_LIST(I),
1296: PRIMARY_KEY_ID_LIST(I),
1297: NUM_COL1_ORIG_LIST(I),
1298: NUM_COL1_NEW_LIST(I),

Line 1315: UPDATE PN_PAYMENT_ITEMS yt SET

1311:
1312: END IF;
1313:
1314: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1315: UPDATE PN_PAYMENT_ITEMS yt SET
1316: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
1317: , CUSTOMER_SITE_USE_ID=NUM_COL2_NEW_LIST(I)
1318: , CUST_SHIP_SITE_ID=NUM_COL3_NEW_LIST(I)
1319: , LAST_UPDATE_DATE=SYSDATE