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_VARCHAR1

Line 149: ( p_req_line_num_tbl IN PO_TBL_VARCHAR100

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
151: , p_start_index IN NUMBER
152: , p_end_index IN NUMBER
153: ) RETURN PO_TBL_VARCHAR100;

Line 150: , p_po_line_num_tbl IN PO_TBL_VARCHAR100

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
151: , p_start_index IN NUMBER
152: , p_end_index IN NUMBER
153: ) RETURN PO_TBL_VARCHAR100;
154:

Line 153: ) RETURN PO_TBL_VARCHAR100;

149: ( p_req_line_num_tbl IN PO_TBL_VARCHAR100
150: , p_po_line_num_tbl IN PO_TBL_VARCHAR100
151: , p_start_index IN 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

Line 163: ( p_po_line_num_tbl IN PO_TBL_VARCHAR100

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

Line 166: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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
170: , p_end_index IN NUMBER

Line 171: ) RETURN PO_TBL_VARCHAR100;

167: , p_add_to_po_header_id IN NUMBER
168: , p_draft_id IN NUMBER --Autocreate grouping
169: , p_start_index IN NUMBER
170: , p_end_index IN NUMBER
171: ) RETURN PO_TBL_VARCHAR100;
172:
173:
174: FUNCTION group_by_default
175: ( p_req_line_id_tbl IN PO_TBL_NUMBER

Line 177: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1

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
181: , p_end_index IN NUMBER

Line 190: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1

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
194: , p_start_index IN NUMBER

Line 202: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1

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
206: , p_start_index IN NUMBER

Line 210: , x_po_line_num_disp_tbl OUT NOCOPY PO_TBL_VARCHAR100

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
214: ( p_current_index IN NUMBER

Line 227: ( p_po_line_num_tbl IN PO_TBL_VARCHAR100

223: , p_req_line_id_2 IN NUMBER
224: ) RETURN BOOLEAN;
225:
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;

Line 234: ( p_neg_line_num_tbl IN PO_TBL_VARCHAR100

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
235: , p_draft_id IN NUMBER := NULL
236: , p_req_group_line_id_tbl IN PO_TBL_NUMBER
237: ) RETURN VARCHAR2;
238:

Line 244: ) RETURN PO_TBL_VARCHAR1;

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;
245:
246: FUNCTION find_matching_po_line_num
247: ( p_req_line_id IN NUMBER
248: , p_comparison_tbl IN PO_TBL_NUMBER

Line 260: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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
264: )

Line 261: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1

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
264: )
265: RETURN NUMBER;

Line 271: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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
275: , p_add_to_po_header_id IN NUMBER

Line 272: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1

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
275: , p_add_to_po_header_id IN NUMBER
276: , p_draft_id IN NUMBER --Autocreate grouping

Line 273: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

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
275: , p_add_to_po_header_id IN NUMBER
276: , p_draft_id IN NUMBER --Autocreate grouping
277: , p_builder_agreement_id IN NUMBER

Line 274: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1

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
275: , p_add_to_po_header_id IN NUMBER
276: , p_draft_id IN NUMBER --Autocreate grouping
277: , p_builder_agreement_id IN NUMBER
278: , p_start_index IN NUMBER

Line 287: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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
291: , p_add_to_neg_header_id IN NUMBER

Line 288: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1

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
291: , p_add_to_neg_header_id IN NUMBER
292: , p_draft_id IN NUMBER --Autocreate grouping

Line 289: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

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
291: , p_add_to_neg_header_id IN NUMBER
292: , p_draft_id IN NUMBER --Autocreate grouping
293: , p_builder_agreement_id IN NUMBER

Line 290: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1

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
291: , p_add_to_neg_header_id IN NUMBER
292: , p_draft_id IN NUMBER --Autocreate grouping
293: , p_builder_agreement_id IN NUMBER
294: , p_start_index IN NUMBER

Line 468: l_line_combined_flag_tbl PO_TBL_VARCHAR1;

464: l_progress_payment_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
465: l_message_code VARCHAR2(30) := NULL;
466: l_token_name VARCHAR2(30) := NULL;
467: l_token_value VARCHAR2(2000) := NULL;
468: l_line_combined_flag_tbl PO_TBL_VARCHAR1;
469: l_line_combined_flag VARCHAR2(1);
470:
471: CURSOR req_line_ids_csr(
472: c_key IN NUMBER,

Line 505: l_line_combined_flag_tbl := PO_TBL_VARCHAR1();

501: x_token_value_tbl := PO_TBL_VARCHAR2000();
502: x_token_value_tbl.EXTEND(l_num_lines);
503:
504: -- Initialize table of flags indicating whether lines are combined.
505: l_line_combined_flag_tbl := PO_TBL_VARCHAR1();
506: l_line_combined_flag_tbl.EXTEND(l_num_lines);
507:
508: -- Get a new session key for use with the temp table.
509: l_key := PO_CORE_S.get_session_gt_nextval;

Line 1178: l_consigned_flag_tbl PO_TBL_VARCHAR1;

1174: IS
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;

Line 1346: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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
1350: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

Line 1347: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1

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
1350: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
1351: , p_add_to_po_header_id IN NUMBER

Line 1348: , p_req_line_num_tbl IN PO_TBL_VARCHAR100

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

Line 1350: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

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
1354: , p_builder_supplier_id IN NUMBER

Line 1365: l_consigned_flag_tbl PO_TBL_VARCHAR1;

1361: IS
1362: l_start_index NUMBER;
1363: l_end_index NUMBER;
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:

Line 1366: l_po_line_num_disp_tbl PO_TBL_VARCHAR100 := p_po_line_num_disp_tbl;

1362: l_start_index NUMBER;
1363: l_end_index NUMBER;
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 ;

Line 1367: x_po_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();

1363: l_end_index NUMBER;
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;

Line 1374: l_renumber_flag PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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

Line 1628: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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
1632: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

Line 1629: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1

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
1632: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
1633: , p_add_to_neg_header_id IN NUMBER

Line 1630: , p_req_line_num_tbl IN PO_TBL_VARCHAR100

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

Line 1632: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

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
1636: , p_builder_supplier_id IN NUMBER

Line 1647: l_consigned_flag_tbl PO_TBL_VARCHAR1;

1643: IS
1644: l_start_index NUMBER;
1645: l_end_index NUMBER;
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:

Line 1648: l_po_line_num_disp_tbl PO_TBL_VARCHAR100 := p_neg_line_num_disp_tbl;

1644: l_start_index NUMBER;
1645: l_end_index NUMBER;
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 ;

Line 1649: x_po_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();

1645: l_end_index NUMBER;
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;

Line 1656: l_renumber_flag PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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

Line 1835: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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
1839: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

Line 1836: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1

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
1839: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
1840: , p_add_to_neg_header_id IN NUMBER

Line 1837: , p_req_line_num_tbl IN PO_TBL_VARCHAR100

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

Line 1839: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

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
1843: , p_builder_supplier_id IN NUMBER

Line 1854: l_consigned_flag_tbl PO_TBL_VARCHAR1;

1850: IS
1851: l_start_index NUMBER;
1852: l_end_index NUMBER;
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:

Line 1855: l_po_line_num_disp_tbl PO_TBL_VARCHAR100 := p_neg_line_num_disp_tbl;

1851: l_start_index NUMBER;
1852: l_end_index NUMBER;
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 ;

Line 1856: x_po_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();

1852: l_end_index NUMBER;
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;

Line 1863: l_renumber_flag PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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

Line 1983: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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
1987: , p_add_to_po_header_id IN NUMBER

Line 1984: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1

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
1987: , p_add_to_po_header_id IN NUMBER
1988: , p_draft_id IN NUMBER --Autocreate grouping

Line 1985: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

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
1987: , p_add_to_po_header_id IN NUMBER
1988: , p_draft_id IN NUMBER --Autocreate grouping
1989: , p_builder_agreement_id IN NUMBER

Line 1986: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1

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
1987: , p_add_to_po_header_id IN NUMBER
1988: , p_draft_id IN NUMBER --Autocreate grouping
1989: , p_builder_agreement_id IN NUMBER
1990: , p_start_index IN NUMBER

Line 2003: l_max_slin_num_disp_tbl PO_TBL_VARCHAR100;

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;
2007: l_po_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();

Line 2007: l_po_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();

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;
2007: l_po_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
2008: l_index NUMBER := 1;
2009:
2010: BEGIN
2011:

Line 2181: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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
2185: , p_add_to_neg_header_id IN NUMBER

Line 2182: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1

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
2185: , p_add_to_neg_header_id IN NUMBER
2186: , p_draft_id IN NUMBER --Autocreate grouping

Line 2183: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

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
2185: , p_add_to_neg_header_id IN NUMBER
2186: , p_draft_id IN NUMBER --Autocreate grouping
2187: , p_builder_agreement_id IN NUMBER

Line 2184: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1

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
2185: , p_add_to_neg_header_id IN NUMBER
2186: , p_draft_id IN NUMBER --Autocreate grouping
2187: , p_builder_agreement_id IN NUMBER
2188: , p_start_index IN NUMBER

Line 2201: l_max_slin_num_disp_tbl PO_TBL_VARCHAR100;

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;
2205: l_neg_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();

Line 2205: l_neg_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();

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;
2205: l_neg_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
2206: l_index NUMBER := 1;
2207:
2208: BEGIN
2209:

Line 2299: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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
2303: )

Line 2300: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1

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
2303: )
2304: RETURN NUMBER

Line 3567: p_req_line_num_tbl IN PO_TBL_VARCHAR100

3563: --End of Comments
3564: -------------------------------------------------------------------------------
3565: FUNCTION group_by_clm_req_line_num
3566: (
3567: p_req_line_num_tbl IN PO_TBL_VARCHAR100
3568: , p_po_line_num_tbl IN PO_TBL_VARCHAR100
3569: , p_start_index IN NUMBER
3570: , p_end_index IN NUMBER
3571: )

Line 3568: , p_po_line_num_tbl IN PO_TBL_VARCHAR100

3564: -------------------------------------------------------------------------------
3565: FUNCTION group_by_clm_req_line_num
3566: (
3567: p_req_line_num_tbl IN PO_TBL_VARCHAR100
3568: , p_po_line_num_tbl IN PO_TBL_VARCHAR100
3569: , p_start_index IN NUMBER
3570: , p_end_index IN NUMBER
3571: )
3572: RETURN PO_TBL_VARCHAR100

Line 3572: RETURN PO_TBL_VARCHAR100

3568: , p_po_line_num_tbl IN PO_TBL_VARCHAR100
3569: , p_start_index IN NUMBER
3570: , p_end_index IN NUMBER
3571: )
3572: RETURN PO_TBL_VARCHAR100
3573: IS
3574: x_po_line_num_tbl PO_TBL_VARCHAR100 := p_po_line_num_tbl;
3575:
3576: TYPE NUM_INDEX_TBL_TYPE IS TABLE OF VARCHAR2(1) INDEX BY VARCHAR2(100);

Line 3574: x_po_line_num_tbl PO_TBL_VARCHAR100 := p_po_line_num_tbl;

3570: , p_end_index IN NUMBER
3571: )
3572: RETURN PO_TBL_VARCHAR100
3573: IS
3574: x_po_line_num_tbl PO_TBL_VARCHAR100 := p_po_line_num_tbl;
3575:
3576: TYPE NUM_INDEX_TBL_TYPE IS TABLE OF VARCHAR2(1) INDEX BY VARCHAR2(100);
3577: l_line_num_used_tbl NUM_INDEX_TBL_TYPE;
3578:

Line 3753: ( p_po_line_num_tbl IN PO_TBL_VARCHAR100

3749: -- N/A
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

Line 3756: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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
3760: , p_end_index IN NUMBER

Line 3761: ) RETURN PO_TBL_VARCHAR100

3757: , p_add_to_po_header_id IN NUMBER
3758: , p_draft_id IN NUMBER --Autocreate grouping
3759: , p_start_index IN NUMBER
3760: , p_end_index IN NUMBER
3761: ) RETURN PO_TBL_VARCHAR100
3762: IS
3763: x_po_line_num_tbl PO_TBL_VARCHAR100 := p_po_line_num_tbl;
3764:
3765: l_max_line_num VARCHAR2(100);

Line 3763: x_po_line_num_tbl PO_TBL_VARCHAR100 := p_po_line_num_tbl;

3759: , p_start_index IN NUMBER
3760: , p_end_index IN NUMBER
3761: ) RETURN PO_TBL_VARCHAR100
3762: IS
3763: x_po_line_num_tbl PO_TBL_VARCHAR100 := p_po_line_num_tbl;
3764:
3765: l_max_line_num VARCHAR2(100);
3766: l_next_line_num VARCHAR2(100);
3767:

Line 3888: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1

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
3892: , p_end_index IN NUMBER

Line 4131: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1

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
4135: , p_start_index IN NUMBER

Line 4276: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1

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
4280: , p_start_index IN NUMBER

Line 4284: , x_po_line_num_disp_tbl OUT NOCOPY PO_TBL_VARCHAR100

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;
4288: l_po_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();

Line 4288: l_po_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();

4284: , x_po_line_num_disp_tbl OUT NOCOPY PO_TBL_VARCHAR100
4285: )
4286: IS
4287: l_key NUMBER;
4288: l_po_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
4289:
4290: l_need_by_grouping_profile
4291: FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
4292: l_ship_to_grouping_profile

Line 4309: x_po_line_num_disp_tbl := PO_TBL_VARCHAR100();

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:
4313: d_position := 10;

Line 4690: p_po_line_num_tbl IN PO_TBL_VARCHAR100

4686: --End of Comments
4687: -------------------------------------------------------------------------------
4688: FUNCTION get_max_clm_po_line_num
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: )

Line 4778: p_neg_line_num_tbl IN PO_TBL_VARCHAR100

4774: --End of Comments
4775: -------------------------------------------------------------------------------
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

Line 4866: RETURN PO_TBL_VARCHAR1

4862: , p_builder_org_id IN NUMBER
4863: , p_builder_supplier_id IN NUMBER
4864: , p_builder_site_id IN NUMBER
4865: )
4866: RETURN PO_TBL_VARCHAR1
4867: IS
4868: l_item_id NUMBER;
4869: x_consigned_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
4870:

Line 4869: x_consigned_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

4865: )
4866: RETURN PO_TBL_VARCHAR1
4867: IS
4868: l_item_id NUMBER;
4869: x_consigned_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
4870:
4871: d_mod CONSTANT VARCHAR2(100) := D_get_consigned_flag_tbl;
4872: d_position NUMBER := 0;
4873:

Line 5015: p_po_line_num_tbl IN PO_TBL_VARCHAR100,

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
5019: IS

Line 5018: RETURN PO_TBL_VARCHAR100

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
5019: IS
5020: l_is_info_fund_req_line VARCHAR2(1) := 'N';
5021: l_is_option_line VARCHAR2(1) :='N';
5022: l_max_slin_num VARCHAR2(10) := NULL;

Line 5023: l_po_line_num_tbl PO_TBL_VARCHAR100 := p_po_line_num_tbl;

5019: IS
5020: l_is_info_fund_req_line VARCHAR2(1) := 'N';
5021: l_is_option_line VARCHAR2(1) :='N';
5022: l_max_slin_num VARCHAR2(10) := NULL;
5023: l_po_line_num_tbl PO_TBL_VARCHAR100 := p_po_line_num_tbl;
5024: l_current_slin VARCHAR2(10) := NULL;
5025: l_po_line_id NUMBER;
5026: d_mod CONSTANT VARCHAR2(100) := D_default_info_slin_numbers;
5027: d_position NUMBER := 0;

Line 5203: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1

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
5207: , p_add_to_po_header_id IN NUMBER

Line 5206: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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
5210: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

Line 5210: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

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
5210: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
5211: )IS
5212:
5213: d_position NUMBER := 0;
5214: d_mod CONSTANT VARCHAR2(100) := D_get_line_num_disp_for_clin;

Line 5306: , p_req_option_flag_tbl IN PO_TBL_VARCHAR1

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
5310: , p_add_to_neg_header_id IN NUMBER

Line 5309: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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
5313: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

Line 5313: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

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
5313: , p_neg_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100
5314: )IS
5315:
5316: d_position NUMBER := 0;
5317: d_mod CONSTANT VARCHAR2(100) := D_get_line_num_disp_for_clin;

Line 5413: , p_po_line_num_disp_tbl IN OUT NOCOPY PO_TBL_VARCHAR100

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
5417: , p_end_index IN NUMBER default null

Line 5414: , p_req_clm_info_flag_tbl IN PO_TBL_VARCHAR1

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
5417: , p_end_index IN NUMBER default null
5418: , p_add_to_po_header_id IN NUMBER default null

Line 5415: , p_renumber_flag IN PO_TBL_VARCHAR1

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
5417: , p_end_index IN NUMBER default null
5418: , p_add_to_po_header_id IN NUMBER default null
5419: , p_draft_id IN NUMBER default NULL

Line 5433: l_renumber_flag PO_TBL_VARCHAR1 := p_renumber_flag;

5429: l_action_tbl PO_TBL_VARCHAR5 := PO_TBL_VARCHAR5();
5430: l_next_slin_num VARCHAR2(100);
5431: l_next_info_slin_num VARCHAR2(100);
5432: l_next_priced_slin_num VARCHAR2(100);
5433: l_renumber_flag PO_TBL_VARCHAR1 := p_renumber_flag;
5434:
5435: BEGIN
5436:
5437: If p_start_index is null then