APPS.PAP_CMERGE dependencies on PA_DRAFT_INVOICE_ITEMS

Line 125: SELECT SHIP_TO_ADDRESS_ID FROM pa_draft_invoice_items PDII

121: AND RACM.SET_NUMBER = set_no )
122: FOR UPDATE NOWAIT;
123: --
124: CURSOR cursor_lock_2 IS
125: SELECT SHIP_TO_ADDRESS_ID FROM pa_draft_invoice_items PDII
126: WHERE
127: PDII.SHIP_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
128: FROM RA_CUSTOMER_MERGES RACM
129: WHERE RACM.PROCESS_FLAG = 'N'

Line 239: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_DRAFT_INVOICE_ITEMS', FALSE );

235: open cursor_lock_1;
236: close cursor_lock_1;
237: --
238: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
239: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_DRAFT_INVOICE_ITEMS', FALSE );
240: --
241: open cursor_lock_2;
242: close cursor_lock_2;
243: --

Line 1214: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_DRAFT_INVOICE_ITEMS' );

1210: AND RACM.SET_NUMBER = set_no
1211: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' );
1212:
1213: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1214: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_DRAFT_INVOICE_ITEMS' );
1215: --
1216: -- update pa_draft_invoice_items for ship_to_address_id only.
1217: --
1218: IF g_audit_profile='Y' THEN

Line 1216: -- update pa_draft_invoice_items for ship_to_address_id only.

1212:
1213: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1214: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_DRAFT_INVOICE_ITEMS' );
1215: --
1216: -- update pa_draft_invoice_items for ship_to_address_id only.
1217: --
1218: IF g_audit_profile='Y' THEN
1219:
1220: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1237: 'PA_DRAFT_INVOICE_ITEMS',

1233: LAST_UPDATE_LOGIN,
1234: LAST_UPDATE_DATE,
1235: LAST_UPDATED_BY)
1236: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1237: 'PA_DRAFT_INVOICE_ITEMS',
1238: RACM.CUSTOMER_MERGE_HEADER_ID,
1239: PDII.project_id,
1240: PDII.draft_invoice_num,
1241: PDII.line_num,

Line 1251: FROM PA_DRAFT_INVOICE_ITEMS PDII, ra_customer_merges RACM

1247: hz_utility_pub.CREATION_DATE,
1248: hz_utility_pub.LAST_UPDATE_LOGIN,
1249: hz_utility_pub.LAST_UPDATE_DATE,
1250: hz_utility_pub.LAST_UPDATED_BY
1251: FROM PA_DRAFT_INVOICE_ITEMS PDII, ra_customer_merges RACM
1252: WHERE RACM.DUPLICATE_ADDRESS_ID = PDII.SHIP_TO_ADDRESS_ID
1253: AND RACM.PROCESS_FLAG = 'N'
1254: AND RACM.SET_NUMBER = set_no
1255: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO');

Line 1259: UPDATE pa_draft_invoice_items PDII

1255: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO');
1256:
1257: END IF;
1258:
1259: UPDATE pa_draft_invoice_items PDII
1260: SET ( SHIP_TO_ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
1261: FROM RA_CUSTOMER_MERGES RACM
1262: WHERE
1263: RACM.DUPLICATE_ADDRESS_ID = PDII.SHIP_TO_ADDRESS_ID