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 3286: l_distribution_id_tbl po_tbl_number;

3282: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_order_totals');
3283: d_position NUMBER := 0;
3284:
3285: l_org_id HR_ALL_ORGANIZATION_UNITS.organization_id%type;
3286: l_distribution_id_tbl po_tbl_number;
3287: l_document_id NUMBER;
3288: l_document_id_tbl po_tbl_number;
3289: l_temp_table_key PO_DOCUMENT_TOTALS_GT.key%TYPE;
3290: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;

Line 3288: l_document_id_tbl po_tbl_number;

3284:
3285: l_org_id HR_ALL_ORGANIZATION_UNITS.organization_id%type;
3286: l_distribution_id_tbl po_tbl_number;
3287: l_document_id NUMBER;
3288: l_document_id_tbl po_tbl_number;
3289: l_temp_table_key PO_DOCUMENT_TOTALS_GT.key%TYPE;
3290: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;
3291: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;
3292: l_temp_table_row_count NUMBER;

Line 3340: p_doc_level_id_tbl => po_tbl_number(p_doc_level_id),

3336: -- based on the passed in doc level ID
3337: PO_CORE_S.get_document_ids(
3338: p_doc_type => p_doc_type,
3339: p_doc_level => p_doc_level,
3340: p_doc_level_id_tbl => po_tbl_number(p_doc_level_id),
3341: x_doc_id_tbl => l_document_id_tbl
3342: );
3343:
3344: d_position := 20;

Line 3496: l_distribution_id_tbl PO_TBL_NUMBER;

3492: d_mod CONSTANT VARCHAR2(100) :=
3493: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'populate_temp_table');
3494: d_position NUMBER := 0;
3495:
3496: l_distribution_id_tbl PO_TBL_NUMBER;
3497: l_distribution_rev_num_tbl po_tbl_number;
3498: l_temp_table_key PO_DOCUMENT_TOTALS_GT.key%TYPE;
3499: l_distribution_type_filter PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3500: BEGIN

Line 3497: l_distribution_rev_num_tbl po_tbl_number;

3493: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'populate_temp_table');
3494: d_position NUMBER := 0;
3495:
3496: l_distribution_id_tbl PO_TBL_NUMBER;
3497: l_distribution_rev_num_tbl po_tbl_number;
3498: l_temp_table_key PO_DOCUMENT_TOTALS_GT.key%TYPE;
3499: l_distribution_type_filter PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3500: BEGIN
3501:

Line 3522: p_doc_level_id_tbl => po_tbl_number(p_doc_level_id),

3518: -- We will get the qty/amt data to sum up based on dist data.
3519: PO_CORE_S.get_distribution_ids(
3520: p_doc_type => p_doc_type,
3521: p_doc_level => p_doc_level,
3522: p_doc_level_id_tbl => po_tbl_number(p_doc_level_id),
3523: x_distribution_id_tbl => l_distribution_id_tbl
3524: );
3525:
3526: d_position := 20;

Line 3613: p_doc_level_id_tbl => po_tbl_number(p_doc_level_id),

3609: -- We will get the qty/amt data to sum up based on dist data.
3610: PO_CORE_S.get_dist_ids_from_archive(
3611: p_doc_type => p_doc_type,
3612: p_doc_level => p_doc_level,
3613: p_doc_level_id_tbl => po_tbl_number(p_doc_level_id),
3614: p_doc_revision_num => p_doc_revision_num,
3615: x_distribution_id_tbl => l_distribution_id_tbl,
3616: x_distribution_rev_num_tbl => l_distribution_rev_num_tbl
3617: );