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 273: x_cost_constraint_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

269: (
270: p_key IN po_session_gt.key%TYPE,
271: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
272: p_cost_constraint_display_tbl IN PO_TBL_VARCHAR240,
273: x_cost_constraint_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
274: );
275:
276: PROCEDURE derive_clm_idc_type
277: (

Line 604: l_rej_line_action_tbl PO_TBL_VARCHAR30;

600:
601: -- interface line id of lines that need to be rejected
602: l_rej_intf_line_id_tbl PO_TBL_NUMBER;
603: l_rej_intf_header_id_tbl PO_TBL_NUMBER;
604: l_rej_line_action_tbl PO_TBL_VARCHAR30;
605:
606: BEGIN
607: d_position := 0;
608:

Line 3066: l_li_unit_of_measure_tbl PO_TBL_VARCHAR30;

3062: l_index_tbl DBMS_SQL.NUMBER_TABLE;
3063:
3064: -- information defaulted from line type
3065: l_li_category_id_tbl PO_TBL_NUMBER;
3066: l_li_unit_of_measure_tbl PO_TBL_VARCHAR30;
3067: l_li_unit_price_tbl PO_TBL_NUMBER;
3068:
3069: -- information defaulted from item
3070: l_it_item_desc_tbl PO_TBL_VARCHAR2000;

Line 3071: l_it_unit_of_measure_tbl PO_TBL_VARCHAR30;

3067: l_li_unit_price_tbl PO_TBL_NUMBER;
3068:
3069: -- information defaulted from item
3070: l_it_item_desc_tbl PO_TBL_VARCHAR2000;
3071: l_it_unit_of_measure_tbl PO_TBL_VARCHAR30;
3072: l_it_unit_price_tbl PO_TBL_NUMBER;
3073: l_it_category_id_tbl PO_TBL_NUMBER;
3074: l_it_un_number_id_tbl PO_TBL_NUMBER;
3075: l_it_hazard_class_id_tbl PO_TBL_NUMBER;

Line 3077: l_it_secondary_uom_tbl PO_TBL_VARCHAR30;

3073: l_it_category_id_tbl PO_TBL_NUMBER;
3074: l_it_un_number_id_tbl PO_TBL_NUMBER;
3075: l_it_hazard_class_id_tbl PO_TBL_NUMBER;
3076: l_it_market_price_tbl PO_TBL_NUMBER;
3077: l_it_secondary_uom_tbl PO_TBL_VARCHAR30;
3078:
3079: -- information defaulted from job
3080: l_job_item_desc_tbl PO_TBL_VARCHAR2000;
3081: l_job_category_id_tbl PO_TBL_NUMBER;

Line 3550: l_order_type_tbl PO_TBL_VARCHAR30;

3546: l_num_list DBMS_SQL.NUMBER_TABLE;
3547:
3548: -- information defaulted from existing po line
3549: l_index_tbl PO_TBL_NUMBER;
3550: l_order_type_tbl PO_TBL_VARCHAR30;
3551: l_item_id_tbl PO_TBL_NUMBER;
3552: l_job_id_tbl PO_TBL_NUMBER;
3553:
3554: l_index NUMBER;

Line 4712: p_vendor_product_num_tbl IN PO_TBL_VARCHAR30,

4708: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4709: p_vendor_id_tbl IN PO_TBL_NUMBER,
4710: p_intf_header_id_tbl IN PO_TBL_NUMBER,
4711: p_intf_line_id_tbl IN PO_TBL_NUMBER,
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

Line 5465: x_unit_of_measure_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

5461: (
5462: p_key IN po_session_gt.key%TYPE,
5463: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5464: p_uom_code_tbl IN PO_TBL_VARCHAR5,
5465: x_unit_of_measure_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
5466: ) IS
5467:
5468: d_api_name CONSTANT VARCHAR2(30) := 'derive_unit_of_measure';
5469: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5474: l_result_tbl PO_TBL_VARCHAR30;

5470: d_position NUMBER;
5471:
5472: -- tables to store the derived result
5473: l_index_tbl PO_TBL_NUMBER;
5474: l_result_tbl PO_TBL_VARCHAR30;
5475: BEGIN
5476: d_position := 0;
5477:
5478: IF (PO_LOG.d_proc) THEN

Line 5557: p_line_type_tbl IN PO_TBL_VARCHAR30,

5553: (
5554: p_key IN po_session_gt.key%TYPE,
5555: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5556: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
5557: p_line_type_tbl IN PO_TBL_VARCHAR30,
5558: x_line_type_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5559: ) IS
5560:
5561: d_api_name CONSTANT VARCHAR2(30) := 'derive_line_type_id';

Line 5653: p_un_number_tbl IN PO_TBL_VARCHAR30,

5649: PROCEDURE derive_un_number_id
5650: (
5651: p_key IN po_session_gt.key%TYPE,
5652: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5653: p_un_number_tbl IN PO_TBL_VARCHAR30,
5654: x_un_number_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5655: ) IS
5656:
5657: d_api_name CONSTANT VARCHAR2(30) := 'derive_un_number_id';

Line 5832: p_template_name_tbl IN PO_TBL_VARCHAR30,

5828: PROCEDURE derive_template_id
5829: (
5830: p_key IN po_session_gt.key%TYPE,
5831: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5832: p_template_name_tbl IN PO_TBL_VARCHAR30,
5833: x_template_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5834: ) IS
5835:
5836: d_api_name CONSTANT VARCHAR2(30) := 'derive_template_id';

Line 5939: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,

5935: (
5936: p_key IN po_session_gt.key%TYPE,
5937: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5938: p_line_type_id_tbl IN PO_TBL_NUMBER,
5939: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5940: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5941: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5942: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5943: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 5940: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,

5936: p_key IN po_session_gt.key%TYPE,
5937: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5938: p_line_type_id_tbl IN PO_TBL_NUMBER,
5939: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5940: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5941: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5942: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5943: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
5944: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER

Line 5941: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,

5937: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5938: p_line_type_id_tbl IN PO_TBL_NUMBER,
5939: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5940: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5941: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5942: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5943: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
5944: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER
5945: ) IS

Line 5943: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,

5939: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5940: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5941: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5942: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
5943: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
5944: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER
5945: ) IS
5946:
5947: d_api_name CONSTANT VARCHAR2(30) := 'default_info_from_line_type';

Line 5953: l_order_type_lookup_code_tbl PO_TBL_VARCHAR30;

5949: d_position NUMBER;
5950:
5951: -- variables to hold result read from temp table
5952: l_index_tbl PO_TBL_NUMBER;
5953: l_order_type_lookup_code_tbl PO_TBL_VARCHAR30;
5954: l_purchase_basis_tbl PO_TBL_VARCHAR30;
5955: l_matching_basis_tbl PO_TBL_VARCHAR30;
5956: l_category_id_tbl PO_TBL_NUMBER;
5957: l_unit_of_measure_tbl PO_TBL_VARCHAR30;

Line 5954: l_purchase_basis_tbl PO_TBL_VARCHAR30;

5950:
5951: -- variables to hold result read from temp table
5952: l_index_tbl PO_TBL_NUMBER;
5953: l_order_type_lookup_code_tbl PO_TBL_VARCHAR30;
5954: l_purchase_basis_tbl PO_TBL_VARCHAR30;
5955: l_matching_basis_tbl PO_TBL_VARCHAR30;
5956: l_category_id_tbl PO_TBL_NUMBER;
5957: l_unit_of_measure_tbl PO_TBL_VARCHAR30;
5958: l_unit_price_tbl PO_TBL_NUMBER;

Line 5955: l_matching_basis_tbl PO_TBL_VARCHAR30;

5951: -- variables to hold result read from temp table
5952: l_index_tbl PO_TBL_NUMBER;
5953: l_order_type_lookup_code_tbl PO_TBL_VARCHAR30;
5954: l_purchase_basis_tbl PO_TBL_VARCHAR30;
5955: l_matching_basis_tbl PO_TBL_VARCHAR30;
5956: l_category_id_tbl PO_TBL_NUMBER;
5957: l_unit_of_measure_tbl PO_TBL_VARCHAR30;
5958: l_unit_price_tbl PO_TBL_NUMBER;
5959:

Line 5957: l_unit_of_measure_tbl PO_TBL_VARCHAR30;

5953: l_order_type_lookup_code_tbl PO_TBL_VARCHAR30;
5954: l_purchase_basis_tbl PO_TBL_VARCHAR30;
5955: l_matching_basis_tbl PO_TBL_VARCHAR30;
5956: l_category_id_tbl PO_TBL_NUMBER;
5957: l_unit_of_measure_tbl PO_TBL_VARCHAR30;
5958: l_unit_price_tbl PO_TBL_NUMBER;
5959:
5960: -- current accessing index in the loop
5961: l_index NUMBER;

Line 5970: x_unit_of_measure_tbl := PO_TBL_VARCHAR30();

5966: PO_LOG.proc_begin(d_module);
5967: END IF;
5968:
5969: x_category_id_tbl := PO_TBL_NUMBER();
5970: x_unit_of_measure_tbl := PO_TBL_VARCHAR30();
5971: x_unit_price_tbl := PO_TBL_NUMBER();
5972:
5973: x_category_id_tbl.EXTEND(p_index_tbl.COUNT);
5974: x_unit_of_measure_tbl.EXTEND(p_index_tbl.COUNT);

Line 6099: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,

6095: p_key IN po_session_gt.key%TYPE,
6096: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
6097: p_item_id_tbl IN PO_TBL_NUMBER,
6098: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
6099: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
6100: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,
6101: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
6102: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,
6103: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 6105: x_secondary_unit_of_meas_tbl OUT NOCOPY PO_TBL_VARCHAR30

6101: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,
6102: x_un_number_id_tbl OUT NOCOPY PO_TBL_NUMBER,
6103: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,
6104: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,
6105: x_secondary_unit_of_meas_tbl OUT NOCOPY PO_TBL_VARCHAR30
6106: ) IS
6107:
6108: d_api_name CONSTANT VARCHAR2(30) := 'default_info_from_item';
6109: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 6115: l_unit_of_measure_tbl PO_TBL_VARCHAR30;

6111:
6112: -- variables to hold result read from temp table
6113: l_index_tbl PO_TBL_NUMBER;
6114: l_item_desc_tbl PO_TBL_VARCHAR2000;
6115: l_unit_of_measure_tbl PO_TBL_VARCHAR30;
6116: l_unit_price_tbl PO_TBL_NUMBER;
6117: l_category_id_tbl PO_TBL_NUMBER;
6118: l_un_number_id_tbl PO_TBL_NUMBER;
6119: l_hazard_class_id_tbl PO_TBL_NUMBER;

Line 6121: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30;

6117: l_category_id_tbl PO_TBL_NUMBER;
6118: l_un_number_id_tbl PO_TBL_NUMBER;
6119: l_hazard_class_id_tbl PO_TBL_NUMBER;
6120: l_market_price_tbl PO_TBL_NUMBER;
6121: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30;
6122:
6123: -- current accessing index in the loop
6124: l_index NUMBER;
6125: BEGIN

Line 6133: x_unit_of_measure_tbl := PO_TBL_VARCHAR30();

6129: PO_LOG.proc_begin(d_module);
6130: END IF;
6131:
6132: x_item_desc_tbl := PO_TBL_VARCHAR2000();
6133: x_unit_of_measure_tbl := PO_TBL_VARCHAR30();
6134: x_unit_price_tbl := PO_TBL_NUMBER();
6135: x_category_id_tbl := PO_TBL_NUMBER();
6136: x_un_number_id_tbl := PO_TBL_NUMBER();
6137: x_hazard_class_id_tbl := PO_TBL_NUMBER();

Line 6139: x_secondary_unit_of_meas_tbl := PO_TBL_VARCHAR30();

6135: x_category_id_tbl := PO_TBL_NUMBER();
6136: x_un_number_id_tbl := PO_TBL_NUMBER();
6137: x_hazard_class_id_tbl := PO_TBL_NUMBER();
6138: x_market_price_tbl := PO_TBL_NUMBER();
6139: x_secondary_unit_of_meas_tbl := PO_TBL_VARCHAR30();
6140:
6141: x_item_desc_tbl.EXTEND(p_index_tbl.COUNT);
6142: x_unit_of_measure_tbl.EXTEND(p_index_tbl.COUNT);
6143: x_unit_price_tbl.EXTEND(p_index_tbl.COUNT);

Line 6559: p_un_number_tbl IN PO_TBL_VARCHAR30,

6555: PROCEDURE default_hc_id_from_un_number
6556: (
6557: p_key IN po_session_gt.key%TYPE,
6558: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
6559: p_un_number_tbl IN PO_TBL_VARCHAR30,
6560: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
6561: ) IS
6562:
6563: d_api_name CONSTANT VARCHAR2(30) := 'default_hc_id_from_un_number';

Line 9177: x_cost_constraint_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

9173: (
9174: p_key IN po_session_gt.key%TYPE,
9175: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9176: p_cost_constraint_display_tbl IN PO_TBL_VARCHAR240,
9177: x_cost_constraint_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
9178: ) IS
9179:
9180: d_api_name CONSTANT VARCHAR2(30) := 'derive_cost_constraint';
9181: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';