22: p_vendor_product_num_tbl IN PO_TBL_VARCHAR30,
23: p_category_id_tbl IN PO_TBL_NUMBER, --bug 7374337
24: p_item_tbl IN PO_TBL_VARCHAR2000,
25: x_item_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
26: x_error_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
27: );
28:
29: PROCEDURE derive_item_revision
30: (
96: PROCEDURE derive_hazard_class_id
97: (
98: p_key IN po_session_gt.key%TYPE,
99: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
100: p_hazard_class_tbl IN PO_TBL_VARCHAR100,
101: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
102: );
103:
104: PROCEDURE derive_template_id
3790: p_vendor_product_num_tbl IN PO_TBL_VARCHAR30,
3791: p_category_id_tbl IN PO_TBL_NUMBER, --bug 7374337
3792: p_item_tbl IN PO_TBL_VARCHAR2000,
3793: x_item_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
3794: x_error_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
3795: ) IS
3796:
3797: d_api_name CONSTANT VARCHAR2(30) := 'derive_item_id';
3798: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4817: PROCEDURE derive_hazard_class_id
4818: (
4819: p_key IN po_session_gt.key%TYPE,
4820: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4821: p_hazard_class_tbl IN PO_TBL_VARCHAR100,
4822: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4823: ) IS
4824:
4825: d_api_name CONSTANT VARCHAR2(30) := 'derive_hazard_class_id';