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 315: WHERE application_id = ap_etax_pkg.ap_application_id

311:
312: CURSOR c_selected_invoices IS
313: SELECT trx_id, event_class_code
314: FROM zx_trx_headers_gt
315: WHERE application_id = ap_etax_pkg.ap_application_id
316: AND entity_code = ap_etax_pkg.ap_entity_code
317: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
318: ap_etax_pkg.ap_pp_event_class_code,
319: ap_etax_pkg.ap_er_event_class_code);

Line 316: AND entity_code = ap_etax_pkg.ap_entity_code

312: CURSOR c_selected_invoices IS
313: SELECT trx_id, event_class_code
314: FROM zx_trx_headers_gt
315: WHERE application_id = ap_etax_pkg.ap_application_id
316: AND entity_code = ap_etax_pkg.ap_entity_code
317: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
318: ap_etax_pkg.ap_pp_event_class_code,
319: ap_etax_pkg.ap_er_event_class_code);
320:

Line 317: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,

313: SELECT trx_id, event_class_code
314: FROM zx_trx_headers_gt
315: WHERE application_id = ap_etax_pkg.ap_application_id
316: AND entity_code = ap_etax_pkg.ap_entity_code
317: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
318: ap_etax_pkg.ap_pp_event_class_code,
319: ap_etax_pkg.ap_er_event_class_code);
320:
321: --6922266

Line 318: ap_etax_pkg.ap_pp_event_class_code,

314: FROM zx_trx_headers_gt
315: WHERE application_id = ap_etax_pkg.ap_application_id
316: AND entity_code = ap_etax_pkg.ap_entity_code
317: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
318: ap_etax_pkg.ap_pp_event_class_code,
319: ap_etax_pkg.ap_er_event_class_code);
320:
321: --6922266
322: l_count NUMBER;

Line 319: ap_etax_pkg.ap_er_event_class_code);

315: WHERE application_id = ap_etax_pkg.ap_application_id
316: AND entity_code = ap_etax_pkg.ap_entity_code
317: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
318: ap_etax_pkg.ap_pp_event_class_code,
319: ap_etax_pkg.ap_er_event_class_code);
320:
321: --6922266
322: l_count NUMBER;
323:

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

463: l_return_status := FALSE;
464: END IF; --Bug15914464
465: END IF;
466:
467: ap_etax_pkg.g_inv_id_list(1) := l_inv_header_rec.invoice_id;
468:
469:
470: --Bug9436217
471:

Line 550: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,

546:
547: OPEN C_SELECTED_INVOICES;
548: LOOP
549: FETCH C_SELECTED_INVOICES
550: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,
551: AP_ETAX_PKG.G_EVNT_CLS_LIST
552: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
553:
554: --Bug9436217

Line 551: AP_ETAX_PKG.G_EVNT_CLS_LIST

547: OPEN C_SELECTED_INVOICES;
548: LOOP
549: FETCH C_SELECTED_INVOICES
550: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,
551: AP_ETAX_PKG.G_EVNT_CLS_LIST
552: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
553:
554: --Bug9436217
555:

Line 552: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

548: LOOP
549: FETCH C_SELECTED_INVOICES
550: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,
551: AP_ETAX_PKG.G_EVNT_CLS_LIST
552: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
553:
554: --Bug9436217
555:
556: IF P_Invoice_Id IS NULL THEN

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

557:
558: --Bug9436217
559:
560: EXIT WHEN (C_SELECTED_INVOICES%NOTFOUND
561: AND AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0);
562: ELSE
563: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;
564: END IF;
565:

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

559:
560: EXIT WHEN (C_SELECTED_INVOICES%NOTFOUND
561: AND AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0);
562: ELSE
563: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;
564: END IF;
565:
566: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST.. AP_ETAX_PKG.G_INV_ID_LIST.LAST
567: LOOP

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

562: ELSE
563: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;
564: END IF;
565:
566: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST.. AP_ETAX_PKG.G_INV_ID_LIST.LAST
567: LOOP
568:
569: --Bug9436217
570:

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

578: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
579: END IF;
580: --Print(l_api_name,l_debug_info);
581: -----------------------------------------------------------------
582: OPEN Invoice_Header(ap_etax_pkg.g_inv_id_list(i));
583: FETCH Invoice_Header INTO l_inv_header_rec;
584: CLOSE Invoice_Header;
585: l_inv_header_rec2:=l_inv_header_rec; ---for bug 6064593
586: -----------------------------------------------------------------

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

589: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
590: END IF;
591: --Print(l_api_name,l_debug_info);
592: -----------------------------------------------------------------
593: l_event_class_code := ap_etax_pkg.g_evnt_cls_list(i);
594:
595: ELSE
596: ap_etax_pkg.g_inv_id_list(1) := l_inv_header_rec.invoice_id;
597: l_inv_header_rec2:=l_inv_header_rec; ---for bug 6064593

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

592: -----------------------------------------------------------------
593: l_event_class_code := ap_etax_pkg.g_evnt_cls_list(i);
594:
595: ELSE
596: ap_etax_pkg.g_inv_id_list(1) := l_inv_header_rec.invoice_id;
597: l_inv_header_rec2:=l_inv_header_rec; ---for bug 6064593
598:
599: END IF;
600:

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

685: END IF;
686: --Print(l_api_name,l_debug_info);
687: -----------------------------------------------------------------
688: BEGIN
689: OPEN Tax_Lines_to_Import (ap_etax_pkg.g_inv_id_list(i));
690: FETCH Tax_Lines_to_Import
691: BULK COLLECT INTO l_inv_tax_list;
692: CLOSE Tax_Lines_to_Import;
693: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

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

742: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
743: END;
744: ELSE
745: BEGIN
746: OPEN Invoice_Lines (ap_etax_pkg.g_inv_id_list(i));
747: FETCH Invoice_Lines
748: BULK COLLECT INTO l_inv_line_list;
749: CLOSE Invoice_Lines;
750: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 942: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

938: END IF;
939: --Print(l_api_name,l_debug_info);
940: -----------------------------------------------------------------
941: DELETE FROM zx_trx_headers_gt
942: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
943: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
944: AND event_class_code IN
945: (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
946: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

Line 943: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

939: --Print(l_api_name,l_debug_info);
940: -----------------------------------------------------------------
941: DELETE FROM zx_trx_headers_gt
942: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
943: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
944: AND event_class_code IN
945: (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
946: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
947: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 945: (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

941: DELETE FROM zx_trx_headers_gt
942: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
943: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
944: AND event_class_code IN
945: (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
946: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
947: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
948: AND trx_id = l_inv_header_rec.invoice_id;
949:

Line 946: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

942: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
943: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
944: AND event_class_code IN
945: (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
946: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
947: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
948: AND trx_id = l_inv_header_rec.invoice_id;
949:
950: --Bug9436217

Line 947: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

943: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
944: AND event_class_code IN
945: (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
946: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
947: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
948: AND trx_id = l_inv_header_rec.invoice_id;
949:
950: --Bug9436217
951:

Line 984: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;

980: END IF;
981:
982: --Bug7136832
983:
984: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
985: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
986: END LOOP;
987: CLOSE C_SELECTED_INVOICES;
988:

Line 985: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;

981:
982: --Bug7136832
983:
984: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
985: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
986: END LOOP;
987: CLOSE C_SELECTED_INVOICES;
988:
989: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;

Line 989: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;

985: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
986: END LOOP;
987: CLOSE C_SELECTED_INVOICES;
988:
989: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
990: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
991:
992:
993: IF (l_Inv_Rcv_Matched = 'Y' OR l_no_tax_lines = 'Y') THEN

Line 990: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;

986: END LOOP;
987: CLOSE C_SELECTED_INVOICES;
988:
989: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
990: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
991:
992:
993: IF (l_Inv_Rcv_Matched = 'Y' OR l_no_tax_lines = 'Y') THEN
994:

Line 1044: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,

1040: -----------------------------------------------------------------
1041: OPEN C_SELECTED_INVOICES;
1042: LOOP
1043: FETCH C_SELECTED_INVOICES
1044: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,
1045: AP_ETAX_PKG.G_EVNT_CLS_LIST
1046: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
1047:
1048: --Bug9436217

Line 1045: AP_ETAX_PKG.G_EVNT_CLS_LIST

1041: OPEN C_SELECTED_INVOICES;
1042: LOOP
1043: FETCH C_SELECTED_INVOICES
1044: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,
1045: AP_ETAX_PKG.G_EVNT_CLS_LIST
1046: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
1047:
1048: --Bug9436217
1049:

Line 1046: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

1042: LOOP
1043: FETCH C_SELECTED_INVOICES
1044: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,
1045: AP_ETAX_PKG.G_EVNT_CLS_LIST
1046: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
1047:
1048: --Bug9436217
1049:
1050: IF P_Invoice_Id IS NULL THEN

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

1052: --Bug9436217
1053:
1054:
1055: EXIT WHEN (C_SELECTED_INVOICES%NOTFOUND
1056: AND AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0);
1057: ELSE
1058: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;
1059: END IF;
1060:

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

1054:
1055: EXIT WHEN (C_SELECTED_INVOICES%NOTFOUND
1056: AND AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0);
1057: ELSE
1058: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;
1059: END IF;
1060:
1061: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST..AP_ETAX_PKG.G_INV_ID_LIST.LAST
1062: LOOP

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

1057: ELSE
1058: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;
1059: END IF;
1060:
1061: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST..AP_ETAX_PKG.G_INV_ID_LIST.LAST
1062: LOOP
1063: OPEN Invoice_Header(ap_etax_pkg.g_inv_id_list(i));
1064: FETCH Invoice_Header INTO l_inv_header_rec;
1065: CLOSE Invoice_Header;

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

1059: END IF;
1060:
1061: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST..AP_ETAX_PKG.G_INV_ID_LIST.LAST
1062: LOOP
1063: OPEN Invoice_Header(ap_etax_pkg.g_inv_id_list(i));
1064: FETCH Invoice_Header INTO l_inv_header_rec;
1065: CLOSE Invoice_Header;
1066:
1067: IF NOT(AP_ETAX_SERVICES_PKG.Update_AP(

Line 1077: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;

1073:
1074: l_return_status := FALSE;
1075: END IF;
1076: END LOOP;
1077: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
1078: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
1079: END LOOP;
1080: CLOSE C_SELECTED_INVOICES;
1081:

Line 1078: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;

1074: l_return_status := FALSE;
1075: END IF;
1076: END LOOP;
1077: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
1078: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
1079: END LOOP;
1080: CLOSE C_SELECTED_INVOICES;
1081:
1082: ELSE

Line 1102: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;

1098: NULL;
1099: END IF;
1100: END IF;
1101:
1102: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
1103: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
1104: g_manual_tax_lines := null; --bug 16656238
1105:
1106: RETURN l_return_status;

Line 1103: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;

1099: END IF;
1100: END IF;
1101:
1102: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
1103: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
1104: g_manual_tax_lines := null; --bug 16656238
1105:
1106: RETURN l_return_status;
1107:

Line 1233: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

1229: --Print(l_api_name, l_debug_info);
1230: -----------------------------------------------------------------
1231: UPDATE zx_trx_headers_gt
1232: SET trx_id = P_Invoice_Id
1233: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1234: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1235: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1236: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1237: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 1234: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

1230: -----------------------------------------------------------------
1231: UPDATE zx_trx_headers_gt
1232: SET trx_id = P_Invoice_Id
1233: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1234: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1235: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1236: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1237: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1238: AND trx_id = P_Interface_Invoice_Id;

Line 1235: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

1231: UPDATE zx_trx_headers_gt
1232: SET trx_id = P_Invoice_Id
1233: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1234: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1235: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1236: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1237: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1238: AND trx_id = P_Interface_Invoice_Id;
1239: */ --commented for bug 16656238

Line 1236: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

1232: SET trx_id = P_Invoice_Id
1233: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1234: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1235: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1236: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1237: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1238: AND trx_id = P_Interface_Invoice_Id;
1239: */ --commented for bug 16656238
1240:

Line 1237: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

1233: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1234: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1235: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1236: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1237: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1238: AND trx_id = P_Interface_Invoice_Id;
1239: */ --commented for bug 16656238
1240:
1241: -- if condition commented bug 16656238

Line 1349: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

1345: END IF;
1346: -----------------------------------------------------------------
1347: UPDATE zx_transaction_lines_gt
1348: SET trx_id = P_Invoice_Id
1349: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1350: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1351: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1352: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1353: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 1350: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

1346: -----------------------------------------------------------------
1347: UPDATE zx_transaction_lines_gt
1348: SET trx_id = P_Invoice_Id
1349: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1350: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1351: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1352: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1353: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1354: AND trx_id = P_Interface_Invoice_Id;

Line 1351: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

1347: UPDATE zx_transaction_lines_gt
1348: SET trx_id = P_Invoice_Id
1349: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1350: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1351: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1352: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1353: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1354: AND trx_id = P_Interface_Invoice_Id;
1355:

Line 1352: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

1348: SET trx_id = P_Invoice_Id
1349: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1350: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1351: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1352: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1353: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1354: AND trx_id = P_Interface_Invoice_Id;
1355:
1356: END IF;

Line 1353: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

1349: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1350: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1351: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1352: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1353: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1354: AND trx_id = P_Interface_Invoice_Id;
1355:
1356: END IF;
1357: */ --bug 16656238

Line 1665: WHERE application_id = ap_etax_pkg.ap_application_id

1661:
1662: CURSOR c_selected_invoices IS
1663: SELECT trx_id, event_class_code
1664: FROM zx_trx_headers_gt
1665: WHERE application_id = ap_etax_pkg.ap_application_id
1666: AND entity_code = ap_etax_pkg.ap_entity_code
1667: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
1668: ap_etax_pkg.ap_pp_event_class_code,
1669: ap_etax_pkg.ap_er_event_class_code);

Line 1666: AND entity_code = ap_etax_pkg.ap_entity_code

1662: CURSOR c_selected_invoices IS
1663: SELECT trx_id, event_class_code
1664: FROM zx_trx_headers_gt
1665: WHERE application_id = ap_etax_pkg.ap_application_id
1666: AND entity_code = ap_etax_pkg.ap_entity_code
1667: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
1668: ap_etax_pkg.ap_pp_event_class_code,
1669: ap_etax_pkg.ap_er_event_class_code);
1670: --ER CHANGES 6772098

Line 1667: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,

1663: SELECT trx_id, event_class_code
1664: FROM zx_trx_headers_gt
1665: WHERE application_id = ap_etax_pkg.ap_application_id
1666: AND entity_code = ap_etax_pkg.ap_entity_code
1667: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
1668: ap_etax_pkg.ap_pp_event_class_code,
1669: ap_etax_pkg.ap_er_event_class_code);
1670: --ER CHANGES 6772098
1671: --Bug6678578 START

Line 1668: ap_etax_pkg.ap_pp_event_class_code,

1664: FROM zx_trx_headers_gt
1665: WHERE application_id = ap_etax_pkg.ap_application_id
1666: AND entity_code = ap_etax_pkg.ap_entity_code
1667: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
1668: ap_etax_pkg.ap_pp_event_class_code,
1669: ap_etax_pkg.ap_er_event_class_code);
1670: --ER CHANGES 6772098
1671: --Bug6678578 START
1672: /* bug 7569660 modified the below two cursors added a new attribute discarded_flag */

Line 1669: ap_etax_pkg.ap_er_event_class_code);

1665: WHERE application_id = ap_etax_pkg.ap_application_id
1666: AND entity_code = ap_etax_pkg.ap_entity_code
1667: AND event_class_code IN (ap_etax_pkg.ap_inv_event_class_code,
1668: ap_etax_pkg.ap_pp_event_class_code,
1669: ap_etax_pkg.ap_er_event_class_code);
1670: --ER CHANGES 6772098
1671: --Bug6678578 START
1672: /* bug 7569660 modified the below two cursors added a new attribute discarded_flag */
1673: /*

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

1776:
1777: l_return_status := FALSE;
1778: END IF;
1779:
1780: ap_etax_pkg.g_inv_id_list(1) := l_inv_header_rec.invoice_id;
1781:
1782:
1783: ELSE
1784: -----------------------------------------------------------------

Line 1854: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,

1850:
1851: OPEN C_SELECTED_INVOICES;
1852: LOOP
1853: FETCH C_SELECTED_INVOICES
1854: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,
1855: AP_ETAX_PKG.G_EVNT_CLS_LIST
1856: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
1857:
1858: --Bug9436217

Line 1855: AP_ETAX_PKG.G_EVNT_CLS_LIST

1851: OPEN C_SELECTED_INVOICES;
1852: LOOP
1853: FETCH C_SELECTED_INVOICES
1854: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,
1855: AP_ETAX_PKG.G_EVNT_CLS_LIST
1856: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
1857:
1858: --Bug9436217
1859:

Line 1856: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

1852: LOOP
1853: FETCH C_SELECTED_INVOICES
1854: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,
1855: AP_ETAX_PKG.G_EVNT_CLS_LIST
1856: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
1857:
1858: --Bug9436217
1859:
1860: IF P_Invoice_id IS NULL THEN

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

1861:
1862: --Bug9436217
1863:
1864: EXIT WHEN (C_SELECTED_INVOICES%NOTFOUND
1865: AND AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0);
1866: ELSE
1867: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;
1868: END IF;
1869:

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

1863:
1864: EXIT WHEN (C_SELECTED_INVOICES%NOTFOUND
1865: AND AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0);
1866: ELSE
1867: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;
1868: END IF;
1869:
1870: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST.. AP_ETAX_PKG.G_INV_ID_LIST.LAST
1871: LOOP

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

1866: ELSE
1867: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;
1868: END IF;
1869:
1870: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST.. AP_ETAX_PKG.G_INV_ID_LIST.LAST
1871: LOOP
1872:
1873: --Bug9436217
1874:

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

1875: IF P_Invoice_id IS NULL THEN
1876:
1877: --Bug9436217
1878:
1879: OPEN Invoice_Header(ap_etax_pkg.g_inv_id_list(i));
1880: FETCH Invoice_Header INTO l_inv_header_rec;
1881: CLOSE Invoice_Header;
1882:
1883: l_event_class_code := ap_etax_pkg.g_evnt_cls_list(i);

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

1879: OPEN Invoice_Header(ap_etax_pkg.g_inv_id_list(i));
1880: FETCH Invoice_Header INTO l_inv_header_rec;
1881: CLOSE Invoice_Header;
1882:
1883: l_event_class_code := ap_etax_pkg.g_evnt_cls_list(i);
1884:
1885: ELSE
1886:
1887: ap_etax_pkg.g_inv_id_list(1) := l_inv_header_rec.invoice_id;

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

1883: l_event_class_code := ap_etax_pkg.g_evnt_cls_list(i);
1884:
1885: ELSE
1886:
1887: ap_etax_pkg.g_inv_id_list(1) := l_inv_header_rec.invoice_id;
1888:
1889: END IF;
1890:
1891: -----------------------------------------------------------------

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

1934: call_determine_recovery_flag := TRUE;
1935: END IF;
1936: ELSE
1937:
1938: OPEN Invoice_Dists (ap_etax_pkg.g_inv_id_list(i));
1939: FETCH Invoice_Dists
1940: BULK COLLECT INTO l_inv_dist_list;
1941: CLOSE Invoice_Dists;
1942:

Line 1953: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

1949:
1950: IF l_inv_dist_list.count = 0 AND NOT TAX_ONLY_LINE_EXIST(l_inv_header_rec.invoice_id) THEN
1951:
1952: DELETE FROM zx_trx_headers_gt
1953: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1954: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1955: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1956: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1957: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 1954: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

1950: IF l_inv_dist_list.count = 0 AND NOT TAX_ONLY_LINE_EXIST(l_inv_header_rec.invoice_id) THEN
1951:
1952: DELETE FROM zx_trx_headers_gt
1953: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1954: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1955: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1956: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1957: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1958: AND trx_id = l_inv_header_rec.invoice_id;

Line 1955: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

1951:
1952: DELETE FROM zx_trx_headers_gt
1953: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1954: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1955: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1956: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1957: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1958: AND trx_id = l_inv_header_rec.invoice_id;
1959:

Line 1956: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

1952: DELETE FROM zx_trx_headers_gt
1953: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1954: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1955: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1956: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1957: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1958: AND trx_id = l_inv_header_rec.invoice_id;
1959:
1960: -----------------------------------------------------------------

Line 1957: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

1953: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1954: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1955: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
1956: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
1957: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
1958: AND trx_id = l_inv_header_rec.invoice_id;
1959:
1960: -----------------------------------------------------------------
1961: l_debug_info := 'DELETE INV ID '||l_inv_header_rec.invoice_id||' FROM zx_trx_headers_gt';

Line 2034: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;

2030: AND AID.recovery_type_code Is Null;
2031: END IF;
2032: END LOOP;
2033:
2034: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
2035: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
2036:
2037: END LOOP;
2038: CLOSE C_SELECTED_INVOICES;

Line 2035: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;

2031: END IF;
2032: END LOOP;
2033:
2034: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
2035: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
2036:
2037: END LOOP;
2038: CLOSE C_SELECTED_INVOICES;
2039:

Line 2112: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,

2108:
2109: OPEN C_SELECTED_INVOICES;
2110: LOOP
2111: FETCH C_SELECTED_INVOICES
2112: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,
2113: AP_ETAX_PKG.G_EVNT_CLS_LIST
2114: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
2115:
2116: --Bug9436217

Line 2113: AP_ETAX_PKG.G_EVNT_CLS_LIST

2109: OPEN C_SELECTED_INVOICES;
2110: LOOP
2111: FETCH C_SELECTED_INVOICES
2112: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,
2113: AP_ETAX_PKG.G_EVNT_CLS_LIST
2114: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
2115:
2116: --Bug9436217
2117: IF P_Invoice_id IS NULL THEN

Line 2114: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;

2110: LOOP
2111: FETCH C_SELECTED_INVOICES
2112: BULK COLLECT INTO AP_ETAX_PKG.G_INV_ID_LIST,
2113: AP_ETAX_PKG.G_EVNT_CLS_LIST
2114: LIMIT AP_ETAX_PKG.G_BATCH_LIMIT;
2115:
2116: --Bug9436217
2117: IF P_Invoice_id IS NULL THEN
2118: --Bug9436217

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

2116: --Bug9436217
2117: IF P_Invoice_id IS NULL THEN
2118: --Bug9436217
2119: EXIT WHEN (C_SELECTED_INVOICES%NOTFOUND
2120: AND AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0);
2121: ELSE
2122: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;
2123: END IF;
2124:

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

2118: --Bug9436217
2119: EXIT WHEN (C_SELECTED_INVOICES%NOTFOUND
2120: AND AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0);
2121: ELSE
2122: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;
2123: END IF;
2124:
2125: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST.. AP_ETAX_PKG.G_INV_ID_LIST.LAST
2126: LOOP

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

2121: ELSE
2122: EXIT WHEN AP_ETAX_PKG.G_INV_ID_LIST.COUNT <= 0;
2123: END IF;
2124:
2125: FOR i IN AP_ETAX_PKG.G_INV_ID_LIST.FIRST.. AP_ETAX_PKG.G_INV_ID_LIST.LAST
2126: LOOP
2127: --Bug9436217
2128: IF P_Invoice_id IS NULL THEN
2129: --Bug9436217

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

2126: LOOP
2127: --Bug9436217
2128: IF P_Invoice_id IS NULL THEN
2129: --Bug9436217
2130: OPEN Invoice_Header (ap_etax_pkg.g_inv_id_list(i));
2131: FETCH Invoice_Header
2132: INTO l_inv_header_rec;
2133: CLOSE Invoice_Header;
2134: END IF;

Line 2153: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;

2149:
2150: l_return_status := FALSE;
2151: END IF;
2152: END LOOP;
2153: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
2154: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
2155: END LOOP;
2156: CLOSE C_SELECTED_INVOICES;
2157:

Line 2154: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;

2150: l_return_status := FALSE;
2151: END IF;
2152: END LOOP;
2153: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
2154: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
2155: END LOOP;
2156: CLOSE C_SELECTED_INVOICES;
2157:
2158: END IF;

Line 2160: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;

2156: CLOSE C_SELECTED_INVOICES;
2157:
2158: END IF;
2159:
2160: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
2161: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
2162:
2163: END IF;
2164:

Line 2161: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;

2157:
2158: END IF;
2159:
2160: AP_ETAX_PKG.G_INV_ID_LIST.DELETE;
2161: AP_ETAX_PKG.G_EVNT_CLS_LIST.DELETE;
2162:
2163: END IF;
2164:
2165: RETURN l_return_status;

Line 2474: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

2470: -----------------------------------------------------------------
2471: BEGIN
2472: UPDATE zx_trx_headers_gt
2473: SET trx_id = P_Invoice_Id
2474: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2475: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2476: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2477: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2478: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 2475: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

2471: BEGIN
2472: UPDATE zx_trx_headers_gt
2473: SET trx_id = P_Invoice_Id
2474: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2475: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2476: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2477: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2478: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2479: AND trx_id = P_Interface_Invoice_Id;

Line 2476: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

2472: UPDATE zx_trx_headers_gt
2473: SET trx_id = P_Invoice_Id
2474: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2475: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2476: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2477: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2478: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2479: AND trx_id = P_Interface_Invoice_Id;
2480: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;

Line 2477: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

2473: SET trx_id = P_Invoice_Id
2474: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2475: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2476: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2477: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2478: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2479: AND trx_id = P_Interface_Invoice_Id;
2480: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
2481: END;

Line 2478: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

2474: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2475: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2476: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2477: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2478: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2479: AND trx_id = P_Interface_Invoice_Id;
2480: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
2481: END;
2482:

Line 2573: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

2569: END IF;
2570: -----------------------------------------------------------------
2571: UPDATE zx_transaction_lines_gt
2572: SET trx_id = P_Invoice_Id
2573: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2574: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2575: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2576: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2577: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 2574: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

2570: -----------------------------------------------------------------
2571: UPDATE zx_transaction_lines_gt
2572: SET trx_id = P_Invoice_Id
2573: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2574: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2575: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2576: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2577: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2578: AND trx_id = P_Interface_Invoice_Id;

Line 2575: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

2571: UPDATE zx_transaction_lines_gt
2572: SET trx_id = P_Invoice_Id
2573: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2574: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2575: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2576: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2577: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2578: AND trx_id = P_Interface_Invoice_Id;
2579:

Line 2576: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

2572: SET trx_id = P_Invoice_Id
2573: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2574: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2575: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2576: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2577: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2578: AND trx_id = P_Interface_Invoice_Id;
2579:
2580: -----------------------------------------------------------------

Line 2577: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

2573: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2574: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2575: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2576: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2577: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2578: AND trx_id = P_Interface_Invoice_Id;
2579:
2580: -----------------------------------------------------------------
2581: l_debug_info := 'Step 4: Update trx_id in tax Lines';

Line 3533: l_success := ap_etax_pkg.calling_etax(

3529: --Bug14779241: End
3530:
3531: IF l_invoice_id IS NOT NULL THEN --Bug14779241
3532: IF ( l_return_status = TRUE ) THEN -- Bug 9383712
3533: l_success := ap_etax_pkg.calling_etax(
3534: P_Invoice_id => l_inv_header_rec.invoice_id,
3535: P_Calling_Mode => 'DISTRIBUTE',
3536: P_All_Error_Messages => P_All_Error_Messages,
3537: P_error_code => P_error_code,

Line 6256: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

6252: -------------------------------------------------------------------
6253: IF (l_return_status = TRUE) THEN
6254:
6255: DELETE FROM zx_trx_headers_gt
6256: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
6257: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
6258: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
6259: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
6260: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 6257: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

6253: IF (l_return_status = TRUE) THEN
6254:
6255: DELETE FROM zx_trx_headers_gt
6256: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
6257: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
6258: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
6259: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
6260: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
6261: AND trx_id = p_invoice_header_rec.invoice_id;

Line 6258: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

6254:
6255: DELETE FROM zx_trx_headers_gt
6256: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
6257: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
6258: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
6259: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
6260: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
6261: AND trx_id = p_invoice_header_rec.invoice_id;
6262:

Line 6259: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

6255: DELETE FROM zx_trx_headers_gt
6256: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
6257: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
6258: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
6259: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
6260: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
6261: AND trx_id = p_invoice_header_rec.invoice_id;
6262:
6263: INSERT INTO zx_trx_headers_gt(

Line 6260: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

6256: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
6257: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
6258: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
6259: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
6260: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
6261: AND trx_id = p_invoice_header_rec.invoice_id;
6262:
6263: INSERT INTO zx_trx_headers_gt(
6264: internal_organization_id,

Line 6660: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

6656: -------------------------------------------------------------------
6657: IF (l_return_status = TRUE) THEN
6658:
6659: DELETE FROM zx_trx_headers_gt
6660: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
6661: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
6662: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
6663: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
6664: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 6661: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

6657: IF (l_return_status = TRUE) THEN
6658:
6659: DELETE FROM zx_trx_headers_gt
6660: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
6661: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
6662: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
6663: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
6664: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
6665: AND trx_id = p_invoice_header_rec.invoice_id;

Line 6662: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

6658:
6659: DELETE FROM zx_trx_headers_gt
6660: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
6661: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
6662: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
6663: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
6664: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
6665: AND trx_id = p_invoice_header_rec.invoice_id;
6666:

Line 6663: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

6659: DELETE FROM zx_trx_headers_gt
6660: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
6661: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
6662: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
6663: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
6664: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
6665: AND trx_id = p_invoice_header_rec.invoice_id;
6666:
6667: INSERT INTO zx_trx_headers_gt(

Line 6664: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

6660: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
6661: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
6662: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
6663: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
6664: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
6665: AND trx_id = p_invoice_header_rec.invoice_id;
6666:
6667: INSERT INTO zx_trx_headers_gt(
6668: internal_organization_id,

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

7886: END IF;
7887: -------------------------------------------------------------------
7888: IF (l_return_status = TRUE ) THEN
7889:
7890: trans_lines(i).application_id := ap_etax_pkg.ap_application_id;
7891: trans_lines(i).entity_code := ap_etax_pkg.ap_entity_code;
7892: trans_lines(i).event_class_code := p_event_class_code;
7893:
7894: IF p_calling_mode = 'RECOUPMENT' THEN

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

7887: -------------------------------------------------------------------
7888: IF (l_return_status = TRUE ) THEN
7889:
7890: trans_lines(i).application_id := ap_etax_pkg.ap_application_id;
7891: trans_lines(i).entity_code := ap_etax_pkg.ap_entity_code;
7892: trans_lines(i).event_class_code := p_event_class_code;
7893:
7894: IF p_calling_mode = 'RECOUPMENT' THEN
7895:

Line 9860: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

9856: -------------------------------------------------------------------
9857: IF ( l_return_status = TRUE ) THEN
9858:
9859: DELETE FROM zx_transaction_lines_gt
9860: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
9861: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
9862: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
9863: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
9864: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 9861: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

9857: IF ( l_return_status = TRUE ) THEN
9858:
9859: DELETE FROM zx_transaction_lines_gt
9860: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
9861: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
9862: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
9863: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
9864: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
9865: AND trx_id = p_invoice_header_rec.invoice_id;

Line 9862: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

9858:
9859: DELETE FROM zx_transaction_lines_gt
9860: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
9861: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
9862: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
9863: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
9864: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
9865: AND trx_id = p_invoice_header_rec.invoice_id;
9866:

Line 9863: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

9859: DELETE FROM zx_transaction_lines_gt
9860: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
9861: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
9862: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
9863: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
9864: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
9865: AND trx_id = p_invoice_header_rec.invoice_id;
9866:
9867: IF (trans_lines.COUNT > 0) THEN

Line 9864: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

9860: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
9861: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
9862: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
9863: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
9864: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
9865: AND trx_id = p_invoice_header_rec.invoice_id;
9866:
9867: IF (trans_lines.COUNT > 0) THEN
9868: FORALL m IN trans_lines.FIRST..trans_lines.LAST

Line 11344: trans_dists(j).application_id := AP_ETAX_PKG.AP_APPLICATION_ID;

11340: END IF;
11341: -------------------------------------------------------------------
11342: IF (l_return_status = TRUE) THEN
11343:
11344: trans_dists(j).application_id := AP_ETAX_PKG.AP_APPLICATION_ID;
11345: trans_dists(j).entity_code := AP_ETAX_PKG.AP_ENTITY_CODE;
11346: trans_dists(j).event_class_code := P_event_class_code;
11347: trans_dists(j).trx_id := l_inv_dist_list(i).invoice_id;
11348:

Line 11345: trans_dists(j).entity_code := AP_ETAX_PKG.AP_ENTITY_CODE;

11341: -------------------------------------------------------------------
11342: IF (l_return_status = TRUE) THEN
11343:
11344: trans_dists(j).application_id := AP_ETAX_PKG.AP_APPLICATION_ID;
11345: trans_dists(j).entity_code := AP_ETAX_PKG.AP_ENTITY_CODE;
11346: trans_dists(j).event_class_code := P_event_class_code;
11347: trans_dists(j).trx_id := l_inv_dist_list(i).invoice_id;
11348:
11349: IF p_calling_mode = 'DISTRIBUTE RECOUP' THEN

Line 14165: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

14161: 'N', NVL(zls.tax_amt, 0),0)),
14162: SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
14163: 'Y', NVL(zls.tax_amt, 0),0))
14164: FROM zx_lines_summary zls
14165: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
14166: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
14167: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
14168: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
14169: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 14166: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

14162: SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
14163: 'Y', NVL(zls.tax_amt, 0),0))
14164: FROM zx_lines_summary zls
14165: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
14166: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
14167: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
14168: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
14169: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
14170: AND zls.trx_id = ai.invoice_id

Line 14167: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

14163: 'Y', NVL(zls.tax_amt, 0),0))
14164: FROM zx_lines_summary zls
14165: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
14166: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
14167: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
14168: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
14169: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
14170: AND zls.trx_id = ai.invoice_id
14171: AND NVL(zls.reporting_only_flag, 'N') = 'N')

Line 14168: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

14164: FROM zx_lines_summary zls
14165: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
14166: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
14167: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
14168: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
14169: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
14170: AND zls.trx_id = ai.invoice_id
14171: AND NVL(zls.reporting_only_flag, 'N') = 'N')
14172: WHERE ai.invoice_id = p_invoice_id;

Line 14169: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

14165: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
14166: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
14167: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
14168: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
14169: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
14170: AND zls.trx_id = ai.invoice_id
14171: AND NVL(zls.reporting_only_flag, 'N') = 'N')
14172: WHERE ai.invoice_id = p_invoice_id;
14173:

Line 16083: l_return_status := ap_etax_pkg.calling_etax

16079: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
16080: END IF;
16081: -----------------------------------------------------------------
16082:
16083: l_return_status := ap_etax_pkg.calling_etax
16084: (p_invoice_id => p_invoice_id,
16085: p_line_number => p_invoice_line_number,
16086: p_calling_mode => 'DISTRIBUTE RECOUP',
16087: p_all_error_messages => 'N',

Line 16418: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

16414:
16415: SELECT 'Tax Only Line Exist'
16416: INTO l_dummy
16417: FROM zx_lines_summary zls
16418: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
16419: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
16420: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
16421: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
16422: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 16419: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

16415: SELECT 'Tax Only Line Exist'
16416: INTO l_dummy
16417: FROM zx_lines_summary zls
16418: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
16419: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
16420: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
16421: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
16422: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
16423: AND zls.trx_id = p_invoice_id

Line 16420: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

16416: INTO l_dummy
16417: FROM zx_lines_summary zls
16418: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
16419: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
16420: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
16421: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
16422: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
16423: AND zls.trx_id = p_invoice_id
16424: AND NVL(zls.reporting_only_flag, 'N') = 'N'

Line 16421: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

16417: FROM zx_lines_summary zls
16418: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
16419: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
16420: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
16421: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
16422: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
16423: AND zls.trx_id = p_invoice_id
16424: AND NVL(zls.reporting_only_flag, 'N') = 'N'
16425: AND NVL(zls.tax_only_line_flag, 'N') = 'Y'

Line 16422: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

16418: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
16419: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
16420: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
16421: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
16422: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
16423: AND zls.trx_id = p_invoice_id
16424: AND NVL(zls.reporting_only_flag, 'N') = 'N'
16425: AND NVL(zls.tax_only_line_flag, 'N') = 'Y'
16426: AND rownum = 1;

Line 17593: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID

17589: SUM(DECODE(NVL(zd.recoverable_flag, 'N'),
17590: 'N', NVL(zd.rec_nrec_tax_amt_funcl_curr, 0),
17591: 0))
17592: FROM zx_rec_nrec_dist zd
17593: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
17594: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
17595: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
17596: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
17597: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 17594: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

17590: 'N', NVL(zd.rec_nrec_tax_amt_funcl_curr, 0),
17591: 0))
17592: FROM zx_rec_nrec_dist zd
17593: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
17594: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
17595: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
17596: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
17597: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
17598: AND zd.trx_id = ail.invoice_id

Line 17595: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

17591: 0))
17592: FROM zx_rec_nrec_dist zd
17593: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
17594: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
17595: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
17596: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
17597: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
17598: AND zd.trx_id = ail.invoice_id
17599: AND ((zd.trx_line_id = ail.line_number AND zd.inclusive_flag = 'Y')

Line 17596: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

17592: FROM zx_rec_nrec_dist zd
17593: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
17594: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
17595: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
17596: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
17597: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
17598: AND zd.trx_id = ail.invoice_id
17599: AND ((zd.trx_line_id = ail.line_number AND zd.inclusive_flag = 'Y')
17600: OR (ail.summary_tax_line_id = zd.summary_tax_line_id AND zd.inclusive_flag = 'N')) --Bug11720331

Line 17597: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

17593: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
17594: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
17595: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
17596: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
17597: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
17598: AND zd.trx_id = ail.invoice_id
17599: AND ((zd.trx_line_id = ail.line_number AND zd.inclusive_flag = 'Y')
17600: OR (ail.summary_tax_line_id = zd.summary_tax_line_id AND zd.inclusive_flag = 'N')) --Bug11720331
17601: AND NVL(zd.self_assessed_flag, 'N') = 'N')