eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PO_TBL_VARCHAR30

Line 22: p_vendor_product_num_tbl IN PO_TBL_VARCHAR30,

18: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
19: p_vendor_id_tbl IN PO_TBL_NUMBER,
20: p_intf_header_id_tbl IN PO_TBL_NUMBER,
21: p_intf_line_id_tbl IN PO_TBL_NUMBER,
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

Line 76: x_unit_of_measure_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

72: (
73: p_key IN po_session_gt.key%TYPE,
74: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
75: p_uom_code_tbl IN PO_TBL_VARCHAR5,
76: x_unit_of_measure_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
77: );
78:
79: PROCEDURE derive_line_type_id
80: (

Line 84: p_line_type_tbl IN PO_TBL_VARCHAR30,

80: (
81: p_key IN po_session_gt.key%TYPE,
82: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
83: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
84: p_line_type_tbl IN PO_TBL_VARCHAR30,
85: x_line_type_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
86: );
87:
88: PROCEDURE derive_un_number_id

Line 92: p_un_number_tbl IN PO_TBL_VARCHAR30,

88: PROCEDURE derive_un_number_id
89: (
90: p_key IN po_session_gt.key%TYPE,
91: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
92: p_un_number_tbl IN PO_TBL_VARCHAR30,
93: x_un_number_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
94: );
95:
96: PROCEDURE derive_hazard_class_id

Line 108: p_template_name_tbl IN PO_TBL_VARCHAR30,

104: PROCEDURE derive_template_id
105: (
106: p_key IN po_session_gt.key%TYPE,
107: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
108: p_template_name_tbl IN PO_TBL_VARCHAR30,
109: x_template_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
110: );
111:
112: PROCEDURE default_info_from_line_type

Line 117: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,

113: (
114: p_key IN po_session_gt.key%TYPE,
115: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
116: p_line_type_id_tbl IN PO_TBL_NUMBER,
117: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
118: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
119: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
120: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
121: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 118: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,

114: p_key IN po_session_gt.key%TYPE,
115: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
116: p_line_type_id_tbl IN PO_TBL_NUMBER,
117: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
118: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
119: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
120: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
121: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
122: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER

Line 119: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,

115: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
116: p_line_type_id_tbl IN PO_TBL_NUMBER,
117: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
118: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
119: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
120: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
121: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
122: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER
123: );

Line 121: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,

117: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
118: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
119: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
120: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
121: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
122: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER
123: );
124:
125: PROCEDURE default_info_from_item

Line 131: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,

127: p_key IN po_session_gt.key%TYPE,
128: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
129: p_item_id_tbl IN PO_TBL_NUMBER,
130: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
131: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
132: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,
133: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
134: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,
135: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 137: x_secondary_unit_of_meas_tbl OUT NOCOPY PO_TBL_VARCHAR30

133: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
134: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,
135: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,
136: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,
137: x_secondary_unit_of_meas_tbl OUT NOCOPY PO_TBL_VARCHAR30
138: );
139:
140: PROCEDURE default_info_from_job
141: (

Line 169: p_un_number_tbl IN PO_TBL_VARCHAR30,

165: PROCEDURE default_hc_id_from_un_number
166: (
167: p_key IN po_session_gt.key%TYPE,
168: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
169: p_un_number_tbl IN PO_TBL_VARCHAR30,
170: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
171: );
172:
173: PROCEDURE match_lines_on_line_num

Line 519: l_rej_line_action_tbl PO_TBL_VARCHAR30;

515:
516: -- interface line id of lines that need to be rejected
517: l_rej_intf_line_id_tbl PO_TBL_NUMBER;
518: l_rej_intf_header_id_tbl PO_TBL_NUMBER;
519: l_rej_line_action_tbl PO_TBL_VARCHAR30;
520:
521: BEGIN
522: d_position := 0;
523:

Line 2246: l_li_unit_of_measure_tbl PO_TBL_VARCHAR30;

2242: l_index_tbl DBMS_SQL.NUMBER_TABLE;
2243:
2244: -- information defaulted from line type
2245: l_li_category_id_tbl PO_TBL_NUMBER;
2246: l_li_unit_of_measure_tbl PO_TBL_VARCHAR30;
2247: l_li_unit_price_tbl PO_TBL_NUMBER;
2248:
2249: -- information defaulted from item
2250: l_it_item_desc_tbl PO_TBL_VARCHAR2000;

Line 2251: l_it_unit_of_measure_tbl PO_TBL_VARCHAR30;

2247: l_li_unit_price_tbl PO_TBL_NUMBER;
2248:
2249: -- information defaulted from item
2250: l_it_item_desc_tbl PO_TBL_VARCHAR2000;
2251: l_it_unit_of_measure_tbl PO_TBL_VARCHAR30;
2252: l_it_unit_price_tbl PO_TBL_NUMBER;
2253: l_it_category_id_tbl PO_TBL_NUMBER;
2254: l_it_un_number_id_tbl PO_TBL_NUMBER;
2255: l_it_hazard_class_id_tbl PO_TBL_NUMBER;

Line 2257: l_it_secondary_uom_tbl PO_TBL_VARCHAR30;

2253: l_it_category_id_tbl PO_TBL_NUMBER;
2254: l_it_un_number_id_tbl PO_TBL_NUMBER;
2255: l_it_hazard_class_id_tbl PO_TBL_NUMBER;
2256: l_it_market_price_tbl PO_TBL_NUMBER;
2257: l_it_secondary_uom_tbl PO_TBL_VARCHAR30;
2258:
2259: -- information defaulted from job
2260: l_job_item_desc_tbl PO_TBL_VARCHAR2000;
2261: l_job_category_id_tbl PO_TBL_NUMBER;

Line 2660: l_order_type_tbl PO_TBL_VARCHAR30;

2656: l_num_list DBMS_SQL.NUMBER_TABLE;
2657:
2658: -- information defaulted from existing po line
2659: l_index_tbl PO_TBL_NUMBER;
2660: l_order_type_tbl PO_TBL_VARCHAR30;
2661: l_item_id_tbl PO_TBL_NUMBER;
2662: l_job_id_tbl PO_TBL_NUMBER;
2663:
2664: l_index NUMBER;

Line 3790: p_vendor_product_num_tbl IN PO_TBL_VARCHAR30,

3786: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3787: p_vendor_id_tbl IN PO_TBL_NUMBER,
3788: p_intf_header_id_tbl IN PO_TBL_NUMBER,
3789: p_intf_line_id_tbl IN PO_TBL_NUMBER,
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

Line 4543: x_unit_of_measure_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

4539: (
4540: p_key IN po_session_gt.key%TYPE,
4541: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4542: p_uom_code_tbl IN PO_TBL_VARCHAR5,
4543: x_unit_of_measure_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
4544: ) IS
4545:
4546: d_api_name CONSTANT VARCHAR2(30) := 'derive_unit_of_measure';
4547: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4552: l_result_tbl PO_TBL_VARCHAR30;

4548: d_position NUMBER;
4549:
4550: -- tables to store the derived result
4551: l_index_tbl PO_TBL_NUMBER;
4552: l_result_tbl PO_TBL_VARCHAR30;
4553: BEGIN
4554: d_position := 0;
4555:
4556: IF (PO_LOG.d_proc) THEN

Line 4635: p_line_type_tbl IN PO_TBL_VARCHAR30,

4631: (
4632: p_key IN po_session_gt.key%TYPE,
4633: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4634: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
4635: p_line_type_tbl IN PO_TBL_VARCHAR30,
4636: x_line_type_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4637: ) IS
4638:
4639: d_api_name CONSTANT VARCHAR2(30) := 'derive_line_type_id';

Line 4731: p_un_number_tbl IN PO_TBL_VARCHAR30,

4727: PROCEDURE derive_un_number_id
4728: (
4729: p_key IN po_session_gt.key%TYPE,
4730: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4731: p_un_number_tbl IN PO_TBL_VARCHAR30,
4732: x_un_number_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4733: ) IS
4734:
4735: d_api_name CONSTANT VARCHAR2(30) := 'derive_un_number_id';

Line 4910: p_template_name_tbl IN PO_TBL_VARCHAR30,

4906: PROCEDURE derive_template_id
4907: (
4908: p_key IN po_session_gt.key%TYPE,
4909: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4910: p_template_name_tbl IN PO_TBL_VARCHAR30,
4911: x_template_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4912: ) IS
4913:
4914: d_api_name CONSTANT VARCHAR2(30) := 'derive_template_id';

Line 5017: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,

5013: (
5014: p_key IN po_session_gt.key%TYPE,
5015: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5016: p_line_type_id_tbl IN PO_TBL_NUMBER,
5017: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5018: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5019: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5020: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5021: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 5018: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,

5014: p_key IN po_session_gt.key%TYPE,
5015: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5016: p_line_type_id_tbl IN PO_TBL_NUMBER,
5017: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5018: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5019: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5020: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5021: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
5022: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER

Line 5019: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,

5015: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5016: p_line_type_id_tbl IN PO_TBL_NUMBER,
5017: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5018: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5019: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5020: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5021: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
5022: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER
5023: ) IS

Line 5021: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,

5017: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5018: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5019: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5020: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5021: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
5022: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER
5023: ) IS
5024:
5025: d_api_name CONSTANT VARCHAR2(30) := 'default_info_from_line_type';

Line 5031: l_order_type_lookup_code_tbl PO_TBL_VARCHAR30;

5027: d_position NUMBER;
5028:
5029: -- variables to hold result read from temp table
5030: l_index_tbl PO_TBL_NUMBER;
5031: l_order_type_lookup_code_tbl PO_TBL_VARCHAR30;
5032: l_purchase_basis_tbl PO_TBL_VARCHAR30;
5033: l_matching_basis_tbl PO_TBL_VARCHAR30;
5034: l_category_id_tbl PO_TBL_NUMBER;
5035: l_unit_of_measure_tbl PO_TBL_VARCHAR30;

Line 5032: l_purchase_basis_tbl PO_TBL_VARCHAR30;

5028:
5029: -- variables to hold result read from temp table
5030: l_index_tbl PO_TBL_NUMBER;
5031: l_order_type_lookup_code_tbl PO_TBL_VARCHAR30;
5032: l_purchase_basis_tbl PO_TBL_VARCHAR30;
5033: l_matching_basis_tbl PO_TBL_VARCHAR30;
5034: l_category_id_tbl PO_TBL_NUMBER;
5035: l_unit_of_measure_tbl PO_TBL_VARCHAR30;
5036: l_unit_price_tbl PO_TBL_NUMBER;

Line 5033: l_matching_basis_tbl PO_TBL_VARCHAR30;

5029: -- variables to hold result read from temp table
5030: l_index_tbl PO_TBL_NUMBER;
5031: l_order_type_lookup_code_tbl PO_TBL_VARCHAR30;
5032: l_purchase_basis_tbl PO_TBL_VARCHAR30;
5033: l_matching_basis_tbl PO_TBL_VARCHAR30;
5034: l_category_id_tbl PO_TBL_NUMBER;
5035: l_unit_of_measure_tbl PO_TBL_VARCHAR30;
5036: l_unit_price_tbl PO_TBL_NUMBER;
5037:

Line 5035: l_unit_of_measure_tbl PO_TBL_VARCHAR30;

5031: l_order_type_lookup_code_tbl PO_TBL_VARCHAR30;
5032: l_purchase_basis_tbl PO_TBL_VARCHAR30;
5033: l_matching_basis_tbl PO_TBL_VARCHAR30;
5034: l_category_id_tbl PO_TBL_NUMBER;
5035: l_unit_of_measure_tbl PO_TBL_VARCHAR30;
5036: l_unit_price_tbl PO_TBL_NUMBER;
5037:
5038: -- current accessing index in the loop
5039: l_index NUMBER;

Line 5048: x_unit_of_measure_tbl := PO_TBL_VARCHAR30();

5044: PO_LOG.proc_begin(d_module);
5045: END IF;
5046:
5047: x_category_id_tbl := PO_TBL_NUMBER();
5048: x_unit_of_measure_tbl := PO_TBL_VARCHAR30();
5049: x_unit_price_tbl := PO_TBL_NUMBER();
5050:
5051: x_category_id_tbl.EXTEND(p_index_tbl.COUNT);
5052: x_unit_of_measure_tbl.EXTEND(p_index_tbl.COUNT);

Line 5177: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,

5173: p_key IN po_session_gt.key%TYPE,
5174: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5175: p_item_id_tbl IN PO_TBL_NUMBER,
5176: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
5177: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
5178: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,
5179: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5180: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5181: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 5183: x_secondary_unit_of_meas_tbl OUT NOCOPY PO_TBL_VARCHAR30

5179: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5180: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5181: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5182: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,
5183: x_secondary_unit_of_meas_tbl OUT NOCOPY PO_TBL_VARCHAR30
5184: ) IS
5185:
5186: d_api_name CONSTANT VARCHAR2(30) := 'default_info_from_item';
5187: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5193: l_unit_of_measure_tbl PO_TBL_VARCHAR30;

5189:
5190: -- variables to hold result read from temp table
5191: l_index_tbl PO_TBL_NUMBER;
5192: l_item_desc_tbl PO_TBL_VARCHAR2000;
5193: l_unit_of_measure_tbl PO_TBL_VARCHAR30;
5194: l_unit_price_tbl PO_TBL_NUMBER;
5195: l_category_id_tbl PO_TBL_NUMBER;
5196: l_un_number_id_tbl PO_TBL_NUMBER;
5197: l_hazard_class_id_tbl PO_TBL_NUMBER;

Line 5199: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30;

5195: l_category_id_tbl PO_TBL_NUMBER;
5196: l_un_number_id_tbl PO_TBL_NUMBER;
5197: l_hazard_class_id_tbl PO_TBL_NUMBER;
5198: l_market_price_tbl PO_TBL_NUMBER;
5199: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30;
5200:
5201: -- current accessing index in the loop
5202: l_index NUMBER;
5203: BEGIN

Line 5211: x_unit_of_measure_tbl := PO_TBL_VARCHAR30();

5207: PO_LOG.proc_begin(d_module);
5208: END IF;
5209:
5210: x_item_desc_tbl := PO_TBL_VARCHAR2000();
5211: x_unit_of_measure_tbl := PO_TBL_VARCHAR30();
5212: x_unit_price_tbl := PO_TBL_NUMBER();
5213: x_category_id_tbl := PO_TBL_NUMBER();
5214: x_un_number_id_tbl := PO_TBL_NUMBER();
5215: x_hazard_class_id_tbl := PO_TBL_NUMBER();

Line 5217: x_secondary_unit_of_meas_tbl := PO_TBL_VARCHAR30();

5213: x_category_id_tbl := PO_TBL_NUMBER();
5214: x_un_number_id_tbl := PO_TBL_NUMBER();
5215: x_hazard_class_id_tbl := PO_TBL_NUMBER();
5216: x_market_price_tbl := PO_TBL_NUMBER();
5217: x_secondary_unit_of_meas_tbl := PO_TBL_VARCHAR30();
5218:
5219: x_item_desc_tbl.EXTEND(p_index_tbl.COUNT);
5220: x_unit_of_measure_tbl.EXTEND(p_index_tbl.COUNT);
5221: x_unit_price_tbl.EXTEND(p_index_tbl.COUNT);

Line 5637: p_un_number_tbl IN PO_TBL_VARCHAR30,

5633: PROCEDURE default_hc_id_from_un_number
5634: (
5635: p_key IN po_session_gt.key%TYPE,
5636: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5637: p_un_number_tbl IN PO_TBL_VARCHAR30,
5638: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5639: ) IS
5640:
5641: d_api_name CONSTANT VARCHAR2(30) := 'default_hc_id_from_un_number';