DBA Data[Home] [Help]

APPS.PO_PDOI_PRICE_TOLERANCE_PVT dependencies on PO_TBL_NUMBER

Line 23: p_po_header_id_tbl IN PO_TBL_NUMBER,

19:
20: PROCEDURE get_price_tolerance
21: (
22: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
23: p_po_header_id_tbl IN PO_TBL_NUMBER,
24: p_item_id_tbl IN PO_TBL_NUMBER,
25: p_category_id_tbl IN PO_TBL_NUMBER,
26: p_vendor_id_tbl IN PO_TBL_NUMBER,
27: x_price_update_tolerance_tbl OUT NOCOPY PO_TBL_NUMBER

Line 24: p_item_id_tbl IN PO_TBL_NUMBER,

20: PROCEDURE get_price_tolerance
21: (
22: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
23: p_po_header_id_tbl IN PO_TBL_NUMBER,
24: p_item_id_tbl IN PO_TBL_NUMBER,
25: p_category_id_tbl IN PO_TBL_NUMBER,
26: p_vendor_id_tbl IN PO_TBL_NUMBER,
27: x_price_update_tolerance_tbl OUT NOCOPY PO_TBL_NUMBER
28: );

Line 25: p_category_id_tbl IN PO_TBL_NUMBER,

21: (
22: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
23: p_po_header_id_tbl IN PO_TBL_NUMBER,
24: p_item_id_tbl IN PO_TBL_NUMBER,
25: p_category_id_tbl IN PO_TBL_NUMBER,
26: p_vendor_id_tbl IN PO_TBL_NUMBER,
27: x_price_update_tolerance_tbl OUT NOCOPY PO_TBL_NUMBER
28: );
29:

Line 26: p_vendor_id_tbl IN PO_TBL_NUMBER,

22: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
23: p_po_header_id_tbl IN PO_TBL_NUMBER,
24: p_item_id_tbl IN PO_TBL_NUMBER,
25: p_category_id_tbl IN PO_TBL_NUMBER,
26: p_vendor_id_tbl IN PO_TBL_NUMBER,
27: x_price_update_tolerance_tbl OUT NOCOPY PO_TBL_NUMBER
28: );
29:
30: FUNCTION exceed_tolerance_check

Line 27: x_price_update_tolerance_tbl OUT NOCOPY PO_TBL_NUMBER

23: p_po_header_id_tbl IN PO_TBL_NUMBER,
24: p_item_id_tbl IN PO_TBL_NUMBER,
25: p_category_id_tbl IN PO_TBL_NUMBER,
26: p_vendor_id_tbl IN PO_TBL_NUMBER,
27: x_price_update_tolerance_tbl OUT NOCOPY PO_TBL_NUMBER
28: );
29:
30: FUNCTION exceed_tolerance_check
31: (