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.INV_ITEM_PVT dependencies on DBMS_SQL

Line 3119: l_cursor := DBMS_SQL.OPEN_CURSOR;

3115: END IF;
3116:
3117: l_sql_stmt := l_sql_stmt || ' ORDER BY MSI.CREATION_DATE ';
3118:
3119: l_cursor := DBMS_SQL.OPEN_CURSOR;
3120:
3121: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
3122: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, P_Item_Id);
3123: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, P_Item_Catalog_Group_Id);

Line 3121: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );

3117: l_sql_stmt := l_sql_stmt || ' ORDER BY MSI.CREATION_DATE ';
3118:
3119: l_cursor := DBMS_SQL.OPEN_CURSOR;
3120:
3121: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
3122: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, P_Item_Id);
3123: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, P_Item_Catalog_Group_Id);
3124: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, P_unit_of_measure,25);
3125: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, P_Description,240);

Line 3122: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, P_Item_Id);

3118:
3119: l_cursor := DBMS_SQL.OPEN_CURSOR;
3120:
3121: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
3122: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, P_Item_Id);
3123: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, P_Item_Catalog_Group_Id);
3124: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, P_unit_of_measure,25);
3125: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, P_Description,240);
3126:

Line 3123: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, P_Item_Catalog_Group_Id);

3119: l_cursor := DBMS_SQL.OPEN_CURSOR;
3120:
3121: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
3122: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, P_Item_Id);
3123: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, P_Item_Catalog_Group_Id);
3124: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, P_unit_of_measure,25);
3125: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, P_Description,240);
3126:
3127: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);

Line 3124: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, P_unit_of_measure,25);

3120:
3121: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
3122: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, P_Item_Id);
3123: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, P_Item_Catalog_Group_Id);
3124: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, P_unit_of_measure,25);
3125: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, P_Description,240);
3126:
3127: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);
3128:

Line 3125: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, P_Description,240);

3121: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
3122: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, P_Item_Id);
3123: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, P_Item_Catalog_Group_Id);
3124: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, P_unit_of_measure,25);
3125: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, P_Description,240);
3126:
3127: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);
3128:
3129: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN

Line 3127: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);

3123: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, P_Item_Catalog_Group_Id);
3124: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, P_unit_of_measure,25);
3125: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, P_Description,240);
3126:
3127: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);
3128:
3129: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN
3130: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, P_Item_Id);
3131: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, P_Item_Catalog_Group_Id);

Line 3129: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN

3125: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, P_Description,240);
3126:
3127: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);
3128:
3129: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN
3130: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, P_Item_Id);
3131: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, P_Item_Catalog_Group_Id);
3132: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, P_unit_of_measure);
3133: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, P_Description);

Line 3130: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, P_Item_Id);

3126:
3127: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);
3128:
3129: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN
3130: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, P_Item_Id);
3131: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, P_Item_Catalog_Group_Id);
3132: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, P_unit_of_measure);
3133: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, P_Description);
3134: ELSE

Line 3131: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, P_Item_Catalog_Group_Id);

3127: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);
3128:
3129: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN
3130: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, P_Item_Id);
3131: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, P_Item_Catalog_Group_Id);
3132: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, P_unit_of_measure);
3133: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, P_Description);
3134: ELSE
3135: P_Item_Id := NULL;

Line 3132: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, P_unit_of_measure);

3128:
3129: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN
3130: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, P_Item_Id);
3131: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, P_Item_Catalog_Group_Id);
3132: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, P_unit_of_measure);
3133: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, P_Description);
3134: ELSE
3135: P_Item_Id := NULL;
3136: P_Description := NULL;

Line 3133: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, P_Description);

3129: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN
3130: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, P_Item_Id);
3131: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, P_Item_Catalog_Group_Id);
3132: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, P_unit_of_measure);
3133: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, P_Description);
3134: ELSE
3135: P_Item_Id := NULL;
3136: P_Description := NULL;
3137: P_unit_of_measure := NULL;

Line 3141: DBMS_SQL.CLOSE_CURSOR(l_cursor);

3137: P_unit_of_measure := NULL;
3138: P_Item_Catalog_Group_Id := NULL;
3139: END IF;
3140:
3141: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3142:
3143: EXCEPTION
3144: WHEN OTHERS THEN
3145: IF DBMS_SQL.IS_OPEN(l_cursor) THEN

Line 3145: IF DBMS_SQL.IS_OPEN(l_cursor) THEN

3141: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3142:
3143: EXCEPTION
3144: WHEN OTHERS THEN
3145: IF DBMS_SQL.IS_OPEN(l_cursor) THEN
3146: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3147: END IF;
3148: RAISE;
3149: END Check_Item_Number;

Line 3146: DBMS_SQL.CLOSE_CURSOR(l_cursor);

3142:
3143: EXCEPTION
3144: WHEN OTHERS THEN
3145: IF DBMS_SQL.IS_OPEN(l_cursor) THEN
3146: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3147: END IF;
3148: RAISE;
3149: END Check_Item_Number;
3150: