APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PO_TBL_NUMBER

Line 19: p_vendor_id_tbl IN PO_TBL_NUMBER,

15: PROCEDURE derive_item_id
16: (
17: p_key IN po_session_gt.key%TYPE,
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

Line 20: p_intf_header_id_tbl IN PO_TBL_NUMBER,

16: (
17: p_key IN po_session_gt.key%TYPE,
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,

Line 21: p_intf_line_id_tbl IN PO_TBL_NUMBER,

17: p_key IN po_session_gt.key%TYPE,
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,

Line 23: p_category_id_tbl IN PO_TBL_NUMBER, --bug 7374337

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

Line 25: x_item_id_tbl IN OUT NOCOPY 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
27: );
28:
29: PROCEDURE derive_item_revision

Line 32: p_item_id_tbl IN PO_TBL_NUMBER,

28:
29: PROCEDURE derive_item_revision
30: (
31: p_key IN po_session_gt.key%TYPE,
32: p_item_id_tbl IN PO_TBL_NUMBER,
33: x_item_revision_tbl IN OUT NOCOPY PO_TBL_VARCHAR5
34: );
35:
36: PROCEDURE derive_job_business_group_id

Line 41: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

37: (
38: p_key IN po_session_gt.key%TYPE,
39: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
40: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
41: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
42: );
43:
44: PROCEDURE derive_job_id
45: (

Line 51: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

47: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
48: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
49: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
50: p_job_name_tbl IN PO_TBL_VARCHAR2000,
51: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
52: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
53: );
54:
55: PROCEDURE derive_category_id

Line 52: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

48: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
49: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
50: p_job_name_tbl IN PO_TBL_VARCHAR2000,
51: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
52: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
53: );
54:
55: PROCEDURE derive_category_id
56: (

Line 59: x_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

55: PROCEDURE derive_category_id
56: (
57: p_key IN po_session_gt.key%TYPE,
58: p_category_tbl IN PO_TBL_VARCHAR2000,
59: x_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
60: );
61:
62: PROCEDURE derive_ip_category_id
63: (

Line 68: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

64: p_key IN po_session_gt.key%TYPE,
65: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
66: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
67: p_ip_category_tbl IN PO_TBL_VARCHAR2000,
68: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
69: );
70:
71: PROCEDURE derive_unit_of_measure
72: (

Line 85: x_line_type_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 93: x_un_number_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 101: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 109: x_template_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 116: p_line_type_id_tbl IN PO_TBL_NUMBER,

112: PROCEDURE default_info_from_line_type
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,

Line 120: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,

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

Line 122: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER

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

Line 129: p_item_id_tbl IN PO_TBL_NUMBER,

125: PROCEDURE default_info_from_item
126: (
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,

Line 132: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,

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,
136: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 133: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,

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,
136: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,
137: x_secondary_unit_of_meas_tbl OUT NOCOPY PO_TBL_VARCHAR30

Line 134: x_un_number_id_tbl OUT NOCOPY 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,
136: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,
137: x_secondary_unit_of_meas_tbl OUT NOCOPY PO_TBL_VARCHAR30
138: );

Line 135: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,

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,
136: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,
137: x_secondary_unit_of_meas_tbl OUT NOCOPY PO_TBL_VARCHAR30
138: );
139:

Line 136: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,

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,
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

Line 144: p_job_id_tbl IN PO_TBL_NUMBER,

140: PROCEDURE default_info_from_job
141: (
142: p_key IN po_session_gt.key%TYPE,
143: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
144: p_job_id_tbl IN PO_TBL_NUMBER,
145: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
146: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER
147: );
148:

Line 146: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER

142: p_key IN po_session_gt.key%TYPE,
143: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
144: p_job_id_tbl IN PO_TBL_NUMBER,
145: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
146: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER
147: );
148:
149: PROCEDURE default_po_cat_id_from_ip
150: (

Line 153: p_ip_category_id_tbl IN PO_TBL_NUMBER,

149: PROCEDURE default_po_cat_id_from_ip
150: (
151: p_key IN po_session_gt.key%TYPE,
152: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
153: p_ip_category_id_tbl IN PO_TBL_NUMBER,
154: x_po_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
155: );
156:
157: PROCEDURE default_ip_cat_id_from_po

Line 154: x_po_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

150: (
151: p_key IN po_session_gt.key%TYPE,
152: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
153: p_ip_category_id_tbl IN PO_TBL_NUMBER,
154: x_po_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
155: );
156:
157: PROCEDURE default_ip_cat_id_from_po
158: (

Line 161: p_po_category_id_tbl IN PO_TBL_NUMBER,

157: PROCEDURE default_ip_cat_id_from_po
158: (
159: p_key IN po_session_gt.key%TYPE,
160: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
161: p_po_category_id_tbl IN PO_TBL_NUMBER,
162: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
163: );
164:
165: PROCEDURE default_hc_id_from_un_number

Line 162: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

158: (
159: p_key IN po_session_gt.key%TYPE,
160: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
161: p_po_category_id_tbl IN PO_TBL_NUMBER,
162: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
163: );
164:
165: PROCEDURE default_hc_id_from_un_number
166: (

Line 170: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_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
174: (

Line 236: p_target_lines_index_tbl IN PO_TBL_NUMBER,

232: PROCEDURE set_action_add
233: (
234: p_key IN po_session_gt.key%TYPE,
235: p_group_num IN NUMBER,
236: p_target_lines_index_tbl IN PO_TBL_NUMBER,
237: p_check_line_num_assign IN VARCHAR2,
238: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
239: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
240: );

Line 289: p_intf_line_id_tbl IN PO_TBL_NUMBER,

285: (
286: p_key IN po_session_gt.key%TYPE,
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

Line 290: p_intf_header_id_tbl IN PO_TBL_NUMBER,

286: p_key IN po_session_gt.key%TYPE,
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: );

Line 293: x_clm_base_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 301: p_from_header_id_tbl IN PO_TBL_NUMBER,

297: (
298: p_key IN po_session_gt.key%TYPE,
299: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
300: p_from_line_disp_tbl IN PO_TBL_VARCHAR240,
301: p_from_header_id_tbl IN PO_TBL_NUMBER,
302: x_from_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
303: );
304:
305: PROCEDURE derive_from_header_id

Line 302: x_from_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

298: p_key IN po_session_gt.key%TYPE,
299: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
300: p_from_line_disp_tbl IN PO_TBL_VARCHAR240,
301: p_from_header_id_tbl IN PO_TBL_NUMBER,
302: x_from_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
303: );
304:
305: PROCEDURE derive_from_header_id
306: (

Line 310: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

306: (
307: p_key IN po_session_gt.key%TYPE,
308: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
309: p_from_header_disp_tbl IN PO_TBL_VARCHAR240,
310: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
311: );
312:
313: PROCEDURE default_clm_option_indicator
314: (

Line 317: p_intf_line_id_tbl IN PO_TBL_NUMBER,

313: PROCEDURE default_clm_option_indicator
314: (
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:

Line 318: p_clm_base_line_num_tbl IN PO_TBL_NUMBER,

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

Line 326: p_intf_header_id_tbl IN PO_TBL_NUMBER,

322: PROCEDURE default_clm_option_num
323: (
324: p_key IN po_session_gt.key%TYPE,
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

Line 327: p_intf_line_id_tbl IN PO_TBL_NUMBER,

323: (
324: p_key IN po_session_gt.key%TYPE,
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: );

Line 328: p_clm_base_line_num_tbl IN PO_TBL_NUMBER,

324: p_key IN po_session_gt.key%TYPE,
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:

Line 330: x_clm_option_num_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 337: p_intf_header_id_tbl IN PO_TBL_NUMBER,

333: PROCEDURE default_from_header_id
334: (
335: p_key IN po_session_gt.key%TYPE,
336: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
337: p_intf_header_id_tbl IN PO_TBL_NUMBER,
338: p_intf_line_id_tbl IN PO_TBL_NUMBER,
339: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
340: );
341:

Line 338: p_intf_line_id_tbl IN PO_TBL_NUMBER,

334: (
335: p_key IN po_session_gt.key%TYPE,
336: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
337: p_intf_header_id_tbl IN PO_TBL_NUMBER,
338: p_intf_line_id_tbl IN PO_TBL_NUMBER,
339: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
340: );
341:
342: --CLM PDOI Integration Ends

Line 339: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

335: p_key IN po_session_gt.key%TYPE,
336: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
337: p_intf_header_id_tbl IN PO_TBL_NUMBER,
338: p_intf_line_id_tbl IN PO_TBL_NUMBER,
339: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
340: );
341:
342: --CLM PDOI Integration Ends
343:

Line 403: l_dup_intf_header_id_tbl PO_TBL_NUMBER;

399: AND intf_lines.line_num = draft_lines.line_num
400: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
401:
402: -- duplicate lines in interface table
403: l_dup_intf_header_id_tbl PO_TBL_NUMBER;
404: l_dup_intf_line_id_tbl PO_TBL_NUMBER;
405: l_dup_intf_line_num_tbl PO_TBL_NUMBER;
406:
407: -- number of duplicate lines retrieved in each batch

Line 404: l_dup_intf_line_id_tbl PO_TBL_NUMBER;

400: AND intf_headers.action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE;
401:
402: -- duplicate lines in interface table
403: l_dup_intf_header_id_tbl PO_TBL_NUMBER;
404: l_dup_intf_line_id_tbl PO_TBL_NUMBER;
405: l_dup_intf_line_num_tbl PO_TBL_NUMBER;
406:
407: -- number of duplicate lines retrieved in each batch
408: l_count NUMBER;

Line 405: l_dup_intf_line_num_tbl PO_TBL_NUMBER;

401:
402: -- duplicate lines in interface table
403: l_dup_intf_header_id_tbl PO_TBL_NUMBER;
404: l_dup_intf_line_id_tbl PO_TBL_NUMBER;
405: l_dup_intf_line_num_tbl PO_TBL_NUMBER;
406:
407: -- number of duplicate lines retrieved in each batch
408: l_count NUMBER;
409: BEGIN

Line 602: l_rej_intf_line_id_tbl PO_TBL_NUMBER;

598: AND NVL(intf_lines.action, PO_PDOI_CONSTANTS.g_ACTION_ADD) <>
599: PO_PDOI_CONSTANTS.g_ACTION_ADD;
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

Line 603: l_rej_intf_header_id_tbl PO_TBL_NUMBER;

599: PO_PDOI_CONSTANTS.g_ACTION_ADD;
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;

Line 3065: l_li_category_id_tbl PO_TBL_NUMBER;

3061: -- table used to save the index of the each row
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

Line 3067: l_li_unit_price_tbl PO_TBL_NUMBER;

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;
3071: l_it_unit_of_measure_tbl PO_TBL_VARCHAR30;

Line 3072: l_it_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;
3076: l_it_market_price_tbl PO_TBL_NUMBER;

Line 3073: l_it_category_id_tbl PO_TBL_NUMBER;

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;
3076: l_it_market_price_tbl PO_TBL_NUMBER;
3077: l_it_secondary_uom_tbl PO_TBL_VARCHAR30;

Line 3074: l_it_un_number_id_tbl PO_TBL_NUMBER;

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;
3076: l_it_market_price_tbl PO_TBL_NUMBER;
3077: l_it_secondary_uom_tbl PO_TBL_VARCHAR30;
3078:

Line 3075: l_it_hazard_class_id_tbl PO_TBL_NUMBER;

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;
3076: l_it_market_price_tbl PO_TBL_NUMBER;
3077: l_it_secondary_uom_tbl PO_TBL_VARCHAR30;
3078:
3079: -- information defaulted from job

Line 3076: l_it_market_price_tbl PO_TBL_NUMBER;

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;
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;

Line 3081: l_job_category_id_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;
3082:
3083: -- information defaulted from ip category
3084: l_ic_category_id_tbl PO_TBL_NUMBER; -- bug5130037
3085:

Line 3084: l_ic_category_id_tbl PO_TBL_NUMBER; -- bug5130037

3080: l_job_item_desc_tbl PO_TBL_VARCHAR2000;
3081: l_job_category_id_tbl PO_TBL_NUMBER;
3082:
3083: -- information defaulted from ip category
3084: l_ic_category_id_tbl PO_TBL_NUMBER; -- bug5130037
3085:
3086: -- bug 9194215
3087: x_currency_unit_price NUMBER := null;
3088: x_precision NUMBER := null;

Line 3178: l_ic_category_id_tbl := PO_TBL_NUMBER();

3174: );
3175:
3176: d_position := 40;
3177:
3178: l_ic_category_id_tbl := PO_TBL_NUMBER();
3179: l_ic_category_id_tbl.EXTEND(x_lines.rec_count);
3180:
3181: IF (PO_PDOI_PARAMS.g_request.document_type IN
3182: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,

Line 3549: l_index_tbl PO_TBL_NUMBER;

3545: -- table used to save the index of the each row
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:

Line 3551: l_item_id_tbl PO_TBL_NUMBER;

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;
3555: --vegajula--bugno:9531925

Line 3552: l_job_id_tbl PO_TBL_NUMBER;

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;
3555: --vegajula--bugno:9531925
3556:

Line 3557: l_po_header_id_tbl PO_TBL_NUMBER;

3553:
3554: l_index NUMBER;
3555: --vegajula--bugno:9531925
3556:
3557: l_po_header_id_tbl PO_TBL_NUMBER;
3558:
3559: BEGIN
3560: d_position := 0;
3561:

Line 3682: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

3678:
3679: l_create_lines PO_PDOI_TYPES.lines_rec_type;
3680: l_update_lines PO_PDOI_TYPES.lines_rec_type;
3681:
3682: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3683: BEGIN
3684: d_position := 0;
3685:
3686: IF (PO_LOG.d_proc) THEN

Line 3878: l_obsoleted_loc_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

3874: d_position NUMBER;
3875:
3876: -- table to mark which line location needs to rejected in
3877: -- line location interface table
3878: l_obsoleted_loc_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3879: l_obsolete_rec_count NUMBER := 0;
3880:
3881: BEGIN
3882: d_position := 0;

Line 4118: l_expire_line_index_tbl PO_TBL_NUMBER;

4114: l_index_tbl DBMS_SQL.NUMBER_TABLE;
4115: l_index NUMBER;
4116:
4117: -- store the index of lines that need to be expired
4118: l_expire_line_index_tbl PO_TBL_NUMBER;
4119:
4120: -- counter
4121: l_count NUMBER := 0;
4122: BEGIN

Line 4469: l_inventory_org_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

4465: l_result_type VARCHAR2(30);
4466: l_results po_validation_results_type;
4467: l_parameter_name_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
4468: l_parameter_value_tbl PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
4469: l_inventory_org_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
4470:
4471: BEGIN
4472: d_position := 0;
4473:

Line 4709: p_vendor_id_tbl IN PO_TBL_NUMBER,

4705: PROCEDURE derive_item_id
4706: (
4707: p_key IN po_session_gt.key%TYPE,
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

Line 4710: p_intf_header_id_tbl IN PO_TBL_NUMBER,

4706: (
4707: p_key IN po_session_gt.key%TYPE,
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,

Line 4711: p_intf_line_id_tbl IN PO_TBL_NUMBER,

4707: p_key IN po_session_gt.key%TYPE,
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,

Line 4713: p_category_id_tbl IN PO_TBL_NUMBER, --bug 7374337

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
4717: ) IS

Line 4715: x_item_id_tbl IN OUT NOCOPY 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
4717: ) IS
4718:
4719: d_api_name CONSTANT VARCHAR2(30) := 'derive_item_id';

Line 4724: l_index_tbl PO_TBL_NUMBER;

4720: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4721: d_position NUMBER;
4722:
4723: -- tables to store the derived result
4724: l_index_tbl PO_TBL_NUMBER;
4725: l_result_tbl PO_TBL_NUMBER;
4726:
4727: -- variable to hold index of the current processing row
4728: l_index NUMBER;

Line 4725: l_result_tbl PO_TBL_NUMBER;

4721: d_position NUMBER;
4722:
4723: -- tables to store the derived result
4724: l_index_tbl PO_TBL_NUMBER;
4725: l_result_tbl PO_TBL_NUMBER;
4726:
4727: -- variable to hold index of the current processing row
4728: l_index NUMBER;
4729:

Line 4862: p_item_id_tbl IN PO_TBL_NUMBER,

4858: ------------------------------------------------------------------------
4859: PROCEDURE derive_item_revision
4860: (
4861: p_key IN po_session_gt.key%TYPE,
4862: p_item_id_tbl IN PO_TBL_NUMBER,
4863: x_item_revision_tbl IN OUT NOCOPY PO_TBL_VARCHAR5
4864: ) IS
4865:
4866: d_api_name CONSTANT VARCHAR2(30) := 'derive_item_revision';

Line 4933: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

4929: (
4930: p_key IN po_session_gt.key%TYPE,
4931: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4932: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
4933: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4934: ) IS
4935:
4936: d_api_name CONSTANT VARCHAR2(30) := 'derive_job_business_group_id';
4937: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4941: l_index_tbl PO_TBL_NUMBER;

4937: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4938: d_position NUMBER;
4939:
4940: -- tables to store the derived result
4941: l_index_tbl PO_TBL_NUMBER;
4942: l_result_tbl PO_TBL_NUMBER;
4943: BEGIN
4944: d_position := 0;
4945:

Line 4942: l_result_tbl PO_TBL_NUMBER;

4938: d_position NUMBER;
4939:
4940: -- tables to store the derived result
4941: l_index_tbl PO_TBL_NUMBER;
4942: l_result_tbl PO_TBL_NUMBER;
4943: BEGIN
4944: d_position := 0;
4945:
4946: IF (PO_LOG.d_proc) THEN

Line 5035: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

5031: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5032: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
5033: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
5034: p_job_name_tbl IN PO_TBL_VARCHAR2000,
5035: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
5036: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5037: ) IS
5038:
5039: d_api_name CONSTANT VARCHAR2(30) := 'derive_job_id';

Line 5036: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

5032: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
5033: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
5034: p_job_name_tbl IN PO_TBL_VARCHAR2000,
5035: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
5036: x_job_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5037: ) IS
5038:
5039: d_api_name CONSTANT VARCHAR2(30) := 'derive_job_id';
5040: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5044: l_index_tbl PO_TBL_NUMBER;

5040: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
5041: d_position NUMBER;
5042:
5043: -- tables to store the derived result
5044: l_index_tbl PO_TBL_NUMBER;
5045: l_result_tbl PO_TBL_NUMBER;
5046:
5047: -- debug variables
5048: d_group_id NUMBER;

Line 5045: l_result_tbl PO_TBL_NUMBER;

5041: d_position NUMBER;
5042:
5043: -- tables to store the derived result
5044: l_index_tbl PO_TBL_NUMBER;
5045: l_result_tbl PO_TBL_NUMBER;
5046:
5047: -- debug variables
5048: d_group_id NUMBER;
5049: d_job_id_tbl PO_TBL_NUMBER;

Line 5049: d_job_id_tbl PO_TBL_NUMBER;

5045: l_result_tbl PO_TBL_NUMBER;
5046:
5047: -- debug variables
5048: d_group_id NUMBER;
5049: d_job_id_tbl PO_TBL_NUMBER;
5050: d_job_name_tbl PO_TBL_VARCHAR2000;
5051: d_bg_id_tbl PO_TBL_NUMBER;
5052:
5053: BEGIN

Line 5051: d_bg_id_tbl PO_TBL_NUMBER;

5047: -- debug variables
5048: d_group_id NUMBER;
5049: d_job_id_tbl PO_TBL_NUMBER;
5050: d_job_name_tbl PO_TBL_VARCHAR2000;
5051: d_bg_id_tbl PO_TBL_NUMBER;
5052:
5053: BEGIN
5054: d_position := 0;
5055:

Line 5252: x_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

5248: PROCEDURE derive_category_id
5249: (
5250: p_key IN po_session_gt.key%TYPE,
5251: p_category_tbl IN PO_TBL_VARCHAR2000,
5252: x_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5253: ) IS
5254:
5255: d_api_name CONSTANT VARCHAR2(30) := 'derive_category_id';
5256: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5336: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

5332: p_key IN po_session_gt.key%TYPE,
5333: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5334: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
5335: p_ip_category_tbl IN PO_TBL_VARCHAR2000,
5336: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5337: ) IS
5338:
5339: d_api_name CONSTANT VARCHAR2(30) := 'derive_ip_category_id';
5340: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5344: l_index_tbl PO_TBL_NUMBER;

5340: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
5341: d_position NUMBER;
5342:
5343: -- tables to store the derived result
5344: l_index_tbl PO_TBL_NUMBER;
5345: l_result_tbl PO_TBL_NUMBER;
5346: BEGIN
5347: d_position := 0;
5348:

Line 5345: l_result_tbl PO_TBL_NUMBER;

5341: d_position NUMBER;
5342:
5343: -- tables to store the derived result
5344: l_index_tbl PO_TBL_NUMBER;
5345: l_result_tbl PO_TBL_NUMBER;
5346: BEGIN
5347: d_position := 0;
5348:
5349: IF (PO_LOG.d_proc) THEN

Line 5473: l_index_tbl PO_TBL_NUMBER;

5469: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
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:

Line 5558: x_line_type_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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';
5562: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5566: l_index_tbl PO_TBL_NUMBER;

5562: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
5563: d_position NUMBER;
5564:
5565: -- tables to store the derived result
5566: l_index_tbl PO_TBL_NUMBER;
5567: l_result_tbl PO_TBL_NUMBER;
5568: BEGIN
5569: d_position := 0;
5570:

Line 5567: l_result_tbl PO_TBL_NUMBER;

5563: d_position NUMBER;
5564:
5565: -- tables to store the derived result
5566: l_index_tbl PO_TBL_NUMBER;
5567: l_result_tbl PO_TBL_NUMBER;
5568: BEGIN
5569: d_position := 0;
5570:
5571: IF (PO_LOG.d_proc) THEN

Line 5654: x_un_number_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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';
5658: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5662: l_index_tbl PO_TBL_NUMBER;

5658: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
5659: d_position NUMBER;
5660:
5661: -- tables to store the derived result
5662: l_index_tbl PO_TBL_NUMBER;
5663: l_result_tbl PO_TBL_NUMBER;
5664: BEGIN
5665: d_position := 0;
5666:

Line 5663: l_result_tbl PO_TBL_NUMBER;

5659: d_position NUMBER;
5660:
5661: -- tables to store the derived result
5662: l_index_tbl PO_TBL_NUMBER;
5663: l_result_tbl PO_TBL_NUMBER;
5664: BEGIN
5665: d_position := 0;
5666:
5667: IF (PO_LOG.d_proc) THEN

Line 5744: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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';
5748: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5752: l_index_tbl PO_TBL_NUMBER;

5748: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
5749: d_position NUMBER;
5750:
5751: -- tables to store the derived result
5752: l_index_tbl PO_TBL_NUMBER;
5753: l_result_tbl PO_TBL_NUMBER;
5754: BEGIN
5755: d_position := 0;
5756:

Line 5753: l_result_tbl PO_TBL_NUMBER;

5749: d_position NUMBER;
5750:
5751: -- tables to store the derived result
5752: l_index_tbl PO_TBL_NUMBER;
5753: l_result_tbl PO_TBL_NUMBER;
5754: BEGIN
5755: d_position := 0;
5756:
5757: IF (PO_LOG.d_proc) THEN

Line 5833: x_template_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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';
5837: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5841: l_index_tbl PO_TBL_NUMBER;

5837: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
5838: d_position NUMBER;
5839:
5840: -- tables to store the derived result
5841: l_index_tbl PO_TBL_NUMBER;
5842: l_result_tbl PO_TBL_NUMBER;
5843: BEGIN
5844: d_position := 0;
5845:

Line 5842: l_result_tbl PO_TBL_NUMBER;

5838: d_position NUMBER;
5839:
5840: -- tables to store the derived result
5841: l_index_tbl PO_TBL_NUMBER;
5842: l_result_tbl PO_TBL_NUMBER;
5843: BEGIN
5844: d_position := 0;
5845:
5846: IF (PO_LOG.d_proc) THEN

Line 5938: p_line_type_id_tbl IN PO_TBL_NUMBER,

5934: PROCEDURE default_info_from_line_type
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,

Line 5942: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,

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

Line 5944: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER

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';
5948: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5952: l_index_tbl PO_TBL_NUMBER;

5948: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
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;

Line 5956: l_category_id_tbl PO_TBL_NUMBER;

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:
5960: -- current accessing index in the loop

Line 5958: l_unit_price_tbl PO_TBL_NUMBER;

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;
5962: BEGIN

Line 5969: x_category_id_tbl := PO_TBL_NUMBER();

5965: IF (PO_LOG.d_proc) THEN
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);

Line 5971: x_unit_price_tbl := PO_TBL_NUMBER();

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);
5975: x_unit_price_tbl.EXTEND(p_index_tbl.COUNT);

Line 6097: p_item_id_tbl IN PO_TBL_NUMBER,

6093: PROCEDURE default_info_from_item
6094: (
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,

Line 6100: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,

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,
6104: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 6101: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER,

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,
6104: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,
6105: x_secondary_unit_of_meas_tbl OUT NOCOPY PO_TBL_VARCHAR30

Line 6102: x_un_number_id_tbl OUT NOCOPY 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,
6104: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,
6105: x_secondary_unit_of_meas_tbl OUT NOCOPY PO_TBL_VARCHAR30
6106: ) IS

Line 6103: x_hazard_class_id_tbl OUT NOCOPY PO_TBL_NUMBER,

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

Line 6104: x_market_price_tbl OUT NOCOPY PO_TBL_NUMBER,

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,
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';

Line 6113: l_index_tbl PO_TBL_NUMBER;

6109: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
6110: d_position NUMBER;
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;

Line 6116: l_unit_price_tbl PO_TBL_NUMBER;

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;
6120: l_market_price_tbl PO_TBL_NUMBER;

Line 6117: l_category_id_tbl PO_TBL_NUMBER;

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;
6120: l_market_price_tbl PO_TBL_NUMBER;
6121: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30;

Line 6118: l_un_number_id_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;
6120: l_market_price_tbl PO_TBL_NUMBER;
6121: l_secondary_unit_of_meas_tbl PO_TBL_VARCHAR30;
6122:

Line 6119: l_hazard_class_id_tbl PO_TBL_NUMBER;

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;
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

Line 6120: l_market_price_tbl PO_TBL_NUMBER;

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;
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;

Line 6134: x_unit_price_tbl := PO_TBL_NUMBER();

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();
6138: x_market_price_tbl := PO_TBL_NUMBER();

Line 6135: x_category_id_tbl := PO_TBL_NUMBER();

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();
6138: x_market_price_tbl := PO_TBL_NUMBER();
6139: x_secondary_unit_of_meas_tbl := PO_TBL_VARCHAR30();

Line 6136: x_un_number_id_tbl := PO_TBL_NUMBER();

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();
6138: x_market_price_tbl := PO_TBL_NUMBER();
6139: x_secondary_unit_of_meas_tbl := PO_TBL_VARCHAR30();
6140:

Line 6137: x_hazard_class_id_tbl := PO_TBL_NUMBER();

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

Line 6138: x_market_price_tbl := PO_TBL_NUMBER();

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

Line 6276: p_job_id_tbl IN PO_TBL_NUMBER,

6272: PROCEDURE default_info_from_job
6273: (
6274: p_key IN po_session_gt.key%TYPE,
6275: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
6276: p_job_id_tbl IN PO_TBL_NUMBER,
6277: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
6278: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER
6279: ) IS
6280:

Line 6278: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER

6274: p_key IN po_session_gt.key%TYPE,
6275: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
6276: p_job_id_tbl IN PO_TBL_NUMBER,
6277: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
6278: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER
6279: ) IS
6280:
6281: d_api_name CONSTANT VARCHAR2(30) := 'default_info_from_job';
6282: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 6288: l_index_tbl PO_TBL_NUMBER;

6284:
6285: l_index NUMBER;
6286:
6287: -- variables to hold result read from temp table
6288: l_index_tbl PO_TBL_NUMBER;
6289: l_item_desc_tbl PO_TBL_VARCHAR2000;
6290: l_category_id_tbl PO_TBL_NUMBER;
6291: BEGIN
6292: d_position := 0;

Line 6290: l_category_id_tbl PO_TBL_NUMBER;

6286:
6287: -- variables to hold result read from temp table
6288: l_index_tbl PO_TBL_NUMBER;
6289: l_item_desc_tbl PO_TBL_VARCHAR2000;
6290: l_category_id_tbl PO_TBL_NUMBER;
6291: BEGIN
6292: d_position := 0;
6293:
6294: IF (PO_LOG.d_proc) THEN

Line 6299: x_category_id_tbl := PO_TBL_NUMBER();

6295: PO_LOG.proc_begin(d_module);
6296: END IF;
6297:
6298: x_item_desc_tbl := PO_TBL_VARCHAR2000();
6299: x_category_id_tbl := PO_TBL_NUMBER();
6300:
6301: x_item_desc_tbl.EXTEND(p_index_tbl.COUNT);
6302: x_category_id_tbl.EXTEND(p_index_tbl.COUNT);
6303:

Line 6383: p_ip_category_id_tbl IN PO_TBL_NUMBER,

6379: PROCEDURE default_po_cat_id_from_ip
6380: (
6381: p_key IN po_session_gt.key%TYPE,
6382: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
6383: p_ip_category_id_tbl IN PO_TBL_NUMBER,
6384: x_po_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
6385: ) IS
6386:
6387: d_api_name CONSTANT VARCHAR2(30) := 'default_po_cat_id_from_ip';

Line 6384: x_po_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

6380: (
6381: p_key IN po_session_gt.key%TYPE,
6382: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
6383: p_ip_category_id_tbl IN PO_TBL_NUMBER,
6384: x_po_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
6385: ) IS
6386:
6387: d_api_name CONSTANT VARCHAR2(30) := 'default_po_cat_id_from_ip';
6388: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 6392: l_index_tbl PO_TBL_NUMBER;

6388: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
6389: d_position NUMBER;
6390:
6391: -- variables to hold result read from temp table
6392: l_index_tbl PO_TBL_NUMBER;
6393: l_result_tbl PO_TBL_NUMBER;
6394: BEGIN
6395: d_position := 0;
6396:

Line 6393: l_result_tbl PO_TBL_NUMBER;

6389: d_position NUMBER;
6390:
6391: -- variables to hold result read from temp table
6392: l_index_tbl PO_TBL_NUMBER;
6393: l_result_tbl PO_TBL_NUMBER;
6394: BEGIN
6395: d_position := 0;
6396:
6397: IF (PO_LOG.d_proc) THEN

Line 6471: p_po_category_id_tbl IN PO_TBL_NUMBER,

6467: PROCEDURE default_ip_cat_id_from_po
6468: (
6469: p_key IN po_session_gt.key%TYPE,
6470: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
6471: p_po_category_id_tbl IN PO_TBL_NUMBER,
6472: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
6473: ) IS
6474:
6475: d_api_name CONSTANT VARCHAR2(30) := 'default_ip_cat_id_from_po';

Line 6472: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

6468: (
6469: p_key IN po_session_gt.key%TYPE,
6470: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
6471: p_po_category_id_tbl IN PO_TBL_NUMBER,
6472: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
6473: ) IS
6474:
6475: d_api_name CONSTANT VARCHAR2(30) := 'default_ip_cat_id_from_po';
6476: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 6480: l_index_tbl PO_TBL_NUMBER;

6476: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
6477: d_position NUMBER;
6478:
6479: -- variables to hold result read from temp table
6480: l_index_tbl PO_TBL_NUMBER;
6481: l_result_tbl PO_TBL_NUMBER;
6482: BEGIN
6483: d_position := 0;
6484:

Line 6481: l_result_tbl PO_TBL_NUMBER;

6477: d_position NUMBER;
6478:
6479: -- variables to hold result read from temp table
6480: l_index_tbl PO_TBL_NUMBER;
6481: l_result_tbl PO_TBL_NUMBER;
6482: BEGIN
6483: d_position := 0;
6484:
6485: IF (PO_LOG.d_proc) THEN

Line 6560: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_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';
6564: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 6568: l_index_tbl PO_TBL_NUMBER;

6564: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
6565: d_position NUMBER;
6566:
6567: -- variables to hold result read from temp table
6568: l_index_tbl PO_TBL_NUMBER;
6569: l_result_tbl PO_TBL_NUMBER;
6570: BEGIN
6571: d_position := 0;
6572:

Line 6569: l_result_tbl PO_TBL_NUMBER;

6565: d_position NUMBER;
6566:
6567: -- variables to hold result read from temp table
6568: l_index_tbl PO_TBL_NUMBER;
6569: l_result_tbl PO_TBL_NUMBER;
6570: BEGIN
6571: d_position := 0;
6572:
6573: IF (PO_LOG.d_proc) THEN

Line 6658: l_index_tbl PO_TBL_NUMBER;

6654: -- hold the key value which is used to identify rows in temp table
6655: l_key po_session_gt.key%TYPE;
6656:
6657: -- po line that has been found as a match for current line
6658: l_index_tbl PO_TBL_NUMBER;
6659: l_result_tbl PO_TBL_NUMBER;
6660:
6661: -- hash table of po_line_id based on po_header_id and line num
6662: --TYPE line_ref_type IS TABLE OF DBMS_SQL.NUMBER_TABLE INDEX BY PLS_INTEGER;

Line 6659: l_result_tbl PO_TBL_NUMBER;

6655: l_key po_session_gt.key%TYPE;
6656:
6657: -- po line that has been found as a match for current line
6658: l_index_tbl PO_TBL_NUMBER;
6659: l_result_tbl PO_TBL_NUMBER;
6660:
6661: -- hash table of po_line_id based on po_header_id and line num
6662: --TYPE line_ref_type IS TABLE OF DBMS_SQL.NUMBER_TABLE INDEX BY PLS_INTEGER;
6663: -- Added as part of bug 8836290 to handle line_num's decimals also without grouping

Line 6813: l_index_tbl PO_TBL_NUMBER;

6809: l_processing_line_tbl DBMS_SQL.NUMBER_TABLE;
6810: l_num_list DBMS_SQL.NUMBER_TABLE;
6811:
6812: -- po line that has been found as a match for current line
6813: l_index_tbl PO_TBL_NUMBER;
6814: l_po_line_id_tbl PO_TBL_NUMBER;
6815: l_line_num_tbl PO_TBL_NUMBER;
6816: l_match_index_tbl PO_TBL_NUMBER;
6817:

Line 6814: l_po_line_id_tbl PO_TBL_NUMBER;

6810: l_num_list DBMS_SQL.NUMBER_TABLE;
6811:
6812: -- po line that has been found as a match for current line
6813: l_index_tbl PO_TBL_NUMBER;
6814: l_po_line_id_tbl PO_TBL_NUMBER;
6815: l_line_num_tbl PO_TBL_NUMBER;
6816: l_match_index_tbl PO_TBL_NUMBER;
6817:
6818: -- temp variable used in processing

Line 6815: l_line_num_tbl PO_TBL_NUMBER;

6811:
6812: -- po line that has been found as a match for current line
6813: l_index_tbl PO_TBL_NUMBER;
6814: l_po_line_id_tbl PO_TBL_NUMBER;
6815: l_line_num_tbl PO_TBL_NUMBER;
6816: l_match_index_tbl PO_TBL_NUMBER;
6817:
6818: -- temp variable used in processing
6819: l_index NUMBER;

Line 6816: l_match_index_tbl PO_TBL_NUMBER;

6812: -- po line that has been found as a match for current line
6813: l_index_tbl PO_TBL_NUMBER;
6814: l_po_line_id_tbl PO_TBL_NUMBER;
6815: l_line_num_tbl PO_TBL_NUMBER;
6816: l_match_index_tbl PO_TBL_NUMBER;
6817:
6818: -- temp variable used in processing
6819: l_index NUMBER;
6820: l_match_index NUMBER;

Line 7408: l_index_tbl PO_TBL_NUMBER;

7404: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
7405: d_position NUMBER;
7406:
7407: -- variables to hold matching result read from po_session_gt table
7408: l_index_tbl PO_TBL_NUMBER;
7409: l_po_line_id_tbl PO_TBL_NUMBER;
7410: l_line_num_tbl PO_TBL_NUMBER;
7411:
7412: l_index NUMBER;

Line 7409: l_po_line_id_tbl PO_TBL_NUMBER;

7405: d_position NUMBER;
7406:
7407: -- variables to hold matching result read from po_session_gt table
7408: l_index_tbl PO_TBL_NUMBER;
7409: l_po_line_id_tbl PO_TBL_NUMBER;
7410: l_line_num_tbl PO_TBL_NUMBER;
7411:
7412: l_index NUMBER;
7413: l_data_key po_session_gt.key%TYPE;

Line 7410: l_line_num_tbl PO_TBL_NUMBER;

7406:
7407: -- variables to hold matching result read from po_session_gt table
7408: l_index_tbl PO_TBL_NUMBER;
7409: l_po_line_id_tbl PO_TBL_NUMBER;
7410: l_line_num_tbl PO_TBL_NUMBER;
7411:
7412: l_index NUMBER;
7413: l_data_key po_session_gt.key%TYPE;
7414:

Line 7664: l_index_tbl PO_TBL_NUMBER;

7660:
7661: l_def_master_org_id NUMBER;
7662:
7663: -- variables to hold matching result read from po_session_gt table
7664: l_index_tbl PO_TBL_NUMBER;
7665: l_po_line_id_tbl PO_TBL_NUMBER;
7666: l_line_num_tbl PO_TBL_NUMBER;
7667:
7668: l_index NUMBER;

Line 7665: l_po_line_id_tbl PO_TBL_NUMBER;

7661: l_def_master_org_id NUMBER;
7662:
7663: -- variables to hold matching result read from po_session_gt table
7664: l_index_tbl PO_TBL_NUMBER;
7665: l_po_line_id_tbl PO_TBL_NUMBER;
7666: l_line_num_tbl PO_TBL_NUMBER;
7667:
7668: l_index NUMBER;
7669: l_data_key po_session_gt.key%TYPE;

Line 7666: l_line_num_tbl PO_TBL_NUMBER;

7662:
7663: -- variables to hold matching result read from po_session_gt table
7664: l_index_tbl PO_TBL_NUMBER;
7665: l_po_line_id_tbl PO_TBL_NUMBER;
7666: l_line_num_tbl PO_TBL_NUMBER;
7667:
7668: l_index NUMBER;
7669: l_data_key po_session_gt.key%TYPE;
7670:

Line 7964: l_index_tbl PO_TBL_NUMBER;

7960: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
7961: d_position NUMBER;
7962:
7963: -- variables to hold matching result read from po_session_gt table
7964: l_index_tbl PO_TBL_NUMBER;
7965: l_po_line_id_tbl PO_TBL_NUMBER;
7966: l_line_num_tbl PO_TBL_NUMBER;
7967:
7968: l_index NUMBER;

Line 7965: l_po_line_id_tbl PO_TBL_NUMBER;

7961: d_position NUMBER;
7962:
7963: -- variables to hold matching result read from po_session_gt table
7964: l_index_tbl PO_TBL_NUMBER;
7965: l_po_line_id_tbl PO_TBL_NUMBER;
7966: l_line_num_tbl PO_TBL_NUMBER;
7967:
7968: l_index NUMBER;
7969: l_data_key po_session_gt.key%TYPE;

Line 7966: l_line_num_tbl PO_TBL_NUMBER;

7962:
7963: -- variables to hold matching result read from po_session_gt table
7964: l_index_tbl PO_TBL_NUMBER;
7965: l_po_line_id_tbl PO_TBL_NUMBER;
7966: l_line_num_tbl PO_TBL_NUMBER;
7967:
7968: l_index NUMBER;
7969: l_data_key po_session_gt.key%TYPE;
7970:

Line 8222: l_index_tbl PO_TBL_NUMBER;

8218: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
8219: d_position NUMBER;
8220:
8221: -- variables to hold matching result read from po_session_gt table
8222: l_index_tbl PO_TBL_NUMBER;
8223: l_po_line_id_tbl PO_TBL_NUMBER;
8224: l_line_num_tbl PO_TBL_NUMBER;
8225:
8226: l_index NUMBER;

Line 8223: l_po_line_id_tbl PO_TBL_NUMBER;

8219: d_position NUMBER;
8220:
8221: -- variables to hold matching result read from po_session_gt table
8222: l_index_tbl PO_TBL_NUMBER;
8223: l_po_line_id_tbl PO_TBL_NUMBER;
8224: l_line_num_tbl PO_TBL_NUMBER;
8225:
8226: l_index NUMBER;
8227: l_data_key po_session_gt.key%TYPE;

Line 8224: l_line_num_tbl PO_TBL_NUMBER;

8220:
8221: -- variables to hold matching result read from po_session_gt table
8222: l_index_tbl PO_TBL_NUMBER;
8223: l_po_line_id_tbl PO_TBL_NUMBER;
8224: l_line_num_tbl PO_TBL_NUMBER;
8225:
8226: l_index NUMBER;
8227: l_data_key po_session_gt.key%TYPE;
8228:

Line 8477: l_index_tbl PO_TBL_NUMBER;

8473: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
8474: d_position NUMBER;
8475:
8476: -- variables to hold matching result read from po_session_gt table
8477: l_index_tbl PO_TBL_NUMBER;
8478: l_po_line_id_tbl PO_TBL_NUMBER;
8479: l_line_num_tbl PO_TBL_NUMBER;
8480:
8481: l_index NUMBER;

Line 8478: l_po_line_id_tbl PO_TBL_NUMBER;

8474: d_position NUMBER;
8475:
8476: -- variables to hold matching result read from po_session_gt table
8477: l_index_tbl PO_TBL_NUMBER;
8478: l_po_line_id_tbl PO_TBL_NUMBER;
8479: l_line_num_tbl PO_TBL_NUMBER;
8480:
8481: l_index NUMBER;
8482: l_data_key po_session_gt.key%TYPE;

Line 8479: l_line_num_tbl PO_TBL_NUMBER;

8475:
8476: -- variables to hold matching result read from po_session_gt table
8477: l_index_tbl PO_TBL_NUMBER;
8478: l_po_line_id_tbl PO_TBL_NUMBER;
8479: l_line_num_tbl PO_TBL_NUMBER;
8480:
8481: l_index NUMBER;
8482: l_data_key po_session_gt.key%TYPE;
8483:

Line 8688: p_target_lines_index_tbl IN PO_TBL_NUMBER,

8684: PROCEDURE set_action_add
8685: (
8686: p_key IN po_session_gt.key%TYPE,
8687: p_group_num IN NUMBER,
8688: p_target_lines_index_tbl IN PO_TBL_NUMBER,
8689: p_check_line_num_assign IN VARCHAR2,
8690: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
8691: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
8692: ) IS

Line 8997: l_remove_err_line_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

8993: l_intf_header_id NUMBER;
8994: l_num_errored_lines NUMBER;
8995: l_num_processed_lines NUMBER;
8996: l_num_valid_lines NUMBER;
8997: l_remove_err_line_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
8998:
8999: BEGIN
9000:
9001: d_position := 0;

Line 9114: l_index_tbl PO_TBL_NUMBER;

9110: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
9111: d_position NUMBER;
9112:
9113: -- tables to store the derived result
9114: l_index_tbl PO_TBL_NUMBER;
9115: l_result_tbl PO_TBL_VARCHAR240;
9116: BEGIN
9117: d_position := 0;
9118:

Line 9185: l_index_tbl PO_TBL_NUMBER;

9181: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
9182: d_position NUMBER;
9183:
9184: -- tables to store the derived result
9185: l_index_tbl PO_TBL_NUMBER;
9186: l_result_tbl PO_TBL_VARCHAR240;
9187: BEGIN
9188: d_position := 0;
9189:

Line 9255: l_index_tbl PO_TBL_NUMBER;

9251: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
9252: d_position NUMBER;
9253:
9254: -- tables to store the derived result
9255: l_index_tbl PO_TBL_NUMBER;
9256: l_result_tbl PO_TBL_VARCHAR240;
9257: BEGIN
9258: d_position := 0;
9259:

Line 9317: p_intf_line_id_tbl IN PO_TBL_NUMBER,

9313: (
9314: p_key IN po_session_gt.key%TYPE,
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

Line 9318: p_intf_header_id_tbl IN PO_TBL_NUMBER,

9314: p_key IN po_session_gt.key%TYPE,
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

Line 9321: x_clm_base_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER

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';
9325: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 9329: l_index_tbl PO_TBL_NUMBER;

9325: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
9326: d_position NUMBER;
9327:
9328: -- tables to store the derived result
9329: l_index_tbl PO_TBL_NUMBER;
9330: l_result_tbl PO_TBL_NUMBER;
9331: BEGIN
9332: d_position := 0;
9333:

Line 9330: l_result_tbl PO_TBL_NUMBER;

9326: d_position NUMBER;
9327:
9328: -- tables to store the derived result
9329: l_index_tbl PO_TBL_NUMBER;
9330: l_result_tbl PO_TBL_NUMBER;
9331: BEGIN
9332: d_position := 0;
9333:
9334: IF (PO_LOG.d_proc) THEN

Line 9398: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

9394: (
9395: p_key IN po_session_gt.key%TYPE,
9396: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9397: p_from_header_disp_tbl IN PO_TBL_VARCHAR240,
9398: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
9399: ) IS
9400:
9401: d_api_name CONSTANT VARCHAR2(30) := 'derive_from_header_id';
9402: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 9406: l_index_tbl PO_TBL_NUMBER;

9402: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
9403: d_position NUMBER;
9404:
9405: -- tables to store the derived result
9406: l_index_tbl PO_TBL_NUMBER;
9407: l_result_tbl PO_TBL_NUMBER;
9408: BEGIN
9409: d_position := 0;
9410:

Line 9407: l_result_tbl PO_TBL_NUMBER;

9403: d_position NUMBER;
9404:
9405: -- tables to store the derived result
9406: l_index_tbl PO_TBL_NUMBER;
9407: l_result_tbl PO_TBL_NUMBER;
9408: BEGIN
9409: d_position := 0;
9410:
9411: IF (PO_LOG.d_proc) THEN

Line 9472: p_from_header_id_tbl IN PO_TBL_NUMBER,

9468: (
9469: p_key IN po_session_gt.key%TYPE,
9470: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9471: p_from_line_disp_tbl IN PO_TBL_VARCHAR240,
9472: p_from_header_id_tbl IN PO_TBL_NUMBER,
9473: x_from_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
9474: ) IS
9475:
9476: d_api_name CONSTANT VARCHAR2(30) := 'derive_from_line_id';

Line 9473: x_from_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

9469: p_key IN po_session_gt.key%TYPE,
9470: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9471: p_from_line_disp_tbl IN PO_TBL_VARCHAR240,
9472: p_from_header_id_tbl IN PO_TBL_NUMBER,
9473: x_from_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
9474: ) IS
9475:
9476: d_api_name CONSTANT VARCHAR2(30) := 'derive_from_line_id';
9477: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 9481: l_index_tbl PO_TBL_NUMBER;

9477: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
9478: d_position NUMBER;
9479:
9480: -- tables to store the derived result
9481: l_index_tbl PO_TBL_NUMBER;
9482: l_result_tbl PO_TBL_NUMBER;
9483: BEGIN
9484: d_position := 0;
9485:

Line 9482: l_result_tbl PO_TBL_NUMBER;

9478: d_position NUMBER;
9479:
9480: -- tables to store the derived result
9481: l_index_tbl PO_TBL_NUMBER;
9482: l_result_tbl PO_TBL_NUMBER;
9483: BEGIN
9484: d_position := 0;
9485:
9486: IF (PO_LOG.d_proc) THEN

Line 9547: p_intf_line_id_tbl IN PO_TBL_NUMBER,

9543: PROCEDURE default_clm_option_indicator
9544: (
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:

Line 9548: p_clm_base_line_num_tbl IN PO_TBL_NUMBER,

9544: (
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';

Line 9557: l_index_tbl PO_TBL_NUMBER;

9553: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
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:

Line 9622: p_intf_header_id_tbl IN PO_TBL_NUMBER,

9618: PROCEDURE default_clm_option_num
9619: (
9620: p_key IN po_session_gt.key%TYPE,
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

Line 9623: p_intf_line_id_tbl IN PO_TBL_NUMBER,

9619: (
9620: p_key IN po_session_gt.key%TYPE,
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

Line 9624: p_clm_base_line_num_tbl IN PO_TBL_NUMBER,

9620: p_key IN po_session_gt.key%TYPE,
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:

Line 9626: x_clm_option_num_tbl IN OUT NOCOPY PO_TBL_NUMBER

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';
9630: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 9634: l_index_tbl PO_TBL_NUMBER;

9630: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
9631: d_position NUMBER;
9632:
9633: -- tables to store the derived result
9634: l_index_tbl PO_TBL_NUMBER;
9635:
9636: l_result_tbl PO_TBL_NUMBER;
9637: l_option_num_tbl PO_TBL_NUMBER;
9638: BEGIN

Line 9636: l_result_tbl PO_TBL_NUMBER;

9632:
9633: -- tables to store the derived result
9634: l_index_tbl PO_TBL_NUMBER;
9635:
9636: l_result_tbl PO_TBL_NUMBER;
9637: l_option_num_tbl PO_TBL_NUMBER;
9638: BEGIN
9639: d_position := 0;
9640:

Line 9637: l_option_num_tbl PO_TBL_NUMBER;

9633: -- tables to store the derived result
9634: l_index_tbl PO_TBL_NUMBER;
9635:
9636: l_result_tbl PO_TBL_NUMBER;
9637: l_option_num_tbl PO_TBL_NUMBER;
9638: BEGIN
9639: d_position := 0;
9640:
9641: IF (PO_LOG.d_proc) THEN

Line 9710: p_intf_header_id_tbl IN PO_TBL_NUMBER,

9706: PROCEDURE default_from_header_id
9707: (
9708: p_key IN po_session_gt.key%TYPE,
9709: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9710: p_intf_header_id_tbl IN PO_TBL_NUMBER,
9711: p_intf_line_id_tbl IN PO_TBL_NUMBER,
9712: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
9713: ) IS
9714:

Line 9711: p_intf_line_id_tbl IN PO_TBL_NUMBER,

9707: (
9708: p_key IN po_session_gt.key%TYPE,
9709: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9710: p_intf_header_id_tbl IN PO_TBL_NUMBER,
9711: p_intf_line_id_tbl IN PO_TBL_NUMBER,
9712: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
9713: ) IS
9714:
9715: d_api_name CONSTANT VARCHAR2(30) := 'default_from_header_id';

Line 9712: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

9708: p_key IN po_session_gt.key%TYPE,
9709: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9710: p_intf_header_id_tbl IN PO_TBL_NUMBER,
9711: p_intf_line_id_tbl IN PO_TBL_NUMBER,
9712: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
9713: ) IS
9714:
9715: d_api_name CONSTANT VARCHAR2(30) := 'default_from_header_id';
9716: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 9720: l_index_tbl PO_TBL_NUMBER;

9716: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
9717: d_position NUMBER;
9718:
9719: -- tables to store the derived result
9720: l_index_tbl PO_TBL_NUMBER;
9721:
9722: l_result_tbl PO_TBL_NUMBER;
9723:
9724: BEGIN

Line 9722: l_result_tbl PO_TBL_NUMBER;

9718:
9719: -- tables to store the derived result
9720: l_index_tbl PO_TBL_NUMBER;
9721:
9722: l_result_tbl PO_TBL_NUMBER;
9723:
9724: BEGIN
9725: d_position := 0;
9726: