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.PO_DOCUMENT_TOTALS_PVT dependencies on PO_TBL_NUMBER

Line 3167: l_distribution_id_tbl po_tbl_number;

3163: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_order_totals');
3164: d_position NUMBER := 0;
3165:
3166: l_org_id HR_ALL_ORGANIZATION_UNITS.organization_id%type;
3167: l_distribution_id_tbl po_tbl_number;
3168: l_document_id NUMBER;
3169: l_document_id_tbl po_tbl_number;
3170: l_temp_table_key PO_DOCUMENT_TOTALS_GT.key%TYPE;
3171: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;

Line 3169: l_document_id_tbl po_tbl_number;

3165:
3166: l_org_id HR_ALL_ORGANIZATION_UNITS.organization_id%type;
3167: l_distribution_id_tbl po_tbl_number;
3168: l_document_id NUMBER;
3169: l_document_id_tbl po_tbl_number;
3170: l_temp_table_key PO_DOCUMENT_TOTALS_GT.key%TYPE;
3171: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;
3172: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;
3173: l_temp_table_row_count NUMBER;

Line 3221: p_doc_level_id_tbl => po_tbl_number(p_doc_level_id),

3217: -- based on the passed in doc level ID
3218: PO_CORE_S.get_document_ids(
3219: p_doc_type => p_doc_type,
3220: p_doc_level => p_doc_level,
3221: p_doc_level_id_tbl => po_tbl_number(p_doc_level_id),
3222: x_doc_id_tbl => l_document_id_tbl
3223: );
3224:
3225: d_position := 20;

Line 3377: l_distribution_id_tbl PO_TBL_NUMBER;

3373: d_mod CONSTANT VARCHAR2(100) :=
3374: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'populate_temp_table');
3375: d_position NUMBER := 0;
3376:
3377: l_distribution_id_tbl PO_TBL_NUMBER;
3378: l_distribution_rev_num_tbl po_tbl_number;
3379: l_temp_table_key PO_DOCUMENT_TOTALS_GT.key%TYPE;
3380: l_distribution_type_filter PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3381: BEGIN

Line 3378: l_distribution_rev_num_tbl po_tbl_number;

3374: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'populate_temp_table');
3375: d_position NUMBER := 0;
3376:
3377: l_distribution_id_tbl PO_TBL_NUMBER;
3378: l_distribution_rev_num_tbl po_tbl_number;
3379: l_temp_table_key PO_DOCUMENT_TOTALS_GT.key%TYPE;
3380: l_distribution_type_filter PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3381: BEGIN
3382:

Line 3403: p_doc_level_id_tbl => po_tbl_number(p_doc_level_id),

3399: -- We will get the qty/amt data to sum up based on dist data.
3400: PO_CORE_S.get_distribution_ids(
3401: p_doc_type => p_doc_type,
3402: p_doc_level => p_doc_level,
3403: p_doc_level_id_tbl => po_tbl_number(p_doc_level_id),
3404: x_distribution_id_tbl => l_distribution_id_tbl
3405: );
3406:
3407: d_position := 20;

Line 3494: p_doc_level_id_tbl => po_tbl_number(p_doc_level_id),

3490: -- We will get the qty/amt data to sum up based on dist data.
3491: PO_CORE_S.get_dist_ids_from_archive(
3492: p_doc_type => p_doc_type,
3493: p_doc_level => p_doc_level,
3494: p_doc_level_id_tbl => po_tbl_number(p_doc_level_id),
3495: p_doc_revision_num => p_doc_revision_num,
3496: x_distribution_id_tbl => l_distribution_id_tbl,
3497: x_distribution_rev_num_tbl => l_distribution_rev_num_tbl
3498: );