APPS.PAP_CMERGE dependencies on PA_DRAFT_INVOICE_ITEMS

Line 93: SELECT SHIP_TO_ADDRESS_ID FROM pa_draft_invoice_items PDII

89: AND RACM.SET_NUMBER = set_no )
90: FOR UPDATE NOWAIT;
91: --
92: CURSOR cursor_lock_2 IS
93: SELECT SHIP_TO_ADDRESS_ID FROM pa_draft_invoice_items PDII
94: WHERE
95: PDII.SHIP_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
96: FROM RA_CUSTOMER_MERGES RACM
97: WHERE RACM.PROCESS_FLAG = 'N'

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

203: open cursor_lock_1;
204: close cursor_lock_1;
205: --
206: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
207: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_DRAFT_INVOICE_ITEMS', FALSE );
208: --
209: open cursor_lock_2;
210: close cursor_lock_2;
211: --

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

1172: AND RACM.SET_NUMBER = set_no
1173: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' );
1174:
1175: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1176: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_DRAFT_INVOICE_ITEMS' );
1177: --
1178: -- update pa_draft_invoice_items for ship_to_address_id only.
1179: --
1180: IF g_audit_profile='Y' THEN

Line 1178: -- update pa_draft_invoice_items for ship_to_address_id only.

1174:
1175: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1176: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_DRAFT_INVOICE_ITEMS' );
1177: --
1178: -- update pa_draft_invoice_items for ship_to_address_id only.
1179: --
1180: IF g_audit_profile='Y' THEN
1181:
1182: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1199: 'PA_DRAFT_INVOICE_ITEMS',

1195: LAST_UPDATE_LOGIN,
1196: LAST_UPDATE_DATE,
1197: LAST_UPDATED_BY)
1198: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1199: 'PA_DRAFT_INVOICE_ITEMS',
1200: RACM.CUSTOMER_MERGE_HEADER_ID,
1201: PDII.project_id,
1202: PDII.draft_invoice_num,
1203: PDII.line_num,

Line 1213: FROM PA_DRAFT_INVOICE_ITEMS PDII, ra_customer_merges RACM

1209: hz_utility_pub.CREATION_DATE,
1210: hz_utility_pub.LAST_UPDATE_LOGIN,
1211: hz_utility_pub.LAST_UPDATE_DATE,
1212: hz_utility_pub.LAST_UPDATED_BY
1213: FROM PA_DRAFT_INVOICE_ITEMS PDII, ra_customer_merges RACM
1214: WHERE RACM.DUPLICATE_ADDRESS_ID = PDII.SHIP_TO_ADDRESS_ID
1215: AND RACM.PROCESS_FLAG = 'N'
1216: AND RACM.SET_NUMBER = set_no
1217: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO');

Line 1221: UPDATE pa_draft_invoice_items PDII

1217: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO');
1218:
1219: END IF;
1220:
1221: UPDATE pa_draft_invoice_items PDII
1222: SET ( SHIP_TO_ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
1223: FROM RA_CUSTOMER_MERGES RACM
1224: WHERE
1225: RACM.DUPLICATE_ADDRESS_ID = PDII.SHIP_TO_ADDRESS_ID