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 ZX_TRANSACTION_LINES_GT

Line 396: DELETE FROM ZX_TRANSACTION_LINES_GT;

392: -----------------------------------------------------------------
393: l_debug_info := 'Purge staging tables';
394: Print(l_api_name,l_debug_info);
395: -----------------------------------------------------------------
396: DELETE FROM ZX_TRANSACTION_LINES_GT;
397: DELETE FROM ZX_IMPORT_TAX_LINES_GT;
398: DELETE FROM ZX_TRX_TAX_LINK_GT;
399:
400: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;

Line 926: -- zx_trx_headers_gt and zx_transaction_lines_gt for validation of

922: AND ail.line_type_lookup_code NOT IN ('TAX', 'AWT')
923: AND NVL(ail.tax_already_calculated_flag, 'N') = 'Y';
924:
925: -- 1. validate_default_import is called during import. This populates
926: -- zx_trx_headers_gt and zx_transaction_lines_gt for validation of
927: -- the taxable lines.
928: -- 2. During import of invoices matched to complex work purchase orders,
929: -- matching will recoup prepayments and calculate tax on it. This
930: -- would have purged zx_trx_headers_gt and zx_transaction_lines_gt.

Line 930: -- would have purged zx_trx_headers_gt and zx_transaction_lines_gt.

926: -- zx_trx_headers_gt and zx_transaction_lines_gt for validation of
927: -- the taxable lines.
928: -- 2. During import of invoices matched to complex work purchase orders,
929: -- matching will recoup prepayments and calculate tax on it. This
930: -- would have purged zx_trx_headers_gt and zx_transaction_lines_gt.
931: -- 3. In this case, the staging table will need to repopulated.
932: -- Parameter P_eTax_Already_called_flag must be passed as 'Y'
933: -- to ensure document level event type is passed to eTax
934: -- as 'STANDARD UPDATED'.

Line 1003: UPDATE zx_transaction_lines_gt

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

Line 1916: UPDATE zx_transaction_lines_gt

1912: -----------------------------------------------------------------
1913: l_debug_info := 'Step 3: Update trx_id in Lines';
1914: -----------------------------------------------------------------
1915: BEGIN
1916: UPDATE zx_transaction_lines_gt
1917: SET trx_id = P_Invoice_Id
1918: WHERE trx_id = P_Interface_Invoice_Id;
1919: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
1920: END;

Line 2674: DELETE FROM ZX_TRANSACTION_LINES_GT;

2670: -----------------------------------------------------------------
2671: l_debug_info := 'Purge staging table, Clear/Load Cache';
2672: Print(l_api_name,l_debug_info);
2673: -----------------------------------------------------------------
2674: DELETE FROM ZX_TRANSACTION_LINES_GT;
2675:
2676: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;
2677: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;
2678:

Line 5858: | ZX_TRANSACTION_LINES_GT

Line 5892: TYPE Trans_Lines_Tab_Type IS TABLE OF zx_transaction_lines_gt%ROWTYPE;

5888: l_curr_calling_sequence VARCHAR2(4000);
5889:
5890: -- This structure to populate all the lines information previous to insert
5891: -- in eTax global temporary table.
5892: TYPE Trans_Lines_Tab_Type IS TABLE OF zx_transaction_lines_gt%ROWTYPE;
5893: trans_lines Trans_Lines_Tab_Type := Trans_Lines_Tab_Type();
5894:
5895: l_application_id zx_trx_headers_gt.application_id%TYPE;
5896: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;

Line 5896: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;

5892: TYPE Trans_Lines_Tab_Type IS TABLE OF zx_transaction_lines_gt%ROWTYPE;
5893: trans_lines Trans_Lines_Tab_Type := Trans_Lines_Tab_Type();
5894:
5895: l_application_id zx_trx_headers_gt.application_id%TYPE;
5896: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
5897: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
5898: l_line_class zx_transaction_lines_gt.line_class%TYPE;
5899: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
5900: l_init_line_amt_incl_tax_fg zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;

Line 5897: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;

5893: trans_lines Trans_Lines_Tab_Type := Trans_Lines_Tab_Type();
5894:
5895: l_application_id zx_trx_headers_gt.application_id%TYPE;
5896: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
5897: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
5898: l_line_class zx_transaction_lines_gt.line_class%TYPE;
5899: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
5900: l_init_line_amt_incl_tax_fg zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
5901: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

Line 5898: l_line_class zx_transaction_lines_gt.line_class%TYPE;

5894:
5895: l_application_id zx_trx_headers_gt.application_id%TYPE;
5896: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
5897: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
5898: l_line_class zx_transaction_lines_gt.line_class%TYPE;
5899: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
5900: l_init_line_amt_incl_tax_fg zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
5901: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
5902: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;

Line 5899: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;

5895: l_application_id zx_trx_headers_gt.application_id%TYPE;
5896: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
5897: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
5898: l_line_class zx_transaction_lines_gt.line_class%TYPE;
5899: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
5900: l_init_line_amt_incl_tax_fg zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
5901: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
5902: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
5903:

Line 5900: l_init_line_amt_incl_tax_fg zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;

5896: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
5897: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
5898: l_line_class zx_transaction_lines_gt.line_class%TYPE;
5899: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
5900: l_init_line_amt_incl_tax_fg zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
5901: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
5902: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
5903:
5904:

Line 5901: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

5897: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
5898: l_line_class zx_transaction_lines_gt.line_class%TYPE;
5899: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
5900: l_init_line_amt_incl_tax_fg zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
5901: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
5902: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
5903:
5904:
5905: -- Purchase Order Info

Line 5902: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;

5898: l_line_class zx_transaction_lines_gt.line_class%TYPE;
5899: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
5900: l_init_line_amt_incl_tax_fg zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
5901: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
5902: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
5903:
5904:
5905: -- Purchase Order Info
5906: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

Line 5906: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

5902: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
5903:
5904:
5905: -- Purchase Order Info
5906: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
5907: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
5908: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
5909: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
5910: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;

Line 5907: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;

5903:
5904:
5905: -- Purchase Order Info
5906: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
5907: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
5908: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
5909: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
5910: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
5911: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

Line 5908: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;

5904:
5905: -- Purchase Order Info
5906: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
5907: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
5908: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
5909: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
5910: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
5911: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
5912: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;

Line 5909: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

5905: -- Purchase Order Info
5906: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
5907: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
5908: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
5909: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
5910: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
5911: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
5912: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
5913: l_uom_code mtl_units_of_measure.uom_code%TYPE;

Line 5911: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

5907: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
5908: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
5909: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
5910: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
5911: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
5912: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
5913: l_uom_code mtl_units_of_measure.uom_code%TYPE;
5914: l_dummy number;
5915:

Line 5918: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;

5914: l_dummy number;
5915:
5916:
5917: -- Receipt Info
5918: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
5919: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
5920: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
5921: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
5922: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

Line 5919: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;

5915:
5916:
5917: -- Receipt Info
5918: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
5919: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
5920: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
5921: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
5922: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
5923:

Line 5920: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;

5916:
5917: -- Receipt Info
5918: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
5919: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
5920: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
5921: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
5922: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
5923:
5924: -- Prepayment Info

Line 5921: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;

5917: -- Receipt Info
5918: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
5919: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
5920: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
5921: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
5922: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
5923:
5924: -- Prepayment Info
5925: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;

Line 5922: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

5918: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
5919: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
5920: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
5921: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
5922: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
5923:
5924: -- Prepayment Info
5925: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
5926: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;

Line 5925: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;

5921: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
5922: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
5923:
5924: -- Prepayment Info
5925: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
5926: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
5927: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
5928: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
5929: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;

Line 5926: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;

5922: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
5923:
5924: -- Prepayment Info
5925: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
5926: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
5927: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
5928: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
5929: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
5930: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;

Line 5927: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;

5923:
5924: -- Prepayment Info
5925: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
5926: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
5927: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
5928: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
5929: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
5930: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
5931: l_applied_from_trx_id zx_transaction_lines_gt.applied_from_trx_id%TYPE;

Line 5930: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;

5926: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
5927: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
5928: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
5929: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
5930: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
5931: l_applied_from_trx_id zx_transaction_lines_gt.applied_from_trx_id%TYPE;
5932: l_applied_from_line_id zx_transaction_lines_gt.applied_from_line_id%TYPE;
5933:
5934: -- Corrected Invoice Info

Line 5931: l_applied_from_trx_id zx_transaction_lines_gt.applied_from_trx_id%TYPE;

5927: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
5928: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
5929: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
5930: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
5931: l_applied_from_trx_id zx_transaction_lines_gt.applied_from_trx_id%TYPE;
5932: l_applied_from_line_id zx_transaction_lines_gt.applied_from_line_id%TYPE;
5933:
5934: -- Corrected Invoice Info
5935: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;

Line 5932: l_applied_from_line_id zx_transaction_lines_gt.applied_from_line_id%TYPE;

5928: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
5929: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
5930: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
5931: l_applied_from_trx_id zx_transaction_lines_gt.applied_from_trx_id%TYPE;
5932: l_applied_from_line_id zx_transaction_lines_gt.applied_from_line_id%TYPE;
5933:
5934: -- Corrected Invoice Info
5935: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
5936: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;

Line 5935: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;

5931: l_applied_from_trx_id zx_transaction_lines_gt.applied_from_trx_id%TYPE;
5932: l_applied_from_line_id zx_transaction_lines_gt.applied_from_line_id%TYPE;
5933:
5934: -- Corrected Invoice Info
5935: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
5936: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
5937: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
5938: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
5939: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;

Line 5936: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;

5932: l_applied_from_line_id zx_transaction_lines_gt.applied_from_line_id%TYPE;
5933:
5934: -- Corrected Invoice Info
5935: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
5936: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
5937: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
5938: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
5939: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
5940: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;

Line 5937: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;

5933:
5934: -- Corrected Invoice Info
5935: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
5936: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
5937: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
5938: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
5939: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
5940: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
5941:

Line 5938: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;

5934: -- Corrected Invoice Info
5935: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
5936: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
5937: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
5938: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
5939: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
5940: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
5941:
5942: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;

Line 5939: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;

5935: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
5936: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
5937: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
5938: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
5939: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
5940: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
5941:
5942: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
5943: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;

Line 5940: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;

5936: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
5937: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
5938: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
5939: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
5940: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
5941:
5942: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
5943: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
5944:

Line 5943: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;

5939: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
5940: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
5941:
5942: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
5943: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
5944:
5945: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
5946: l_allow_tax_code_override varchar2(10);
5947:

Line 5945: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;

5941:
5942: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
5943: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
5944:
5945: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
5946: l_allow_tax_code_override varchar2(10);
5947:
5948: l_intended_use zx_lines_det_factors.line_intended_use%type;
5949: l_product_type zx_lines_det_factors.product_type%type;

Line 6674: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_transaction_lines_gt values ');

6670: trans_lines(i).ctrl_hdr_tx_appl_flag := l_ctrl_hdr_tx_appl_flag;
6671: trans_lines(i).ctrl_total_line_tx_amt := l_inv_line_list(i).control_amount;
6672:
6673: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6674: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_transaction_lines_gt values ');
6675: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'event_class_code: ' || trans_lines(i).event_class_code);
6676: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_id: ' || trans_lines(i).trx_id);
6677: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_line_id: ' || trans_lines(i).trx_line_id);
6678: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_level_type: ' || trans_lines(i).trx_level_type);

Line 6697: INSERT INTO zx_transaction_lines_gt

6693: l_debug_info := 'Bulk Insert into global temp table';
6694: -------------------------------------------------------------------
6695: IF ( l_return_status = TRUE ) THEN
6696: FORALL m IN trans_lines.FIRST..trans_lines.LAST
6697: INSERT INTO zx_transaction_lines_gt
6698: VALUES trans_lines(m);
6699: END IF;
6700:
6701: RETURN l_return_status;

Line 6726: | ZX_TRANSACTION_LINES_GT

Line 6756: TYPE Trx_Lines_Tab_Type IS TABLE OF zx_transaction_lines_gt%ROWTYPE;

6752:
6753: l_debug_info VARCHAR2(240);
6754: l_curr_calling_sequence VARCHAR2(4000);
6755:
6756: TYPE Trx_Lines_Tab_Type IS TABLE OF zx_transaction_lines_gt%ROWTYPE;
6757: TYPE Tax_Lines_Tab_Type IS TABLE OF zx_import_tax_lines_gt%ROWTYPE;
6758: TYPE Link_Lines_Tab_Type IS TABLE OF zx_trx_tax_link_gt%ROWTYPE;
6759:
6760: trans_lines Trx_Lines_Tab_Type := Trx_Lines_Tab_Type();

Line 6764: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;

6760: trans_lines Trx_Lines_Tab_Type := Trx_Lines_Tab_Type();
6761: tax_lines Tax_Lines_Tab_Type := Tax_Lines_Tab_Type();
6762: link_lines Link_Lines_Tab_Type := Link_Lines_Tab_Type();
6763:
6764: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
6765: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
6766: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
6767: l_line_class zx_transaction_lines_gt.line_class%TYPE;
6768: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;

Line 6765: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;

6761: tax_lines Tax_Lines_Tab_Type := Tax_Lines_Tab_Type();
6762: link_lines Link_Lines_Tab_Type := Link_Lines_Tab_Type();
6763:
6764: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
6765: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
6766: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
6767: l_line_class zx_transaction_lines_gt.line_class%TYPE;
6768: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
6769:

Line 6766: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;

6762: link_lines Link_Lines_Tab_Type := Link_Lines_Tab_Type();
6763:
6764: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
6765: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
6766: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
6767: l_line_class zx_transaction_lines_gt.line_class%TYPE;
6768: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
6769:
6770: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

Line 6767: l_line_class zx_transaction_lines_gt.line_class%TYPE;

6763:
6764: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
6765: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
6766: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
6767: l_line_class zx_transaction_lines_gt.line_class%TYPE;
6768: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
6769:
6770: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
6771: l_uom_code mtl_units_of_measure.uom_code%TYPE;

Line 6768: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;

6764: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
6765: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
6766: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
6767: l_line_class zx_transaction_lines_gt.line_class%TYPE;
6768: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
6769:
6770: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
6771: l_uom_code mtl_units_of_measure.uom_code%TYPE;
6772: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;

Line 6770: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

6766: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
6767: l_line_class zx_transaction_lines_gt.line_class%TYPE;
6768: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
6769:
6770: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
6771: l_uom_code mtl_units_of_measure.uom_code%TYPE;
6772: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
6773:
6774: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;

Line 6775: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;

6771: l_uom_code mtl_units_of_measure.uom_code%TYPE;
6772: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
6773:
6774: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
6775: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
6776: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
6777: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
6778:
6779: -- Purchase Order Info

Line 6777: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;

6773:
6774: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
6775: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
6776: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
6777: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
6778:
6779: -- Purchase Order Info
6780: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
6781: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;

Line 6780: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

6776: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
6777: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
6778:
6779: -- Purchase Order Info
6780: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
6781: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
6782: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
6783: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
6784: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

Line 6781: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;

6777: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
6778:
6779: -- Purchase Order Info
6780: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
6781: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
6782: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
6783: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
6784: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
6785: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

Line 6782: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;

6778:
6779: -- Purchase Order Info
6780: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
6781: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
6782: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
6783: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
6784: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
6785: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
6786: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;

Line 6783: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

6779: -- Purchase Order Info
6780: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
6781: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
6782: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
6783: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
6784: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
6785: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
6786: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
6787: l_dummy number;

Line 6784: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

6780: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
6781: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
6782: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
6783: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
6784: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
6785: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
6786: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
6787: l_dummy number;
6788:

Line 6785: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

6781: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
6782: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
6783: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
6784: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
6785: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
6786: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
6787: l_dummy number;
6788:
6789: -- Receipt Info

Line 6790: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;

6786: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
6787: l_dummy number;
6788:
6789: -- Receipt Info
6790: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
6791: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
6792: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
6793: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
6794:

Line 6791: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;

6787: l_dummy number;
6788:
6789: -- Receipt Info
6790: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
6791: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
6792: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
6793: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
6794:
6795: -- Correction Invoices

Line 6792: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;

6788:
6789: -- Receipt Info
6790: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
6791: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
6792: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
6793: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
6794:
6795: -- Correction Invoices
6796: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;

Line 6793: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;

6789: -- Receipt Info
6790: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
6791: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
6792: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
6793: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
6794:
6795: -- Correction Invoices
6796: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
6797: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;

Line 6796: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;

6792: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
6793: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
6794:
6795: -- Correction Invoices
6796: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
6797: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
6798: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
6799: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
6800: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;

Line 6797: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;

6793: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
6794:
6795: -- Correction Invoices
6796: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
6797: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
6798: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
6799: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
6800: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
6801:

Line 6798: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;

6794:
6795: -- Correction Invoices
6796: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
6797: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
6798: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
6799: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
6800: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
6801:
6802: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;

Line 6799: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;

6795: -- Correction Invoices
6796: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
6797: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
6798: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
6799: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
6800: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
6801:
6802: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
6803: l_allow_tax_code_override varchar2(10);

Line 6800: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;

6796: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
6797: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
6798: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
6799: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
6800: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
6801:
6802: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
6803: l_allow_tax_code_override varchar2(10);
6804:

Line 6802: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;

6798: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
6799: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
6800: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
6801:
6802: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
6803: l_allow_tax_code_override varchar2(10);
6804:
6805: l_return_status BOOLEAN := TRUE;
6806: j INT := 1;

Line 7193: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_transaction_lines_gt values ');

7189: -- flag will be always N.
7190: trans_lines(j).historical_flag := 'N';
7191: -- Debug messages added for 6321366
7192: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7193: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_transaction_lines_gt values ');
7194: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'event_class_code: ' || trans_lines(j).event_class_code);
7195: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_id: ' || trans_lines(j).trx_id);
7196: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_line_id: ' || trans_lines(j).trx_line_id);
7197: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_level_type: ' || trans_lines(j).trx_level_type);

Line 7465: -- in the zx_transaction_lines_gt table.

7461: -- Invoice is tax-only, and there is no need to run applicability.
7462: -- In this case the user provides all the tax information for the line
7463: -- to be imported. However, the additional taxable related info
7464: -- that eTax need to store will be passed to eTax using a pseudo line
7465: -- in the zx_transaction_lines_gt table.
7466:
7467: l_line_level_action := 'LINE_INFO_TAX_ONLY';
7468: END IF;
7469:

Line 7712: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_transaction_lines_gt values ');

7708:
7709: trans_lines(j).input_tax_classification_code := p_inv_line_list(i).tax_classification_code;
7710: --debug log messages added for 6321366
7711: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7712: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_transaction_lines_gt values ');
7713: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'event_class_code: ' || trans_lines(j).event_class_code);
7714: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_id: ' || trans_lines(j).trx_id);
7715: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_line_id: ' || trans_lines(j).trx_line_id);
7716: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_level_type: ' || trans_lines(j).trx_level_type);

Line 7813: DELETE FROM zx_transaction_lines_gt

7809: l_debug_info := 'Step 12: Bulk Insert into global temp tables';
7810: -------------------------------------------------------------------
7811: IF ( l_return_status = TRUE ) THEN
7812:
7813: DELETE FROM zx_transaction_lines_gt
7814: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
7815: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
7816: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
7817: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

Line 7823: INSERT INTO zx_transaction_lines_gt

7819: AND trx_id = p_invoice_header_rec.invoice_id;
7820:
7821: IF (trans_lines.COUNT > 0) THEN
7822: FORALL m IN trans_lines.FIRST..trans_lines.LAST
7823: INSERT INTO zx_transaction_lines_gt
7824: VALUES trans_lines(m);
7825: END IF;
7826:
7827: IF (tax_lines.COUNT > 0) THEN

Line 7868: | ZX_TRANSACTION_LINES_GT, and ZX_IMPORT_TAX_LINES_GT.

7864: | FUNCTION - Populate_Tax_Lines_GT()
7865: |
7866: | DESCRIPTION
7867: | This function will get additional information required to populate the
7868: | ZX_TRANSACTION_LINES_GT, and ZX_IMPORT_TAX_LINES_GT.
7869: | There is no need to populate ZX_TRX_TAX_LINK_GT since any tax line
7870: | manually created is assume to be allocated to all the ITEM lines in the
7871: | invoice.
7872: | This function returns TRUE if the population of the temp table goes

Line 7903: TYPE Trx_Lines_Tab_Type IS TABLE OF zx_transaction_lines_gt%ROWTYPE;

7899:
7900: l_debug_info VARCHAR2(240);
7901: l_curr_calling_sequence VARCHAR2(4000);
7902:
7903: TYPE Trx_Lines_Tab_Type IS TABLE OF zx_transaction_lines_gt%ROWTYPE;
7904: TYPE Tax_Lines_Tab_Type IS TABLE OF zx_import_tax_lines_gt%ROWTYPE;
7905: TYPE Link_Lines_Tab_Type IS TABLE OF zx_trx_tax_link_gt%ROWTYPE;
7906:
7907: trans_lines Trx_Lines_Tab_Type := Trx_Lines_Tab_Type();

Line 7911: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;

7907: trans_lines Trx_Lines_Tab_Type := Trx_Lines_Tab_Type();
7908: tax_lines Tax_Lines_Tab_Type := Tax_Lines_Tab_Type();
7909: link_lines Link_Lines_Tab_Type := Link_Lines_Tab_Type();
7910:
7911: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
7912: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
7913: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
7914: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
7915: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

Line 7912: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;

7908: tax_lines Tax_Lines_Tab_Type := Tax_Lines_Tab_Type();
7909: link_lines Link_Lines_Tab_Type := Link_Lines_Tab_Type();
7910:
7911: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
7912: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
7913: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
7914: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
7915: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
7916:

Line 7913: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;

7909: link_lines Link_Lines_Tab_Type := Link_Lines_Tab_Type();
7910:
7911: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
7912: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
7913: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
7914: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
7915: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
7916:
7917: -- Purchase Order

Line 7914: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;

7910:
7911: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
7912: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
7913: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
7914: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
7915: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
7916:
7917: -- Purchase Order
7918: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

Line 7915: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

7911: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
7912: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
7913: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
7914: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
7915: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
7916:
7917: -- Purchase Order
7918: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
7919: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;

Line 7918: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

7914: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
7915: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
7916:
7917: -- Purchase Order
7918: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
7919: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
7920: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
7921: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
7922: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

Line 7919: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;

7915: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
7916:
7917: -- Purchase Order
7918: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
7919: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
7920: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
7921: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
7922: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
7923: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;

Line 7920: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;

7916:
7917: -- Purchase Order
7918: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
7919: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
7920: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
7921: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
7922: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
7923: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
7924:

Line 7921: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

7917: -- Purchase Order
7918: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
7919: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
7920: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
7921: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
7922: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
7923: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
7924:
7925: -- Receipt Matched

Line 7922: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

7918: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
7919: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
7920: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
7921: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
7922: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
7923: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
7924:
7925: -- Receipt Matched
7926: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;

Line 7926: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;

7922: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
7923: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
7924:
7925: -- Receipt Matched
7926: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
7927: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
7928: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
7929: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
7930: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

Line 7927: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;

7923: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
7924:
7925: -- Receipt Matched
7926: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
7927: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
7928: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
7929: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
7930: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
7931: l_uom_code mtl_units_of_measure.uom_code%TYPE;

Line 7928: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;

7924:
7925: -- Receipt Matched
7926: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
7927: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
7928: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
7929: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
7930: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
7931: l_uom_code mtl_units_of_measure.uom_code%TYPE;
7932: l_dummy number;

Line 7929: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;

7925: -- Receipt Matched
7926: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
7927: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
7928: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
7929: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
7930: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
7931: l_uom_code mtl_units_of_measure.uom_code%TYPE;
7932: l_dummy number;
7933:

Line 7930: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

7926: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
7927: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
7928: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
7929: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
7930: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
7931: l_uom_code mtl_units_of_measure.uom_code%TYPE;
7932: l_dummy number;
7933:
7934: -- Corrections

Line 7935: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;

7931: l_uom_code mtl_units_of_measure.uom_code%TYPE;
7932: l_dummy number;
7933:
7934: -- Corrections
7935: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
7936: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
7937: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
7938: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
7939: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;

Line 7936: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;

7932: l_dummy number;
7933:
7934: -- Corrections
7935: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
7936: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
7937: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
7938: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
7939: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
7940:

Line 7937: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;

7933:
7934: -- Corrections
7935: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
7936: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
7937: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
7938: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
7939: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
7940:
7941: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;

Line 7938: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;

7934: -- Corrections
7935: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
7936: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
7937: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
7938: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
7939: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
7940:
7941: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
7942: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;

Line 7939: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;

7935: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
7936: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
7937: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
7938: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
7939: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
7940:
7941: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
7942: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
7943: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;

Line 7942: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;

7938: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
7939: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
7940:
7941: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
7942: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
7943: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
7944: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
7945: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269
7946:

Line 7943: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;

7939: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
7940:
7941: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
7942: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
7943: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
7944: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
7945: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269
7946:
7947: k INT := 1;

Line 8150: -- zx_transaction_lines_gt GT table.

8146: -- the RCV_TRANSACTION_ID field it is a match other charges case.
8147: -- In this case we expect the tax columns to be null and the we require
8148: -- the control amount to be populated so that eTax will know how much the
8149: -- tax should be. In this case we will populate the
8150: -- zx_transaction_lines_gt GT table.
8151: -- For the second case, where the tax lines are manually created we will
8152: -- populate both zx_transaction_lines_gt and zx_import_tax_lines_gt. It
8153: -- is also required to populate the zx_trx_tax_link_gt with a one to one
8154: -- allocation.

Line 8152: -- populate both zx_transaction_lines_gt and zx_import_tax_lines_gt. It

8148: -- the control amount to be populated so that eTax will know how much the
8149: -- tax should be. In this case we will populate the
8150: -- zx_transaction_lines_gt GT table.
8151: -- For the second case, where the tax lines are manually created we will
8152: -- populate both zx_transaction_lines_gt and zx_import_tax_lines_gt. It
8153: -- is also required to populate the zx_trx_tax_link_gt with a one to one
8154: -- allocation.
8155:
8156:

Line 8200: -- in the zx_transaction_lines_gt table.

8196: -- Invoice is tax-only, and there is no need to run applicability.
8197: -- In this case the user provides all the tax information for the line
8198: -- to be imported. The additional taxable related info
8199: -- that eTax need to store will be passed to eTax using a pseudo line
8200: -- in the zx_transaction_lines_gt table.
8201:
8202: l_line_level_action := 'LINE_INFO_TAX_ONLY';
8203: l_line_control_amount := l_inv_tax_list(i).control_amount;
8204:

Line 8455: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_transaction_lines_gt values ');

8451:
8452: trans_lines(i).input_tax_classification_code := l_inv_tax_list(i).tax_classification_code;
8453: -- Debug messages added for 6321366
8454: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8455: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_transaction_lines_gt values ');
8456: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'event_class_code: ' || trans_lines(i).event_class_code);
8457: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_id: ' || trans_lines(i).trx_id);
8458: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_line_id: ' || trans_lines(i).trx_line_id);
8459: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_level_type: ' || trans_lines(i).trx_level_type);

Line 8554: INSERT INTO zx_transaction_lines_gt

8550: IF ( l_return_status = TRUE ) THEN
8551:
8552: IF (trans_lines.COUNT > 0) THEN
8553: FORALL m IN trans_lines.FIRST..trans_lines.LAST
8554: INSERT INTO zx_transaction_lines_gt
8555: VALUES trans_lines(m);
8556: END IF;
8557:
8558: IF (tax_lines.COUNT > 0) THEN

Line 8646: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

8642: l_ref_doc_entity_code zx_itm_distributions_gt.ref_doc_entity_code%TYPE;
8643: l_ref_doc_event_class_code zx_itm_distributions_gt.ref_doc_event_class_code%TYPE;
8644: l_ref_doc_trx_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
8645: l_ref_doc_trx_level_type zx_itm_distributions_gt.ref_doc_trx_level_type%TYPE;
8646: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
8647: l_ref_doc_trx_line_dist_qty zx_itm_distributions_gt.ref_doc_trx_line_dist_qty%TYPE;
8648: l_po_unit_price po_line_locations_all.price_override%TYPE;
8649: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
8650: l_po_release_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;

Line 8651: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

8647: l_ref_doc_trx_line_dist_qty zx_itm_distributions_gt.ref_doc_trx_line_dist_qty%TYPE;
8648: l_po_unit_price po_line_locations_all.price_override%TYPE;
8649: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
8650: l_po_release_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
8651: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
8652: l_uom_code mtl_units_of_measure.uom_code%TYPE;
8653:
8654: l_dist_level_action zx_itm_distributions_gt.dist_level_action%TYPE;
8655: l_line_quantity_invoiced zx_itm_distributions_gt.trx_line_quantity%TYPE;

Line 8664: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;

8660: l_converted_qty ap_invoice_distributions_all.quantity_invoiced%TYPE;
8661: l_converted_price ap_invoice_distributions_all.unit_price%TYPE;
8662:
8663: -- Correction Invoice Info
8664: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
8665: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
8666: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
8667: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
8668: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;

Line 8665: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;

8661: l_converted_price ap_invoice_distributions_all.unit_price%TYPE;
8662:
8663: -- Correction Invoice Info
8664: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
8665: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
8666: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
8667: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
8668: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
8669: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;

Line 8666: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;

8662:
8663: -- Correction Invoice Info
8664: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
8665: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
8666: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
8667: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
8668: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
8669: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
8670: l_adj_doc_trx_id zx_itm_distributions_gt.adjusted_doc_trx_id%TYPE;

Line 8667: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;

8663: -- Correction Invoice Info
8664: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
8665: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
8666: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
8667: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
8668: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
8669: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
8670: l_adj_doc_trx_id zx_itm_distributions_gt.adjusted_doc_trx_id%TYPE;
8671: l_adj_doc_line_id zx_itm_distributions_gt.adjusted_doc_line_id%TYPE;

Line 8668: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;

8664: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
8665: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
8666: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
8667: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
8668: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
8669: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
8670: l_adj_doc_trx_id zx_itm_distributions_gt.adjusted_doc_trx_id%TYPE;
8671: l_adj_doc_line_id zx_itm_distributions_gt.adjusted_doc_line_id%TYPE;
8672:

Line 8669: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;

8665: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
8666: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
8667: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
8668: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
8669: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
8670: l_adj_doc_trx_id zx_itm_distributions_gt.adjusted_doc_trx_id%TYPE;
8671: l_adj_doc_line_id zx_itm_distributions_gt.adjusted_doc_line_id%TYPE;
8672:
8673: -- Prepayment Info

Line 8674: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;

8670: l_adj_doc_trx_id zx_itm_distributions_gt.adjusted_doc_trx_id%TYPE;
8671: l_adj_doc_line_id zx_itm_distributions_gt.adjusted_doc_line_id%TYPE;
8672:
8673: -- Prepayment Info
8674: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
8675: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
8676: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
8677: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
8678: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;

Line 8675: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;

8671: l_adj_doc_line_id zx_itm_distributions_gt.adjusted_doc_line_id%TYPE;
8672:
8673: -- Prepayment Info
8674: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
8675: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
8676: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
8677: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
8678: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
8679: l_applied_from_trx_id ap_invoice_lines_all.invoice_id%TYPE;

Line 8676: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;

8672:
8673: -- Prepayment Info
8674: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
8675: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
8676: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
8677: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
8678: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
8679: l_applied_from_trx_id ap_invoice_lines_all.invoice_id%TYPE;
8680: l_applied_from_line_id ap_invoice_lines_all.line_number%TYPE;

Line 8681: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;

8677: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
8678: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
8679: l_applied_from_trx_id ap_invoice_lines_all.invoice_id%TYPE;
8680: l_applied_from_line_id ap_invoice_lines_all.line_number%TYPE;
8681: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
8682:
8683: l_prepay_inv_id ap_invoice_lines_all.invoice_id%TYPE;
8684: l_prepay_line_num ap_invoice_lines_all.line_number%TYPE;
8685:

Line 9260: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;

9256:
9257: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
9258: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
9259:
9260: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
9261: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
9262: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
9263: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
9264:

Line 9261: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;

9257: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
9258: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
9259:
9260: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
9261: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
9262: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
9263: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
9264:
9265: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;

Line 9265: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;

9261: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
9262: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
9263: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
9264:
9265: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
9266: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
9267: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
9268: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
9269: l_uom_code mtl_units_of_measure.uom_code%TYPE;

Line 9266: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;

9262: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
9263: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
9264:
9265: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
9266: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
9267: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
9268: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
9269: l_uom_code mtl_units_of_measure.uom_code%TYPE;
9270:

Line 9267: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;

9263: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
9264:
9265: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
9266: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
9267: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
9268: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
9269: l_uom_code mtl_units_of_measure.uom_code%TYPE;
9270:
9271: -- Variables for PO doc info

Line 9268: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

9264:
9265: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
9266: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
9267: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
9268: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
9269: l_uom_code mtl_units_of_measure.uom_code%TYPE;
9270:
9271: -- Variables for PO doc info
9272: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

Line 9272: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

9268: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
9269: l_uom_code mtl_units_of_measure.uom_code%TYPE;
9270:
9271: -- Variables for PO doc info
9272: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
9273: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
9274: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
9275: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
9276: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

Line 9273: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;

9269: l_uom_code mtl_units_of_measure.uom_code%TYPE;
9270:
9271: -- Variables for PO doc info
9272: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
9273: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
9274: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
9275: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
9276: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
9277: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;

Line 9274: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;

9270:
9271: -- Variables for PO doc info
9272: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
9273: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
9274: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
9275: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
9276: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
9277: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
9278: l_dummy number;

Line 9275: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

9271: -- Variables for PO doc info
9272: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
9273: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
9274: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
9275: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
9276: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
9277: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
9278: l_dummy number;
9279:

Line 9276: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

9272: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
9273: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
9274: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
9275: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
9276: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
9277: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
9278: l_dummy number;
9279:
9280: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

Line 9280: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

9276: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
9277: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
9278: l_dummy number;
9279:
9280: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
9281:
9282: l_return_status BOOLEAN := TRUE;
9283: l_return_status_service VARCHAR2(4000);
9284: l_msg_count NUMBER;

Line 9470: l_debug_info := 'Step 9: Insert into zx_transaction_lines_gt';

9466: END IF;
9467: END IF;
9468:
9469: ------------------------------------------------------------------------
9470: l_debug_info := 'Step 9: Insert into zx_transaction_lines_gt';
9471: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9472: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
9473: END IF;
9474: ------------------------------------------------------------------------

Line 9477: INSERT INTO zx_transaction_lines_gt

9473: END IF;
9474: ------------------------------------------------------------------------
9475: IF ( l_return_status = TRUE ) THEN
9476:
9477: INSERT INTO zx_transaction_lines_gt
9478: (
9479: application_id,
9480: entity_code,
9481: event_class_code,

Line 9686: BEGIN DELETE zx_transaction_lines_gt;

9682: BEGIN DELETE zx_trx_headers_gt;
9683: EXCEPTION WHEN NO_DATA_FOUND THEN null;
9684: END;
9685:
9686: BEGIN DELETE zx_transaction_lines_gt;
9687: EXCEPTION WHEN NO_DATA_FOUND THEN null;
9688: END;
9689:
9690: RETURN l_return_status;

Line 12437: DELETE FROM ZX_TRANSACTION_LINES_GT;

12433: -----------------------------------------------------------------
12434: l_debug_info := 'Purge Staging Tables. Clear/Load Cache';
12435: Print(l_api_name,l_debug_info);
12436: -----------------------------------------------------------------
12437: DELETE FROM ZX_TRANSACTION_LINES_GT;
12438:
12439: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;
12440: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;
12441:

Line 12545: DELETE FROM ZX_TRANSACTION_LINES_GT;

12541: END IF;
12542: END IF;
12543:
12544: DELETE FROM ZX_TRX_HEADERS_GT;
12545: DELETE FROM ZX_TRANSACTION_LINES_GT;
12546:
12547: RETURN l_return_status;
12548:
12549: EXCEPTION

Line 12567: DELETE FROM ZX_TRANSACTION_LINES_GT;

12563: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
12564: END IF;
12565:
12566: DELETE FROM ZX_TRX_HEADERS_GT;
12567: DELETE FROM ZX_TRANSACTION_LINES_GT;
12568:
12569: APP_EXCEPTION.RAISE_EXCEPTION;
12570:
12571: END Generate_Recouped_Tax;

Line 13041: l_debug_info := 'Step 5: Populate zx_transaction_lines_gt';

13037: END IF;
13038: END IF;
13039:
13040: ------------------------------------------------------------
13041: l_debug_info := 'Step 5: Populate zx_transaction_lines_gt';
13042: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13043: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
13044: END IF;
13045: ------------------------------------------------------------

Line 13142: TYPE Trx_Lines_Tab_Type IS TABLE OF zx_transaction_lines_gt%ROWTYPE;

13138: P_Event_Class_Code IN VARCHAR2,
13139: P_Error_Code OUT NOCOPY VARCHAR2,
13140: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN IS
13141:
13142: TYPE Trx_Lines_Tab_Type IS TABLE OF zx_transaction_lines_gt%ROWTYPE;
13143:
13144: trans_lines Trx_Lines_Tab_Type := Trx_Lines_Tab_Type();
13145:
13146: l_line_class zx_transaction_lines_gt.line_class%TYPE;

Line 13146: l_line_class zx_transaction_lines_gt.line_class%TYPE;

13142: TYPE Trx_Lines_Tab_Type IS TABLE OF zx_transaction_lines_gt%ROWTYPE;
13143:
13144: trans_lines Trx_Lines_Tab_Type := Trx_Lines_Tab_Type();
13145:
13146: l_line_class zx_transaction_lines_gt.line_class%TYPE;
13147: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
13148: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
13149: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
13150: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;

Line 13147: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;

13143:
13144: trans_lines Trx_Lines_Tab_Type := Trx_Lines_Tab_Type();
13145:
13146: l_line_class zx_transaction_lines_gt.line_class%TYPE;
13147: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
13148: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
13149: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
13150: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
13151: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;

Line 13148: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;

13144: trans_lines Trx_Lines_Tab_Type := Trx_Lines_Tab_Type();
13145:
13146: l_line_class zx_transaction_lines_gt.line_class%TYPE;
13147: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
13148: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
13149: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
13150: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
13151: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
13152: l_fob_point zx_transaction_lines_gt.fob_point%TYPE;

Line 13149: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

13145:
13146: l_line_class zx_transaction_lines_gt.line_class%TYPE;
13147: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
13148: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
13149: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
13150: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
13151: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
13152: l_fob_point zx_transaction_lines_gt.fob_point%TYPE;
13153:

Line 13150: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;

13146: l_line_class zx_transaction_lines_gt.line_class%TYPE;
13147: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
13148: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
13149: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
13150: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
13151: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
13152: l_fob_point zx_transaction_lines_gt.fob_point%TYPE;
13153:
13154: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;

Line 13151: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;

13147: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
13148: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
13149: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
13150: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
13151: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
13152: l_fob_point zx_transaction_lines_gt.fob_point%TYPE;
13153:
13154: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
13155:

Line 13152: l_fob_point zx_transaction_lines_gt.fob_point%TYPE;

13148: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
13149: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
13150: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
13151: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
13152: l_fob_point zx_transaction_lines_gt.fob_point%TYPE;
13153:
13154: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
13155:
13156: -- Purchase Order

Line 13157: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

13153:
13154: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
13155:
13156: -- Purchase Order
13157: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
13158: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
13159: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
13160: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
13161: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;

Line 13158: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;

13154: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
13155:
13156: -- Purchase Order
13157: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
13158: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
13159: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
13160: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
13161: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
13162: l_uom_code mtl_units_of_measure.uom_code%TYPE;

Line 13159: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;

13155:
13156: -- Purchase Order
13157: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
13158: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
13159: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
13160: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
13161: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
13162: l_uom_code mtl_units_of_measure.uom_code%TYPE;
13163: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

Line 13160: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

13156: -- Purchase Order
13157: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
13158: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
13159: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
13160: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
13161: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
13162: l_uom_code mtl_units_of_measure.uom_code%TYPE;
13163: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
13164: l_dummy number;

Line 13163: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

13159: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
13160: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
13161: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
13162: l_uom_code mtl_units_of_measure.uom_code%TYPE;
13163: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
13164: l_dummy number;
13165:
13166: -- Receipt
13167: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;

Line 13167: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;

13163: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
13164: l_dummy number;
13165:
13166: -- Receipt
13167: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
13168: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
13169: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
13170: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
13171: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

Line 13168: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;

13164: l_dummy number;
13165:
13166: -- Receipt
13167: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
13168: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
13169: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
13170: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
13171: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
13172:

Line 13169: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;

13165:
13166: -- Receipt
13167: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
13168: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
13169: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
13170: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
13171: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
13172:
13173: -- PO Tax Determining Attributes

Line 13170: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;

13166: -- Receipt
13167: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
13168: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
13169: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
13170: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
13171: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
13172:
13173: -- PO Tax Determining Attributes
13174: l_trx_bus_category zx_transaction_lines_gt.trx_business_category%TYPE;

Line 13171: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

13167: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
13168: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
13169: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
13170: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
13171: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
13172:
13173: -- PO Tax Determining Attributes
13174: l_trx_bus_category zx_transaction_lines_gt.trx_business_category%TYPE;
13175: l_intended_use zx_lines_det_factors.line_intended_use%type;

Line 13174: l_trx_bus_category zx_transaction_lines_gt.trx_business_category%TYPE;

13170: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
13171: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
13172:
13173: -- PO Tax Determining Attributes
13174: l_trx_bus_category zx_transaction_lines_gt.trx_business_category%TYPE;
13175: l_intended_use zx_lines_det_factors.line_intended_use%type;
13176: l_product_type zx_lines_det_factors.product_type%type;
13177: l_product_category zx_lines_det_factors.product_category%type;
13178: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;

Line 13181: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;

13177: l_product_category zx_lines_det_factors.product_category%type;
13178: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
13179: l_user_def_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
13180: l_assessable_value zx_lines_det_factors.assessable_value%type;
13181: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
13182: l_allow_tax_code_override VARCHAR2(10);
13183: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269
13184:
13185: l_debug_info Varchar2(240);

Line 13220: l_debug_info := 'Step 4: Populate zx_transaction_lines_gt';

13216: WHERE vendor_site_id = P_Invoice_Header_Rec.vendor_site_id;
13217: END;
13218:
13219: ----------------------------------------------------------------------
13220: l_debug_info := 'Step 4: Populate zx_transaction_lines_gt';
13221: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13222: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
13223: END IF;
13224: ----------------------------------------------------------------------

Line 13478: DELETE FROM zx_transaction_lines_gt;

13474: IF (l_return_status = TRUE) THEN
13475:
13476: IF (trans_lines.COUNT > 0) THEN
13477:
13478: DELETE FROM zx_transaction_lines_gt;
13479:
13480: FORALL m IN trans_lines.FIRST..trans_lines.LAST
13481: INSERT INTO zx_transaction_lines_gt
13482: VALUES trans_lines(m);

Line 13481: INSERT INTO zx_transaction_lines_gt

13477:
13478: DELETE FROM zx_transaction_lines_gt;
13479:
13480: FORALL m IN trans_lines.FIRST..trans_lines.LAST
13481: INSERT INTO zx_transaction_lines_gt
13482: VALUES trans_lines(m);
13483:
13484: END IF;
13485: END IF;