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_AUTOCREATE_GROUPING_PVT dependencies on PO_TBL_NUMBER

Line 142: ( p_req_line_num_tbl IN PO_TBL_NUMBER

138: x_token_value OUT NOCOPY VARCHAR2
139: );
140:
141: FUNCTION group_by_requisition_line_num
142: ( p_req_line_num_tbl IN PO_TBL_NUMBER
143: , p_po_line_num_tbl IN PO_TBL_NUMBER
144: , p_start_index IN NUMBER
145: , p_end_index IN NUMBER
146: ) RETURN PO_TBL_NUMBER;

Line 143: , p_po_line_num_tbl IN PO_TBL_NUMBER

139: );
140:
141: FUNCTION group_by_requisition_line_num
142: ( p_req_line_num_tbl IN PO_TBL_NUMBER
143: , p_po_line_num_tbl IN PO_TBL_NUMBER
144: , p_start_index IN NUMBER
145: , p_end_index IN NUMBER
146: ) RETURN PO_TBL_NUMBER;
147:

Line 146: ) RETURN PO_TBL_NUMBER;

142: ( p_req_line_num_tbl IN PO_TBL_NUMBER
143: , p_po_line_num_tbl IN PO_TBL_NUMBER
144: , p_start_index IN NUMBER
145: , p_end_index IN NUMBER
146: ) RETURN PO_TBL_NUMBER;
147:
148: FUNCTION group_by_clm_req_line_num
149: ( p_req_line_num_tbl IN PO_TBL_VARCHAR100
150: , p_po_line_num_tbl IN PO_TBL_VARCHAR100

Line 156: ( p_po_line_num_tbl IN PO_TBL_NUMBER

152: , p_end_index IN NUMBER
153: ) RETURN PO_TBL_VARCHAR100;
154:
155: FUNCTION group_by_requisition_seq_num
156: ( p_po_line_num_tbl IN PO_TBL_NUMBER
157: , p_add_to_po_header_id IN NUMBER
158: , p_start_index IN NUMBER
159: , p_end_index IN NUMBER
160: ) RETURN PO_TBL_NUMBER;

Line 160: ) RETURN PO_TBL_NUMBER;

156: ( p_po_line_num_tbl IN PO_TBL_NUMBER
157: , p_add_to_po_header_id IN NUMBER
158: , p_start_index IN NUMBER
159: , p_end_index IN NUMBER
160: ) RETURN PO_TBL_NUMBER;
161:
162: FUNCTION group_by_clm_req_seq_num
163: ( p_po_line_num_tbl IN PO_TBL_VARCHAR100
164: , p_req_line_id_tbl IN PO_TBL_NUMBER

Line 164: , p_req_line_id_tbl IN PO_TBL_NUMBER

160: ) RETURN PO_TBL_NUMBER;
161:
162: FUNCTION group_by_clm_req_seq_num
163: ( p_po_line_num_tbl IN PO_TBL_VARCHAR100
164: , p_req_line_id_tbl IN PO_TBL_NUMBER
165: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
166: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
167: , p_add_to_po_header_id IN NUMBER
168: , p_draft_id IN NUMBER --Autocreate grouping

Line 165: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

161:
162: FUNCTION group_by_clm_req_seq_num
163: ( p_po_line_num_tbl IN PO_TBL_VARCHAR100
164: , p_req_line_id_tbl IN PO_TBL_NUMBER
165: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
166: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
167: , p_add_to_po_header_id IN NUMBER
168: , p_draft_id IN NUMBER --Autocreate grouping
169: , p_start_index IN NUMBER

Line 175: ( p_req_line_id_tbl IN PO_TBL_NUMBER

171: ) RETURN PO_TBL_VARCHAR100;
172:
173:
174: FUNCTION group_by_default
175: ( p_req_line_id_tbl IN PO_TBL_NUMBER
176: , p_po_line_num_tbl IN PO_TBL_NUMBER
177: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
178: , p_add_to_po_header_id IN NUMBER
179: , p_builder_agreement_id IN NUMBER

Line 176: , p_po_line_num_tbl IN PO_TBL_NUMBER

172:
173:
174: FUNCTION group_by_default
175: ( p_req_line_id_tbl IN PO_TBL_NUMBER
176: , p_po_line_num_tbl IN PO_TBL_NUMBER
177: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
178: , p_add_to_po_header_id IN NUMBER
179: , p_builder_agreement_id IN NUMBER
180: , p_start_index IN NUMBER

Line 182: ) RETURN PO_TBL_NUMBER;

178: , p_add_to_po_header_id IN NUMBER
179: , p_builder_agreement_id IN NUMBER
180: , p_start_index IN NUMBER
181: , p_end_index IN NUMBER
182: ) RETURN PO_TBL_NUMBER;
183:
184: FUNCTION has_same_req_header
185: ( p_req_line_id_tbl IN PO_TBL_NUMBER
186: ) RETURN BOOLEAN;

Line 185: ( p_req_line_id_tbl IN PO_TBL_NUMBER

181: , p_end_index IN NUMBER
182: ) RETURN PO_TBL_NUMBER;
183:
184: FUNCTION has_same_req_header
185: ( p_req_line_id_tbl IN PO_TBL_NUMBER
186: ) RETURN BOOLEAN;
187:
188: PROCEDURE match_add_to_po_lines
189: ( p_req_line_id_tbl IN PO_TBL_NUMBER

Line 189: ( p_req_line_id_tbl IN PO_TBL_NUMBER

185: ( p_req_line_id_tbl IN PO_TBL_NUMBER
186: ) RETURN BOOLEAN;
187:
188: PROCEDURE match_add_to_po_lines
189: ( p_req_line_id_tbl IN PO_TBL_NUMBER
190: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
191: , p_add_to_po_header_id IN NUMBER
192: , p_draft_id IN NUMBER --Autocreate grouping
193: , p_builder_agreement_id IN NUMBER

Line 196: , x_req_line_id_tbl OUT NOCOPY PO_TBL_NUMBER

192: , p_draft_id IN NUMBER --Autocreate grouping
193: , p_builder_agreement_id IN NUMBER
194: , p_start_index IN NUMBER
195: , p_end_index IN NUMBER
196: , x_req_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
197: , x_po_line_num_tbl OUT NOCOPY PO_TBL_NUMBER
198: );
199:
200: Procedure clm_match_add_to_po_lines

Line 197: , x_po_line_num_tbl OUT NOCOPY PO_TBL_NUMBER

193: , p_builder_agreement_id IN NUMBER
194: , p_start_index IN NUMBER
195: , p_end_index IN NUMBER
196: , x_req_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
197: , x_po_line_num_tbl OUT NOCOPY PO_TBL_NUMBER
198: );
199:
200: Procedure clm_match_add_to_po_lines
201: ( p_req_line_id_tbl IN PO_TBL_NUMBER

Line 201: ( p_req_line_id_tbl IN PO_TBL_NUMBER

197: , x_po_line_num_tbl OUT NOCOPY PO_TBL_NUMBER
198: );
199:
200: Procedure clm_match_add_to_po_lines
201: ( p_req_line_id_tbl IN PO_TBL_NUMBER
202: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
203: , p_add_to_po_header_id IN NUMBER
204: , p_draft_id IN NUMBER --Autocreate grouping
205: , p_builder_agreement_id IN NUMBER

Line 208: , x_req_line_id_tbl OUT NOCOPY PO_TBL_NUMBER

204: , p_draft_id IN NUMBER --Autocreate grouping
205: , p_builder_agreement_id IN NUMBER
206: , p_start_index IN NUMBER
207: , p_end_index IN NUMBER
208: , x_req_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
209: , x_po_line_num_tbl OUT NOCOPY PO_TBL_NUMBER
210: , x_po_line_num_disp_tbl OUT NOCOPY PO_TBL_VARCHAR100
211: );
212:

Line 209: , x_po_line_num_tbl OUT NOCOPY PO_TBL_NUMBER

205: , p_builder_agreement_id IN NUMBER
206: , p_start_index IN NUMBER
207: , p_end_index IN NUMBER
208: , x_req_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
209: , x_po_line_num_tbl OUT NOCOPY PO_TBL_NUMBER
210: , x_po_line_num_disp_tbl OUT NOCOPY PO_TBL_VARCHAR100
211: );
212:
213: FUNCTION find_matching_builder_line_num

Line 215: , p_req_line_id_tbl IN PO_TBL_NUMBER

211: );
212:
213: FUNCTION find_matching_builder_line_num
214: ( p_current_index IN NUMBER
215: , p_req_line_id_tbl IN PO_TBL_NUMBER
216: , p_po_line_num_tbl IN PO_TBL_NUMBER
217: , p_builder_agreement_id IN NUMBER
218: ) RETURN NUMBER;
219:

Line 216: , p_po_line_num_tbl IN PO_TBL_NUMBER

212:
213: FUNCTION find_matching_builder_line_num
214: ( p_current_index IN NUMBER
215: , p_req_line_id_tbl IN PO_TBL_NUMBER
216: , p_po_line_num_tbl IN PO_TBL_NUMBER
217: , p_builder_agreement_id IN NUMBER
218: ) RETURN NUMBER;
219:
220: FUNCTION req_lines_match

Line 230: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

226: FUNCTION get_max_clm_po_line_num
227: ( p_po_line_num_tbl IN PO_TBL_VARCHAR100
228: , p_po_header_id IN NUMBER := NULL
229: , p_draft_id IN NUMBER := -1 --Autocreate grouping
230: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
231: ) RETURN VARCHAR2;
232:
233: FUNCTION get_max_clm_sol_line_num
234: ( p_neg_line_num_tbl IN PO_TBL_VARCHAR100

Line 236: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

232:
233: FUNCTION get_max_clm_sol_line_num
234: ( p_neg_line_num_tbl IN PO_TBL_VARCHAR100
235: , p_draft_id IN NUMBER := NULL
236: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
237: ) RETURN VARCHAR2;
238:
239: FUNCTION get_consigned_flag_tbl
240: ( p_req_line_id_tbl IN PO_TBL_NUMBER

Line 240: ( p_req_line_id_tbl IN PO_TBL_NUMBER

236: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
237: ) RETURN VARCHAR2;
238:
239: FUNCTION get_consigned_flag_tbl
240: ( p_req_line_id_tbl IN PO_TBL_NUMBER
241: , p_builder_org_id IN NUMBER
242: , p_builder_supplier_id IN NUMBER
243: , p_builder_site_id IN NUMBER
244: ) RETURN PO_TBL_VARCHAR1;

Line 248: , p_comparison_tbl IN PO_TBL_NUMBER

244: ) RETURN PO_TBL_VARCHAR1;
245:
246: FUNCTION find_matching_po_line_num
247: ( p_req_line_id IN NUMBER
248: , p_comparison_tbl IN PO_TBL_NUMBER
249: , p_po_line_num_tbl IN PO_TBL_NUMBER
250: ) RETURN NUMBER;
251:
252: --Adding the two new functions clm_find_match_builder_linenum and clm_group_by_default which will be used

Line 249: , p_po_line_num_tbl IN PO_TBL_NUMBER

245:
246: FUNCTION find_matching_po_line_num
247: ( p_req_line_id IN NUMBER
248: , p_comparison_tbl IN PO_TBL_NUMBER
249: , p_po_line_num_tbl IN PO_TBL_NUMBER
250: ) RETURN NUMBER;
251:
252: --Adding the two new functions clm_find_match_builder_linenum and clm_group_by_default which will be used
253: --for grouping in DEFAULT mode

Line 258: , p_req_line_id_tbl IN PO_TBL_NUMBER

254:
255: FUNCTION clm_find_match_builder_linenum
256: (
257: p_current_index IN NUMBER
258: , p_req_line_id_tbl IN PO_TBL_NUMBER
259: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
260: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
261: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
262: , p_po_line_num_tbl IN PO_TBL_NUMBER

Line 259: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

255: FUNCTION clm_find_match_builder_linenum
256: (
257: p_current_index IN NUMBER
258: , p_req_line_id_tbl IN PO_TBL_NUMBER
259: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
260: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
261: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
262: , p_po_line_num_tbl IN PO_TBL_NUMBER
263: , p_builder_agreement_id IN NUMBER

Line 262: , p_po_line_num_tbl IN PO_TBL_NUMBER

258: , p_req_line_id_tbl IN PO_TBL_NUMBER
259: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
260: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
261: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
262: , p_po_line_num_tbl IN PO_TBL_NUMBER
263: , p_builder_agreement_id IN NUMBER
264: )
265: RETURN NUMBER;
266:

Line 269: p_req_line_id_tbl IN PO_TBL_NUMBER

265: RETURN NUMBER;
266:
267: Procedure clm_group_by_default
268: (
269: p_req_line_id_tbl IN PO_TBL_NUMBER
270: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
271: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
272: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
273: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

Line 270: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

266:
267: Procedure clm_group_by_default
268: (
269: p_req_line_id_tbl IN PO_TBL_NUMBER
270: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
271: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
272: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
273: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
274: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1

Line 280: , p_po_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER

276: , p_draft_id IN NUMBER --Autocreate grouping
277: , p_builder_agreement_id IN NUMBER
278: , p_start_index IN NUMBER
279: , p_end_index IN NUMBER
280: , p_po_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
281: );
282:
283: Procedure clm_group_sol_by_default
284: (

Line 285: p_req_line_id_tbl IN PO_TBL_NUMBER

281: );
282:
283: Procedure clm_group_sol_by_default
284: (
285: p_req_line_id_tbl IN PO_TBL_NUMBER
286: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
287: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
288: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
289: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

Line 286: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

282:
283: Procedure clm_group_sol_by_default
284: (
285: p_req_line_id_tbl IN PO_TBL_NUMBER
286: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
287: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
288: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
289: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
290: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1

Line 296: , p_neg_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER

292: , p_draft_id IN NUMBER --Autocreate grouping
293: , p_builder_agreement_id IN NUMBER
294: , p_start_index IN NUMBER
295: , p_end_index IN NUMBER
296: , p_neg_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
297: );
298:
299:
300:

Line 338: p_po_line_number_tbl IN PO_TBL_NUMBER,

334: -- None
335: --End of Comments
336: -------------------------------------------------------------------------------
337: FUNCTION get_line_action_tbl(
338: p_po_line_number_tbl IN PO_TBL_NUMBER,
339: p_add_to_po_header_id IN NUMBER,
340: p_draft_id IN NUMBER --CLM Autogrouping
341: ) RETURN PO_TBL_VARCHAR5
342: IS

Line 446: p_req_line_id_tbl IN PO_TBL_NUMBER,

442: p_style_id IN NUMBER,
443: p_agreement_id IN NUMBER,
444: p_supplier_id IN NUMBER,
445: p_site_id IN NUMBER,
446: p_req_line_id_tbl IN PO_TBL_NUMBER,
447: p_po_line_number_tbl IN PO_TBL_NUMBER,
448: p_add_to_po_header_id IN NUMBER,
449: p_draft_id IN NUMBER, --Autocreate grouping
450: x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 447: p_po_line_number_tbl IN PO_TBL_NUMBER,

443: p_agreement_id IN NUMBER,
444: p_supplier_id IN NUMBER,
445: p_site_id IN NUMBER,
446: p_req_line_id_tbl IN PO_TBL_NUMBER,
447: p_po_line_number_tbl IN PO_TBL_NUMBER,
448: p_add_to_po_header_id IN NUMBER,
449: p_draft_id IN NUMBER, --Autocreate grouping
450: x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
451: x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 703: p_req_line_id_tbl IN PO_TBL_NUMBER,

699: END check_po_line_numbers;
700:
701:
702: PROCEDURE check_neg_line_numbers(
703: p_req_line_id_tbl IN PO_TBL_NUMBER,
704: p_sol_line_number_display_tbl IN PO_TBL_VARCHAR30,
705: p_sol_line_number_tbl IN PO_TBL_NUMBER,
706: p_draft_id IN NUMBER, --Autocreate grouping
707: x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 705: p_sol_line_number_tbl IN PO_TBL_NUMBER,

701:
702: PROCEDURE check_neg_line_numbers(
703: p_req_line_id_tbl IN PO_TBL_NUMBER,
704: p_sol_line_number_display_tbl IN PO_TBL_VARCHAR30,
705: p_sol_line_number_tbl IN PO_TBL_NUMBER,
706: p_draft_id IN NUMBER, --Autocreate grouping
707: x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
708: x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,
709: x_token_value_tbl OUT NOCOPY PO_TBL_VARCHAR2000

Line 1161: p_req_line_id_tbl IN PO_TBL_NUMBER

1157: --End of Comments
1158: -------------------------------------------------------------------------------
1159: FUNCTION group_req_lines
1160: (
1161: p_req_line_id_tbl IN PO_TBL_NUMBER
1162: , p_req_line_num_tbl IN PO_TBL_NUMBER
1163: , p_po_line_num_tbl IN PO_TBL_NUMBER
1164: , p_add_to_po_header_id IN NUMBER
1165: , p_builder_agreement_id IN NUMBER

Line 1162: , p_req_line_num_tbl IN PO_TBL_NUMBER

1158: -------------------------------------------------------------------------------
1159: FUNCTION group_req_lines
1160: (
1161: p_req_line_id_tbl IN PO_TBL_NUMBER
1162: , p_req_line_num_tbl IN PO_TBL_NUMBER
1163: , p_po_line_num_tbl IN PO_TBL_NUMBER
1164: , p_add_to_po_header_id IN NUMBER
1165: , p_builder_agreement_id IN NUMBER
1166: , p_builder_supplier_id IN NUMBER

Line 1163: , p_po_line_num_tbl IN PO_TBL_NUMBER

1159: FUNCTION group_req_lines
1160: (
1161: p_req_line_id_tbl IN PO_TBL_NUMBER
1162: , p_req_line_num_tbl IN PO_TBL_NUMBER
1163: , p_po_line_num_tbl IN PO_TBL_NUMBER
1164: , p_add_to_po_header_id IN NUMBER
1165: , p_builder_agreement_id IN NUMBER
1166: , p_builder_supplier_id IN NUMBER
1167: , p_builder_site_id IN NUMBER

Line 1173: RETURN PO_TBL_NUMBER

1169: , p_start_index IN NUMBER
1170: , p_end_index IN NUMBER
1171: , p_grouping_method IN VARCHAR2
1172: )
1173: RETURN PO_TBL_NUMBER
1174: IS
1175: l_start_index NUMBER;
1176: l_end_index NUMBER;
1177:

Line 1179: l_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;

1175: l_start_index NUMBER;
1176: l_end_index NUMBER;
1177:
1178: l_consigned_flag_tbl PO_TBL_VARCHAR1;
1179: l_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
1180: x_po_line_num_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1181:
1182: d_mod CONSTANT VARCHAR2(100) := D_group_req_lines;
1183: d_position NUMBER := 0;

Line 1180: x_po_line_num_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1176: l_end_index NUMBER;
1177:
1178: l_consigned_flag_tbl PO_TBL_VARCHAR1;
1179: l_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
1180: x_po_line_num_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1181:
1182: d_mod CONSTANT VARCHAR2(100) := D_group_req_lines;
1183: d_position NUMBER := 0;
1184:

Line 1344: p_req_line_id_tbl IN PO_TBL_NUMBER

1340: --End of Comments
1341: -------------------------------------------------------------------------------
1342: Procedure group_clm_req_lines
1343: (
1344: p_req_line_id_tbl IN PO_TBL_NUMBER
1345: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
1346: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
1347: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
1348: , p_req_line_num_tbl IN PO_TBL_VARCHAR100

Line 1345: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

1341: -------------------------------------------------------------------------------
1342: Procedure group_clm_req_lines
1343: (
1344: p_req_line_id_tbl IN PO_TBL_NUMBER
1345: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
1346: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
1347: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
1348: , p_req_line_num_tbl IN PO_TBL_VARCHAR100
1349: , p_po_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 1349: , p_po_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER

1345: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
1346: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
1347: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
1348: , p_req_line_num_tbl IN PO_TBL_VARCHAR100
1349: , p_po_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
1350: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
1351: , p_add_to_po_header_id IN NUMBER
1352: , p_draft_id IN NUMBER --Autocreate grouping
1353: , p_builder_agreement_id IN NUMBER

Line 1368: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;

1364:
1365: l_consigned_flag_tbl PO_TBL_VARCHAR1;
1366: l_po_line_num_disp_tbl PO_TBL_VARCHAR100 := p_po_line_num_disp_tbl;
1367: x_po_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
1368: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
1369:
1370: d_mod CONSTANT VARCHAR2(100) := D_group_clm_req_lines ;
1371: d_position NUMBER := 0;
1372: l_grouping_method VARCHAR2(50);

Line 1373: l_req_group_line_id_tbl PO_TBL_NUMBER := p_req_group_line_id_tbl;

1369:
1370: d_mod CONSTANT VARCHAR2(100) := D_group_clm_req_lines ;
1371: d_position NUMBER := 0;
1372: l_grouping_method VARCHAR2(50);
1373: l_req_group_line_id_tbl PO_TBL_NUMBER := p_req_group_line_id_tbl;
1374: l_renumber_flag PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1375: l_line_num NUMBER := 1;
1376: l_max_line_num NUMBER := 0;
1377:

Line 1626: p_req_line_id_tbl IN PO_TBL_NUMBER

1622: --End of Comments
1623: -------------------------------------------------------------------------------
1624: Procedure group_clm_sol_req_lines
1625: (
1626: p_req_line_id_tbl IN PO_TBL_NUMBER
1627: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
1628: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
1629: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
1630: , p_req_line_num_tbl IN PO_TBL_VARCHAR100

Line 1627: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

1623: -------------------------------------------------------------------------------
1624: Procedure group_clm_sol_req_lines
1625: (
1626: p_req_line_id_tbl IN PO_TBL_NUMBER
1627: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
1628: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
1629: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
1630: , p_req_line_num_tbl IN PO_TBL_VARCHAR100
1631: , p_neg_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 1631: , p_neg_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER

1627: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
1628: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
1629: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
1630: , p_req_line_num_tbl IN PO_TBL_VARCHAR100
1631: , p_neg_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
1632: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
1633: , p_add_to_neg_header_id IN NUMBER
1634: , p_draft_id IN NUMBER --Autocreate grouping
1635: , p_builder_agreement_id IN NUMBER

Line 1650: x_po_line_num_tbl PO_TBL_NUMBER := p_neg_line_num_tbl;

1646:
1647: l_consigned_flag_tbl PO_TBL_VARCHAR1;
1648: l_po_line_num_disp_tbl PO_TBL_VARCHAR100 := p_neg_line_num_disp_tbl;
1649: x_po_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
1650: x_po_line_num_tbl PO_TBL_NUMBER := p_neg_line_num_tbl;
1651:
1652: d_mod CONSTANT VARCHAR2(100) := D_group_clm_req_lines ;
1653: d_position NUMBER := 0;
1654: l_grouping_method VARCHAR2(50);

Line 1655: l_req_group_line_id_tbl PO_TBL_NUMBER := p_req_group_line_id_tbl;

1651:
1652: d_mod CONSTANT VARCHAR2(100) := D_group_clm_req_lines ;
1653: d_position NUMBER := 0;
1654: l_grouping_method VARCHAR2(50);
1655: l_req_group_line_id_tbl PO_TBL_NUMBER := p_req_group_line_id_tbl;
1656: l_renumber_flag PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1657: l_line_num NUMBER := 1;
1658: l_max_line_num NUMBER := 0;
1659:

Line 1833: p_req_line_id_tbl IN PO_TBL_NUMBER

1829: --End of Comments
1830: -------------------------------------------------------------------------------
1831: Procedure group_neg_req_lines
1832: (
1833: p_req_line_id_tbl IN PO_TBL_NUMBER
1834: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
1835: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
1836: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
1837: , p_req_line_num_tbl IN PO_TBL_VARCHAR100

Line 1834: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

1830: -------------------------------------------------------------------------------
1831: Procedure group_neg_req_lines
1832: (
1833: p_req_line_id_tbl IN PO_TBL_NUMBER
1834: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
1835: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
1836: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
1837: , p_req_line_num_tbl IN PO_TBL_VARCHAR100
1838: , p_neg_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 1838: , p_neg_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER

1834: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
1835: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
1836: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
1837: , p_req_line_num_tbl IN PO_TBL_VARCHAR100
1838: , p_neg_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
1839: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
1840: , p_add_to_neg_header_id IN NUMBER
1841: , p_draft_id IN NUMBER --Autocreate grouping
1842: , p_builder_agreement_id IN NUMBER

Line 1857: x_po_line_num_tbl PO_TBL_NUMBER := p_neg_line_num_tbl;

1853:
1854: l_consigned_flag_tbl PO_TBL_VARCHAR1;
1855: l_po_line_num_disp_tbl PO_TBL_VARCHAR100 := p_neg_line_num_disp_tbl;
1856: x_po_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
1857: x_po_line_num_tbl PO_TBL_NUMBER := p_neg_line_num_tbl;
1858:
1859: d_mod CONSTANT VARCHAR2(100) := D_group_neg_req_lines ;
1860: d_position NUMBER := 0;
1861: l_grouping_method VARCHAR2(50);

Line 1862: l_req_group_line_id_tbl PO_TBL_NUMBER := p_req_group_line_id_tbl;

1858:
1859: d_mod CONSTANT VARCHAR2(100) := D_group_neg_req_lines ;
1860: d_position NUMBER := 0;
1861: l_grouping_method VARCHAR2(50);
1862: l_req_group_line_id_tbl PO_TBL_NUMBER := p_req_group_line_id_tbl;
1863: l_renumber_flag PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1864: l_line_num NUMBER := 1;
1865: l_max_line_num NUMBER := 0;
1866:

Line 1981: p_req_line_id_tbl IN PO_TBL_NUMBER

1977: */
1978:
1979: Procedure clm_group_by_default
1980: (
1981: p_req_line_id_tbl IN PO_TBL_NUMBER
1982: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
1983: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
1984: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
1985: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

Line 1982: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

1978:
1979: Procedure clm_group_by_default
1980: (
1981: p_req_line_id_tbl IN PO_TBL_NUMBER
1982: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
1983: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
1984: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
1985: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
1986: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1

Line 1992: , p_po_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER

1988: , p_draft_id IN NUMBER --Autocreate grouping
1989: , p_builder_agreement_id IN NUMBER
1990: , p_start_index IN NUMBER
1991: , p_end_index IN NUMBER
1992: , p_po_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
1993: )
1994: IS
1995:
1996: l_max_line_num NUMBER;

Line 1999: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;

1995:
1996: l_max_line_num NUMBER;
1997: l_matching_index NUMBER;
1998: l_po_line_num NUMBER;
1999: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
2000:
2001: l_add_to_po_req_line_id_tbl PO_TBL_NUMBER;
2002: l_add_to_po_line_num_tbl PO_TBL_NUMBER;
2003: l_max_slin_num_disp_tbl PO_TBL_VARCHAR100;

Line 2001: l_add_to_po_req_line_id_tbl PO_TBL_NUMBER;

1997: l_matching_index NUMBER;
1998: l_po_line_num NUMBER;
1999: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
2000:
2001: l_add_to_po_req_line_id_tbl PO_TBL_NUMBER;
2002: l_add_to_po_line_num_tbl PO_TBL_NUMBER;
2003: l_max_slin_num_disp_tbl PO_TBL_VARCHAR100;
2004:
2005: d_mod CONSTANT VARCHAR2(100) := D_clm_group_by_default;

Line 2002: l_add_to_po_line_num_tbl PO_TBL_NUMBER;

1998: l_po_line_num NUMBER;
1999: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
2000:
2001: l_add_to_po_req_line_id_tbl PO_TBL_NUMBER;
2002: l_add_to_po_line_num_tbl PO_TBL_NUMBER;
2003: l_max_slin_num_disp_tbl PO_TBL_VARCHAR100;
2004:
2005: d_mod CONSTANT VARCHAR2(100) := D_clm_group_by_default;
2006: d_position NUMBER := 0;

Line 2179: p_req_line_id_tbl IN PO_TBL_NUMBER

2175: */
2176:
2177: Procedure clm_group_sol_by_default
2178: (
2179: p_req_line_id_tbl IN PO_TBL_NUMBER
2180: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
2181: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
2182: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
2183: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

Line 2180: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

2176:
2177: Procedure clm_group_sol_by_default
2178: (
2179: p_req_line_id_tbl IN PO_TBL_NUMBER
2180: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
2181: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
2182: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
2183: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
2184: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1

Line 2190: , p_neg_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER

2186: , p_draft_id IN NUMBER --Autocreate grouping
2187: , p_builder_agreement_id IN NUMBER
2188: , p_start_index IN NUMBER
2189: , p_end_index IN NUMBER
2190: , p_neg_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
2191: )
2192: IS
2193:
2194: l_max_line_num NUMBER;

Line 2197: x_neg_line_num_tbl PO_TBL_NUMBER := p_neg_line_num_tbl;

2193:
2194: l_max_line_num NUMBER;
2195: l_matching_index NUMBER;
2196: l_neg_line_num NUMBER;
2197: x_neg_line_num_tbl PO_TBL_NUMBER := p_neg_line_num_tbl;
2198:
2199: l_add_to_neg_req_line_id_tbl PO_TBL_NUMBER;
2200: l_add_to_neg_line_num_tbl PO_TBL_NUMBER;
2201: l_max_slin_num_disp_tbl PO_TBL_VARCHAR100;

Line 2199: l_add_to_neg_req_line_id_tbl PO_TBL_NUMBER;

2195: l_matching_index NUMBER;
2196: l_neg_line_num NUMBER;
2197: x_neg_line_num_tbl PO_TBL_NUMBER := p_neg_line_num_tbl;
2198:
2199: l_add_to_neg_req_line_id_tbl PO_TBL_NUMBER;
2200: l_add_to_neg_line_num_tbl PO_TBL_NUMBER;
2201: l_max_slin_num_disp_tbl PO_TBL_VARCHAR100;
2202:
2203: d_mod CONSTANT VARCHAR2(100) := D_clm_group_by_default;

Line 2200: l_add_to_neg_line_num_tbl PO_TBL_NUMBER;

2196: l_neg_line_num NUMBER;
2197: x_neg_line_num_tbl PO_TBL_NUMBER := p_neg_line_num_tbl;
2198:
2199: l_add_to_neg_req_line_id_tbl PO_TBL_NUMBER;
2200: l_add_to_neg_line_num_tbl PO_TBL_NUMBER;
2201: l_max_slin_num_disp_tbl PO_TBL_VARCHAR100;
2202:
2203: d_mod CONSTANT VARCHAR2(100) := D_clm_group_by_default;
2204: d_position NUMBER := 0;

Line 2297: , p_req_line_id_tbl IN PO_TBL_NUMBER

2293:
2294: FUNCTION clm_find_match_builder_linenum
2295: (
2296: p_current_index IN NUMBER
2297: , p_req_line_id_tbl IN PO_TBL_NUMBER
2298: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
2299: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
2300: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
2301: , p_po_line_num_tbl IN PO_TBL_NUMBER

Line 2298: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

2294: FUNCTION clm_find_match_builder_linenum
2295: (
2296: p_current_index IN NUMBER
2297: , p_req_line_id_tbl IN PO_TBL_NUMBER
2298: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
2299: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
2300: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
2301: , p_po_line_num_tbl IN PO_TBL_NUMBER
2302: , p_builder_agreement_id IN NUMBER

Line 2301: , p_po_line_num_tbl IN PO_TBL_NUMBER

2297: , p_req_line_id_tbl IN PO_TBL_NUMBER
2298: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
2299: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
2300: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
2301: , p_po_line_num_tbl IN PO_TBL_NUMBER
2302: , p_builder_agreement_id IN NUMBER
2303: )
2304: RETURN NUMBER
2305: IS

Line 3457: p_req_line_num_tbl IN PO_TBL_NUMBER

3453: --End of Comments
3454: -------------------------------------------------------------------------------
3455: FUNCTION group_by_requisition_line_num
3456: (
3457: p_req_line_num_tbl IN PO_TBL_NUMBER
3458: , p_po_line_num_tbl IN PO_TBL_NUMBER
3459: , p_start_index IN NUMBER
3460: , p_end_index IN NUMBER
3461: )

Line 3458: , p_po_line_num_tbl IN PO_TBL_NUMBER

3454: -------------------------------------------------------------------------------
3455: FUNCTION group_by_requisition_line_num
3456: (
3457: p_req_line_num_tbl IN PO_TBL_NUMBER
3458: , p_po_line_num_tbl IN PO_TBL_NUMBER
3459: , p_start_index IN NUMBER
3460: , p_end_index IN NUMBER
3461: )
3462: RETURN PO_TBL_NUMBER

Line 3462: RETURN PO_TBL_NUMBER

3458: , p_po_line_num_tbl IN PO_TBL_NUMBER
3459: , p_start_index IN NUMBER
3460: , p_end_index IN NUMBER
3461: )
3462: RETURN PO_TBL_NUMBER
3463: IS
3464: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
3465:
3466: -- Bug 13778496 change the index type of NUM_INDEX_TBL_TYPE from PLS_INTEGER

Line 3464: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;

3460: , p_end_index IN NUMBER
3461: )
3462: RETURN PO_TBL_NUMBER
3463: IS
3464: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
3465:
3466: -- Bug 13778496 change the index type of NUM_INDEX_TBL_TYPE from PLS_INTEGER
3467: -- to VARCHAR2(40) in order to resolve the fraction requisition line num and
3468: -- generate fraction value of po line num

Line 3672: p_po_line_num_tbl IN PO_TBL_NUMBER

3668: --End of Comments
3669: -------------------------------------------------------------------------------
3670: FUNCTION group_by_requisition_seq_num
3671: (
3672: p_po_line_num_tbl IN PO_TBL_NUMBER
3673: , p_add_to_po_header_id IN NUMBER
3674: , p_start_index IN NUMBER
3675: , p_end_index IN NUMBER
3676: )

Line 3677: RETURN PO_TBL_NUMBER

3673: , p_add_to_po_header_id IN NUMBER
3674: , p_start_index IN NUMBER
3675: , p_end_index IN NUMBER
3676: )
3677: RETURN PO_TBL_NUMBER
3678: IS
3679: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
3680:
3681: l_max_line_num NUMBER;

Line 3679: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;

3675: , p_end_index IN NUMBER
3676: )
3677: RETURN PO_TBL_NUMBER
3678: IS
3679: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
3680:
3681: l_max_line_num NUMBER;
3682: l_next_line_num NUMBER;
3683:

Line 3754: , p_req_line_id_tbl IN PO_TBL_NUMBER

3750: --End of Comments
3751: -------------------------------------------------------------------------------
3752: FUNCTION group_by_clm_req_seq_num
3753: ( p_po_line_num_tbl IN PO_TBL_VARCHAR100
3754: , p_req_line_id_tbl IN PO_TBL_NUMBER
3755: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
3756: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
3757: , p_add_to_po_header_id IN NUMBER
3758: , p_draft_id IN NUMBER --Autocreate grouping

Line 3755: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

3751: -------------------------------------------------------------------------------
3752: FUNCTION group_by_clm_req_seq_num
3753: ( p_po_line_num_tbl IN PO_TBL_VARCHAR100
3754: , p_req_line_id_tbl IN PO_TBL_NUMBER
3755: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
3756: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
3757: , p_add_to_po_header_id IN NUMBER
3758: , p_draft_id IN NUMBER --Autocreate grouping
3759: , p_start_index IN NUMBER

Line 3886: p_req_line_id_tbl IN PO_TBL_NUMBER

3882: --End of Comments
3883: -------------------------------------------------------------------------------
3884: FUNCTION group_by_default
3885: (
3886: p_req_line_id_tbl IN PO_TBL_NUMBER
3887: , p_po_line_num_tbl IN PO_TBL_NUMBER
3888: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
3889: , p_add_to_po_header_id IN NUMBER
3890: , p_builder_agreement_id IN NUMBER

Line 3887: , p_po_line_num_tbl IN PO_TBL_NUMBER

3883: -------------------------------------------------------------------------------
3884: FUNCTION group_by_default
3885: (
3886: p_req_line_id_tbl IN PO_TBL_NUMBER
3887: , p_po_line_num_tbl IN PO_TBL_NUMBER
3888: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
3889: , p_add_to_po_header_id IN NUMBER
3890: , p_builder_agreement_id IN NUMBER
3891: , p_start_index IN NUMBER

Line 3894: RETURN PO_TBL_NUMBER

3890: , p_builder_agreement_id IN NUMBER
3891: , p_start_index IN NUMBER
3892: , p_end_index IN NUMBER
3893: )
3894: RETURN PO_TBL_NUMBER
3895: IS
3896: l_max_line_num NUMBER := 0;
3897: l_matching_index NUMBER;
3898: l_po_line_num NUMBER;

Line 3899: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;

3895: IS
3896: l_max_line_num NUMBER := 0;
3897: l_matching_index NUMBER;
3898: l_po_line_num NUMBER;
3899: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
3900:
3901: l_add_to_po_req_line_id_tbl PO_TBL_NUMBER;
3902: l_add_to_po_line_num_tbl PO_TBL_NUMBER;
3903:

Line 3901: l_add_to_po_req_line_id_tbl PO_TBL_NUMBER;

3897: l_matching_index NUMBER;
3898: l_po_line_num NUMBER;
3899: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
3900:
3901: l_add_to_po_req_line_id_tbl PO_TBL_NUMBER;
3902: l_add_to_po_line_num_tbl PO_TBL_NUMBER;
3903:
3904: d_mod CONSTANT VARCHAR2(100) := D_group_by_default;
3905: d_position NUMBER := 0;

Line 3902: l_add_to_po_line_num_tbl PO_TBL_NUMBER;

3898: l_po_line_num NUMBER;
3899: x_po_line_num_tbl PO_TBL_NUMBER := p_po_line_num_tbl;
3900:
3901: l_add_to_po_req_line_id_tbl PO_TBL_NUMBER;
3902: l_add_to_po_line_num_tbl PO_TBL_NUMBER;
3903:
3904: d_mod CONSTANT VARCHAR2(100) := D_group_by_default;
3905: d_position NUMBER := 0;
3906:

Line 4030: p_req_line_id_tbl IN PO_TBL_NUMBER

4026: --End of Comments
4027: -------------------------------------------------------------------------------
4028: FUNCTION has_same_req_header
4029: (
4030: p_req_line_id_tbl IN PO_TBL_NUMBER
4031: )
4032: RETURN BOOLEAN
4033: IS
4034: l_req_header_id NUMBER;

Line 4130: p_req_line_id_tbl IN PO_TBL_NUMBER

4126: --End of Comments
4127: -------------------------------------------------------------------------------
4128: PROCEDURE match_add_to_po_lines
4129: (
4130: p_req_line_id_tbl IN PO_TBL_NUMBER
4131: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
4132: , p_add_to_po_header_id IN NUMBER
4133: , p_draft_id IN NUMBER --Autocreate grouping
4134: , p_builder_agreement_id IN NUMBER

Line 4137: , x_req_line_id_tbl OUT NOCOPY PO_TBL_NUMBER

4133: , p_draft_id IN NUMBER --Autocreate grouping
4134: , p_builder_agreement_id IN NUMBER
4135: , p_start_index IN NUMBER
4136: , p_end_index IN NUMBER
4137: , x_req_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
4138: , x_po_line_num_tbl OUT NOCOPY PO_TBL_NUMBER
4139: )
4140: IS
4141: l_key NUMBER;

Line 4138: , x_po_line_num_tbl OUT NOCOPY PO_TBL_NUMBER

4134: , p_builder_agreement_id IN NUMBER
4135: , p_start_index IN NUMBER
4136: , p_end_index IN NUMBER
4137: , x_req_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
4138: , x_po_line_num_tbl OUT NOCOPY PO_TBL_NUMBER
4139: )
4140: IS
4141: l_key NUMBER;
4142:

Line 4159: x_req_line_id_tbl := PO_TBL_NUMBER();

4155: -- Return immediately if there is no Add To PO.
4156: --
4157: IF ( p_add_to_po_header_id IS NULL )
4158: THEN
4159: x_req_line_id_tbl := PO_TBL_NUMBER();
4160: x_po_line_num_tbl := PO_TBL_NUMBER();
4161: return;
4162: END IF;
4163:

Line 4160: x_po_line_num_tbl := PO_TBL_NUMBER();

4156: --
4157: IF ( p_add_to_po_header_id IS NULL )
4158: THEN
4159: x_req_line_id_tbl := PO_TBL_NUMBER();
4160: x_po_line_num_tbl := PO_TBL_NUMBER();
4161: return;
4162: END IF;
4163:
4164: d_position := 10;

Line 4275: p_req_line_id_tbl IN PO_TBL_NUMBER

4271: -------------------------------------------------------------------------------
4272:
4273: Procedure clm_match_add_to_po_lines
4274: (
4275: p_req_line_id_tbl IN PO_TBL_NUMBER
4276: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
4277: , p_add_to_po_header_id IN NUMBER
4278: , p_draft_id IN NUMBER --Autocreate grouping
4279: , p_builder_agreement_id IN NUMBER

Line 4282: , x_req_line_id_tbl OUT NOCOPY PO_TBL_NUMBER

4278: , p_draft_id IN NUMBER --Autocreate grouping
4279: , p_builder_agreement_id IN NUMBER
4280: , p_start_index IN NUMBER
4281: , p_end_index IN NUMBER
4282: , x_req_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
4283: , x_po_line_num_tbl OUT NOCOPY PO_TBL_NUMBER
4284: , x_po_line_num_disp_tbl OUT NOCOPY PO_TBL_VARCHAR100
4285: )
4286: IS

Line 4283: , x_po_line_num_tbl OUT NOCOPY PO_TBL_NUMBER

4279: , p_builder_agreement_id IN NUMBER
4280: , p_start_index IN NUMBER
4281: , p_end_index IN NUMBER
4282: , x_req_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
4283: , x_po_line_num_tbl OUT NOCOPY PO_TBL_NUMBER
4284: , x_po_line_num_disp_tbl OUT NOCOPY PO_TBL_VARCHAR100
4285: )
4286: IS
4287: l_key NUMBER;

Line 4307: x_req_line_id_tbl := PO_TBL_NUMBER();

4303:
4304:
4305: IF ( p_add_to_po_header_id IS NULL )
4306: THEN
4307: x_req_line_id_tbl := PO_TBL_NUMBER();
4308: x_po_line_num_tbl := PO_TBL_NUMBER();
4309: x_po_line_num_disp_tbl := PO_TBL_VARCHAR100();
4310: RETURN;
4311: END IF;

Line 4308: x_po_line_num_tbl := PO_TBL_NUMBER();

4304:
4305: IF ( p_add_to_po_header_id IS NULL )
4306: THEN
4307: x_req_line_id_tbl := PO_TBL_NUMBER();
4308: x_po_line_num_tbl := PO_TBL_NUMBER();
4309: x_po_line_num_disp_tbl := PO_TBL_VARCHAR100();
4310: RETURN;
4311: END IF;
4312:

Line 4458: , p_req_line_id_tbl IN PO_TBL_NUMBER

4454: -------------------------------------------------------------------------------
4455: FUNCTION find_matching_builder_line_num
4456: (
4457: p_current_index IN NUMBER
4458: , p_req_line_id_tbl IN PO_TBL_NUMBER
4459: , p_po_line_num_tbl IN PO_TBL_NUMBER
4460: , p_builder_agreement_id IN NUMBER
4461: )
4462: RETURN NUMBER

Line 4459: , p_po_line_num_tbl IN PO_TBL_NUMBER

4455: FUNCTION find_matching_builder_line_num
4456: (
4457: p_current_index IN NUMBER
4458: , p_req_line_id_tbl IN PO_TBL_NUMBER
4459: , p_po_line_num_tbl IN PO_TBL_NUMBER
4460: , p_builder_agreement_id IN NUMBER
4461: )
4462: RETURN NUMBER
4463: IS

Line 4608: p_po_line_num_tbl IN PO_TBL_NUMBER

4604: --End of Comments
4605: -------------------------------------------------------------------------------
4606: FUNCTION get_max_po_line_num
4607: (
4608: p_po_line_num_tbl IN PO_TBL_NUMBER
4609: , p_po_header_id IN NUMBER := NULL
4610: , p_draft_id IN NUMBER := -1
4611: )
4612: RETURN NUMBER

Line 4693: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

4689: (
4690: p_po_line_num_tbl IN PO_TBL_VARCHAR100
4691: , p_po_header_id IN NUMBER := NULL
4692: , p_draft_id IN NUMBER := -1
4693: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
4694: )
4695: RETURN VARCHAR2
4696: IS
4697: x_max_po_line_num VARCHAR2(100) := '0000';

Line 4780: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

4776: FUNCTION get_max_clm_sol_line_num
4777: (
4778: p_neg_line_num_tbl IN PO_TBL_VARCHAR100
4779: , p_draft_id IN NUMBER := NULL
4780: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
4781: )
4782: RETURN VARCHAR2
4783: IS
4784: x_max_po_line_num VARCHAR2(100) := '0000';

Line 4861: p_req_line_id_tbl IN PO_TBL_NUMBER

4857: --End of Comments
4858: -------------------------------------------------------------------------------
4859: FUNCTION get_consigned_flag_tbl
4860: (
4861: p_req_line_id_tbl IN PO_TBL_NUMBER
4862: , p_builder_org_id IN NUMBER
4863: , p_builder_supplier_id IN NUMBER
4864: , p_builder_site_id IN NUMBER
4865: )

Line 4951: , p_comparison_tbl IN PO_TBL_NUMBER

4947: -------------------------------------------------------------------------------
4948: FUNCTION find_matching_po_line_num
4949: (
4950: p_req_line_id IN NUMBER
4951: , p_comparison_tbl IN PO_TBL_NUMBER
4952: , p_po_line_num_tbl IN PO_TBL_NUMBER
4953: )
4954: RETURN NUMBER
4955: IS

Line 4952: , p_po_line_num_tbl IN PO_TBL_NUMBER

4948: FUNCTION find_matching_po_line_num
4949: (
4950: p_req_line_id IN NUMBER
4951: , p_comparison_tbl IN PO_TBL_NUMBER
4952: , p_po_line_num_tbl IN PO_TBL_NUMBER
4953: )
4954: RETURN NUMBER
4955: IS
4956: d_mod CONSTANT VARCHAR2(100) := D_find_matching_po_line_num;

Line 5014: p_req_group_line_id_tbl IN PO_TBL_NUMBER,

5010: -------------------------------------------------------------------------------
5011:
5012: FUNCTION default_info_slin_numbers (
5013: p_req_line_id IN NUMBER,
5014: p_req_group_line_id_tbl IN PO_TBL_NUMBER,
5015: p_po_line_num_tbl IN PO_TBL_VARCHAR100,
5016: p_po_line_num IN NUMBER,
5017: p_po_header_id IN NUMBER)
5018: RETURN PO_TBL_VARCHAR100

Line 5116: p_po_line_number_tbl IN PO_TBL_NUMBER,

5112: -- requisition lines.
5113: --End of Comments
5114: -------------------------------------------------------------------------------
5115: PROCEDURE check_mod_lock_availability(
5116: p_po_line_number_tbl IN PO_TBL_NUMBER,
5117: p_add_to_po_header_id IN NUMBER,
5118: p_draft_id IN NUMBER, --Autocreate grouping
5119: x_message_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
5120: x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 5201: ( p_po_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER

5197: END check_mod_lock_availability;
5198:
5199:
5200: PROCEDURE get_line_num_disp_for_clin
5201: ( p_po_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
5202: , p_req_line_id_tbl IN PO_TBL_NUMBER
5203: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
5204: , p_draft_id IN NUMBER
5205: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

Line 5202: , p_req_line_id_tbl IN PO_TBL_NUMBER

5198:
5199:
5200: PROCEDURE get_line_num_disp_for_clin
5201: ( p_po_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
5202: , p_req_line_id_tbl IN PO_TBL_NUMBER
5203: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
5204: , p_draft_id IN NUMBER
5205: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
5206: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

Line 5205: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

5201: ( p_po_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
5202: , p_req_line_id_tbl IN PO_TBL_NUMBER
5203: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
5204: , p_draft_id IN NUMBER
5205: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
5206: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
5207: , p_add_to_po_header_id IN NUMBER
5208: , p_start_index IN NUMBER
5209: , p_end_index IN NUMBER

Line 5304: ( p_neg_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER

5300:
5301: END get_line_num_disp_for_clin;
5302:
5303: PROCEDURE get_sol_line_num_disp_for_clin
5304: ( p_neg_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
5305: , p_req_line_id_tbl IN PO_TBL_NUMBER
5306: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
5307: , p_draft_id IN NUMBER
5308: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

Line 5305: , p_req_line_id_tbl IN PO_TBL_NUMBER

5301: END get_line_num_disp_for_clin;
5302:
5303: PROCEDURE get_sol_line_num_disp_for_clin
5304: ( p_neg_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
5305: , p_req_line_id_tbl IN PO_TBL_NUMBER
5306: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
5307: , p_draft_id IN NUMBER
5308: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
5309: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

Line 5308: , p_req_group_line_id_tbl IN PO_TBL_NUMBER

5304: ( p_neg_line_num_tbl IN OUT NOCOPY PO_TBL_NUMBER
5305: , p_req_line_id_tbl IN PO_TBL_NUMBER
5306: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1
5307: , p_draft_id IN NUMBER
5308: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
5309: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
5310: , p_add_to_neg_header_id IN NUMBER
5311: , p_start_index IN NUMBER
5312: , p_end_index IN NUMBER

Line 5410: p_source_line_id_tbl IN PO_TBL_NUMBER

5406: -------------------------------------------------------------------------------
5407:
5408: Procedure RenumberSlins
5409: (
5410: p_source_line_id_tbl IN PO_TBL_NUMBER
5411: , p_source_group_line_id_tbl IN PO_TBL_NUMBER
5412: , p_po_line_num_tbl IN PO_TBL_NUMBER
5413: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
5414: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

Line 5411: , p_source_group_line_id_tbl IN PO_TBL_NUMBER

5407:
5408: Procedure RenumberSlins
5409: (
5410: p_source_line_id_tbl IN PO_TBL_NUMBER
5411: , p_source_group_line_id_tbl IN PO_TBL_NUMBER
5412: , p_po_line_num_tbl IN PO_TBL_NUMBER
5413: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
5414: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
5415: , p_renumber_flag IN PO_TBL_VARCHAR1

Line 5412: , p_po_line_num_tbl IN PO_TBL_NUMBER

5408: Procedure RenumberSlins
5409: (
5410: p_source_line_id_tbl IN PO_TBL_NUMBER
5411: , p_source_group_line_id_tbl IN PO_TBL_NUMBER
5412: , p_po_line_num_tbl IN PO_TBL_NUMBER
5413: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
5414: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1
5415: , p_renumber_flag IN PO_TBL_VARCHAR1
5416: , p_start_index IN NUMBER default null