APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on ZX_TRANSACTION_LINES_GT

Line 51: -- trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,

47: line_amt zx_trx_tax_link_gt.line_amt%TYPE
48: -- trx_date zx_trx_headers_gt.trx_date%TYPE,
49: -- minimum_accountable_unit zx_trx_headers_gt.minimum_accountable_unit%TYPE,
50: -- precision zx_trx_headers_gt.precision%TYPE,
51: -- trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,
52: -- adjusted_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE,
53: -- line_level_action zx_transaction_lines_gt.line_level_action%TYPE
54: );
55:

Line 52: -- adjusted_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE,

48: -- trx_date zx_trx_headers_gt.trx_date%TYPE,
49: -- minimum_accountable_unit zx_trx_headers_gt.minimum_accountable_unit%TYPE,
50: -- precision zx_trx_headers_gt.precision%TYPE,
51: -- trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,
52: -- adjusted_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE,
53: -- line_level_action zx_transaction_lines_gt.line_level_action%TYPE
54: );
55:
56: -- Private Methods

Line 53: -- line_level_action zx_transaction_lines_gt.line_level_action%TYPE

49: -- minimum_accountable_unit zx_trx_headers_gt.minimum_accountable_unit%TYPE,
50: -- precision zx_trx_headers_gt.precision%TYPE,
51: -- trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,
52: -- adjusted_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE,
53: -- line_level_action zx_transaction_lines_gt.line_level_action%TYPE
54: );
55:
56: -- Private Methods
57: PROCEDURE get_vat_tax_rate;

Line 6002: | zx_transaction_lines_gt during autoinvoice |

5998: | product_category and product_fiscal_class for Latin Tax Engine |
5999: | |
6000: | This procedure should be called by Receivables at the time of |
6001: | populating eBTax Global Temporary tables zx_trx_headers_gt and |
6002: | zx_transaction_lines_gt during autoinvoice |
6003: | |
6004: | MODIFICATION HISTORY |
6005: | 19-Jan-2005 Nilesh Patel Created |
6006: | |

Line 6028: MERGE INTO ZX_TRANSACTION_LINES_GT lines_gt

6024: -- bug#6834705 - use tax_event_class_code from
6025: -- zx_evnt_cls_mappings, not from zx_trx_headers_gt
6026: --
6027:
6028: MERGE INTO ZX_TRANSACTION_LINES_GT lines_gt
6029: USING (SELECT
6030: ratrxlines.global_attribute2 product_category,
6031: ratrxlines.global_attribute3 trx_business_category,
6032: Event.tax_event_class_code tax_event_class_code,

Line 6035: zx_transaction_lines_gt Lines,

6031: ratrxlines.global_attribute3 trx_business_category,
6032: Event.tax_event_class_code tax_event_class_code,
6033: Lines.trx_line_id trx_line_id
6034: FROM
6035: zx_transaction_lines_gt Lines,
6036: --zx_trx_headers_gt Headers,
6037: zx_evnt_cls_mappings event,
6038: ra_customer_trx_lines_all ratrxlines
6039: WHERE

Line 6059: MERGE INTO ZX_TRANSACTION_LINES_GT lines_gt

6055: WHEN NOT MATCHED THEN
6056: INSERT (LINE_AMT) VALUES(NULL);
6057:
6058:
6059: MERGE INTO ZX_TRANSACTION_LINES_GT lines_gt
6060: USING (SELECT
6061: ratrxlines.global_attribute2 product_fiscal_class,
6062: ratrxlines.global_attribute3 trx_business_category,
6063: Event.tax_event_class_code tax_event_class_code,

Line 6066: zx_transaction_lines_gt Lines,

6062: ratrxlines.global_attribute3 trx_business_category,
6063: Event.tax_event_class_code tax_event_class_code,
6064: Lines.trx_line_id trx_line_id
6065: FROM
6066: zx_transaction_lines_gt Lines,
6067: --zx_trx_headers_gt Headers,
6068: zx_evnt_cls_mappings event,
6069: ra_customer_trx_lines_all ratrxlines
6070: WHERE