DBA Data[Home] [Help]

APPS.PO_PALT_ASSIGNMENTS dependencies on PO_TBL_NUMBER

Line 232: x_associated_line_ids OUT NOCOPY PO_TBL_NUMBER)

228:
229:
230:
231: PROCEDURE getAssociatedReqLines(pReqLineId IN NUMBER,
232: x_associated_line_ids OUT NOCOPY PO_TBL_NUMBER)
233: IS
234:
235: l_line_ids Dbms_Sql.number_table;
236: l_cnt NUMBER :=0;

Line 264: x_associated_line_ids := PO_TBL_NUMBER();

260: CLOSE C;
261:
262: IF l_line_ids IS NOT NULL AND l_line_ids.Count > 0 THEN
263:
264: x_associated_line_ids := PO_TBL_NUMBER();
265:
266: FOR i IN 1..l_line_ids.Count LOOP
267: l_cnt := l_cnt+1;
268: x_associated_line_ids.extend(1);

Line 286: l_line_ids PO_TBL_NUMBER;

282: IS
283: l_cnt NUMBER;
284: err_ids_cnt NUMBER:=0;
285: l_req_line_ids_str VARCHAR2(1000):='';
286: l_line_ids PO_TBL_NUMBER;
287: l_query VARCHAR2(2000);
288: l_par_query VARCHAR2(3000);
289: BEGIN
290: