APPS.MTL_DEFAULT_CATEGORY_SETS_PKG dependencies on DBMS_SQL

Line 371: source_cursor := dbms_sql.open_cursor;

367:
368: IF INV_ITEM_UTIL.Object_Exists(p_object_type => 'SYNONYM'
369: ,p_object_name => 'CST_MATERIAL_OVHD_RULES') ='Y'
370: THEN
371: source_cursor := dbms_sql.open_cursor;
372: l_dyn_sql := ' Select count(*) '||
373: ' From CST_MATERIAL_OVHD_RULES '||
374: ' where category_id is NOT NULL '||
375: ' and rownum < 2';

Line 376: DBMS_SQL.PARSE(source_cursor,l_dyn_sql,1);

372: l_dyn_sql := ' Select count(*) '||
373: ' From CST_MATERIAL_OVHD_RULES '||
374: ' where category_id is NOT NULL '||
375: ' and rownum < 2';
376: DBMS_SQL.PARSE(source_cursor,l_dyn_sql,1);
377: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, co_Count);
378: ignore := DBMS_SQL.EXECUTE(source_cursor);
379: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
380: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, co_Count);

Line 377: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, co_Count);

373: ' From CST_MATERIAL_OVHD_RULES '||
374: ' where category_id is NOT NULL '||
375: ' and rownum < 2';
376: DBMS_SQL.PARSE(source_cursor,l_dyn_sql,1);
377: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, co_Count);
378: ignore := DBMS_SQL.EXECUTE(source_cursor);
379: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
380: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, co_Count);
381: END IF;

Line 378: ignore := DBMS_SQL.EXECUTE(source_cursor);

374: ' where category_id is NOT NULL '||
375: ' and rownum < 2';
376: DBMS_SQL.PARSE(source_cursor,l_dyn_sql,1);
377: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, co_Count);
378: ignore := DBMS_SQL.EXECUTE(source_cursor);
379: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
380: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, co_Count);
381: END IF;
382: DBMS_SQL.CLOSE_CURSOR(source_cursor);

Line 379: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN

375: ' and rownum < 2';
376: DBMS_SQL.PARSE(source_cursor,l_dyn_sql,1);
377: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, co_Count);
378: ignore := DBMS_SQL.EXECUTE(source_cursor);
379: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
380: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, co_Count);
381: END IF;
382: DBMS_SQL.CLOSE_CURSOR(source_cursor);
383: END IF;

Line 380: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, co_Count);

376: DBMS_SQL.PARSE(source_cursor,l_dyn_sql,1);
377: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, co_Count);
378: ignore := DBMS_SQL.EXECUTE(source_cursor);
379: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
380: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, co_Count);
381: END IF;
382: DBMS_SQL.CLOSE_CURSOR(source_cursor);
383: END IF;
384: If (co_Count = 0) then

Line 382: DBMS_SQL.CLOSE_CURSOR(source_cursor);

378: ignore := DBMS_SQL.EXECUTE(source_cursor);
379: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
380: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, co_Count);
381: END IF;
382: DBMS_SQL.CLOSE_CURSOR(source_cursor);
383: END IF;
384: If (co_Count = 0) then
385: Select count(*)
386: Into co_Count