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
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: );
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:
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
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: (