APPS.PO_PDOI_PRICE_TOLERANCE_PVT dependencies on PO_TBL_NUMBER

Line 395: p_po_header_id_tbl IN PO_TBL_NUMBER,

391: ------------------------------------------------------------------------
392: PROCEDURE get_price_tolerance
393: (
394: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
395: p_po_header_id_tbl IN PO_TBL_NUMBER,
396: p_item_id_tbl IN PO_TBL_NUMBER,
397: p_category_id_tbl IN PO_TBL_NUMBER,
398: p_vendor_id_tbl IN PO_TBL_NUMBER,
399: x_price_update_tolerance_tbl OUT NOCOPY PO_TBL_NUMBER

Line 396: p_item_id_tbl IN PO_TBL_NUMBER,

392: PROCEDURE get_price_tolerance
393: (
394: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
395: p_po_header_id_tbl IN PO_TBL_NUMBER,
396: p_item_id_tbl IN PO_TBL_NUMBER,
397: p_category_id_tbl IN PO_TBL_NUMBER,
398: p_vendor_id_tbl IN PO_TBL_NUMBER,
399: x_price_update_tolerance_tbl OUT NOCOPY PO_TBL_NUMBER
400: ) IS

Line 397: p_category_id_tbl IN PO_TBL_NUMBER,

393: (
394: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
395: p_po_header_id_tbl IN PO_TBL_NUMBER,
396: p_item_id_tbl IN PO_TBL_NUMBER,
397: p_category_id_tbl IN PO_TBL_NUMBER,
398: p_vendor_id_tbl IN PO_TBL_NUMBER,
399: x_price_update_tolerance_tbl OUT NOCOPY PO_TBL_NUMBER
400: ) IS
401:

Line 398: p_vendor_id_tbl IN PO_TBL_NUMBER,

394: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
395: p_po_header_id_tbl IN PO_TBL_NUMBER,
396: p_item_id_tbl IN PO_TBL_NUMBER,
397: p_category_id_tbl IN PO_TBL_NUMBER,
398: p_vendor_id_tbl IN PO_TBL_NUMBER,
399: x_price_update_tolerance_tbl OUT NOCOPY PO_TBL_NUMBER
400: ) IS
401:
402: d_api_name CONSTANT VARCHAR2(30) := 'get_price_tolerance';

Line 399: x_price_update_tolerance_tbl OUT NOCOPY PO_TBL_NUMBER

395: p_po_header_id_tbl IN PO_TBL_NUMBER,
396: p_item_id_tbl IN PO_TBL_NUMBER,
397: p_category_id_tbl IN PO_TBL_NUMBER,
398: p_vendor_id_tbl IN PO_TBL_NUMBER,
399: x_price_update_tolerance_tbl OUT NOCOPY PO_TBL_NUMBER
400: ) IS
401:
402: d_api_name CONSTANT VARCHAR2(30) := 'get_price_tolerance';
403: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 408: l_index_tbl PO_TBL_NUMBER;

404: d_position NUMBER;
405:
406: l_key po_session_gt.key%TYPE;
407:
408: l_index_tbl PO_TBL_NUMBER;
409: l_tolerance_tbl PO_TBL_NUMBER;
410:
411: l_index NUMBER;
412: BEGIN

Line 409: l_tolerance_tbl PO_TBL_NUMBER;

405:
406: l_key po_session_gt.key%TYPE;
407:
408: l_index_tbl PO_TBL_NUMBER;
409: l_tolerance_tbl PO_TBL_NUMBER;
410:
411: l_index NUMBER;
412: BEGIN
413: d_position := 0;

Line 423: x_price_update_tolerance_tbl := PO_TBL_NUMBER();

419: PO_LOG.proc_begin(d_module, 'p_vendor_id_tbl', p_vendor_id_tbl);
420: END IF;
421:
422: -- initialize out parameter
423: x_price_update_tolerance_tbl := PO_TBL_NUMBER();
424: x_price_update_tolerance_tbl.EXTEND(p_po_header_id_tbl.COUNT);
425:
426: l_key := PO_CORE_S.get_session_gt_nextval;
427: