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_ITM_DISTRIBUTIONS_GT

Line 1357: DELETE FROM zx_itm_distributions_gt;

1353: -----------------------------------------------------------------
1354: l_debug_info := 'Purge Staging Table';
1355: Print(l_api_name,l_debug_info);
1356: -----------------------------------------------------------------
1357: DELETE FROM zx_itm_distributions_gt;
1358:
1359:
1360: OPEN C_SELECTED_INVOICES;
1361: LOOP

Line 8608: | ZX_ITM_DISTRIBUTIONS_GT

Line 8637: TYPE Trans_Dist_Tab_Type IS TABLE OF zx_itm_distributions_gt%ROWTYPE;

8633: IS
8634: l_debug_info VARCHAR2(240);
8635: l_curr_calling_sequence VARCHAR2(4000);
8636:
8637: TYPE Trans_Dist_Tab_Type IS TABLE OF zx_itm_distributions_gt%ROWTYPE;
8638: trans_dists Trans_Dist_Tab_Type := Trans_Dist_Tab_Type();
8639:
8640: -- Purchase Order Info
8641: l_ref_doc_application_id zx_itm_distributions_gt.ref_doc_application_id%TYPE;

Line 8641: l_ref_doc_application_id zx_itm_distributions_gt.ref_doc_application_id%TYPE;

8637: TYPE Trans_Dist_Tab_Type IS TABLE OF zx_itm_distributions_gt%ROWTYPE;
8638: trans_dists Trans_Dist_Tab_Type := Trans_Dist_Tab_Type();
8639:
8640: -- Purchase Order Info
8641: l_ref_doc_application_id zx_itm_distributions_gt.ref_doc_application_id%TYPE;
8642: l_ref_doc_entity_code zx_itm_distributions_gt.ref_doc_entity_code%TYPE;
8643: l_ref_doc_event_class_code zx_itm_distributions_gt.ref_doc_event_class_code%TYPE;
8644: l_ref_doc_trx_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
8645: l_ref_doc_trx_level_type zx_itm_distributions_gt.ref_doc_trx_level_type%TYPE;

Line 8642: l_ref_doc_entity_code zx_itm_distributions_gt.ref_doc_entity_code%TYPE;

8638: trans_dists Trans_Dist_Tab_Type := Trans_Dist_Tab_Type();
8639:
8640: -- Purchase Order Info
8641: l_ref_doc_application_id zx_itm_distributions_gt.ref_doc_application_id%TYPE;
8642: l_ref_doc_entity_code zx_itm_distributions_gt.ref_doc_entity_code%TYPE;
8643: l_ref_doc_event_class_code zx_itm_distributions_gt.ref_doc_event_class_code%TYPE;
8644: l_ref_doc_trx_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
8645: l_ref_doc_trx_level_type zx_itm_distributions_gt.ref_doc_trx_level_type%TYPE;
8646: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

Line 8643: l_ref_doc_event_class_code zx_itm_distributions_gt.ref_doc_event_class_code%TYPE;

8639:
8640: -- Purchase Order Info
8641: l_ref_doc_application_id zx_itm_distributions_gt.ref_doc_application_id%TYPE;
8642: l_ref_doc_entity_code zx_itm_distributions_gt.ref_doc_entity_code%TYPE;
8643: l_ref_doc_event_class_code zx_itm_distributions_gt.ref_doc_event_class_code%TYPE;
8644: l_ref_doc_trx_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
8645: l_ref_doc_trx_level_type zx_itm_distributions_gt.ref_doc_trx_level_type%TYPE;
8646: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
8647: l_ref_doc_trx_line_dist_qty zx_itm_distributions_gt.ref_doc_trx_line_dist_qty%TYPE;

Line 8644: l_ref_doc_trx_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;

8640: -- Purchase Order Info
8641: l_ref_doc_application_id zx_itm_distributions_gt.ref_doc_application_id%TYPE;
8642: l_ref_doc_entity_code zx_itm_distributions_gt.ref_doc_entity_code%TYPE;
8643: l_ref_doc_event_class_code zx_itm_distributions_gt.ref_doc_event_class_code%TYPE;
8644: l_ref_doc_trx_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
8645: l_ref_doc_trx_level_type zx_itm_distributions_gt.ref_doc_trx_level_type%TYPE;
8646: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
8647: l_ref_doc_trx_line_dist_qty zx_itm_distributions_gt.ref_doc_trx_line_dist_qty%TYPE;
8648: l_po_unit_price po_line_locations_all.price_override%TYPE;

Line 8645: l_ref_doc_trx_level_type zx_itm_distributions_gt.ref_doc_trx_level_type%TYPE;

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

Line 8647: l_ref_doc_trx_line_dist_qty zx_itm_distributions_gt.ref_doc_trx_line_dist_qty%TYPE;

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

Line 8650: l_po_release_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;

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

Line 8654: l_dist_level_action zx_itm_distributions_gt.dist_level_action%TYPE;

8650: l_po_release_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
8651: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
8652: l_uom_code mtl_units_of_measure.uom_code%TYPE;
8653:
8654: l_dist_level_action zx_itm_distributions_gt.dist_level_action%TYPE;
8655: l_line_quantity_invoiced zx_itm_distributions_gt.trx_line_quantity%TYPE;
8656: l_amount zx_itm_distributions_gt.trx_line_dist_amt%TYPE;
8657: l_price_diff zx_itm_distributions_gt.price_diff%TYPE;
8658: l_po_header_curr_conv_rate zx_itm_distributions_gt.ref_doc_curr_conv_rate%TYPE;

Line 8655: l_line_quantity_invoiced zx_itm_distributions_gt.trx_line_quantity%TYPE;

8651: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
8652: l_uom_code mtl_units_of_measure.uom_code%TYPE;
8653:
8654: l_dist_level_action zx_itm_distributions_gt.dist_level_action%TYPE;
8655: l_line_quantity_invoiced zx_itm_distributions_gt.trx_line_quantity%TYPE;
8656: l_amount zx_itm_distributions_gt.trx_line_dist_amt%TYPE;
8657: l_price_diff zx_itm_distributions_gt.price_diff%TYPE;
8658: l_po_header_curr_conv_rate zx_itm_distributions_gt.ref_doc_curr_conv_rate%TYPE;
8659: l_receipt_curr_conv_rate zx_itm_distributions_gt.applied_to_doc_curr_conv_rate%TYPE;

Line 8656: l_amount zx_itm_distributions_gt.trx_line_dist_amt%TYPE;

8652: l_uom_code mtl_units_of_measure.uom_code%TYPE;
8653:
8654: l_dist_level_action zx_itm_distributions_gt.dist_level_action%TYPE;
8655: l_line_quantity_invoiced zx_itm_distributions_gt.trx_line_quantity%TYPE;
8656: l_amount zx_itm_distributions_gt.trx_line_dist_amt%TYPE;
8657: l_price_diff zx_itm_distributions_gt.price_diff%TYPE;
8658: l_po_header_curr_conv_rate zx_itm_distributions_gt.ref_doc_curr_conv_rate%TYPE;
8659: l_receipt_curr_conv_rate zx_itm_distributions_gt.applied_to_doc_curr_conv_rate%TYPE;
8660: l_converted_qty ap_invoice_distributions_all.quantity_invoiced%TYPE;

Line 8657: l_price_diff zx_itm_distributions_gt.price_diff%TYPE;

8653:
8654: l_dist_level_action zx_itm_distributions_gt.dist_level_action%TYPE;
8655: l_line_quantity_invoiced zx_itm_distributions_gt.trx_line_quantity%TYPE;
8656: l_amount zx_itm_distributions_gt.trx_line_dist_amt%TYPE;
8657: l_price_diff zx_itm_distributions_gt.price_diff%TYPE;
8658: l_po_header_curr_conv_rate zx_itm_distributions_gt.ref_doc_curr_conv_rate%TYPE;
8659: l_receipt_curr_conv_rate zx_itm_distributions_gt.applied_to_doc_curr_conv_rate%TYPE;
8660: l_converted_qty ap_invoice_distributions_all.quantity_invoiced%TYPE;
8661: l_converted_price ap_invoice_distributions_all.unit_price%TYPE;

Line 8658: l_po_header_curr_conv_rate zx_itm_distributions_gt.ref_doc_curr_conv_rate%TYPE;

8654: l_dist_level_action zx_itm_distributions_gt.dist_level_action%TYPE;
8655: l_line_quantity_invoiced zx_itm_distributions_gt.trx_line_quantity%TYPE;
8656: l_amount zx_itm_distributions_gt.trx_line_dist_amt%TYPE;
8657: l_price_diff zx_itm_distributions_gt.price_diff%TYPE;
8658: l_po_header_curr_conv_rate zx_itm_distributions_gt.ref_doc_curr_conv_rate%TYPE;
8659: l_receipt_curr_conv_rate zx_itm_distributions_gt.applied_to_doc_curr_conv_rate%TYPE;
8660: l_converted_qty ap_invoice_distributions_all.quantity_invoiced%TYPE;
8661: l_converted_price ap_invoice_distributions_all.unit_price%TYPE;
8662:

Line 8659: l_receipt_curr_conv_rate zx_itm_distributions_gt.applied_to_doc_curr_conv_rate%TYPE;

8655: l_line_quantity_invoiced zx_itm_distributions_gt.trx_line_quantity%TYPE;
8656: l_amount zx_itm_distributions_gt.trx_line_dist_amt%TYPE;
8657: l_price_diff zx_itm_distributions_gt.price_diff%TYPE;
8658: l_po_header_curr_conv_rate zx_itm_distributions_gt.ref_doc_curr_conv_rate%TYPE;
8659: l_receipt_curr_conv_rate zx_itm_distributions_gt.applied_to_doc_curr_conv_rate%TYPE;
8660: l_converted_qty ap_invoice_distributions_all.quantity_invoiced%TYPE;
8661: l_converted_price ap_invoice_distributions_all.unit_price%TYPE;
8662:
8663: -- Correction Invoice Info

Line 8670: l_adj_doc_trx_id zx_itm_distributions_gt.adjusted_doc_trx_id%TYPE;

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

Line 8671: l_adj_doc_line_id zx_itm_distributions_gt.adjusted_doc_line_id%TYPE;

8667: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
8668: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
8669: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
8670: l_adj_doc_trx_id zx_itm_distributions_gt.adjusted_doc_trx_id%TYPE;
8671: l_adj_doc_line_id zx_itm_distributions_gt.adjusted_doc_line_id%TYPE;
8672:
8673: -- Prepayment Info
8674: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
8675: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;

Line 9058: INSERT INTO zx_itm_distributions_gt

9054: -------------------------------------------------------------------
9055: IF (l_return_status = TRUE) THEN
9056:
9057: FORALL m IN trans_dists.FIRST..trans_dists.LAST
9058: INSERT INTO zx_itm_distributions_gt
9059: VALUES trans_dists(m);
9060:
9061: END IF;
9062: END IF;