APPS.JTF_IH_WRAP_UPS_SEED_PUB dependencies on DBMS_SQL

Line 486: n_Cursor := dbms_sql.open_cursor;

482: END IF;
483: l_Sql := l_Sql || 'ORDER BY wrap_id';
484: --dbms_output.put_line(l_Sql);
485: BEGIN
486: n_Cursor := dbms_sql.open_cursor;
487: dbms_sql.parse(n_Cursor, l_Sql, dbms_sql.native);
488: FOR i IN 1..v_Params.count LOOP
489: dbms_sql.bind_variable(n_Cursor,v_Params(i).name,v_Params(i).value);
490: END LOOP;

Line 487: dbms_sql.parse(n_Cursor, l_Sql, dbms_sql.native);

483: l_Sql := l_Sql || 'ORDER BY wrap_id';
484: --dbms_output.put_line(l_Sql);
485: BEGIN
486: n_Cursor := dbms_sql.open_cursor;
487: dbms_sql.parse(n_Cursor, l_Sql, dbms_sql.native);
488: FOR i IN 1..v_Params.count LOOP
489: dbms_sql.bind_variable(n_Cursor,v_Params(i).name,v_Params(i).value);
490: END LOOP;
491: dbms_sql.define_column(n_Cursor,1,n_Wrap_Id);

Line 489: dbms_sql.bind_variable(n_Cursor,v_Params(i).name,v_Params(i).value);

485: BEGIN
486: n_Cursor := dbms_sql.open_cursor;
487: dbms_sql.parse(n_Cursor, l_Sql, dbms_sql.native);
488: FOR i IN 1..v_Params.count LOOP
489: dbms_sql.bind_variable(n_Cursor,v_Params(i).name,v_Params(i).value);
490: END LOOP;
491: dbms_sql.define_column(n_Cursor,1,n_Wrap_Id);
492: n_Res := dbms_sql.execute(n_Cursor);
493: LOOP

Line 491: dbms_sql.define_column(n_Cursor,1,n_Wrap_Id);

487: dbms_sql.parse(n_Cursor, l_Sql, dbms_sql.native);
488: FOR i IN 1..v_Params.count LOOP
489: dbms_sql.bind_variable(n_Cursor,v_Params(i).name,v_Params(i).value);
490: END LOOP;
491: dbms_sql.define_column(n_Cursor,1,n_Wrap_Id);
492: n_Res := dbms_sql.execute(n_Cursor);
493: LOOP
494: IF dbms_sql.fetch_rows(n_Cursor) = 0 THEN
495: EXIT;

Line 492: n_Res := dbms_sql.execute(n_Cursor);

488: FOR i IN 1..v_Params.count LOOP
489: dbms_sql.bind_variable(n_Cursor,v_Params(i).name,v_Params(i).value);
490: END LOOP;
491: dbms_sql.define_column(n_Cursor,1,n_Wrap_Id);
492: n_Res := dbms_sql.execute(n_Cursor);
493: LOOP
494: IF dbms_sql.fetch_rows(n_Cursor) = 0 THEN
495: EXIT;
496: END IF;

Line 494: IF dbms_sql.fetch_rows(n_Cursor) = 0 THEN

490: END LOOP;
491: dbms_sql.define_column(n_Cursor,1,n_Wrap_Id);
492: n_Res := dbms_sql.execute(n_Cursor);
493: LOOP
494: IF dbms_sql.fetch_rows(n_Cursor) = 0 THEN
495: EXIT;
496: END IF;
497: dbms_sql.column_value(n_Cursor,1,n_Wrap_Id);
498: END LOOP;

Line 497: dbms_sql.column_value(n_Cursor,1,n_Wrap_Id);

493: LOOP
494: IF dbms_sql.fetch_rows(n_Cursor) = 0 THEN
495: EXIT;
496: END IF;
497: dbms_sql.column_value(n_Cursor,1,n_Wrap_Id);
498: END LOOP;
499: END;
500: --dbms_output.put_line('Pass l_wrap_id = '||l_wrap_id);
501: --dbms_output.put_line('Get n_Wrap_Id = '||n_Wrap_Id);