DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PO_TBL_VARCHAR1

Line 26: x_error_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1

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

Line 100: p_hazard_class_tbl IN PO_TBL_VARCHAR100,

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

Line 291: p_line_num_display_tbl IN PO_TBL_VARCHAR100,

287: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
288: p_clm_base_line_num_disp_tbl IN PO_TBL_VARCHAR240,
289: p_intf_line_id_tbl IN PO_TBL_NUMBER,
290: p_intf_header_id_tbl IN PO_TBL_NUMBER,
291: p_line_num_display_tbl IN PO_TBL_VARCHAR100,
292: p_clm_option_indicator IN PO_TBL_VARCHAR1,
293: x_clm_base_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
294: );
295:

Line 292: p_clm_option_indicator IN PO_TBL_VARCHAR1,

288: p_clm_base_line_num_disp_tbl IN PO_TBL_VARCHAR240,
289: p_intf_line_id_tbl IN PO_TBL_NUMBER,
290: p_intf_header_id_tbl IN PO_TBL_NUMBER,
291: p_line_num_display_tbl IN PO_TBL_VARCHAR100,
292: p_clm_option_indicator IN PO_TBL_VARCHAR1,
293: x_clm_base_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
294: );
295:
296: PROCEDURE derive_from_line_id

Line 319: x_clm_option_indicator_tbl IN OUT NOCOPY PO_TBL_VARCHAR1

315: p_key IN po_session_gt.key%TYPE,
316: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
317: p_intf_line_id_tbl IN PO_TBL_NUMBER,
318: p_clm_base_line_num_tbl IN PO_TBL_NUMBER,
319: x_clm_option_indicator_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
320: );
321:
322: PROCEDURE default_clm_option_num
323: (

Line 329: p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1,

325: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
326: p_intf_header_id_tbl IN PO_TBL_NUMBER,
327: p_intf_line_id_tbl IN PO_TBL_NUMBER,
328: p_clm_base_line_num_tbl IN PO_TBL_NUMBER,
329: p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1,
330: x_clm_option_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
331: );
332:
333: PROCEDURE default_from_header_id

Line 4716: x_error_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1

4712: p_vendor_product_num_tbl IN PO_TBL_VARCHAR30,
4713: p_category_id_tbl IN PO_TBL_NUMBER, --bug 7374337
4714: p_item_tbl IN PO_TBL_VARCHAR2000,
4715: x_item_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
4716: x_error_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
4717: ) IS
4718:
4719: d_api_name CONSTANT VARCHAR2(30) := 'derive_item_id';
4720: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5743: p_hazard_class_tbl IN PO_TBL_VARCHAR100,

5739: PROCEDURE derive_hazard_class_id
5740: (
5741: p_key IN po_session_gt.key%TYPE,
5742: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5743: p_hazard_class_tbl IN PO_TBL_VARCHAR100,
5744: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5745: ) IS
5746:
5747: d_api_name CONSTANT VARCHAR2(30) := 'derive_hazard_class_id';

Line 9319: p_line_num_display_tbl IN PO_TBL_VARCHAR100,

9315: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9316: p_clm_base_line_num_disp_tbl IN PO_TBL_VARCHAR240,
9317: p_intf_line_id_tbl IN PO_TBL_NUMBER,
9318: p_intf_header_id_tbl IN PO_TBL_NUMBER,
9319: p_line_num_display_tbl IN PO_TBL_VARCHAR100,
9320: p_clm_option_indicator IN PO_TBL_VARCHAR1,
9321: x_clm_base_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
9322: ) IS
9323:

Line 9320: p_clm_option_indicator IN PO_TBL_VARCHAR1,

9316: p_clm_base_line_num_disp_tbl IN PO_TBL_VARCHAR240,
9317: p_intf_line_id_tbl IN PO_TBL_NUMBER,
9318: p_intf_header_id_tbl IN PO_TBL_NUMBER,
9319: p_line_num_display_tbl IN PO_TBL_VARCHAR100,
9320: p_clm_option_indicator IN PO_TBL_VARCHAR1,
9321: x_clm_base_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
9322: ) IS
9323:
9324: d_api_name CONSTANT VARCHAR2(30) := 'derive_clm_base_line_num';

Line 9549: x_clm_option_indicator_tbl IN OUT NOCOPY PO_TBL_VARCHAR1

9545: p_key IN po_session_gt.key%TYPE,
9546: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9547: p_intf_line_id_tbl IN PO_TBL_NUMBER,
9548: p_clm_base_line_num_tbl IN PO_TBL_NUMBER,
9549: x_clm_option_indicator_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
9550: ) IS
9551:
9552: d_api_name CONSTANT VARCHAR2(30) := 'default_clm_option_indicator';
9553: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 9558: l_result_tbl PO_TBL_VARCHAR1;

9554: d_position NUMBER;
9555:
9556: -- tables to store the derived result
9557: l_index_tbl PO_TBL_NUMBER;
9558: l_result_tbl PO_TBL_VARCHAR1;
9559: BEGIN
9560: d_position := 0;
9561:
9562: IF (PO_LOG.d_proc) THEN

Line 9625: p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1,

9621: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9622: p_intf_header_id_tbl IN PO_TBL_NUMBER,
9623: p_intf_line_id_tbl IN PO_TBL_NUMBER,
9624: p_clm_base_line_num_tbl IN PO_TBL_NUMBER,
9625: p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1,
9626: x_clm_option_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
9627: ) IS
9628:
9629: d_api_name CONSTANT VARCHAR2(30) := 'default_clm_option_indicator';