DBA Data[Home] [Help]

APPS.ZX_VERTEX_TAX_SERVICE_PKG dependencies on ZX_TAX_VERTEX_QSU

Line 107: version_rec ZX_TAX_VERTEX_QSU.tQSUVersionRecord;

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

Line 108: context_rec ZX_TAX_VERTEX_QSU.tQSUContextRecord;

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

Line 109: inv_in_rec ZX_TAX_VERTEX_QSU.tQSUInvoiceRecord;

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

Line 110: line_in_tab ZX_TAX_VERTEX_QSU.tQSULineItemTable;

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

Line 111: inv_out_rec ZX_TAX_VERTEX_QSU.tQSUInvoiceRecord;

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

Line 112: line_out_tab ZX_TAX_VERTEX_QSU.tQSULineItemTable;

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

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

2165: | The transaction type identifies the type of transaction |
2166: | being processed. |
2167: -----------------------------------------------------------*/
2168: IF pg_Line_char1_tab(I) = 'PURCHASE' THEN
2169: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypePurchase;
2170: ELSIF pg_Line_char1_tab(I) = 'RENTAL' THEN
2171: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2172: ELSIF pg_Line_char1_tab(I) = 'LEASE' THEN
2173: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;

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

2167: -----------------------------------------------------------*/
2168: IF pg_Line_char1_tab(I) = 'PURCHASE' THEN
2169: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypePurchase;
2170: ELSIF pg_Line_char1_tab(I) = 'RENTAL' THEN
2171: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2172: ELSIF pg_Line_char1_tab(I) = 'LEASE' THEN
2173: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2174: ELSIF pg_Line_char1_tab(I) = 'SALE' THEN
2175: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeSale;

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

2169: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypePurchase;
2170: ELSIF pg_Line_char1_tab(I) = 'RENTAL' THEN
2171: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2172: ELSIF pg_Line_char1_tab(I) = 'LEASE' THEN
2173: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2174: ELSIF pg_Line_char1_tab(I) = 'SALE' THEN
2175: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeSale;
2176: ELSIF pg_Line_char1_tab(I) = 'SERVICE' THEN
2177: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeService;

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

2171: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2172: ELSIF pg_Line_char1_tab(I) = 'LEASE' THEN
2173: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2174: ELSIF pg_Line_char1_tab(I) = 'SALE' THEN
2175: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeSale;
2176: ELSIF pg_Line_char1_tab(I) = 'SERVICE' THEN
2177: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeService;
2178: END IF;
2179: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2173: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2174: ELSIF pg_Line_char1_tab(I) = 'SALE' THEN
2175: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeSale;
2176: ELSIF pg_Line_char1_tab(I) = 'SERVICE' THEN
2177: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeService;
2178: END IF;
2179: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2180: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'line_in_tab(1).fTransType :'||to_char(line_in_tab(1).fTransType));
2181: END IF;

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

2551: | The transaction type identifies the type of transaction |
2552: | being processed. |
2553: -----------------------------------------------------------*/
2554: IF arp_trx_line_type = 'PURCHASE' THEN
2555: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypePurchase;
2556: ELSIF arp_trx_line_type = 'RENTAL' THEN
2557: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2558: ELSIF arp_trx_line_type = 'LEASE' THEN
2559: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;

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

2553: -----------------------------------------------------------*/
2554: IF arp_trx_line_type = 'PURCHASE' THEN
2555: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypePurchase;
2556: ELSIF arp_trx_line_type = 'RENTAL' THEN
2557: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2558: ELSIF arp_trx_line_type = 'LEASE' THEN
2559: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2560: ELSIF arp_trx_line_type = 'SALE' THEN
2561: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeSale;

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

2555: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypePurchase;
2556: ELSIF arp_trx_line_type = 'RENTAL' THEN
2557: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2558: ELSIF arp_trx_line_type = 'LEASE' THEN
2559: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2560: ELSIF arp_trx_line_type = 'SALE' THEN
2561: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeSale;
2562: ELSIF arp_trx_line_type = 'SERVICE' THEN
2563: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeService;

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

2557: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2558: ELSIF arp_trx_line_type = 'LEASE' THEN
2559: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2560: ELSIF arp_trx_line_type = 'SALE' THEN
2561: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeSale;
2562: ELSIF arp_trx_line_type = 'SERVICE' THEN
2563: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeService;
2564: END IF;
2565: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2559: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeRentLease;
2560: ELSIF arp_trx_line_type = 'SALE' THEN
2561: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeSale;
2562: ELSIF arp_trx_line_type = 'SERVICE' THEN
2563: line_in_tab(1).fTransType := ZX_TAX_VERTEX_QSU.cQSUTransTypeService;
2564: END IF;
2565: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2566: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'line_in_tab(1).fTransType :'||to_char(line_in_tab(1).fTransType));
2567: END IF;

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

2623:
2624: IF (l_document_type in ('INVOICE', 'DEBIT_MEMO', 'ON_ACCT_CREDIT_MEMO')) THEN
2625: IF (l_line_level_action IN ('CREATE','DELETE','CANCEL')) THEN
2626: inv_in_rec.fInvDate := pg_trx_date_tab(i);
2627: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdNormal;
2628:
2629: IF l_line_level_action = 'CREATE' THEN
2630: line_in_tab(1).fTransExtendedAmt := pg_line_amount_tab(I);
2631: line_in_tab(1).fPriStExmtAmt := pg_line_numeric1_tab(i) * pg_line_amount_tab(I)/100;

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

2642:
2643: line_in_tab(1).fTransQuantity :=pg_trx_line_qty_tab(I);
2644:
2645: IF (pg_exempt_cont_flag_tab(I)='R') then
2646: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2647: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2648: END IF;
2649:
2650: line_in_tab(1).fPriCustExmtCrtfNum := substrb(pg_Line_char3_tab(I), 1, 15);

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

2643: line_in_tab(1).fTransQuantity :=pg_trx_line_qty_tab(I);
2644:
2645: IF (pg_exempt_cont_flag_tab(I)='R') then
2646: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2647: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2648: END IF;
2649:
2650: line_in_tab(1).fPriCustExmtCrtfNum := substrb(pg_Line_char3_tab(I), 1, 15);
2651: line_in_tab(1).fPriStExmtRsnCd := SUBSTRB(pg_Line_char4_tab(I),1,1);

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

2654: line_in_tab(1).fPriDiExmtRsnCd := SUBSTRB(pg_Line_char7_tab(I),1,1);
2655:
2656: ELSE
2657: inv_in_rec.fInvDate := arp_trx_date;
2658: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdNormal;
2659: line_in_tab(1).fTransExtendedAmt :=(-1*arp_line_amount);
2660: line_in_tab(1).fTransQuantity :=arp_quantity;
2661:
2662: IF (arp_exemption_control_flag ='R') THEN

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

2659: line_in_tab(1).fTransExtendedAmt :=(-1*arp_line_amount);
2660: line_in_tab(1).fTransQuantity :=arp_quantity;
2661:
2662: IF (arp_exemption_control_flag ='R') THEN
2663: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2664: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2665: END IF;
2666:
2667: line_in_tab(1).fPriCustExmtCrtfNum := substrb(arp_cert_num, 1, 15);

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

2660: line_in_tab(1).fTransQuantity :=arp_quantity;
2661:
2662: IF (arp_exemption_control_flag ='R') THEN
2663: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2664: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2665: END IF;
2666:
2667: line_in_tab(1).fPriCustExmtCrtfNum := substrb(arp_cert_num, 1, 15);
2668: line_in_tab(1).fPriStExmtRsnCd := SUBSTRB(arp_state_exempt_reason,1,1);

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

2704: END;
2705:
2706: IF (l_line_level_action IN ('CREATE','DELETE','CANCEL')) THEN
2707: inv_in_rec.fInvDate := pg_adj_doc_date_tab(I);
2708: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdNormal;
2709: line_in_tab(1).fTransExtendedAmt :=pg_line_amount_tab(I);
2710: line_in_tab(1).fTransQuantity :=pg_trx_line_qty_tab(I);
2711:
2712: IF (pg_exempt_cont_flag_tab(I)='R') THEN

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

2709: line_in_tab(1).fTransExtendedAmt :=pg_line_amount_tab(I);
2710: line_in_tab(1).fTransQuantity :=pg_trx_line_qty_tab(I);
2711:
2712: IF (pg_exempt_cont_flag_tab(I)='R') THEN
2713: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2714: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2715: END IF;
2716:
2717: line_in_tab(1).fPriCustExmtCrtfNum := substrb(pg_Line_char3_tab(I), 1, 15);

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

2710: line_in_tab(1).fTransQuantity :=pg_trx_line_qty_tab(I);
2711:
2712: IF (pg_exempt_cont_flag_tab(I)='R') THEN
2713: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2714: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2715: END IF;
2716:
2717: line_in_tab(1).fPriCustExmtCrtfNum := substrb(pg_Line_char3_tab(I), 1, 15);
2718: line_in_tab(1).fPriStExmtRsnCd := SUBSTRB(pg_Line_char4_tab(I),1,1);

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

2730: pg_line_amount_tab(I)/100;
2731:
2732: ELSE
2733: inv_in_rec.fInvDate := arp_adjusted_doc_date;
2734: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdNormal;
2735: line_in_tab(1).fTransExtendedAmt :=(-1*arp_line_amount);
2736: line_in_tab(1).fTransQuantity :=arp_quantity;
2737:
2738: IF (arp_exemption_control_flag='R') THEN /*Need to check*/

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

2735: line_in_tab(1).fTransExtendedAmt :=(-1*arp_line_amount);
2736: line_in_tab(1).fTransQuantity :=arp_quantity;
2737:
2738: IF (arp_exemption_control_flag='R') THEN /*Need to check*/
2739: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2740: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2741: END IF;
2742: line_in_tab(1).fPriCustExmtCrtfNum := substrb(arp_cert_num, 1, 15);
2743: line_in_tab(1).fPriStExmtRsnCd := SUBSTRB(arp_state_exempt_reason,1,1);

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

2736: line_in_tab(1).fTransQuantity :=arp_quantity;
2737:
2738: IF (arp_exemption_control_flag='R') THEN /*Need to check*/
2739: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2740: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2741: END IF;
2742: line_in_tab(1).fPriCustExmtCrtfNum := substrb(arp_cert_num, 1, 15);
2743: line_in_tab(1).fPriStExmtRsnCd := SUBSTRB(arp_state_exempt_reason,1,1);
2744: line_in_tab(1).fPriStExmtAmt := -1 * arp_state_exempt_percent *

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

2758:
2759: ELSIF (l_document_type IN ('LINE_ONLY_CREDIT_MEMO')) THEN
2760: IF (l_line_level_action IN ('CREATE','DELETE','CANCEL')) THEN
2761: inv_in_rec.fInvDate := pg_adj_doc_date_tab(I);
2762: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdDistributeTax;
2763: line_in_tab(1).fTransExtendedAmt :=pg_line_amount_tab(I);
2764: line_in_tab(1).fTransQuantity :=pg_trx_line_qty_tab(I);
2765: line_in_tab(1).fTransTotalTaxAmt :=0;
2766:

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

2764: line_in_tab(1).fTransQuantity :=pg_trx_line_qty_tab(I);
2765: line_in_tab(1).fTransTotalTaxAmt :=0;
2766:
2767: if(pg_exempt_cont_flag_tab(I)='R') then
2768: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2769: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2770: end if;
2771: else
2772: inv_in_rec.fInvDate := arp_adjusted_doc_date;

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

2765: line_in_tab(1).fTransTotalTaxAmt :=0;
2766:
2767: if(pg_exempt_cont_flag_tab(I)='R') then
2768: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2769: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2770: end if;
2771: else
2772: inv_in_rec.fInvDate := arp_adjusted_doc_date;
2773: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdDistributeTax;

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

2769: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2770: end if;
2771: else
2772: inv_in_rec.fInvDate := arp_adjusted_doc_date;
2773: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdDistributeTax;
2774: line_in_tab(1).fTransExtendedAmt :=(-1*arp_line_amount);
2775: line_in_tab(1).fTransQuantity :=arp_quantity;
2776: line_in_tab(1).fTransTotalTaxAmt :=0;
2777:

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

2775: line_in_tab(1).fTransQuantity :=arp_quantity;
2776: line_in_tab(1).fTransTotalTaxAmt :=0;
2777:
2778: if(arp_exemption_control_flag='R') then /*Need to check*/
2779: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2780: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2781: end if;
2782: end if;
2783:

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

2776: line_in_tab(1).fTransTotalTaxAmt :=0;
2777:
2778: if(arp_exemption_control_flag='R') then /*Need to check*/
2779: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2780: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2781: end if;
2782: end if;
2783:
2784: ELSIF l_document_type IN ('TAX_ONLY_CREDIT_MEMO') THEN

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

2783:
2784: ELSIF l_document_type IN ('TAX_ONLY_CREDIT_MEMO') THEN
2785: IF (l_line_level_action IN ('CREATE','DELETE','CANCEL')) THEN
2786: inv_in_rec.fInvDate := pg_adj_doc_date_tab(I);
2787: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdTaxOnlyCredit;
2788: line_in_tab(1).fTransExtendedAmt := NULL;
2789: line_in_tab(1).fTransQuantity := NULL;
2790:
2791: IF (pg_exempt_cont_flag_tab(I)='R') THEN

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

2796: line_in_tab(1).fPriCoTaxAmt := g_CoTaxAmt;
2797: line_in_tab(1).fPriCiTaxAmt := g_CiTaxAmt;
2798: ELSE
2799: inv_in_rec.fInvDate := arp_adjusted_doc_date;
2800: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdTaxOnlyCredit;
2801: line_in_tab(1).fTransExtendedAmt := NULL;
2802: line_in_tab(1).fTransQuantity := NULL;
2803:
2804: IF (arp_exemption_control_flag='R') THEN /*Need to check*/

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

2807: END IF;
2808: END IF;
2809: ELSIF l_document_type in ('ADJUSTMENT') THEN
2810: inv_in_rec.fInvDate := pg_trx_date_tab(i);
2811: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdDistributeTax;
2812: line_in_tab(1).fTransExtendedAmt := NULL;
2813: line_in_tab(1).fTransQuantity := NULL;
2814: ELSIF l_document_type in ('TAX_LINE_SYNC'
2815: ,'TAX_ONLY_INVOICE'

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

2814: ELSIF l_document_type in ('TAX_LINE_SYNC'
2815: ,'TAX_ONLY_INVOICE'
2816: ,'TAX_ONLY_ADJUSTMENT') THEN
2817: inv_in_rec.fInvDate := arp_trx_date;
2818: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdDistributeTax;
2819: line_in_tab(1).fTransExtendedAmt := NULL;
2820: line_in_tab(1).fTransQuantity := NULL;
2821: --bug#6831713
2822: line_in_tab(1).fTransTotalTaxAmt := g_TotalTaxAmt;

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

2834: END IF;
2835:
2836: ELSIF (l_document_type in ('SALES_QUOTE')) then -- Bug5927656
2837: inv_in_rec.fInvDate := pg_trx_date_tab(i);
2838: line_in_tab(1).fTransCd := ZX_TAX_VERTEX_QSU.cQSUTransCdNormal;
2839:
2840: IF l_line_level_action = 'CREATE' THEN
2841: line_in_tab(1).fTransExtendedAmt := pg_line_amount_tab(I);
2842: END IF;

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

2843:
2844: line_in_tab(1).fTransQuantity :=pg_trx_line_qty_tab(I);
2845:
2846: IF (pg_exempt_cont_flag_tab(I)='R') then
2847: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2848: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2849: END IF;
2850:
2851: line_in_tab(1).fPriCustExmtCrtfNum := substrb(pg_Line_char3_tab(I), 1, 15);

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

2844: line_in_tab(1).fTransQuantity :=pg_trx_line_qty_tab(I);
2845:
2846: IF (pg_exempt_cont_flag_tab(I)='R') then
2847: line_in_tab(1).fProdTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2848: inv_in_rec.fCustTxblty := ZX_TAX_VERTEX_QSU.cQSUTxbltyTxbl ;
2849: END IF;
2850:
2851: line_in_tab(1).fPriCustExmtCrtfNum := substrb(pg_Line_char3_tab(I), 1, 15);
2852: line_in_tab(1).fPriStExmtRsnCd := SUBSTRB(pg_Line_char4_tab(I),1,1);

Line 3112: ZX_TAX_VERTEX_QSU.QSUCalculateTaxes(context_rec,

3108: to_char(sysdate, 'DD/MON/YYYY HH:MI:SS'));
3109: END IF;
3110:
3111: BEGIN
3112: ZX_TAX_VERTEX_QSU.QSUCalculateTaxes(context_rec,
3113: inv_in_rec,
3114: line_in_tab,
3115: inv_out_rec,
3116: line_out_tab,

Line 3155: ZX_TAX_VERTEX_QSU.QSUWritePreReturnsData(context_rec,

3151: | Write the transaction to register table(regprereturnstbl)|
3152: -----------------------------------------------------------*/
3153:
3154: BEGIN
3155: ZX_TAX_VERTEX_QSU.QSUWritePreReturnsData(context_rec,
3156: inv_out_rec,
3157: line_out_tab);
3158: EXCEPTION
3159: WHEN OTHERS THEN

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

3238:
3239: /*-----------------------------------------------------------
3240: | Populate Secondary Tax Amounts and Rates |
3241: -----------------------------------------------------------*/
3242: IF line_out_tab(1).fPriDiAppliesTo = ZX_TAX_VERTEX_QSU.cQSUDiApplyCi THEN
3243: sec_county_tax_rate := 0;
3244: sec_county_tax_amount := 0;
3245: sec_city_tax_rate := dist_tax_rate;
3246: sec_city_tax_amount := dist_tax_amount;

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

3267: add_dist_tax_rate := line_out_tab(1).fAddDiRate * 100;
3268: /* District tax amount */
3269: add_dist_tax_amount := line_out_tab(1).fAddDiTaxAmt;
3270:
3271: IF line_out_tab(1).fAddDiAppliesTo = ZX_TAX_VERTEX_QSU.cQSUDiApplyCi THEN
3272: add_city_tax_rate := round(add_city_tax_rate + add_dist_tax_rate, 6);
3273: add_city_tax_amount := add_city_tax_amount + add_dist_tax_amount;
3274: ELSE
3275: add_county_tax_rate := round(add_county_tax_rate + add_dist_tax_rate, 6);

Line 3611: ZX_TAX_VERTEX_QSU.QSUInitializeInvoice(context_rec,

3607: /*------------------------------------------------------
3608: | Initialize context_rec, inv_in_rec, and line_in_tab.|
3609: ------------------------------------------------------*/
3610: BEGIN
3611: ZX_TAX_VERTEX_QSU.QSUInitializeInvoice(context_rec,
3612: inv_in_rec,
3613: line_in_tab);
3614:
3615: EXCEPTION

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

5479: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
5480: END IF;
5481:
5482: context_rec.fGetJurisNames := TRUE;
5483: context_rec.fRoundingMethod := ZX_TAX_VERTEX_QSU.cQSURndngMethodQuantum;
5484:
5485: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5486: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
5487: END IF;