APPS.PO_PDOI_PRICE_TOLERANCE_PVT dependencies on PO_TBL_NUMBER

Line 389: p_po_header_id_tbl IN PO_TBL_NUMBER,

385: ------------------------------------------------------------------------
386: PROCEDURE get_price_tolerance
387: (
388: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
389: p_po_header_id_tbl IN PO_TBL_NUMBER,
390: p_item_id_tbl IN PO_TBL_NUMBER,
391: p_category_id_tbl IN PO_TBL_NUMBER,
392: p_vendor_id_tbl IN PO_TBL_NUMBER,
393: x_price_update_tolerance_tbl OUT NOCOPY PO_TBL_NUMBER

Line 390: p_item_id_tbl IN PO_TBL_NUMBER,

386: PROCEDURE get_price_tolerance
387: (
388: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
389: p_po_header_id_tbl IN PO_TBL_NUMBER,
390: p_item_id_tbl IN PO_TBL_NUMBER,
391: p_category_id_tbl IN PO_TBL_NUMBER,
392: p_vendor_id_tbl IN PO_TBL_NUMBER,
393: x_price_update_tolerance_tbl OUT NOCOPY PO_TBL_NUMBER
394: ) IS

Line 391: p_category_id_tbl IN PO_TBL_NUMBER,

387: (
388: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
389: p_po_header_id_tbl IN PO_TBL_NUMBER,
390: p_item_id_tbl IN PO_TBL_NUMBER,
391: p_category_id_tbl IN PO_TBL_NUMBER,
392: p_vendor_id_tbl IN PO_TBL_NUMBER,
393: x_price_update_tolerance_tbl OUT NOCOPY PO_TBL_NUMBER
394: ) IS
395:

Line 392: p_vendor_id_tbl IN PO_TBL_NUMBER,

388: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
389: p_po_header_id_tbl IN PO_TBL_NUMBER,
390: p_item_id_tbl IN PO_TBL_NUMBER,
391: p_category_id_tbl IN PO_TBL_NUMBER,
392: p_vendor_id_tbl IN PO_TBL_NUMBER,
393: x_price_update_tolerance_tbl OUT NOCOPY PO_TBL_NUMBER
394: ) IS
395:
396: d_api_name CONSTANT VARCHAR2(30) := 'get_price_tolerance';

Line 393: x_price_update_tolerance_tbl OUT NOCOPY PO_TBL_NUMBER

389: p_po_header_id_tbl IN PO_TBL_NUMBER,
390: p_item_id_tbl IN PO_TBL_NUMBER,
391: p_category_id_tbl IN PO_TBL_NUMBER,
392: p_vendor_id_tbl IN PO_TBL_NUMBER,
393: x_price_update_tolerance_tbl OUT NOCOPY PO_TBL_NUMBER
394: ) IS
395:
396: d_api_name CONSTANT VARCHAR2(30) := 'get_price_tolerance';
397: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 402: l_index_tbl PO_TBL_NUMBER;

398: d_position NUMBER;
399:
400: l_key po_session_gt.key%TYPE;
401:
402: l_index_tbl PO_TBL_NUMBER;
403: l_tolerance_tbl PO_TBL_NUMBER;
404:
405: l_index NUMBER;
406: BEGIN

Line 403: l_tolerance_tbl PO_TBL_NUMBER;

399:
400: l_key po_session_gt.key%TYPE;
401:
402: l_index_tbl PO_TBL_NUMBER;
403: l_tolerance_tbl PO_TBL_NUMBER;
404:
405: l_index NUMBER;
406: BEGIN
407: d_position := 0;

Line 417: x_price_update_tolerance_tbl := PO_TBL_NUMBER();

413: PO_LOG.proc_begin(d_module, 'p_vendor_id_tbl', p_vendor_id_tbl);
414: END IF;
415:
416: -- initialize out parameter
417: x_price_update_tolerance_tbl := PO_TBL_NUMBER();
418: x_price_update_tolerance_tbl.EXTEND(p_po_header_id_tbl.COUNT);
419:
420: l_key := PO_CORE_S.get_session_gt_nextval;
421: