APPS.MTL_DEFAULT_CATEGORY_SETS_PKG dependencies on DBMS_SQL

Line 366: source_cursor := dbms_sql.open_cursor;

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

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

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

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

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

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

369: ' where category_id is NOT NULL '||
370: ' and rownum < 2';
371: DBMS_SQL.PARSE(source_cursor,l_dyn_sql,1);
372: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, co_Count);
373: ignore := DBMS_SQL.EXECUTE(source_cursor);
374: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
375: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, co_Count);
376: END IF;
377: DBMS_SQL.CLOSE_CURSOR(source_cursor);

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

370: ' and rownum < 2';
371: DBMS_SQL.PARSE(source_cursor,l_dyn_sql,1);
372: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, co_Count);
373: ignore := DBMS_SQL.EXECUTE(source_cursor);
374: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
375: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, co_Count);
376: END IF;
377: DBMS_SQL.CLOSE_CURSOR(source_cursor);
378: END IF;

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

371: DBMS_SQL.PARSE(source_cursor,l_dyn_sql,1);
372: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, co_Count);
373: ignore := DBMS_SQL.EXECUTE(source_cursor);
374: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
375: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, co_Count);
376: END IF;
377: DBMS_SQL.CLOSE_CURSOR(source_cursor);
378: END IF;
379: If (co_Count = 0) then

Line 377: DBMS_SQL.CLOSE_CURSOR(source_cursor);

373: ignore := DBMS_SQL.EXECUTE(source_cursor);
374: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
375: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, co_Count);
376: END IF;
377: DBMS_SQL.CLOSE_CURSOR(source_cursor);
378: END IF;
379: If (co_Count = 0) then
380: Select count(*)
381: Into co_Count