DBA Data[Home] [Help]

APPS.AP_ETAX_SERVICES_PKG dependencies on AP_APPROVAL_PKG

Line 247: l_validation_request_id := ap_approval_pkg.g_validation_request_id;

243: Print(l_api_name,'AP_ETAX_SERVICES_PKG.Calculate (+)');
244:
245: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Calculate<-' || P_calling_sequence;
246:
247: l_validation_request_id := ap_approval_pkg.g_validation_request_id;
248:
249: g_invoices_to_process := 0;
250:
251: IF l_validation_request_id IS NOT NULL THEN

Line 411: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NOT NULL THEN

407: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,
408: AP_ETAX_PKG.G_EVNT_CLS_LIST
409: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
410:
411: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NOT NULL THEN
412: EXIT WHEN (C_SELECTED_INVOICES%NOTFOUND
413: AND AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0);
414: ELSE
415: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;

Line 751: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NOT NULL THEN

747: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,
748: AP_ETAX_PKG.G_EVNT_CLS_LIST
749: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
750:
751: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NOT NULL THEN
752: EXIT WHEN (C_SELECTED_INVOICES%NOTFOUND
753: AND AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0);
754: ELSE
755: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;

Line 1285: IF ap_approval_pkg.g_validation_request_id IS NULL THEN

1281:
1282: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Distribute<-' ||
1283: P_calling_sequence;
1284:
1285: IF ap_approval_pkg.g_validation_request_id IS NULL THEN
1286:
1287: DELETE FROM ZX_TRX_HEADERS_GT;
1288:
1289: -----------------------------------------------------------------

Line 1341: p_validation_request_id => ap_approval_pkg.g_validation_request_id,

1337: l_debug_info := 'Batch: Bulk Populate Header';
1338: Print(l_api_name,l_debug_info);
1339: -----------------------------------------------------------------
1340: IF NOT AP_ETAX_SERVICES_PKG.Bulk_Populate_Headers_GT(
1341: p_validation_request_id => ap_approval_pkg.g_validation_request_id,
1342: p_calling_mode => p_calling_mode,
1343: p_error_code => p_error_code) THEN
1344:
1345: l_return_status := FALSE;

Line 1367: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NOT NULL THEN

1363: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,
1364: AP_ETAX_PKG.G_EVNT_CLS_LIST
1365: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
1366:
1367: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NOT NULL THEN
1368: EXIT WHEN (C_SELECTED_INVOICES%NOTFOUND
1369: AND AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0);
1370: ELSE
1371: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;

Line 1377: IF ap_approval_pkg.g_validation_request_id IS NOT NULL THEN

1373:
1374: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST.. AP_ETAX_PKG.G_INV_ID_LIST.LAST
1375: LOOP
1376:
1377: IF ap_approval_pkg.g_validation_request_id IS NOT NULL THEN
1378:
1379: OPEN Invoice_Header(ap_etax_pkg.g_inv_id_list(i));
1380: FETCH Invoice_Header INTO l_inv_header_rec;
1381: CLOSE Invoice_Header;

Line 1626: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NOT NULL THEN

1622: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,
1623: AP_ETAX_PKG.G_EVNT_CLS_LIST
1624: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
1625:
1626: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NOT NULL THEN
1627: EXIT WHEN (C_SELECTED_INVOICES%NOTFOUND
1628: AND AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0);
1629: ELSE
1630: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;

Line 1635: IF ap_approval_pkg.g_validation_request_id IS NOT NULL THEN

1631: END IF;
1632:
1633: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST.. AP_ETAX_PKG.G_INV_ID_LIST.LAST
1634: LOOP
1635: IF ap_approval_pkg.g_validation_request_id IS NOT NULL THEN
1636: OPEN Invoice_Header (ap_etax_pkg.g_inv_id_list(i));
1637: FETCH Invoice_Header
1638: INTO l_inv_header_rec;
1639: CLOSE Invoice_Header;

Line 4684: l_holds AP_APPROVAL_PKG.HOLDSARRAY;

4680: l_api_name varchar2(30);
4681: --Bug 7410237 start
4682: l_system_user NUMBER := 5;
4683:
4684: l_holds AP_APPROVAL_PKG.HOLDSARRAY;
4685: l_hold_count AP_APPROVAL_PKG.COUNTARRAY;
4686: l_release_count AP_APPROVAL_PKG.COUNTARRAY;
4687: --Bug 7410237 End
4688:

Line 4685: l_hold_count AP_APPROVAL_PKG.COUNTARRAY;

4681: --Bug 7410237 start
4682: l_system_user NUMBER := 5;
4683:
4684: l_holds AP_APPROVAL_PKG.HOLDSARRAY;
4685: l_hold_count AP_APPROVAL_PKG.COUNTARRAY;
4686: l_release_count AP_APPROVAL_PKG.COUNTARRAY;
4687: --Bug 7410237 End
4688:
4689:

Line 4686: l_release_count AP_APPROVAL_PKG.COUNTARRAY;

4682: l_system_user NUMBER := 5;
4683:
4684: l_holds AP_APPROVAL_PKG.HOLDSARRAY;
4685: l_hold_count AP_APPROVAL_PKG.COUNTARRAY;
4686: l_release_count AP_APPROVAL_PKG.COUNTARRAY;
4687: --Bug 7410237 End
4688:
4689:
4690: BEGIN

Line 4836: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

4832: X_held_by => NULL,
4833: X_calling_sequence => l_curr_calling_sequence);
4834: */
4835:
4836: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
4837: p_invoice_id => l_inv_header_rec.invoice_id,
4838: p_line_location_id => NULL,
4839: p_rcv_transaction_id => NULL,
4840: p_hold_lookup_code => l_hold_lookup_code(i),

Line 4878: AP_APPROVAL_PKG.Process_Inv_Hold_Status(

4874: X_hold_reason => NULL,
4875: X_held_by => l_user_id,
4876: X_calling_sequence => l_curr_calling_sequence);
4877: */
4878: AP_APPROVAL_PKG.Process_Inv_Hold_Status(
4879: p_invoice_id => l_inv_header_rec.invoice_id,
4880: p_line_location_id => NULL,
4881: p_rcv_transaction_id => NULL,
4882: p_hold_lookup_code => l_hold_codes_tab(i),