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.ZX_VERTEX_TAX_SERVICE_PKG dependencies on ZX_TAX_VERTEX_QSU

Line 108: version_rec ZX_TAX_VERTEX_QSU.tQSUVersionRecord;

104: -- combination in the table
105: /*-----------------------------------------------
106: | Records for Tax Calculation Package |
107: -----------------------------------------------*/
108: version_rec ZX_TAX_VERTEX_QSU.tQSUVersionRecord;
109: context_rec ZX_TAX_VERTEX_QSU.tQSUContextRecord;
110: inv_in_rec ZX_TAX_VERTEX_QSU.tQSUInvoiceRecord;
111: line_in_tab ZX_TAX_VERTEX_QSU.tQSULineItemTable;
112: inv_out_rec ZX_TAX_VERTEX_QSU.tQSUInvoiceRecord;

Line 109: context_rec ZX_TAX_VERTEX_QSU.tQSUContextRecord;

105: /*-----------------------------------------------
106: | Records for Tax Calculation Package |
107: -----------------------------------------------*/
108: version_rec ZX_TAX_VERTEX_QSU.tQSUVersionRecord;
109: context_rec ZX_TAX_VERTEX_QSU.tQSUContextRecord;
110: inv_in_rec ZX_TAX_VERTEX_QSU.tQSUInvoiceRecord;
111: line_in_tab ZX_TAX_VERTEX_QSU.tQSULineItemTable;
112: inv_out_rec ZX_TAX_VERTEX_QSU.tQSUInvoiceRecord;
113: line_out_tab ZX_TAX_VERTEX_QSU.tQSULineItemTable;

Line 110: inv_in_rec ZX_TAX_VERTEX_QSU.tQSUInvoiceRecord;

106: | Records for Tax Calculation Package |
107: -----------------------------------------------*/
108: version_rec ZX_TAX_VERTEX_QSU.tQSUVersionRecord;
109: context_rec ZX_TAX_VERTEX_QSU.tQSUContextRecord;
110: inv_in_rec ZX_TAX_VERTEX_QSU.tQSUInvoiceRecord;
111: line_in_tab ZX_TAX_VERTEX_QSU.tQSULineItemTable;
112: inv_out_rec ZX_TAX_VERTEX_QSU.tQSUInvoiceRecord;
113: line_out_tab ZX_TAX_VERTEX_QSU.tQSULineItemTable;
114:

Line 111: line_in_tab ZX_TAX_VERTEX_QSU.tQSULineItemTable;

107: -----------------------------------------------*/
108: version_rec ZX_TAX_VERTEX_QSU.tQSUVersionRecord;
109: context_rec ZX_TAX_VERTEX_QSU.tQSUContextRecord;
110: inv_in_rec ZX_TAX_VERTEX_QSU.tQSUInvoiceRecord;
111: line_in_tab ZX_TAX_VERTEX_QSU.tQSULineItemTable;
112: inv_out_rec ZX_TAX_VERTEX_QSU.tQSUInvoiceRecord;
113: line_out_tab ZX_TAX_VERTEX_QSU.tQSULineItemTable;
114:
115: /* ======================================================================*

Line 112: inv_out_rec ZX_TAX_VERTEX_QSU.tQSUInvoiceRecord;

108: version_rec ZX_TAX_VERTEX_QSU.tQSUVersionRecord;
109: context_rec ZX_TAX_VERTEX_QSU.tQSUContextRecord;
110: inv_in_rec ZX_TAX_VERTEX_QSU.tQSUInvoiceRecord;
111: line_in_tab ZX_TAX_VERTEX_QSU.tQSULineItemTable;
112: inv_out_rec ZX_TAX_VERTEX_QSU.tQSUInvoiceRecord;
113: line_out_tab ZX_TAX_VERTEX_QSU.tQSULineItemTable;
114:
115: /* ======================================================================*
116: | Data Type Definitions |

Line 113: line_out_tab ZX_TAX_VERTEX_QSU.tQSULineItemTable;

109: context_rec ZX_TAX_VERTEX_QSU.tQSUContextRecord;
110: inv_in_rec ZX_TAX_VERTEX_QSU.tQSUInvoiceRecord;
111: line_in_tab ZX_TAX_VERTEX_QSU.tQSULineItemTable;
112: inv_out_rec ZX_TAX_VERTEX_QSU.tQSUInvoiceRecord;
113: line_out_tab ZX_TAX_VERTEX_QSU.tQSULineItemTable;
114:
115: /* ======================================================================*
116: | Data Type Definitions |
117: * ======================================================================*/

Line 2225: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypePurchase;

2221: | The transaction type identifies the type of transaction |
2222: | being processed. |
2223: -----------------------------------------------------------*/
2224: IF pg_Line_char1_tab(I) = 'PURCHASE' THEN
2225: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypePurchase;
2226: ELSIF pg_Line_char1_tab(I) = 'RENTAL' THEN
2227: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2228: ELSIF pg_Line_char1_tab(I) = 'LEASE' THEN
2229: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;

Line 2227: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;

2223: -----------------------------------------------------------*/
2224: IF pg_Line_char1_tab(I) = 'PURCHASE' THEN
2225: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypePurchase;
2226: ELSIF pg_Line_char1_tab(I) = 'RENTAL' THEN
2227: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2228: ELSIF pg_Line_char1_tab(I) = 'LEASE' THEN
2229: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2230: ELSIF pg_Line_char1_tab(I) = 'SALE' THEN
2231: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeSale;

Line 2229: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;

2225: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypePurchase;
2226: ELSIF pg_Line_char1_tab(I) = 'RENTAL' THEN
2227: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2228: ELSIF pg_Line_char1_tab(I) = 'LEASE' THEN
2229: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2230: ELSIF pg_Line_char1_tab(I) = 'SALE' THEN
2231: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeSale;
2232: ELSIF pg_Line_char1_tab(I) = 'SERVICE' THEN
2233: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeService;

Line 2231: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeSale;

2227: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2228: ELSIF pg_Line_char1_tab(I) = 'LEASE' THEN
2229: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2230: ELSIF pg_Line_char1_tab(I) = 'SALE' THEN
2231: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeSale;
2232: ELSIF pg_Line_char1_tab(I) = 'SERVICE' THEN
2233: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeService;
2234: END IF;
2235: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2233: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeService;

2229: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2230: ELSIF pg_Line_char1_tab(I) = 'SALE' THEN
2231: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeSale;
2232: ELSIF pg_Line_char1_tab(I) = 'SERVICE' THEN
2233: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeService;
2234: END IF;
2235: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2236: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'line_in_tab(1).fTransType :'||to_char(line_in_tab(1).fTransType));
2237: END IF;

Line 2608: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypePurchase;

2604: | The transaction type identifies the type of transaction |
2605: | being processed. |
2606: -----------------------------------------------------------*/
2607: IF arp_trx_line_type = 'PURCHASE' THEN
2608: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypePurchase;
2609: ELSIF arp_trx_line_type = 'RENTAL' THEN
2610: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2611: ELSIF arp_trx_line_type = 'LEASE' THEN
2612: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;

Line 2610: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;

2606: -----------------------------------------------------------*/
2607: IF arp_trx_line_type = 'PURCHASE' THEN
2608: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypePurchase;
2609: ELSIF arp_trx_line_type = 'RENTAL' THEN
2610: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2611: ELSIF arp_trx_line_type = 'LEASE' THEN
2612: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2613: ELSIF arp_trx_line_type = 'SALE' THEN
2614: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeSale;

Line 2612: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;

2608: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypePurchase;
2609: ELSIF arp_trx_line_type = 'RENTAL' THEN
2610: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2611: ELSIF arp_trx_line_type = 'LEASE' THEN
2612: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2613: ELSIF arp_trx_line_type = 'SALE' THEN
2614: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeSale;
2615: ELSIF arp_trx_line_type = 'SERVICE' THEN
2616: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeService;

Line 2614: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeSale;

2610: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2611: ELSIF arp_trx_line_type = 'LEASE' THEN
2612: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2613: ELSIF arp_trx_line_type = 'SALE' THEN
2614: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeSale;
2615: ELSIF arp_trx_line_type = 'SERVICE' THEN
2616: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeService;
2617: END IF;
2618:

Line 2616: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeService;

2612: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2613: ELSIF arp_trx_line_type = 'SALE' THEN
2614: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeSale;
2615: ELSIF arp_trx_line_type = 'SERVICE' THEN
2616: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeService;
2617: END IF;
2618:
2619: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2620: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'line_in_tab(1).fTransType :'||to_char(line_in_tab(1).fTransType));

Line 2681: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdNormal;

2677:
2678: IF (l_document_type in ('INVOICE', 'DEBIT_MEMO', 'ON_ACCT_CREDIT_MEMO')) THEN
2679: IF (l_line_level_action IN ('CREATE','DELETE','CANCEL')) THEN
2680: inv_in_rec.fInvDate := pg_trx_date_tab(i);
2681: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdNormal;
2682:
2683: IF l_line_level_action = 'CREATE' THEN
2684: line_in_tab(1).fTransExtendedAmt := pg_line_amount_tab(I);
2685: line_in_tab(1).fPriStExmtAmt := pg_line_numeric1_tab(i) * pg_line_amount_tab(I)/100;

Line 2700: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;

2696:
2697: line_in_tab(1).fTransQuantity := abs(pg_trx_line_qty_tab(I));
2698:
2699: IF (pg_exempt_cont_flag_tab(I)='R') then
2700: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2701: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2702: END IF;
2703:
2704: line_in_tab(1).fPriCustExmtCrtfNum := substrb(pg_Line_char3_tab(I), 1, 15);

Line 2701: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;

2697: line_in_tab(1).fTransQuantity := abs(pg_trx_line_qty_tab(I));
2698:
2699: IF (pg_exempt_cont_flag_tab(I)='R') then
2700: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2701: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2702: END IF;
2703:
2704: line_in_tab(1).fPriCustExmtCrtfNum := substrb(pg_Line_char3_tab(I), 1, 15);
2705: line_in_tab(1).fPriStExmtRsnCd := SUBSTRB(pg_Line_char4_tab(I),1,1);

Line 2712: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdNormal;

2708: line_in_tab(1).fPriDiExmtRsnCd := SUBSTRB(pg_Line_char7_tab(I),1,1);
2709:
2710: ELSE
2711: inv_in_rec.fInvDate := arp_trx_date;
2712: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdNormal;
2713: line_in_tab(1).fTransExtendedAmt :=(-1*arp_line_amount);
2714: line_in_tab(1).fTransQuantity := abs(arp_quantity);
2715:
2716: IF (arp_exemption_control_flag ='R') THEN

Line 2717: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;

2713: line_in_tab(1).fTransExtendedAmt :=(-1*arp_line_amount);
2714: line_in_tab(1).fTransQuantity := abs(arp_quantity);
2715:
2716: IF (arp_exemption_control_flag ='R') THEN
2717: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2718: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2719: END IF;
2720:
2721: line_in_tab(1).fPriCustExmtCrtfNum := substrb(arp_cert_num, 1, 15);

Line 2718: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;

2714: line_in_tab(1).fTransQuantity := abs(arp_quantity);
2715:
2716: IF (arp_exemption_control_flag ='R') THEN
2717: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2718: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2719: END IF;
2720:
2721: line_in_tab(1).fPriCustExmtCrtfNum := substrb(arp_cert_num, 1, 15);
2722: line_in_tab(1).fPriStExmtRsnCd := SUBSTRB(arp_state_exempt_reason,1,1);

Line 2761: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdNormal;

2757: END;
2758:
2759: IF (l_line_level_action IN ('CREATE','DELETE','CANCEL')) THEN
2760: inv_in_rec.fInvDate := pg_adj_doc_date_tab(I);
2761: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdNormal;
2762: line_in_tab(1).fTransExtendedAmt :=pg_line_amount_tab(I);
2763: line_in_tab(1).fTransQuantity := abs(pg_trx_line_qty_tab(I));
2764:
2765: IF (pg_exempt_cont_flag_tab(I)='R') THEN

Line 2766: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;

2762: line_in_tab(1).fTransExtendedAmt :=pg_line_amount_tab(I);
2763: line_in_tab(1).fTransQuantity := abs(pg_trx_line_qty_tab(I));
2764:
2765: IF (pg_exempt_cont_flag_tab(I)='R') THEN
2766: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2767: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2768: END IF;
2769:
2770: line_in_tab(1).fPriCustExmtCrtfNum := substrb(pg_Line_char3_tab(I), 1, 15);

Line 2767: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;

2763: line_in_tab(1).fTransQuantity := abs(pg_trx_line_qty_tab(I));
2764:
2765: IF (pg_exempt_cont_flag_tab(I)='R') THEN
2766: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2767: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2768: END IF;
2769:
2770: line_in_tab(1).fPriCustExmtCrtfNum := substrb(pg_Line_char3_tab(I), 1, 15);
2771: line_in_tab(1).fPriStExmtRsnCd := SUBSTRB(pg_Line_char4_tab(I),1,1);

Line 2786: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdNormal;

2782: line_in_tab(1).fPriDiExmtAmt := pg_line_numeric4_tab(i) *
2783: pg_line_amount_tab(I)/100;
2784: ELSE
2785: inv_in_rec.fInvDate := arp_adjusted_doc_date;
2786: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdNormal;
2787: line_in_tab(1).fTransExtendedAmt :=(-1*arp_line_amount);
2788: line_in_tab(1).fTransQuantity := abs(arp_quantity);
2789:
2790: IF (arp_exemption_control_flag='R') THEN /*Need to check*/

Line 2791: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;

2787: line_in_tab(1).fTransExtendedAmt :=(-1*arp_line_amount);
2788: line_in_tab(1).fTransQuantity := abs(arp_quantity);
2789:
2790: IF (arp_exemption_control_flag='R') THEN /*Need to check*/
2791: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2792: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2793: END IF;
2794: line_in_tab(1).fPriCustExmtCrtfNum := substrb(arp_cert_num, 1, 15);
2795: line_in_tab(1).fPriStExmtRsnCd := SUBSTRB(arp_state_exempt_reason,1,1);

Line 2792: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;

2788: line_in_tab(1).fTransQuantity := abs(arp_quantity);
2789:
2790: IF (arp_exemption_control_flag='R') THEN /*Need to check*/
2791: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2792: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2793: END IF;
2794: line_in_tab(1).fPriCustExmtCrtfNum := substrb(arp_cert_num, 1, 15);
2795: line_in_tab(1).fPriStExmtRsnCd := SUBSTRB(arp_state_exempt_reason,1,1);
2796: line_in_tab(1).fPriStExmtAmt := -1 * arp_state_exempt_percent *

Line 2814: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdDistributeTax;

2810:
2811: ELSIF (l_document_type IN ('LINE_ONLY_CREDIT_MEMO')) THEN
2812: IF (l_line_level_action IN ('CREATE','DELETE','CANCEL')) THEN
2813: inv_in_rec.fInvDate := pg_adj_doc_date_tab(I);
2814: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdDistributeTax;
2815: line_in_tab(1).fTransExtendedAmt :=pg_line_amount_tab(I);
2816: line_in_tab(1).fTransQuantity := abs(pg_trx_line_qty_tab(I));
2817: line_in_tab(1).fTransTotalTaxAmt :=0;
2818:

Line 2820: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;

2816: line_in_tab(1).fTransQuantity := abs(pg_trx_line_qty_tab(I));
2817: line_in_tab(1).fTransTotalTaxAmt :=0;
2818:
2819: IF (pg_exempt_cont_flag_tab(I)='R') then
2820: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2821: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2822: end if;
2823: ELSE
2824: inv_in_rec.fInvDate := arp_adjusted_doc_date;

Line 2821: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;

2817: line_in_tab(1).fTransTotalTaxAmt :=0;
2818:
2819: IF (pg_exempt_cont_flag_tab(I)='R') then
2820: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2821: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2822: end if;
2823: ELSE
2824: inv_in_rec.fInvDate := arp_adjusted_doc_date;
2825: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdDistributeTax;

Line 2825: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdDistributeTax;

2821: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2822: end if;
2823: ELSE
2824: inv_in_rec.fInvDate := arp_adjusted_doc_date;
2825: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdDistributeTax;
2826: line_in_tab(1).fTransExtendedAmt :=(-1*arp_line_amount);
2827: line_in_tab(1).fTransQuantity := abs(arp_quantity);
2828: line_in_tab(1).fTransTotalTaxAmt :=0;
2829:

Line 2831: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;

2827: line_in_tab(1).fTransQuantity := abs(arp_quantity);
2828: line_in_tab(1).fTransTotalTaxAmt :=0;
2829:
2830: if(arp_exemption_control_flag='R') then /*Need to check*/
2831: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2832: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2833: END IF;
2834: END IF;
2835:

Line 2832: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;

2828: line_in_tab(1).fTransTotalTaxAmt :=0;
2829:
2830: if(arp_exemption_control_flag='R') then /*Need to check*/
2831: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2832: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2833: END IF;
2834: END IF;
2835:
2836: ELSIF l_document_type IN ('TAX_ONLY_CREDIT_MEMO') THEN

Line 2847: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdTaxOnlyDebit;

2843: line_in_tab(1).fTransTotalTaxAmt := g_TotalTaxAmt;
2844: END IF;
2845:
2846: IF line_in_tab(1).fTransTotalTaxAmt > 0 THEN
2847: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdTaxOnlyDebit;
2848: ELSE
2849: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdTaxOnlyCredit;
2850: END IF;
2851:

Line 2849: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdTaxOnlyCredit;

2845:
2846: IF line_in_tab(1).fTransTotalTaxAmt > 0 THEN
2847: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdTaxOnlyDebit;
2848: ELSE
2849: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdTaxOnlyCredit;
2850: END IF;
2851:
2852: line_in_tab(1).fTransExtendedAmt := NULL;
2853: line_in_tab(1).fTransQuantity := NULL;

Line 2872: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdTaxOnlyDebit;

2868: line_in_tab(1).fTransTotalTaxAmt := g_TotalTaxAmt;
2869: END IF;
2870:
2871: IF line_in_tab(1).fTransTotalTaxAmt > 0 THEN
2872: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdTaxOnlyDebit;
2873: ELSE
2874: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdTaxOnlyCredit;
2875: END IF;
2876:

Line 2874: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdTaxOnlyCredit;

2870:
2871: IF line_in_tab(1).fTransTotalTaxAmt > 0 THEN
2872: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdTaxOnlyDebit;
2873: ELSE
2874: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdTaxOnlyCredit;
2875: END IF;
2876:
2877: line_in_tab(1).fTransExtendedAmt := NULL;
2878: line_in_tab(1).fTransQuantity := NULL;

Line 2887: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdDistributeTax;

2883: END IF;
2884: END IF;
2885: ELSIF l_document_type in ('INVOICE_ADJUSTMENT') THEN
2886: inv_in_rec.fInvDate := pg_trx_date_tab(i);
2887: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdDistributeTax;
2888: line_in_tab(1).fTransExtendedAmt := pg_line_amount_tab(i)-
2889: (g_StTaxAmt+g_CoTaxAmt+g_CiTaxAmt);
2890: line_in_tab(1).fTransQuantity := abs(pg_trx_line_qty_tab(I));
2891: line_in_tab(1).fTransTotalTaxAmt := g_StTaxAmt+g_CoTaxAmt+g_CiTaxAmt;

Line 2896: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdDistributeTax;

2892: ELSIF l_document_type in ('TAX_LINE_SYNC'
2893: ,'TAX_ONLY_INVOICE'
2894: ,'TAX_ONLY_ADJUSTMENT') THEN
2895: inv_in_rec.fInvDate := arp_trx_date;
2896: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdDistributeTax;
2897: line_in_tab(1).fTransExtendedAmt := NULL;
2898: line_in_tab(1).fTransQuantity := NULL;
2899: --bug#6831713
2900: line_in_tab(1).fTransTotalTaxAmt := g_TotalTaxAmt;

Line 2915: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdNormal;

2911: END IF;
2912:
2913: ELSIF (l_document_type in ('SALES_QUOTE')) then -- Bug5927656
2914: inv_in_rec.fInvDate := pg_trx_date_tab(i);
2915: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdNormal;
2916:
2917: IF l_line_level_action = 'CREATE' THEN
2918: line_in_tab(1).fTransExtendedAmt := pg_line_amount_tab(I);
2919: END IF;

Line 2924: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;

2920:
2921: line_in_tab(1).fTransQuantity := abs(pg_trx_line_qty_tab(I));
2922:
2923: IF (pg_exempt_cont_flag_tab(I)='R') then
2924: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2925: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2926: END IF;
2927:
2928: line_in_tab(1).fPriCustExmtCrtfNum := substrb(pg_Line_char3_tab(I), 1, 15);

Line 2925: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;

2921: line_in_tab(1).fTransQuantity := abs(pg_trx_line_qty_tab(I));
2922:
2923: IF (pg_exempt_cont_flag_tab(I)='R') then
2924: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2925: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2926: END IF;
2927:
2928: line_in_tab(1).fPriCustExmtCrtfNum := substrb(pg_Line_char3_tab(I), 1, 15);
2929: line_in_tab(1).fPriStExmtRsnCd := SUBSTRB(pg_Line_char4_tab(I),1,1);

Line 3189: ZX_TAX_VERTEX_QSU.QSUCalculateTaxes(context_rec,

3185: to_char(sysdate, 'DD/MON/YYYY HH:MI:SS'));
3186: END IF;
3187:
3188: BEGIN
3189: ZX_TAX_VERTEX_QSU.QSUCalculateTaxes(context_rec,
3190: inv_in_rec,
3191: line_in_tab,
3192: inv_out_rec,
3193: line_out_tab,

Line 3251: ZX_TAX_VERTEX_QSU.QSUWritePreReturnsData(context_rec,

3247: | Write the transaction to register table(regprereturnstbl)|
3248: -----------------------------------------------------------*/
3249:
3250: BEGIN
3251: ZX_TAX_VERTEX_QSU.QSUWritePreReturnsData(context_rec,
3252: inv_out_rec,
3253: line_out_tab);
3254: EXCEPTION
3255: WHEN OTHERS THEN

Line 3338: IF line_out_tab(1).fPriDiAppliesTo = ZX_TAX_VERTEX_QSU.cQSUDiApplyCi THEN

3334:
3335: /*-----------------------------------------------------------
3336: | Populate Secondary Tax Amounts and Rates |
3337: -----------------------------------------------------------*/
3338: IF line_out_tab(1).fPriDiAppliesTo = ZX_TAX_VERTEX_QSU.cQSUDiApplyCi THEN
3339: sec_county_tax_rate := 0;
3340: sec_county_tax_amount := 0;
3341: sec_city_tax_rate := dist_tax_rate;
3342: sec_city_tax_amount := dist_tax_amount;

Line 3367: IF line_out_tab(1).fAddDiAppliesTo = ZX_TAX_VERTEX_QSU.cQSUDiApplyCi THEN

3363: add_dist_tax_rate := line_out_tab(1).fAddDiRate * 100;
3364: /* District tax amount */
3365: add_dist_tax_amount := line_out_tab(1).fAddDiTaxAmt;
3366:
3367: IF line_out_tab(1).fAddDiAppliesTo = ZX_TAX_VERTEX_QSU.cQSUDiApplyCi THEN
3368: add_city_tax_rate := round(add_city_tax_rate + add_dist_tax_rate, 6);
3369: add_city_tax_amount := add_city_tax_amount + add_dist_tax_amount;
3370: ELSE
3371: add_county_tax_rate := round(add_county_tax_rate + add_dist_tax_rate, 6);

Line 3709: ZX_TAX_VERTEX_QSU.QSUInitializeInvoice(context_rec,

3705: /*------------------------------------------------------
3706: | Initialize context_rec, inv_in_rec, and line_in_tab.|
3707: ------------------------------------------------------*/
3708: BEGIN
3709: ZX_TAX_VERTEX_QSU.QSUInitializeInvoice(context_rec,
3710: inv_in_rec,
3711: line_in_tab);
3712:
3713: EXCEPTION

Line 4323: IF line_out_tab(1).fPriDiAppliesTo = ZX_TAX_VERTEX_QSU.cQSUDiApplyCi and l_city_tax_cnt IS NOT NULL THEN

4319: x_output_sync_tax_lines(l_city_tax_cnt).TAX_RATE_PERCENTAGE := line_out_tab(1).fPriCiRate*100 + Nvl(line_out_tab(1).fAddCiRate,0) * 100;
4320: x_output_sync_tax_lines(l_city_tax_cnt).TAXABLE_AMOUNT := line_out_tab(1).fPriCiTaxedAmt;
4321: END IF;
4322:
4323: IF line_out_tab(1).fPriDiAppliesTo = ZX_TAX_VERTEX_QSU.cQSUDiApplyCi and l_city_tax_cnt IS NOT NULL THEN
4324: x_output_sync_tax_lines(l_city_tax_cnt).TAX_RATE_PERCENTAGE
4325: := x_output_sync_tax_lines(l_city_tax_cnt).TAX_RATE_PERCENTAGE + nvl(line_out_tab(1).fPriDiRate,0) * 100;
4326: ELSIF l_county_tax_cnt IS NOT NULL THEN
4327: x_output_sync_tax_lines(l_county_tax_cnt).TAX_RATE_PERCENTAGE

Line 4331: IF line_out_tab(1).fAddDiAppliesTo = ZX_TAX_VERTEX_QSU.cQSUDiApplyCi and l_city_tax_cnt IS NOT NULL THEN

4327: x_output_sync_tax_lines(l_county_tax_cnt).TAX_RATE_PERCENTAGE
4328: := x_output_sync_tax_lines(l_county_tax_cnt).TAX_RATE_PERCENTAGE + nvl(line_out_tab(1).fPriDiRate,0) * 100;
4329: END IF;
4330:
4331: IF line_out_tab(1).fAddDiAppliesTo = ZX_TAX_VERTEX_QSU.cQSUDiApplyCi and l_city_tax_cnt IS NOT NULL THEN
4332: x_output_sync_tax_lines(l_city_tax_cnt).TAX_RATE_PERCENTAGE
4333: := x_output_sync_tax_lines(l_city_tax_cnt).TAX_RATE_PERCENTAGE + nvl(line_out_tab(1).fAddDiRate,0) * 100;
4334: ELSIF l_county_tax_cnt IS NOT NULL THEN
4335: x_output_sync_tax_lines(l_county_tax_cnt).TAX_RATE_PERCENTAGE

Line 4357: IF line_out_tab(1).fPriDiAppliesTo = ZX_TAX_VERTEX_QSU.cQSUDiApplyCi THEN

4353: x_output_sync_tax_lines(p_sync_tax_cnt).TAX_RATE_PERCENTAGE := line_out_tab(1).fPriCiRate*100 + Nvl(line_out_tab(1).fAddCiRate,0) * 100;
4354: x_output_sync_tax_lines(p_sync_tax_cnt).TAXABLE_AMOUNT := line_out_tab(1).fPriCiTaxedAmt;
4355: END IF;
4356:
4357: IF line_out_tab(1).fPriDiAppliesTo = ZX_TAX_VERTEX_QSU.cQSUDiApplyCi THEN
4358: IF INSTR(upper(p_tax),'CITY') > 0 THEN
4359: x_output_sync_tax_lines(p_sync_tax_cnt).TAX_RATE_PERCENTAGE
4360: := x_output_sync_tax_lines(p_sync_tax_cnt).TAX_RATE_PERCENTAGE + nvl(line_out_tab(1).fPriDiRate,0) * 100;
4361: END IF;

Line 4369: IF line_out_tab(1).fAddDiAppliesTo = ZX_TAX_VERTEX_QSU.cQSUDiApplyCi THEN

4365: := x_output_sync_tax_lines(p_sync_tax_cnt).TAX_RATE_PERCENTAGE + nvl(line_out_tab(1).fPriDiRate,0) * 100;
4366: END IF;
4367: END IF;
4368:
4369: IF line_out_tab(1).fAddDiAppliesTo = ZX_TAX_VERTEX_QSU.cQSUDiApplyCi THEN
4370: IF INSTR(upper(p_tax),'CITY') > 0 THEN
4371: x_output_sync_tax_lines(p_sync_tax_cnt).TAX_RATE_PERCENTAGE
4372: := x_output_sync_tax_lines(p_sync_tax_cnt).TAX_RATE_PERCENTAGE + nvl(line_out_tab(1).fAddDiRate,0) * 100;
4373: END IF;

Line 6121: context_rec.fRoundingMethod := ZX_TAX_VERTEX_QSU.cQSURndngMethodQuantum;

6117: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
6118: END IF;
6119:
6120: context_rec.fGetJurisNames := TRUE;
6121: context_rec.fRoundingMethod := ZX_TAX_VERTEX_QSU.cQSURndngMethodQuantum;
6122:
6123: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6124: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
6125: END IF;