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 539: DELETE FROM ZX_TRANSACTION_LINES_GT;

535: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
536: END IF;
537: --Print(l_api_name,l_debug_info);
538: -----------------------------------------------------------------
539: DELETE FROM ZX_TRANSACTION_LINES_GT;
540: DELETE FROM ZX_IMPORT_TAX_LINES_GT;
541: DELETE FROM ZX_TRX_TAX_LINK_GT;
542:
543: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;

Line 1219: DELETE FROM ZX_TRANSACTION_LINES_GT;

1215: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1216: END IF;
1217: -----------------------------------------------------------------
1218: DELETE FROM ZX_TRX_HEADERS_GT;
1219: DELETE FROM ZX_TRANSACTION_LINES_GT;
1220: DELETE FROM ZX_IMPORT_TAX_LINES_GT;
1221: DELETE FROM ZX_TRX_TAX_LINK_GT;
1222:
1223: /*

Line 1258: -- zx_trx_headers_gt and zx_transaction_lines_gt for validation of

1254: AND ail.line_type_lookup_code NOT IN ('TAX', 'AWT')
1255: AND NVL(ail.tax_already_calculated_flag, 'N') = 'Y';
1256:
1257: -- 1. validate_default_import is called during import. This populates
1258: -- zx_trx_headers_gt and zx_transaction_lines_gt for validation of
1259: -- the taxable lines.
1260: -- 2. During import of invoices matched to complex work purchase orders,
1261: -- matching will recoup prepayments and calculate tax on it. This
1262: -- would have purged zx_trx_headers_gt and zx_transaction_lines_gt.

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

1258: -- zx_trx_headers_gt and zx_transaction_lines_gt for validation of
1259: -- the taxable lines.
1260: -- 2. During import of invoices matched to complex work purchase orders,
1261: -- matching will recoup prepayments and calculate tax on it. This
1262: -- would have purged zx_trx_headers_gt and zx_transaction_lines_gt.
1263: -- 3. In this case, the staging table will need to repopulated.
1264: -- Parameter P_eTax_Already_called_flag must be passed as 'Y'
1265: -- to ensure document level event type is passed to eTax
1266: -- as 'STANDARD UPDATED'.

Line 1347: UPDATE zx_transaction_lines_gt

1343: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1344: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1345: END IF;
1346: -----------------------------------------------------------------
1347: UPDATE zx_transaction_lines_gt
1348: SET trx_id = P_Invoice_Id
1349: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
1350: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
1351: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

Line 2458: DELETE FROM ZX_TRANSACTION_LINES_GT;

2454: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2455: END IF;
2456: -----------------------------------------------------------------
2457: DELETE FROM ZX_TRX_HEADERS_GT;
2458: DELETE FROM ZX_TRANSACTION_LINES_GT;
2459: DELETE FROM ZX_IMPORT_TAX_LINES_GT;
2460: DELETE FROM ZX_TRX_TAX_LINK_GT;
2461:
2462: -----------------------------------------------------------------

Line 2571: UPDATE zx_transaction_lines_gt

2567: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2568: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2569: END IF;
2570: -----------------------------------------------------------------
2571: UPDATE zx_transaction_lines_gt
2572: SET trx_id = P_Invoice_Id
2573: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2574: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2575: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

Line 3383: DELETE FROM ZX_TRANSACTION_LINES_GT;

3379: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3380: END IF;
3381: --Print(l_api_name,l_debug_info);
3382: -----------------------------------------------------------------
3383: DELETE FROM ZX_TRANSACTION_LINES_GT;
3384:
3385: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;
3386: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;
3387:

Line 6870: | ZX_TRANSACTION_LINES_GT

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

6900: l_curr_calling_sequence VARCHAR2(4000);
6901:
6902: -- This structure to populate all the lines information previous to insert
6903: -- in eTax global temporary table.
6904: TYPE Trans_Lines_Tab_Type IS TABLE OF zx_transaction_lines_gt%ROWTYPE;
6905: trans_lines Trans_Lines_Tab_Type := Trans_Lines_Tab_Type();
6906:
6907: l_application_id zx_trx_headers_gt.application_id%TYPE;
6908: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;

Line 6908: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;

6904: TYPE Trans_Lines_Tab_Type IS TABLE OF zx_transaction_lines_gt%ROWTYPE;
6905: trans_lines Trans_Lines_Tab_Type := Trans_Lines_Tab_Type();
6906:
6907: l_application_id zx_trx_headers_gt.application_id%TYPE;
6908: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
6909: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
6910: l_line_class zx_transaction_lines_gt.line_class%TYPE;
6911: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
6912: l_init_line_amt_incl_tax_fg zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;

Line 6909: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;

6905: trans_lines Trans_Lines_Tab_Type := Trans_Lines_Tab_Type();
6906:
6907: l_application_id zx_trx_headers_gt.application_id%TYPE;
6908: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
6909: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
6910: l_line_class zx_transaction_lines_gt.line_class%TYPE;
6911: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
6912: l_init_line_amt_incl_tax_fg zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
6913: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

Line 6910: l_line_class zx_transaction_lines_gt.line_class%TYPE;

6906:
6907: l_application_id zx_trx_headers_gt.application_id%TYPE;
6908: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
6909: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
6910: l_line_class zx_transaction_lines_gt.line_class%TYPE;
6911: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
6912: l_init_line_amt_incl_tax_fg zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
6913: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
6914: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;

Line 6911: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;

6907: l_application_id zx_trx_headers_gt.application_id%TYPE;
6908: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
6909: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
6910: l_line_class zx_transaction_lines_gt.line_class%TYPE;
6911: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
6912: l_init_line_amt_incl_tax_fg zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
6913: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
6914: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
6915:

Line 6912: l_init_line_amt_incl_tax_fg zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;

6908: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
6909: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
6910: l_line_class zx_transaction_lines_gt.line_class%TYPE;
6911: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
6912: l_init_line_amt_incl_tax_fg zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
6913: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
6914: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
6915:
6916:

Line 6913: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

6909: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
6910: l_line_class zx_transaction_lines_gt.line_class%TYPE;
6911: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
6912: l_init_line_amt_incl_tax_fg zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
6913: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
6914: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
6915:
6916:
6917: -- Purchase Order Info

Line 6914: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;

6910: l_line_class zx_transaction_lines_gt.line_class%TYPE;
6911: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
6912: l_init_line_amt_incl_tax_fg zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
6913: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
6914: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
6915:
6916:
6917: -- Purchase Order Info
6918: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

Line 6918: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

6914: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
6915:
6916:
6917: -- Purchase Order Info
6918: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
6919: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
6920: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
6921: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
6922: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;

Line 6919: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;

6915:
6916:
6917: -- Purchase Order Info
6918: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
6919: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
6920: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
6921: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
6922: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
6923: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

Line 6920: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;

6916:
6917: -- Purchase Order Info
6918: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
6919: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
6920: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
6921: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
6922: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
6923: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
6924: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;

Line 6921: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

6917: -- Purchase Order Info
6918: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
6919: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
6920: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
6921: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
6922: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
6923: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
6924: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
6925: l_uom_code mtl_units_of_measure.uom_code%TYPE;

Line 6923: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

6919: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
6920: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
6921: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
6922: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
6923: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
6924: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
6925: l_uom_code mtl_units_of_measure.uom_code%TYPE;
6926: l_dummy number;
6927:

Line 6930: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;

6926: l_dummy number;
6927:
6928:
6929: -- Receipt Info
6930: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
6931: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
6932: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
6933: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
6934: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

Line 6931: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;

6927:
6928:
6929: -- Receipt Info
6930: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
6931: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
6932: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
6933: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
6934: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
6935:

Line 6932: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;

6928:
6929: -- Receipt Info
6930: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
6931: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
6932: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
6933: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
6934: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
6935:
6936: -- Prepayment Info

Line 6933: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;

6929: -- Receipt Info
6930: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
6931: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
6932: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
6933: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
6934: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
6935:
6936: -- Prepayment Info
6937: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;

Line 6934: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

6930: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
6931: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
6932: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
6933: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
6934: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
6935:
6936: -- Prepayment Info
6937: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
6938: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;

Line 6937: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;

6933: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
6934: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
6935:
6936: -- Prepayment Info
6937: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
6938: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
6939: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
6940: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
6941: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;

Line 6938: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;

6934: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
6935:
6936: -- Prepayment Info
6937: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
6938: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
6939: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
6940: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
6941: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
6942: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;

Line 6939: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;

6935:
6936: -- Prepayment Info
6937: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
6938: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
6939: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
6940: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
6941: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
6942: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
6943: l_applied_from_trx_id zx_transaction_lines_gt.applied_from_trx_id%TYPE;

Line 6942: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;

6938: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
6939: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
6940: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
6941: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
6942: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
6943: l_applied_from_trx_id zx_transaction_lines_gt.applied_from_trx_id%TYPE;
6944: l_applied_from_line_id zx_transaction_lines_gt.applied_from_line_id%TYPE;
6945:
6946: -- Corrected Invoice Info

Line 6943: l_applied_from_trx_id zx_transaction_lines_gt.applied_from_trx_id%TYPE;

6939: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
6940: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
6941: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
6942: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
6943: l_applied_from_trx_id zx_transaction_lines_gt.applied_from_trx_id%TYPE;
6944: l_applied_from_line_id zx_transaction_lines_gt.applied_from_line_id%TYPE;
6945:
6946: -- Corrected Invoice Info
6947: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;

Line 6944: l_applied_from_line_id zx_transaction_lines_gt.applied_from_line_id%TYPE;

6940: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
6941: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
6942: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
6943: l_applied_from_trx_id zx_transaction_lines_gt.applied_from_trx_id%TYPE;
6944: l_applied_from_line_id zx_transaction_lines_gt.applied_from_line_id%TYPE;
6945:
6946: -- Corrected Invoice Info
6947: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
6948: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;

Line 6947: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;

6943: l_applied_from_trx_id zx_transaction_lines_gt.applied_from_trx_id%TYPE;
6944: l_applied_from_line_id zx_transaction_lines_gt.applied_from_line_id%TYPE;
6945:
6946: -- Corrected Invoice Info
6947: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
6948: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
6949: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
6950: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
6951: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;

Line 6948: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;

6944: l_applied_from_line_id zx_transaction_lines_gt.applied_from_line_id%TYPE;
6945:
6946: -- Corrected Invoice Info
6947: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
6948: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
6949: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
6950: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
6951: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
6952: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;

Line 6949: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;

6945:
6946: -- Corrected Invoice Info
6947: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
6948: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
6949: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
6950: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
6951: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
6952: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
6953:

Line 6950: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;

6946: -- Corrected Invoice Info
6947: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
6948: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
6949: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
6950: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
6951: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
6952: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
6953:
6954: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;

Line 6951: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;

6947: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
6948: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
6949: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
6950: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
6951: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
6952: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
6953:
6954: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
6955: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;

Line 6952: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;

6948: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
6949: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
6950: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
6951: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
6952: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
6953:
6954: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
6955: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
6956:

Line 6955: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;

6951: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
6952: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
6953:
6954: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
6955: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
6956:
6957: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
6958: l_allow_tax_code_override varchar2(10);
6959:

Line 6957: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;

6953:
6954: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
6955: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
6956:
6957: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
6958: l_allow_tax_code_override varchar2(10);
6959:
6960: l_intended_use zx_lines_det_factors.line_intended_use%type;
6961: l_product_type zx_lines_det_factors.product_type%type;

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

8083: trans_lines(i).ctrl_hdr_tx_appl_flag := l_ctrl_hdr_tx_appl_flag;
8084: trans_lines(i).ctrl_total_line_tx_amt := l_inv_line_list(i).control_amount;
8085:
8086: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8087: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_transaction_lines_gt values ');
8088: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'event_class_code: ' || trans_lines(i).event_class_code);
8089: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_id: ' || trans_lines(i).trx_id);
8090: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_line_id: ' || trans_lines(i).trx_line_id);
8091: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_level_type: ' || trans_lines(i).trx_level_type);

Line 8113: INSERT INTO zx_transaction_lines_gt

8109: END IF;
8110: -------------------------------------------------------------------
8111: IF ( l_return_status = TRUE ) THEN
8112: FORALL m IN trans_lines.FIRST..trans_lines.LAST
8113: INSERT INTO zx_transaction_lines_gt
8114: VALUES trans_lines(m);
8115: END IF;
8116:
8117: RETURN l_return_status;

Line 8149: | ZX_TRANSACTION_LINES_GT

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

8175:
8176: l_debug_info VARCHAR2(240);
8177: l_curr_calling_sequence VARCHAR2(4000);
8178:
8179: TYPE Trx_Lines_Tab_Type IS TABLE OF zx_transaction_lines_gt%ROWTYPE;
8180: TYPE Tax_Lines_Tab_Type IS TABLE OF zx_import_tax_lines_gt%ROWTYPE;
8181: TYPE Link_Lines_Tab_Type IS TABLE OF zx_trx_tax_link_gt%ROWTYPE;
8182:
8183: trans_lines Trx_Lines_Tab_Type := Trx_Lines_Tab_Type();

Line 8187: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;

8183: trans_lines Trx_Lines_Tab_Type := Trx_Lines_Tab_Type();
8184: tax_lines Tax_Lines_Tab_Type := Tax_Lines_Tab_Type();
8185: link_lines Link_Lines_Tab_Type := Link_Lines_Tab_Type();
8186:
8187: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
8188: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
8189: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
8190: l_line_class zx_transaction_lines_gt.line_class%TYPE;
8191: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;

Line 8188: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;

8184: tax_lines Tax_Lines_Tab_Type := Tax_Lines_Tab_Type();
8185: link_lines Link_Lines_Tab_Type := Link_Lines_Tab_Type();
8186:
8187: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
8188: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
8189: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
8190: l_line_class zx_transaction_lines_gt.line_class%TYPE;
8191: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
8192:

Line 8189: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;

8185: link_lines Link_Lines_Tab_Type := Link_Lines_Tab_Type();
8186:
8187: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
8188: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
8189: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
8190: l_line_class zx_transaction_lines_gt.line_class%TYPE;
8191: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
8192:
8193: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

Line 8190: l_line_class zx_transaction_lines_gt.line_class%TYPE;

8186:
8187: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
8188: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
8189: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
8190: l_line_class zx_transaction_lines_gt.line_class%TYPE;
8191: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
8192:
8193: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
8194: l_uom_code mtl_units_of_measure.uom_code%TYPE;

Line 8191: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;

8187: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
8188: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
8189: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
8190: l_line_class zx_transaction_lines_gt.line_class%TYPE;
8191: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
8192:
8193: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
8194: l_uom_code mtl_units_of_measure.uom_code%TYPE;
8195: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;

Line 8193: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

8189: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
8190: l_line_class zx_transaction_lines_gt.line_class%TYPE;
8191: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
8192:
8193: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
8194: l_uom_code mtl_units_of_measure.uom_code%TYPE;
8195: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
8196:
8197: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;

Line 8198: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;

8194: l_uom_code mtl_units_of_measure.uom_code%TYPE;
8195: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
8196:
8197: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
8198: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
8199: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
8200: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
8201:
8202: -- Purchase Order Info

Line 8200: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;

8196:
8197: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
8198: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
8199: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
8200: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
8201:
8202: -- Purchase Order Info
8203: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
8204: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;

Line 8203: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

8199: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
8200: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
8201:
8202: -- Purchase Order Info
8203: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
8204: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
8205: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
8206: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
8207: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

Line 8204: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;

8200: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
8201:
8202: -- Purchase Order Info
8203: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
8204: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
8205: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
8206: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
8207: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
8208: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

Line 8205: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;

8201:
8202: -- Purchase Order Info
8203: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
8204: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
8205: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
8206: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
8207: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
8208: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
8209: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;

Line 8206: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

8202: -- Purchase Order Info
8203: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
8204: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
8205: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
8206: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
8207: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
8208: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
8209: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
8210: l_dummy number;

Line 8207: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

8203: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
8204: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
8205: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
8206: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
8207: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
8208: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
8209: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
8210: l_dummy number;
8211:

Line 8208: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

8204: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
8205: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
8206: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
8207: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
8208: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
8209: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
8210: l_dummy number;
8211:
8212: -- Receipt Info

Line 8213: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;

8209: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
8210: l_dummy number;
8211:
8212: -- Receipt Info
8213: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
8214: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
8215: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
8216: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
8217:

Line 8214: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;

8210: l_dummy number;
8211:
8212: -- Receipt Info
8213: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
8214: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
8215: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
8216: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
8217:
8218: -- Correction Invoices

Line 8215: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;

8211:
8212: -- Receipt Info
8213: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
8214: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
8215: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
8216: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
8217:
8218: -- Correction Invoices
8219: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;

Line 8216: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;

8212: -- Receipt Info
8213: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
8214: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
8215: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
8216: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
8217:
8218: -- Correction Invoices
8219: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
8220: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;

Line 8219: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;

8215: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
8216: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
8217:
8218: -- Correction Invoices
8219: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
8220: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
8221: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
8222: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
8223: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;

Line 8220: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;

8216: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
8217:
8218: -- Correction Invoices
8219: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
8220: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
8221: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
8222: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
8223: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
8224: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE; --Bug8332737

Line 8221: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;

8217:
8218: -- Correction Invoices
8219: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
8220: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
8221: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
8222: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
8223: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
8224: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE; --Bug8332737
8225:

Line 8222: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;

8218: -- Correction Invoices
8219: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
8220: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
8221: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
8222: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
8223: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
8224: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE; --Bug8332737
8225:
8226:

Line 8223: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;

8219: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
8220: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
8221: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
8222: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
8223: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
8224: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE; --Bug8332737
8225:
8226:
8227: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;

Line 8224: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE; --Bug8332737

8220: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
8221: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
8222: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
8223: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
8224: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE; --Bug8332737
8225:
8226:
8227: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
8228: l_allow_tax_code_override varchar2(10);

Line 8227: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;

8223: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
8224: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE; --Bug8332737
8225:
8226:
8227: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
8228: l_allow_tax_code_override varchar2(10);
8229:
8230: l_return_status BOOLEAN := TRUE;
8231: j INT := 1;

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

8935: -- flag will be always N.
8936: trans_lines(j).historical_flag := 'N';
8937: -- Debug messages added for 6321366
8938: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8939: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_transaction_lines_gt values ');
8940: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'event_class_code: ' || trans_lines(j).event_class_code);
8941: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_id: ' || trans_lines(j).trx_id);
8942: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_line_id: ' || trans_lines(j).trx_line_id);
8943: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_level_type: ' || trans_lines(j).trx_level_type);

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

9343:
9344: trans_lines(l_pseudo).input_tax_classification_code:= p_inv_line_list(i).tax_classification_code;
9345:
9346: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9347: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_transaction_lines_gt values ');
9348: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'event_class_code: ' || trans_lines(l_pseudo).event_class_code);
9349: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_id: ' || trans_lines(l_pseudo).trx_id);
9350: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_line_id: ' || trans_lines(l_pseudo).trx_line_id);
9351: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_level_type: ' || trans_lines(l_pseudo).trx_level_type);

Line 9412: -- in the zx_transaction_lines_gt table.

9408: -- Invoice is tax-only, and there is no need to run applicability.
9409: -- In this case the user provides all the tax information for the line
9410: -- to be imported. However, the additional taxable related info
9411: -- that eTax need to store will be passed to eTax using a pseudo line
9412: -- in the zx_transaction_lines_gt table.
9413:
9414: l_line_level_action := 'LINE_INFO_TAX_ONLY';
9415: END IF;
9416:

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

9724:
9725: trans_lines(j).input_tax_classification_code := p_inv_line_list(i).tax_classification_code;
9726: --debug log messages added for 6321366
9727: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9728: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_transaction_lines_gt values ');
9729: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'event_class_code: ' || trans_lines(j).event_class_code);
9730: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_id: ' || trans_lines(j).trx_id);
9731: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_line_id: ' || trans_lines(j).trx_line_id);
9732: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_level_type: ' || trans_lines(j).trx_level_type);

Line 9859: DELETE FROM zx_transaction_lines_gt

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

Line 9869: INSERT INTO zx_transaction_lines_gt

9865: AND trx_id = p_invoice_header_rec.invoice_id;
9866:
9867: IF (trans_lines.COUNT > 0) THEN
9868: FORALL m IN trans_lines.FIRST..trans_lines.LAST
9869: INSERT INTO zx_transaction_lines_gt
9870: VALUES trans_lines(m);
9871: END IF;
9872:
9873: IF (tax_lines.COUNT > 0) THEN

Line 9971: | ZX_TRANSACTION_LINES_GT, and ZX_IMPORT_TAX_LINES_GT.

9967: | FUNCTION - Populate_Tax_Lines_GT()
9968: |
9969: | DESCRIPTION
9970: | This function will get additional information required to populate the
9971: | ZX_TRANSACTION_LINES_GT, and ZX_IMPORT_TAX_LINES_GT.
9972: | There is no need to populate ZX_TRX_TAX_LINK_GT since any tax line
9973: | manually created is assume to be allocated to all the ITEM lines in the
9974: | invoice.
9975: | This function returns TRUE if the population of the temp table goes

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

10002:
10003: l_debug_info VARCHAR2(240);
10004: l_curr_calling_sequence VARCHAR2(4000);
10005:
10006: TYPE Trx_Lines_Tab_Type IS TABLE OF zx_transaction_lines_gt%ROWTYPE;
10007: TYPE Tax_Lines_Tab_Type IS TABLE OF zx_import_tax_lines_gt%ROWTYPE;
10008: TYPE Link_Lines_Tab_Type IS TABLE OF zx_trx_tax_link_gt%ROWTYPE;
10009:
10010: trans_lines Trx_Lines_Tab_Type := Trx_Lines_Tab_Type();

Line 10014: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;

10010: trans_lines Trx_Lines_Tab_Type := Trx_Lines_Tab_Type();
10011: tax_lines Tax_Lines_Tab_Type := Tax_Lines_Tab_Type();
10012: link_lines Link_Lines_Tab_Type := Link_Lines_Tab_Type();
10013:
10014: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
10015: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
10016: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
10017: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
10018: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

Line 10015: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;

10011: tax_lines Tax_Lines_Tab_Type := Tax_Lines_Tab_Type();
10012: link_lines Link_Lines_Tab_Type := Link_Lines_Tab_Type();
10013:
10014: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
10015: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
10016: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
10017: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
10018: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
10019:

Line 10016: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;

10012: link_lines Link_Lines_Tab_Type := Link_Lines_Tab_Type();
10013:
10014: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
10015: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
10016: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
10017: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
10018: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
10019:
10020: -- Purchase Order

Line 10017: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;

10013:
10014: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
10015: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
10016: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
10017: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
10018: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
10019:
10020: -- Purchase Order
10021: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

Line 10018: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

10014: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
10015: l_line_control_amount zx_transaction_lines_gt.ctrl_total_line_tx_amt%TYPE;
10016: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
10017: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
10018: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
10019:
10020: -- Purchase Order
10021: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
10022: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;

Line 10021: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

10017: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
10018: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
10019:
10020: -- Purchase Order
10021: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
10022: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
10023: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
10024: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
10025: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

Line 10022: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;

10018: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
10019:
10020: -- Purchase Order
10021: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
10022: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
10023: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
10024: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
10025: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
10026: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;

Line 10023: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;

10019:
10020: -- Purchase Order
10021: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
10022: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
10023: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
10024: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
10025: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
10026: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
10027:

Line 10024: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

10020: -- Purchase Order
10021: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
10022: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
10023: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
10024: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
10025: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
10026: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
10027:
10028: -- Receipt Matched

Line 10025: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

10021: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
10022: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
10023: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
10024: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
10025: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
10026: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
10027:
10028: -- Receipt Matched
10029: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;

Line 10029: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;

10025: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
10026: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
10027:
10028: -- Receipt Matched
10029: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
10030: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
10031: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
10032: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
10033: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

Line 10030: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;

10026: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
10027:
10028: -- Receipt Matched
10029: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
10030: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
10031: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
10032: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
10033: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
10034: l_uom_code mtl_units_of_measure.uom_code%TYPE;

Line 10031: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;

10027:
10028: -- Receipt Matched
10029: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
10030: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
10031: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
10032: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
10033: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
10034: l_uom_code mtl_units_of_measure.uom_code%TYPE;
10035: l_dummy number;

Line 10032: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;

10028: -- Receipt Matched
10029: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
10030: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
10031: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
10032: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
10033: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
10034: l_uom_code mtl_units_of_measure.uom_code%TYPE;
10035: l_dummy number;
10036:

Line 10033: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

10029: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
10030: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
10031: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
10032: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
10033: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
10034: l_uom_code mtl_units_of_measure.uom_code%TYPE;
10035: l_dummy number;
10036:
10037: -- Corrections

Line 10038: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;

10034: l_uom_code mtl_units_of_measure.uom_code%TYPE;
10035: l_dummy number;
10036:
10037: -- Corrections
10038: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
10039: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
10040: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
10041: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
10042: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;

Line 10039: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;

10035: l_dummy number;
10036:
10037: -- Corrections
10038: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
10039: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
10040: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
10041: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
10042: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
10043:

Line 10040: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;

10036:
10037: -- Corrections
10038: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
10039: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
10040: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
10041: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
10042: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
10043:
10044: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;

Line 10041: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;

10037: -- Corrections
10038: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
10039: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
10040: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
10041: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
10042: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
10043:
10044: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
10045: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;

Line 10042: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;

10038: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
10039: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
10040: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
10041: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
10042: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
10043:
10044: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
10045: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
10046: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;

Line 10045: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;

10041: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
10042: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
10043:
10044: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
10045: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
10046: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
10047: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
10048: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269
10049:

Line 10046: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;

10042: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
10043:
10044: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
10045: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
10046: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
10047: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
10048: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269
10049:
10050: k INT := 1;

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

10375:
10376: trans_lines(l_pseudo).input_tax_classification_code:= l_inv_tax_list(i).tax_classification_code;
10377:
10378: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
10379: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_transaction_lines_gt values ');
10380: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'event_class_code: ' || trans_lines(l_pseudo).event_class_code);
10381: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_id: ' || trans_lines(l_pseudo).trx_id);
10382: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_line_id: ' || trans_lines(l_pseudo).trx_line_id);
10383: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_level_type: ' || trans_lines(l_pseudo).trx_level_type);

Line 10433: -- zx_transaction_lines_gt GT table.

10429: -- the RCV_TRANSACTION_ID field it is a match other charges case.
10430: -- In this case we expect the tax columns to be null and the we require
10431: -- the control amount to be populated so that eTax will know how much the
10432: -- tax should be. In this case we will populate the
10433: -- zx_transaction_lines_gt GT table.
10434: -- For the second case, where the tax lines are manually created we will
10435: -- populate both zx_transaction_lines_gt and zx_import_tax_lines_gt. It
10436: -- is also required to populate the zx_trx_tax_link_gt with a one to one
10437: -- allocation.

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

10431: -- the control amount to be populated so that eTax will know how much the
10432: -- tax should be. In this case we will populate the
10433: -- zx_transaction_lines_gt GT table.
10434: -- For the second case, where the tax lines are manually created we will
10435: -- populate both zx_transaction_lines_gt and zx_import_tax_lines_gt. It
10436: -- is also required to populate the zx_trx_tax_link_gt with a one to one
10437: -- allocation.
10438:
10439:

Line 10483: -- in the zx_transaction_lines_gt table.

10479: -- Invoice is tax-only, and there is no need to run applicability.
10480: -- In this case the user provides all the tax information for the line
10481: -- to be imported. The additional taxable related info
10482: -- that eTax need to store will be passed to eTax using a pseudo line
10483: -- in the zx_transaction_lines_gt table.
10484:
10485: l_line_level_action := 'LINE_INFO_TAX_ONLY';
10486: l_line_control_amount := l_inv_tax_list(i).control_amount;
10487:

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

10746:
10747: trans_lines(i).input_tax_classification_code := l_inv_tax_list(i).tax_classification_code;
10748: -- Debug messages added for 6321366
10749: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
10750: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_transaction_lines_gt values ');
10751: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'event_class_code: ' || trans_lines(i).event_class_code);
10752: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_id: ' || trans_lines(i).trx_id);
10753: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_line_id: ' || trans_lines(i).trx_line_id);
10754: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'trx_level_type: ' || trans_lines(i).trx_level_type);

Line 10873: INSERT INTO zx_transaction_lines_gt

10869: IF ( l_return_status = TRUE ) THEN
10870:
10871: IF (trans_lines.COUNT > 0) THEN
10872: FORALL m IN trans_lines.FIRST..trans_lines.LAST
10873: INSERT INTO zx_transaction_lines_gt
10874: VALUES trans_lines(m);
10875: END IF;
10876:
10877: IF (tax_lines.COUNT > 0) THEN

Line 11026: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

11022: l_ref_doc_entity_code zx_itm_distributions_gt.ref_doc_entity_code%TYPE;
11023: l_ref_doc_event_class_code zx_itm_distributions_gt.ref_doc_event_class_code%TYPE;
11024: l_ref_doc_trx_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
11025: l_ref_doc_trx_level_type zx_itm_distributions_gt.ref_doc_trx_level_type%TYPE;
11026: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
11027: l_ref_doc_trx_line_dist_qty zx_itm_distributions_gt.ref_doc_trx_line_dist_qty%TYPE;
11028: l_po_unit_price po_line_locations_all.price_override%TYPE;
11029: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
11030: l_po_release_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;

Line 11031: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

11027: l_ref_doc_trx_line_dist_qty zx_itm_distributions_gt.ref_doc_trx_line_dist_qty%TYPE;
11028: l_po_unit_price po_line_locations_all.price_override%TYPE;
11029: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
11030: l_po_release_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
11031: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
11032: l_uom_code mtl_units_of_measure.uom_code%TYPE;
11033:
11034: l_dist_level_action zx_itm_distributions_gt.dist_level_action%TYPE;
11035: l_line_quantity_invoiced zx_itm_distributions_gt.trx_line_quantity%TYPE;

Line 11044: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;

11040: l_converted_qty ap_invoice_distributions_all.quantity_invoiced%TYPE;
11041: l_converted_price ap_invoice_distributions_all.unit_price%TYPE;
11042:
11043: -- Correction Invoice Info
11044: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
11045: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
11046: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
11047: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
11048: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;

Line 11045: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;

11041: l_converted_price ap_invoice_distributions_all.unit_price%TYPE;
11042:
11043: -- Correction Invoice Info
11044: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
11045: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
11046: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
11047: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
11048: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
11049: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;

Line 11046: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;

11042:
11043: -- Correction Invoice Info
11044: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
11045: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
11046: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
11047: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
11048: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
11049: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
11050: l_adj_doc_trx_id zx_itm_distributions_gt.adjusted_doc_trx_id%TYPE;

Line 11047: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;

11043: -- Correction Invoice Info
11044: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
11045: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
11046: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
11047: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
11048: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
11049: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
11050: l_adj_doc_trx_id zx_itm_distributions_gt.adjusted_doc_trx_id%TYPE;
11051: l_adj_doc_line_id zx_itm_distributions_gt.adjusted_doc_line_id%TYPE;

Line 11048: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;

11044: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
11045: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
11046: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
11047: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
11048: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
11049: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
11050: l_adj_doc_trx_id zx_itm_distributions_gt.adjusted_doc_trx_id%TYPE;
11051: l_adj_doc_line_id zx_itm_distributions_gt.adjusted_doc_line_id%TYPE;
11052:

Line 11049: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;

11045: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;
11046: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
11047: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
11048: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
11049: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
11050: l_adj_doc_trx_id zx_itm_distributions_gt.adjusted_doc_trx_id%TYPE;
11051: l_adj_doc_line_id zx_itm_distributions_gt.adjusted_doc_line_id%TYPE;
11052:
11053: -- Prepayment Info

Line 11054: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;

11050: l_adj_doc_trx_id zx_itm_distributions_gt.adjusted_doc_trx_id%TYPE;
11051: l_adj_doc_line_id zx_itm_distributions_gt.adjusted_doc_line_id%TYPE;
11052:
11053: -- Prepayment Info
11054: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
11055: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
11056: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
11057: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
11058: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;

Line 11055: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;

11051: l_adj_doc_line_id zx_itm_distributions_gt.adjusted_doc_line_id%TYPE;
11052:
11053: -- Prepayment Info
11054: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
11055: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
11056: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
11057: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
11058: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
11059: l_applied_from_trx_id ap_invoice_lines_all.invoice_id%TYPE;

Line 11056: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;

11052:
11053: -- Prepayment Info
11054: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
11055: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
11056: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
11057: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
11058: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
11059: l_applied_from_trx_id ap_invoice_lines_all.invoice_id%TYPE;
11060: l_applied_from_line_id ap_invoice_lines_all.line_number%TYPE;

Line 11061: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;

11057: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
11058: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
11059: l_applied_from_trx_id ap_invoice_lines_all.invoice_id%TYPE;
11060: l_applied_from_line_id ap_invoice_lines_all.line_number%TYPE;
11061: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
11062:
11063: l_prepay_inv_id ap_invoice_lines_all.invoice_id%TYPE;
11064: l_prepay_line_num ap_invoice_lines_all.line_number%TYPE;
11065:

Line 11848: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;

11844:
11845: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
11846: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
11847:
11848: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
11849: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
11850: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
11851: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
11852:

Line 11849: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;

11845: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
11846: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
11847:
11848: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
11849: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
11850: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
11851: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
11852:
11853: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;

Line 11853: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;

11849: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
11850: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
11851: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
11852:
11853: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
11854: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
11855: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
11856: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
11857: l_uom_code mtl_units_of_measure.uom_code%TYPE;

Line 11854: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;

11850: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
11851: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
11852:
11853: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
11854: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
11855: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
11856: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
11857: l_uom_code mtl_units_of_measure.uom_code%TYPE;
11858:

Line 11855: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;

11851: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
11852:
11853: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
11854: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
11855: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
11856: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
11857: l_uom_code mtl_units_of_measure.uom_code%TYPE;
11858:
11859: -- Variables for PO doc info

Line 11856: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

11852:
11853: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
11854: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
11855: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
11856: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
11857: l_uom_code mtl_units_of_measure.uom_code%TYPE;
11858:
11859: -- Variables for PO doc info
11860: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

Line 11860: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

11856: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
11857: l_uom_code mtl_units_of_measure.uom_code%TYPE;
11858:
11859: -- Variables for PO doc info
11860: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
11861: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
11862: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
11863: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
11864: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

Line 11861: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;

11857: l_uom_code mtl_units_of_measure.uom_code%TYPE;
11858:
11859: -- Variables for PO doc info
11860: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
11861: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
11862: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
11863: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
11864: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
11865: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;

Line 11862: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;

11858:
11859: -- Variables for PO doc info
11860: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
11861: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
11862: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
11863: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
11864: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
11865: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
11866: l_dummy number;

Line 11863: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

11859: -- Variables for PO doc info
11860: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
11861: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
11862: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
11863: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
11864: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
11865: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
11866: l_dummy number;
11867:

Line 11864: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

11860: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
11861: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
11862: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
11863: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
11864: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
11865: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
11866: l_dummy number;
11867:
11868: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

Line 11868: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

11864: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
11865: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
11866: l_dummy number;
11867:
11868: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
11869:
11870: l_return_status BOOLEAN := TRUE;
11871: l_return_status_service VARCHAR2(4000);
11872: l_msg_count NUMBER;

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

12069: END IF;
12070: END IF;
12071:
12072: ------------------------------------------------------------------------
12073: l_debug_info := 'Step 9: Insert into zx_transaction_lines_gt';
12074: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
12075: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
12076: END IF;
12077: ------------------------------------------------------------------------

Line 12080: INSERT INTO zx_transaction_lines_gt

12076: END IF;
12077: ------------------------------------------------------------------------
12078: IF ( l_return_status = TRUE ) THEN
12079:
12080: INSERT INTO zx_transaction_lines_gt
12081: (
12082: application_id,
12083: entity_code,
12084: event_class_code,

Line 12289: BEGIN DELETE zx_transaction_lines_gt;

12285: BEGIN DELETE zx_trx_headers_gt;
12286: EXCEPTION WHEN NO_DATA_FOUND THEN null;
12287: END;
12288:
12289: BEGIN DELETE zx_transaction_lines_gt;
12290: EXCEPTION WHEN NO_DATA_FOUND THEN null;
12291: END;
12292:
12293: RETURN l_return_status;

Line 13460: DELETE zx_transaction_lines_gt;

13456: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
13457: END IF;
13458:
13459:
13460: DELETE zx_transaction_lines_gt;
13461: DELETE zx_import_tax_lines_gt;
13462: DELETE zx_trx_tax_link_gt;
13463: DELETE zx_reverse_dist_gt;
13464:

Line 14034: DELETE zx_transaction_lines_gt;

14030: P_Error_Code => l_Error_Code,
14031: P_Calling_Sequence => l_curr_calling_sequence)) THEN
14032: NULL;
14033: END IF;
14034: DELETE zx_transaction_lines_gt;
14035: DELETE zx_import_tax_lines_gt;
14036: DELETE zx_trx_tax_link_gt;
14037: DELETE zx_reverse_dist_gt;
14038: RETURN l_return_status;

Line 15996: DELETE FROM ZX_TRANSACTION_LINES_GT;

15992: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
15993: END IF;
15994: --Print(l_api_name,l_debug_info);
15995: -----------------------------------------------------------------
15996: DELETE FROM ZX_TRANSACTION_LINES_GT;
15997:
15998: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;
15999: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;
16000:

Line 16116: DELETE FROM ZX_TRANSACTION_LINES_GT;

16112: END IF;
16113: END IF;
16114:
16115: DELETE FROM ZX_TRX_HEADERS_GT;
16116: DELETE FROM ZX_TRANSACTION_LINES_GT;
16117:
16118: RETURN l_return_status;
16119:
16120: EXCEPTION

Line 16138: DELETE FROM ZX_TRANSACTION_LINES_GT;

16134: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
16135: END IF;
16136:
16137: DELETE FROM ZX_TRX_HEADERS_GT;
16138: DELETE FROM ZX_TRANSACTION_LINES_GT;
16139:
16140: APP_EXCEPTION.RAISE_EXCEPTION;
16141:
16142: END Generate_Recouped_Tax;

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

16666: END IF;
16667: END IF;
16668:
16669: ------------------------------------------------------------
16670: l_debug_info := 'Step 5: Populate zx_transaction_lines_gt';
16671: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
16672: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
16673: END IF;
16674: ------------------------------------------------------------

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

16767: P_Event_Class_Code IN VARCHAR2,
16768: P_Error_Code OUT NOCOPY VARCHAR2,
16769: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN IS
16770:
16771: TYPE Trx_Lines_Tab_Type IS TABLE OF zx_transaction_lines_gt%ROWTYPE;
16772:
16773: trans_lines Trx_Lines_Tab_Type := Trx_Lines_Tab_Type();
16774:
16775: l_line_class zx_transaction_lines_gt.line_class%TYPE;

Line 16775: l_line_class zx_transaction_lines_gt.line_class%TYPE;

16771: TYPE Trx_Lines_Tab_Type IS TABLE OF zx_transaction_lines_gt%ROWTYPE;
16772:
16773: trans_lines Trx_Lines_Tab_Type := Trx_Lines_Tab_Type();
16774:
16775: l_line_class zx_transaction_lines_gt.line_class%TYPE;
16776: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
16777: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
16778: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
16779: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;

Line 16776: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;

16772:
16773: trans_lines Trx_Lines_Tab_Type := Trx_Lines_Tab_Type();
16774:
16775: l_line_class zx_transaction_lines_gt.line_class%TYPE;
16776: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
16777: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
16778: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
16779: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
16780: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;

Line 16777: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;

16773: trans_lines Trx_Lines_Tab_Type := Trx_Lines_Tab_Type();
16774:
16775: l_line_class zx_transaction_lines_gt.line_class%TYPE;
16776: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
16777: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
16778: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
16779: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
16780: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
16781: l_fob_point zx_transaction_lines_gt.fob_point%TYPE;

Line 16778: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

16774:
16775: l_line_class zx_transaction_lines_gt.line_class%TYPE;
16776: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
16777: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
16778: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
16779: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
16780: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
16781: l_fob_point zx_transaction_lines_gt.fob_point%TYPE;
16782:

Line 16779: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;

16775: l_line_class zx_transaction_lines_gt.line_class%TYPE;
16776: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
16777: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
16778: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
16779: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
16780: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
16781: l_fob_point zx_transaction_lines_gt.fob_point%TYPE;
16782:
16783: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;

Line 16780: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;

16776: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
16777: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
16778: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
16779: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
16780: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
16781: l_fob_point zx_transaction_lines_gt.fob_point%TYPE;
16782:
16783: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
16784:

Line 16781: l_fob_point zx_transaction_lines_gt.fob_point%TYPE;

16777: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
16778: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
16779: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
16780: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
16781: l_fob_point zx_transaction_lines_gt.fob_point%TYPE;
16782:
16783: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
16784:
16785: -- Purchase Order

Line 16786: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

16782:
16783: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
16784:
16785: -- Purchase Order
16786: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
16787: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
16788: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
16789: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
16790: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;

Line 16787: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;

16783: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
16784:
16785: -- Purchase Order
16786: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
16787: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
16788: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
16789: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
16790: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
16791: l_uom_code mtl_units_of_measure.uom_code%TYPE;

Line 16788: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;

16784:
16785: -- Purchase Order
16786: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
16787: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
16788: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
16789: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
16790: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
16791: l_uom_code mtl_units_of_measure.uom_code%TYPE;
16792: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

Line 16789: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

16785: -- Purchase Order
16786: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
16787: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
16788: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
16789: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
16790: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
16791: l_uom_code mtl_units_of_measure.uom_code%TYPE;
16792: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
16793: l_dummy number;

Line 16792: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

16788: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
16789: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
16790: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
16791: l_uom_code mtl_units_of_measure.uom_code%TYPE;
16792: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
16793: l_dummy number;
16794:
16795: -- Receipt
16796: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;

Line 16796: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;

16792: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
16793: l_dummy number;
16794:
16795: -- Receipt
16796: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
16797: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
16798: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
16799: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
16800: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

Line 16797: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;

16793: l_dummy number;
16794:
16795: -- Receipt
16796: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
16797: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
16798: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
16799: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
16800: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
16801:

Line 16798: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;

16794:
16795: -- Receipt
16796: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
16797: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
16798: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
16799: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
16800: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
16801:
16802: -- PO Tax Determining Attributes

Line 16799: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;

16795: -- Receipt
16796: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
16797: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
16798: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
16799: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
16800: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
16801:
16802: -- PO Tax Determining Attributes
16803: l_trx_bus_category zx_transaction_lines_gt.trx_business_category%TYPE;

Line 16800: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

16796: l_applied_to_application_id zx_transaction_lines_gt.applied_to_application_id%TYPE;
16797: l_applied_to_entity_code zx_transaction_lines_gt.applied_to_entity_code%TYPE;
16798: l_applied_to_event_class_code zx_transaction_lines_gt.applied_to_event_class_code%TYPE;
16799: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
16800: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
16801:
16802: -- PO Tax Determining Attributes
16803: l_trx_bus_category zx_transaction_lines_gt.trx_business_category%TYPE;
16804: l_intended_use zx_lines_det_factors.line_intended_use%type;

Line 16803: l_trx_bus_category zx_transaction_lines_gt.trx_business_category%TYPE;

16799: l_trx_receipt_date zx_transaction_lines_gt.trx_receipt_date%TYPE;
16800: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
16801:
16802: -- PO Tax Determining Attributes
16803: l_trx_bus_category zx_transaction_lines_gt.trx_business_category%TYPE;
16804: l_intended_use zx_lines_det_factors.line_intended_use%type;
16805: l_product_type zx_lines_det_factors.product_type%type;
16806: l_product_category zx_lines_det_factors.product_category%type;
16807: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;

Line 16810: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;

16806: l_product_category zx_lines_det_factors.product_category%type;
16807: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
16808: l_user_def_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
16809: l_assessable_value zx_lines_det_factors.assessable_value%type;
16810: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
16811: l_allow_tax_code_override VARCHAR2(10);
16812: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269
16813:
16814: l_debug_info Varchar2(240);

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

16855: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
16856: END IF;
16857: ----------------------------------------------------------------------
16858: ----------------------------------------------------------------------
16859: l_debug_info := 'Step 4: Populate zx_transaction_lines_gt';
16860: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
16861: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
16862: END IF;
16863: ----------------------------------------------------------------------

Line 17121: DELETE FROM zx_transaction_lines_gt;

17117: IF (l_return_status = TRUE) THEN
17118:
17119: IF (trans_lines.COUNT > 0) THEN
17120:
17121: DELETE FROM zx_transaction_lines_gt;
17122:
17123: FORALL m IN trans_lines.FIRST..trans_lines.LAST
17124: INSERT INTO zx_transaction_lines_gt
17125: VALUES trans_lines(m);

Line 17124: INSERT INTO zx_transaction_lines_gt

17120:
17121: DELETE FROM zx_transaction_lines_gt;
17122:
17123: FORALL m IN trans_lines.FIRST..trans_lines.LAST
17124: INSERT INTO zx_transaction_lines_gt
17125: VALUES trans_lines(m);
17126:
17127: END IF;
17128: END IF;