eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_ETAX_SERVICES_PKG dependencies on AP_ETAX_PKG

Line 232: WHERE application_id = ap_etax_pkg.ap_application_id

228:
229: CURSOR c_selected_invoices IS
230: SELECT trx_id, event_class_code
231: FROM zx_trx_headers_gt
232: WHERE application_id = ap_etax_pkg.ap_application_id
233: AND entity_code = ap_etax_pkg.ap_entity_code
234: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
235: ap_etax_pkg.ap_pp_event_class_code,
236: ap_etax_pkg.ap_er_event_class_code);

Line 233: AND entity_code = ap_etax_pkg.ap_entity_code

229: CURSOR c_selected_invoices IS
230: SELECT trx_id, event_class_code
231: FROM zx_trx_headers_gt
232: WHERE application_id = ap_etax_pkg.ap_application_id
233: AND entity_code = ap_etax_pkg.ap_entity_code
234: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
235: ap_etax_pkg.ap_pp_event_class_code,
236: ap_etax_pkg.ap_er_event_class_code);
237:

Line 234: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,

230: SELECT trx_id, event_class_code
231: FROM zx_trx_headers_gt
232: WHERE application_id = ap_etax_pkg.ap_application_id
233: AND entity_code = ap_etax_pkg.ap_entity_code
234: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
235: ap_etax_pkg.ap_pp_event_class_code,
236: ap_etax_pkg.ap_er_event_class_code);
237:
238: --6922266

Line 235: ap_etax_pkg.ap_pp_event_class_code,

231: FROM zx_trx_headers_gt
232: WHERE application_id = ap_etax_pkg.ap_application_id
233: AND entity_code = ap_etax_pkg.ap_entity_code
234: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
235: ap_etax_pkg.ap_pp_event_class_code,
236: ap_etax_pkg.ap_er_event_class_code);
237:
238: --6922266
239: l_count NUMBER;

Line 236: ap_etax_pkg.ap_er_event_class_code);

232: WHERE application_id = ap_etax_pkg.ap_application_id
233: AND entity_code = ap_etax_pkg.ap_entity_code
234: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
235: ap_etax_pkg.ap_pp_event_class_code,
236: ap_etax_pkg.ap_er_event_class_code);
237:
238: --6922266
239: l_count NUMBER;
240:

Line 344: ap_etax_pkg.g_inv_id_list(1) := l_inv_header_rec.invoice_id;

340:
341: l_return_status := FALSE;
342: END IF;
343:
344: ap_etax_pkg.g_inv_id_list(1) := l_inv_header_rec.invoice_id;
345:
346: END IF;
347:
348: IF g_invoices_to_process = 0 THEN

Line 407: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,

403:
404: OPEN C_SELECTED_INVOICES;
405: LOOP
406: FETCH C_SELECTED_INVOICES
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

Line 408: AP_ETAX_PKG.G_EVNT_CLS_LIST

404: OPEN C_SELECTED_INVOICES;
405: LOOP
406: FETCH C_SELECTED_INVOICES
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

Line 409: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

405: LOOP
406: FETCH C_SELECTED_INVOICES
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);

Line 413: AND AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0);

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;
416: END IF;
417:

Line 415: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;

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;
416: END IF;
417:
418: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST.. AP_ETAX_PKG.G_INV_ID_LIST.LAST
419: LOOP

Line 418: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST.. AP_ETAX_PKG.G_INV_ID_LIST.LAST

414: ELSE
415: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;
416: END IF;
417:
418: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST.. AP_ETAX_PKG.G_INV_ID_LIST.LAST
419: LOOP
420:
421: IF l_validation_request_id IS NOT NULL THEN
422: -----------------------------------------------------------------

Line 426: OPEN Invoice_Header(ap_etax_pkg.g_inv_id_list(i));

422: -----------------------------------------------------------------
423: l_debug_info := 'Collect Invoice Header Details';
424: Print(l_api_name,l_debug_info);
425: -----------------------------------------------------------------
426: OPEN Invoice_Header(ap_etax_pkg.g_inv_id_list(i));
427: FETCH Invoice_Header INTO l_inv_header_rec;
428: CLOSE Invoice_Header;
429: l_inv_header_rec2:=l_inv_header_rec; ---for bug 6064593
430: -----------------------------------------------------------------

Line 434: l_event_class_code := ap_etax_pkg.g_evnt_cls_list(i);

430: -----------------------------------------------------------------
431: l_debug_info := 'Get event class code';
432: Print(l_api_name,l_debug_info);
433: -----------------------------------------------------------------
434: l_event_class_code := ap_etax_pkg.g_evnt_cls_list(i);
435:
436: ELSE
437: ap_etax_pkg.g_inv_id_list(1) := l_inv_header_rec.invoice_id;
438: l_inv_header_rec2:=l_inv_header_rec; ---for bug 6064593

Line 437: ap_etax_pkg.g_inv_id_list(1) := l_inv_header_rec.invoice_id;

433: -----------------------------------------------------------------
434: l_event_class_code := ap_etax_pkg.g_evnt_cls_list(i);
435:
436: ELSE
437: ap_etax_pkg.g_inv_id_list(1) := l_inv_header_rec.invoice_id;
438: l_inv_header_rec2:=l_inv_header_rec; ---for bug 6064593
439:
440: END IF;
441:

Line 468: OPEN Tax_Lines_to_Import (ap_etax_pkg.g_inv_id_list(i));

464: l_debug_info := 'Populate invoice tax lines collection';
465: Print(l_api_name,l_debug_info);
466: -----------------------------------------------------------------
467: BEGIN
468: OPEN Tax_Lines_to_Import (ap_etax_pkg.g_inv_id_list(i));
469: FETCH Tax_Lines_to_Import
470: BULK COLLECT INTO l_inv_tax_list;
471: CLOSE Tax_Lines_to_Import;
472: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 522: OPEN Invoice_Lines (ap_etax_pkg.g_inv_id_list(i));

518: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
519: END;
520: ELSE
521: BEGIN
522: OPEN Invoice_Lines (ap_etax_pkg.g_inv_id_list(i));
523: FETCH Invoice_Lines
524: BULK COLLECT INTO l_inv_line_list;
525: CLOSE Invoice_Lines;
526: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 665: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

661: l_debug_info := 'No invoice lines to be processed for Invoice Id '||l_inv_header_rec.invoice_id;
662: Print(l_api_name,l_debug_info);
663: -----------------------------------------------------------------
664: DELETE FROM zx_trx_headers_gt
665: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
666: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
667: AND event_class_code IN
668: (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
669: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

Line 666: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

662: Print(l_api_name,l_debug_info);
663: -----------------------------------------------------------------
664: DELETE FROM zx_trx_headers_gt
665: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
666: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
667: AND event_class_code IN
668: (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
669: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
670: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 668: (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

664: DELETE FROM zx_trx_headers_gt
665: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
666: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
667: AND event_class_code IN
668: (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
669: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
670: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
671: AND trx_id = l_inv_header_rec.invoice_id;
672:

Line 669: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

665: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
666: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
667: AND event_class_code IN
668: (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
669: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
670: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
671: AND trx_id = l_inv_header_rec.invoice_id;
672:
673: If l_validation_request_id IS NULL THEN

Line 670: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

666: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
667: AND event_class_code IN
668: (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
669: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
670: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
671: AND trx_id = l_inv_header_rec.invoice_id;
672:
673: If l_validation_request_id IS NULL THEN
674: -----------------------------------------------------------------

Line 696: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;

692: END IF;
693:
694: --Bug7136832
695:
696: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
697: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
698: END LOOP;
699: CLOSE C_SELECTED_INVOICES;
700:

Line 697: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;

693:
694: --Bug7136832
695:
696: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
697: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
698: END LOOP;
699: CLOSE C_SELECTED_INVOICES;
700:
701: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;

Line 701: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;

697: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
698: END LOOP;
699: CLOSE C_SELECTED_INVOICES;
700:
701: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
702: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
703:
704:
705: IF (l_Inv_Rcv_Matched = 'Y' OR l_no_tax_lines = 'Y') THEN

Line 702: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;

698: END LOOP;
699: CLOSE C_SELECTED_INVOICES;
700:
701: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
702: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
703:
704:
705: IF (l_Inv_Rcv_Matched = 'Y' OR l_no_tax_lines = 'Y') THEN
706:

Line 747: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,

743: -----------------------------------------------------------------
744: OPEN C_SELECTED_INVOICES;
745: LOOP
746: FETCH C_SELECTED_INVOICES
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

Line 748: AP_ETAX_PKG.G_EVNT_CLS_LIST

744: OPEN C_SELECTED_INVOICES;
745: LOOP
746: FETCH C_SELECTED_INVOICES
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

Line 749: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

745: LOOP
746: FETCH C_SELECTED_INVOICES
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);

Line 753: AND AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0);

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;
756: END IF;
757:

Line 755: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;

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;
756: END IF;
757:
758: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST..AP_ETAX_PKG.G_INV_ID_LIST.LAST
759: LOOP

Line 758: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST..AP_ETAX_PKG.G_INV_ID_LIST.LAST

754: ELSE
755: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;
756: END IF;
757:
758: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST..AP_ETAX_PKG.G_INV_ID_LIST.LAST
759: LOOP
760: OPEN Invoice_Header(ap_etax_pkg.g_inv_id_list(i));
761: FETCH Invoice_Header INTO l_inv_header_rec;
762: CLOSE Invoice_Header;

Line 760: OPEN Invoice_Header(ap_etax_pkg.g_inv_id_list(i));

756: END IF;
757:
758: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST..AP_ETAX_PKG.G_INV_ID_LIST.LAST
759: LOOP
760: OPEN Invoice_Header(ap_etax_pkg.g_inv_id_list(i));
761: FETCH Invoice_Header INTO l_inv_header_rec;
762: CLOSE Invoice_Header;
763:
764: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(

Line 775: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;

771:
772: l_return_status := FALSE;
773: END IF;
774: END LOOP;
775: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
776: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
777: END LOOP;
778: CLOSE C_SELECTED_INVOICES;
779:

Line 776: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;

772: l_return_status := FALSE;
773: END IF;
774: END LOOP;
775: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
776: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
777: END LOOP;
778: CLOSE C_SELECTED_INVOICES;
779:
780: ELSE

Line 797: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;

793: NULL;
794: END IF;
795: END IF;
796:
797: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
798: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
799:
800: RETURN l_return_status;
801:

Line 798: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;

794: END IF;
795: END IF;
796:
797: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
798: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
799:
800: RETURN l_return_status;
801:
802: EXCEPTION

Line 905: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

901: Print(l_api_name, l_debug_info);
902: -----------------------------------------------------------------
903: UPDATE zx_trx_headers_gt
904: SET trx_id = P_Invoice_Id
905: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
906: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
907: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
908: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
909: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 906: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

902: -----------------------------------------------------------------
903: UPDATE zx_trx_headers_gt
904: SET trx_id = P_Invoice_Id
905: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
906: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
907: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
908: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
909: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
910: AND trx_id = P_Interface_Invoice_Id;

Line 907: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

903: UPDATE zx_trx_headers_gt
904: SET trx_id = P_Invoice_Id
905: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
906: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
907: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
908: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
909: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
910: AND trx_id = P_Interface_Invoice_Id;
911:

Line 908: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

904: SET trx_id = P_Invoice_Id
905: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
906: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
907: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
908: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
909: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
910: AND trx_id = P_Interface_Invoice_Id;
911:
912:

Line 909: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

905: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
906: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
907: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
908: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
909: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
910: AND trx_id = P_Interface_Invoice_Id;
911:
912:
913: IF SQL%ROWCOUNT = 0 THEN

Line 1005: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

1001: l_debug_info := 'Step 3: Update trx_id in Lines';
1002: -----------------------------------------------------------------
1003: UPDATE zx_transaction_lines_gt
1004: SET trx_id = P_Invoice_Id
1005: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1006: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1007: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1008: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1009: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 1006: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

1002: -----------------------------------------------------------------
1003: UPDATE zx_transaction_lines_gt
1004: SET trx_id = P_Invoice_Id
1005: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1006: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1007: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1008: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1009: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1010: AND trx_id = P_Interface_Invoice_Id;

Line 1007: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

1003: UPDATE zx_transaction_lines_gt
1004: SET trx_id = P_Invoice_Id
1005: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1006: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1007: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1008: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1009: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1010: AND trx_id = P_Interface_Invoice_Id;
1011:

Line 1008: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

1004: SET trx_id = P_Invoice_Id
1005: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1006: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1007: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1008: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1009: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1010: AND trx_id = P_Interface_Invoice_Id;
1011:
1012: END IF;

Line 1009: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

1005: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1006: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1007: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1008: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1009: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1010: AND trx_id = P_Interface_Invoice_Id;
1011:
1012: END IF;
1013:

Line 1250: WHERE application_id = ap_etax_pkg.ap_application_id

1246:
1247: CURSOR c_selected_invoices IS
1248: SELECT trx_id, event_class_code
1249: FROM zx_trx_headers_gt
1250: WHERE application_id = ap_etax_pkg.ap_application_id
1251: AND entity_code = ap_etax_pkg.ap_entity_code
1252: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
1253: ap_etax_pkg.ap_pp_event_class_code,
1254: ap_etax_pkg.ap_er_event_class_code);

Line 1251: AND entity_code = ap_etax_pkg.ap_entity_code

1247: CURSOR c_selected_invoices IS
1248: SELECT trx_id, event_class_code
1249: FROM zx_trx_headers_gt
1250: WHERE application_id = ap_etax_pkg.ap_application_id
1251: AND entity_code = ap_etax_pkg.ap_entity_code
1252: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
1253: ap_etax_pkg.ap_pp_event_class_code,
1254: ap_etax_pkg.ap_er_event_class_code);
1255:

Line 1252: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,

1248: SELECT trx_id, event_class_code
1249: FROM zx_trx_headers_gt
1250: WHERE application_id = ap_etax_pkg.ap_application_id
1251: AND entity_code = ap_etax_pkg.ap_entity_code
1252: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
1253: ap_etax_pkg.ap_pp_event_class_code,
1254: ap_etax_pkg.ap_er_event_class_code);
1255:
1256: --Bug6678578 START

Line 1253: ap_etax_pkg.ap_pp_event_class_code,

1249: FROM zx_trx_headers_gt
1250: WHERE application_id = ap_etax_pkg.ap_application_id
1251: AND entity_code = ap_etax_pkg.ap_entity_code
1252: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
1253: ap_etax_pkg.ap_pp_event_class_code,
1254: ap_etax_pkg.ap_er_event_class_code);
1255:
1256: --Bug6678578 START
1257: CURSOR c_included_tax_amounts (c_invoice_id NUMBER) IS

Line 1254: ap_etax_pkg.ap_er_event_class_code);

1250: WHERE application_id = ap_etax_pkg.ap_application_id
1251: AND entity_code = ap_etax_pkg.ap_entity_code
1252: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
1253: ap_etax_pkg.ap_pp_event_class_code,
1254: ap_etax_pkg.ap_er_event_class_code);
1255:
1256: --Bug6678578 START
1257: CURSOR c_included_tax_amounts (c_invoice_id NUMBER) IS
1258: SELECT amount,

Line 1332: ap_etax_pkg.g_inv_id_list(1) := l_inv_header_rec.invoice_id;

1328:
1329: l_return_status := FALSE;
1330: END IF;
1331:
1332: ap_etax_pkg.g_inv_id_list(1) := l_inv_header_rec.invoice_id;
1333:
1334:
1335: ELSE
1336: -----------------------------------------------------------------

Line 1363: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,

1359:
1360: OPEN C_SELECTED_INVOICES;
1361: LOOP
1362: FETCH C_SELECTED_INVOICES
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

Line 1364: AP_ETAX_PKG.G_EVNT_CLS_LIST

1360: OPEN C_SELECTED_INVOICES;
1361: LOOP
1362: FETCH C_SELECTED_INVOICES
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

Line 1365: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

1361: LOOP
1362: FETCH C_SELECTED_INVOICES
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);

Line 1369: AND AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0);

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;
1372: END IF;
1373:

Line 1371: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;

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;
1372: END IF;
1373:
1374: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST.. AP_ETAX_PKG.G_INV_ID_LIST.LAST
1375: LOOP

Line 1374: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST.. AP_ETAX_PKG.G_INV_ID_LIST.LAST

1370: ELSE
1371: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;
1372: END IF;
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:

Line 1379: OPEN Invoice_Header(ap_etax_pkg.g_inv_id_list(i));

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;
1382:
1383: l_event_class_code := ap_etax_pkg.g_evnt_cls_list(i);

Line 1383: l_event_class_code := ap_etax_pkg.g_evnt_cls_list(i);

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;
1382:
1383: l_event_class_code := ap_etax_pkg.g_evnt_cls_list(i);
1384: --Bug7110987
1385: IF (l_tax_only_invoice = 0) THEN
1386:
1387: SELECT count(1)

Line 1390: WHERE ail.invoice_id = ap_etax_pkg.g_inv_id_list(i)

1386:
1387: SELECT count(1)
1388: INTO l_tax_only_invoice
1389: FROM ap_invoice_lines_all ail
1390: WHERE ail.invoice_id = ap_etax_pkg.g_inv_id_list(i)
1391: AND ail.line_type_lookup_code = 'TAX'
1392: AND NOT EXISTS --To Make Sure We do not call Determine Recovery If we do not have any lines to process
1393: (SELECT 'No Non Tax Line'
1394: FROM ap_invoice_lines_all ail2

Line 1401: ap_etax_pkg.g_inv_id_list(1) := l_inv_header_rec.invoice_id;

1397: END IF;
1398: --Bug7110987
1399: ELSE
1400:
1401: ap_etax_pkg.g_inv_id_list(1) := l_inv_header_rec.invoice_id;
1402: --Bug7110987
1403: IF (l_tax_only_invoice = 0) THEN
1404:
1405: SELECT count(1)

Line 1488: OPEN Invoice_Dists (ap_etax_pkg.g_inv_id_list(i));

1484: AND aid1.line_type_lookup_code IN ('ITEM', 'ACCRUAL', 'FREIGHT', 'MISCELLANEOUS','PREPAY');--/*Bug7338249*/
1485: -- END IF; --Bug6874234
1486: END LOOP;
1487: --Bug6678578END
1488: OPEN Invoice_Dists (ap_etax_pkg.g_inv_id_list(i));
1489: FETCH Invoice_Dists
1490: BULK COLLECT INTO l_inv_dist_list;
1491: CLOSE Invoice_Dists;
1492:

Line 1553: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;

1549: AND AID.recovery_type_code Is Null;
1550: END IF;
1551: END LOOP;
1552:
1553: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
1554: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
1555:
1556: END LOOP;
1557: CLOSE C_SELECTED_INVOICES;

Line 1554: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;

1550: END IF;
1551: END LOOP;
1552:
1553: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
1554: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
1555:
1556: END LOOP;
1557: CLOSE C_SELECTED_INVOICES;
1558:

Line 1622: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,

1618:
1619: OPEN C_SELECTED_INVOICES;
1620: LOOP
1621: FETCH C_SELECTED_INVOICES
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

Line 1623: AP_ETAX_PKG.G_EVNT_CLS_LIST

1619: OPEN C_SELECTED_INVOICES;
1620: LOOP
1621: FETCH C_SELECTED_INVOICES
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

Line 1624: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

1620: LOOP
1621: FETCH C_SELECTED_INVOICES
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);

Line 1628: AND AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0);

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;
1631: END IF;
1632:

Line 1630: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;

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;
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

Line 1633: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST.. AP_ETAX_PKG.G_INV_ID_LIST.LAST

1629: ELSE
1630: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;
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

Line 1636: OPEN Invoice_Header (ap_etax_pkg.g_inv_id_list(i));

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;
1640: END IF;

Line 1656: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;

1652:
1653: l_return_status := FALSE;
1654: END IF;
1655: END LOOP;
1656: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
1657: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
1658: END LOOP;
1659: CLOSE C_SELECTED_INVOICES;
1660:

Line 1657: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;

1653: l_return_status := FALSE;
1654: END IF;
1655: END LOOP;
1656: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
1657: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
1658: END LOOP;
1659: CLOSE C_SELECTED_INVOICES;
1660:
1661: END IF;

Line 1663: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;

1659: CLOSE C_SELECTED_INVOICES;
1660:
1661: END IF;
1662:
1663: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
1664: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
1665:
1666: END IF;
1667:

Line 1664: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;

1660:
1661: END IF;
1662:
1663: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
1664: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
1665:
1666: END IF;
1667:
1668: RETURN l_return_status;

Line 1903: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

1899: -----------------------------------------------------------------
1900: BEGIN
1901: UPDATE zx_trx_headers_gt
1902: SET trx_id = P_Invoice_Id
1903: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1904: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1905: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1906: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1907: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 1904: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

1900: BEGIN
1901: UPDATE zx_trx_headers_gt
1902: SET trx_id = P_Invoice_Id
1903: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1904: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1905: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1906: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1907: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1908: AND trx_id = P_Interface_Invoice_Id;

Line 1905: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

1901: UPDATE zx_trx_headers_gt
1902: SET trx_id = P_Invoice_Id
1903: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1904: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1905: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1906: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1907: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1908: AND trx_id = P_Interface_Invoice_Id;
1909: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 1906: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

1902: SET trx_id = P_Invoice_Id
1903: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1904: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1905: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1906: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1907: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1908: AND trx_id = P_Interface_Invoice_Id;
1909: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
1910: END;

Line 1907: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

1903: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1904: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1905: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1906: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1907: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1908: AND trx_id = P_Interface_Invoice_Id;
1909: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
1910: END;
1911:

Line 2811: l_success := ap_etax_pkg.calling_etax(

2807: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2808: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2809: END IF;
2810: -----------------------------------------------------------------
2811: l_success := ap_etax_pkg.calling_etax(
2812: P_Invoice_id => l_inv_header_rec.invoice_id,
2813: P_Calling_Mode => 'DISTRIBUTE',
2814: P_All_Error_Messages => P_All_Error_Messages,
2815: P_error_code => P_error_code,

Line 2838: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

2834: SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
2835: 'Y', NVL(zls.tax_amt, 0),
2836: 0))
2837: FROM zx_lines_summary zls
2838: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2839: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2840: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2841: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2842: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 2839: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

2835: 'Y', NVL(zls.tax_amt, 0),
2836: 0))
2837: FROM zx_lines_summary zls
2838: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2839: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2840: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2841: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2842: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2843: AND zls.trx_id = ai.invoice_id

Line 2840: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

2836: 0))
2837: FROM zx_lines_summary zls
2838: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2839: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2840: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2841: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2842: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2843: AND zls.trx_id = ai.invoice_id
2844: AND NVL(zls.reporting_only_flag, 'N') = 'N')

Line 2841: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

2837: FROM zx_lines_summary zls
2838: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2839: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2840: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2841: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2842: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2843: AND zls.trx_id = ai.invoice_id
2844: AND NVL(zls.reporting_only_flag, 'N') = 'N')
2845: WHERE ai.invoice_id = l_inv_header_rec.invoice_id;

Line 2842: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

2838: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2839: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2840: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2841: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2842: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2843: AND zls.trx_id = ai.invoice_id
2844: AND NVL(zls.reporting_only_flag, 'N') = 'N')
2845: WHERE ai.invoice_id = l_inv_header_rec.invoice_id;
2846:

Line 3993: l_success := ap_etax_pkg.calling_etax(

3989: AND P_Calling_Mode = 'CANCEL INVOICE'
3990: AND ail.control_amount IS NOT NULL ;
3991:
3992:
3993: l_success := ap_etax_pkg.calling_etax(
3994: p_invoice_id => p_invoice_id,
3995: p_calling_mode => 'CALCULATE',
3996: p_all_error_messages => 'N',
3997: p_error_code => p_error_code,

Line 5272: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

5268: -------------------------------------------------------------------
5269: IF (l_return_status = TRUE) THEN
5270:
5271: DELETE FROM zx_trx_headers_gt
5272: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5273: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5274: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5275: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5276: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 5273: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

5269: IF (l_return_status = TRUE) THEN
5270:
5271: DELETE FROM zx_trx_headers_gt
5272: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5273: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5274: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5275: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5276: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
5277: AND trx_id = p_invoice_header_rec.invoice_id;

Line 5274: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

5270:
5271: DELETE FROM zx_trx_headers_gt
5272: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5273: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5274: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5275: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5276: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
5277: AND trx_id = p_invoice_header_rec.invoice_id;
5278:

Line 5275: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

5271: DELETE FROM zx_trx_headers_gt
5272: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5273: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5274: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5275: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5276: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
5277: AND trx_id = p_invoice_header_rec.invoice_id;
5278:
5279: INSERT INTO zx_trx_headers_gt(

Line 5276: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

5272: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5273: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5274: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5275: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5276: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
5277: AND trx_id = p_invoice_header_rec.invoice_id;
5278:
5279: INSERT INTO zx_trx_headers_gt(
5280: internal_organization_id,

Line 5648: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

5644: -------------------------------------------------------------------
5645: IF (l_return_status = TRUE) THEN
5646:
5647: DELETE FROM zx_trx_headers_gt
5648: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5649: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5650: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5651: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5652: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 5649: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

5645: IF (l_return_status = TRUE) THEN
5646:
5647: DELETE FROM zx_trx_headers_gt
5648: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5649: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5650: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5651: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5652: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
5653: AND trx_id = p_invoice_header_rec.invoice_id;

Line 5650: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

5646:
5647: DELETE FROM zx_trx_headers_gt
5648: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5649: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5650: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5651: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5652: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
5653: AND trx_id = p_invoice_header_rec.invoice_id;
5654:

Line 5651: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

5647: DELETE FROM zx_trx_headers_gt
5648: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5649: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5650: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5651: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5652: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
5653: AND trx_id = p_invoice_header_rec.invoice_id;
5654:
5655: INSERT INTO zx_trx_headers_gt(

Line 5652: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

5648: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5649: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5650: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5651: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
5652: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
5653: AND trx_id = p_invoice_header_rec.invoice_id;
5654:
5655: INSERT INTO zx_trx_headers_gt(
5656: internal_organization_id,

Line 6527: trans_lines(i).application_id := ap_etax_pkg.ap_application_id;

6523: l_debug_info := 'Populate pl/sql table';
6524: -------------------------------------------------------------------
6525: IF (l_return_status = TRUE ) THEN
6526:
6527: trans_lines(i).application_id := ap_etax_pkg.ap_application_id;
6528: trans_lines(i).entity_code := ap_etax_pkg.ap_entity_code;
6529: trans_lines(i).event_class_code := p_event_class_code;
6530:
6531: IF p_calling_mode = 'RECOUPMENT' THEN

Line 6528: trans_lines(i).entity_code := ap_etax_pkg.ap_entity_code;

6524: -------------------------------------------------------------------
6525: IF (l_return_status = TRUE ) THEN
6526:
6527: trans_lines(i).application_id := ap_etax_pkg.ap_application_id;
6528: trans_lines(i).entity_code := ap_etax_pkg.ap_entity_code;
6529: trans_lines(i).event_class_code := p_event_class_code;
6530:
6531: IF p_calling_mode = 'RECOUPMENT' THEN
6532:

Line 7814: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

7810: -------------------------------------------------------------------
7811: IF ( l_return_status = TRUE ) THEN
7812:
7813: DELETE FROM zx_transaction_lines_gt
7814: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
7815: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
7816: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
7817: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
7818: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 7815: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

7811: IF ( l_return_status = TRUE ) THEN
7812:
7813: DELETE FROM zx_transaction_lines_gt
7814: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
7815: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
7816: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
7817: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
7818: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
7819: AND trx_id = p_invoice_header_rec.invoice_id;

Line 7816: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

7812:
7813: DELETE FROM zx_transaction_lines_gt
7814: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
7815: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
7816: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
7817: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
7818: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
7819: AND trx_id = p_invoice_header_rec.invoice_id;
7820:

Line 7817: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

7813: DELETE FROM zx_transaction_lines_gt
7814: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
7815: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
7816: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
7817: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
7818: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
7819: AND trx_id = p_invoice_header_rec.invoice_id;
7820:
7821: IF (trans_lines.COUNT > 0) THEN

Line 7818: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

7814: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
7815: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
7816: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
7817: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
7818: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
7819: AND trx_id = p_invoice_header_rec.invoice_id;
7820:
7821: IF (trans_lines.COUNT > 0) THEN
7822: FORALL m IN trans_lines.FIRST..trans_lines.LAST

Line 8915: trans_dists(i).application_id := AP_ETAX_PKG.AP_APPLICATION_ID;

8911: END IF;
8912: -------------------------------------------------------------------
8913: IF (l_return_status = TRUE) THEN
8914:
8915: trans_dists(i).application_id := AP_ETAX_PKG.AP_APPLICATION_ID;
8916: trans_dists(i).entity_code := AP_ETAX_PKG.AP_ENTITY_CODE;
8917: trans_dists(i).event_class_code := P_event_class_code;
8918: trans_dists(i).trx_id := l_inv_dist_list(i).invoice_id;
8919:

Line 8916: trans_dists(i).entity_code := AP_ETAX_PKG.AP_ENTITY_CODE;

8912: -------------------------------------------------------------------
8913: IF (l_return_status = TRUE) THEN
8914:
8915: trans_dists(i).application_id := AP_ETAX_PKG.AP_APPLICATION_ID;
8916: trans_dists(i).entity_code := AP_ETAX_PKG.AP_ENTITY_CODE;
8917: trans_dists(i).event_class_code := P_event_class_code;
8918: trans_dists(i).trx_id := l_inv_dist_list(i).invoice_id;
8919:
8920: IF p_calling_mode = 'DISTRIBUTE RECOUP' THEN

Line 12201: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

12197: SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
12198: 'Y', NVL(zls.tax_amt, 0),
12199: 0))
12200: FROM zx_lines_summary zls
12201: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
12202: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
12203: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
12204: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
12205: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 12202: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

12198: 'Y', NVL(zls.tax_amt, 0),
12199: 0))
12200: FROM zx_lines_summary zls
12201: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
12202: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
12203: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
12204: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
12205: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
12206: AND zls.trx_id = ai.invoice_id

Line 12203: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

12199: 0))
12200: FROM zx_lines_summary zls
12201: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
12202: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
12203: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
12204: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
12205: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
12206: AND zls.trx_id = ai.invoice_id
12207: AND NVL(zls.reporting_only_flag, 'N') = 'N')

Line 12204: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

12200: FROM zx_lines_summary zls
12201: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
12202: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
12203: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
12204: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
12205: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
12206: AND zls.trx_id = ai.invoice_id
12207: AND NVL(zls.reporting_only_flag, 'N') = 'N')
12208: WHERE ai.invoice_id = p_invoice_id;

Line 12205: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

12201: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
12202: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
12203: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
12204: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
12205: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
12206: AND zls.trx_id = ai.invoice_id
12207: AND NVL(zls.reporting_only_flag, 'N') = 'N')
12208: WHERE ai.invoice_id = p_invoice_id;
12209:

Line 12512: l_return_status := ap_etax_pkg.calling_etax

12508: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
12509: END IF;
12510: -----------------------------------------------------------------
12511:
12512: l_return_status := ap_etax_pkg.calling_etax
12513: (p_invoice_id => p_invoice_id,
12514: p_line_number => p_invoice_line_number,
12515: p_calling_mode => 'DISTRIBUTE RECOUP',
12516: p_all_error_messages => 'N',

Line 12808: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

12804:
12805: SELECT 'Tax Only Line Exist'
12806: INTO l_dummy
12807: FROM zx_lines_summary zls
12808: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
12809: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
12810: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
12811: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
12812: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 12809: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

12805: SELECT 'Tax Only Line Exist'
12806: INTO l_dummy
12807: FROM zx_lines_summary zls
12808: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
12809: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
12810: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
12811: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
12812: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
12813: AND zls.trx_id = p_invoice_id

Line 12810: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

12806: INTO l_dummy
12807: FROM zx_lines_summary zls
12808: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
12809: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
12810: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
12811: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
12812: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
12813: AND zls.trx_id = p_invoice_id
12814: AND NVL(zls.reporting_only_flag, 'N') = 'N'

Line 12811: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

12807: FROM zx_lines_summary zls
12808: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
12809: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
12810: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
12811: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
12812: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
12813: AND zls.trx_id = p_invoice_id
12814: AND NVL(zls.reporting_only_flag, 'N') = 'N'
12815: AND NVL(zls.tax_only_line_flag, 'N') = 'Y'

Line 12812: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

12808: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
12809: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
12810: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
12811: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
12812: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
12813: AND zls.trx_id = p_invoice_id
12814: AND NVL(zls.reporting_only_flag, 'N') = 'N'
12815: AND NVL(zls.tax_only_line_flag, 'N') = 'Y'
12816: AND rownum = 1;

Line 13889: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

13885: SUM(DECODE(NVL(zd.recoverable_flag, 'N'),
13886: 'N', NVL(zd.rec_nrec_tax_amt_funcl_curr, 0),
13887: 0))
13888: FROM zx_rec_nrec_dist zd
13889: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
13890: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
13891: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
13892: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
13893: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 13890: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

13886: 'N', NVL(zd.rec_nrec_tax_amt_funcl_curr, 0),
13887: 0))
13888: FROM zx_rec_nrec_dist zd
13889: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
13890: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
13891: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
13892: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
13893: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
13894: AND zd.trx_id = ail.invoice_id

Line 13891: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

13887: 0))
13888: FROM zx_rec_nrec_dist zd
13889: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
13890: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
13891: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
13892: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
13893: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
13894: AND zd.trx_id = ail.invoice_id
13895: AND zd.trx_line_id = ail.line_number

Line 13892: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

13888: FROM zx_rec_nrec_dist zd
13889: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
13890: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
13891: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
13892: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
13893: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
13894: AND zd.trx_id = ail.invoice_id
13895: AND zd.trx_line_id = ail.line_number
13896: AND NVL(zd.self_assessed_flag, 'N') = 'N')

Line 13893: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

13889: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
13890: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
13891: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
13892: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
13893: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
13894: AND zd.trx_id = ail.invoice_id
13895: AND zd.trx_line_id = ail.line_number
13896: AND NVL(zd.self_assessed_flag, 'N') = 'N')
13897: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id