DBA Data[Home] [Help]

APPS.AP_IMPORT_UTILITIES_PKG dependencies on AP_BATCHES_ALL

Line 1376: FROM ap_batches_all

1372: SELECT 'OLD BATCH',
1373: batch_id
1374: INTO p_batch_type,
1375: l_batch_id
1376: FROM ap_batches_all
1377: WHERE batch_name = P_batch_name;
1378:
1379: EXCEPTION
1380: WHEN NO_DATA_FOUND THEN

Line 4194: -- bug 5441261. Insert should be into AP_BATCHES_ALL

4190: ---------------------------------------------
4191: -- Insert ap_batches
4192: ---------------------------------------------
4193: debug_info := 'Insert ap_batches';
4194: -- bug 5441261. Insert should be into AP_BATCHES_ALL
4195: INSERT INTO ap_batches_all(
4196: batch_id,
4197: batch_name,
4198: batch_date,

Line 4195: INSERT INTO ap_batches_all(

4191: -- Insert ap_batches
4192: ---------------------------------------------
4193: debug_info := 'Insert ap_batches';
4194: -- bug 5441261. Insert should be into AP_BATCHES_ALL
4195: INSERT INTO ap_batches_all(
4196: batch_id,
4197: batch_name,
4198: batch_date,
4199: last_update_date,

Line 4271: UPDATE ap_batches_all --Bug 8419706 Changed the table ap_batches to ap_batches_all

4267: -- Update ap_batches
4268:
4269: debug_info :='Update ap_batches';
4270:
4271: UPDATE ap_batches_all --Bug 8419706 Changed the table ap_batches to ap_batches_all
4272: -- as the update is not taking place, since org_id is updated
4273: -- as null in ap_batches_all during insertion of data.
4274: SET control_invoice_count =
4275: NVL(control_invoice_count,0)+

Line 4273: -- as null in ap_batches_all during insertion of data.

4269: debug_info :='Update ap_batches';
4270:
4271: UPDATE ap_batches_all --Bug 8419706 Changed the table ap_batches to ap_batches_all
4272: -- as the update is not taking place, since org_id is updated
4273: -- as null in ap_batches_all during insertion of data.
4274: SET control_invoice_count =
4275: NVL(control_invoice_count,0)+
4276: p_actual_invoice_count,
4277: control_invoice_total =