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 3380: l_cursor := DBMS_SQL.OPEN_CURSOR;

3376: END IF;
3377:
3378: l_sql_stmt := l_sql_stmt || ' ORDER BY MSI.CREATION_DATE ';
3379:
3380: l_cursor := DBMS_SQL.OPEN_CURSOR;
3381:
3382: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
3383: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, P_Item_Id);
3384: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, P_Item_Catalog_Group_Id);

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

3378: l_sql_stmt := l_sql_stmt || ' ORDER BY MSI.CREATION_DATE ';
3379:
3380: l_cursor := DBMS_SQL.OPEN_CURSOR;
3381:
3382: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
3383: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, P_Item_Id);
3384: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, P_Item_Catalog_Group_Id);
3385: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, P_unit_of_measure,25);
3386: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, P_Description,240);

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

3379:
3380: l_cursor := DBMS_SQL.OPEN_CURSOR;
3381:
3382: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
3383: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, P_Item_Id);
3384: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, P_Item_Catalog_Group_Id);
3385: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, P_unit_of_measure,25);
3386: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, P_Description,240);
3387:

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

3380: l_cursor := DBMS_SQL.OPEN_CURSOR;
3381:
3382: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
3383: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, P_Item_Id);
3384: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, P_Item_Catalog_Group_Id);
3385: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, P_unit_of_measure,25);
3386: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, P_Description,240);
3387:
3388: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);

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

3381:
3382: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
3383: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, P_Item_Id);
3384: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, P_Item_Catalog_Group_Id);
3385: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, P_unit_of_measure,25);
3386: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, P_Description,240);
3387:
3388: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);
3389:

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

3382: DBMS_SQL.PARSE( l_cursor, l_sql_stmt , DBMS_SQL.NATIVE );
3383: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, P_Item_Id);
3384: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, P_Item_Catalog_Group_Id);
3385: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, P_unit_of_measure,25);
3386: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, P_Description,240);
3387:
3388: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);
3389:
3390: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN

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

3384: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, P_Item_Catalog_Group_Id);
3385: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, P_unit_of_measure,25);
3386: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, P_Description,240);
3387:
3388: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);
3389:
3390: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN
3391: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, P_Item_Id);
3392: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, P_Item_Catalog_Group_Id);

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

3386: DBMS_SQL.DEFINE_COLUMN(l_cursor, 4, P_Description,240);
3387:
3388: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);
3389:
3390: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN
3391: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, P_Item_Id);
3392: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, P_Item_Catalog_Group_Id);
3393: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, P_unit_of_measure);
3394: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, P_Description);

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

3387:
3388: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);
3389:
3390: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN
3391: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, P_Item_Id);
3392: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, P_Item_Catalog_Group_Id);
3393: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, P_unit_of_measure);
3394: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, P_Description);
3395: ELSE

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

3388: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor);
3389:
3390: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN
3391: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, P_Item_Id);
3392: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, P_Item_Catalog_Group_Id);
3393: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, P_unit_of_measure);
3394: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, P_Description);
3395: ELSE
3396: P_Item_Id := NULL;

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

3389:
3390: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN
3391: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, P_Item_Id);
3392: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, P_Item_Catalog_Group_Id);
3393: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, P_unit_of_measure);
3394: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, P_Description);
3395: ELSE
3396: P_Item_Id := NULL;
3397: P_Description := NULL;

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

3390: IF ( DBMS_SQL.FETCH_ROWS(l_cursor) > 0 ) THEN
3391: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, P_Item_Id);
3392: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, P_Item_Catalog_Group_Id);
3393: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, P_unit_of_measure);
3394: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, P_Description);
3395: ELSE
3396: P_Item_Id := NULL;
3397: P_Description := NULL;
3398: P_unit_of_measure := NULL;

Line 3402: DBMS_SQL.CLOSE_CURSOR(l_cursor);

3398: P_unit_of_measure := NULL;
3399: P_Item_Catalog_Group_Id := NULL;
3400: END IF;
3401:
3402: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3403:
3404: EXCEPTION
3405: WHEN OTHERS THEN
3406: IF DBMS_SQL.IS_OPEN(l_cursor) THEN

Line 3406: IF DBMS_SQL.IS_OPEN(l_cursor) THEN

3402: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3403:
3404: EXCEPTION
3405: WHEN OTHERS THEN
3406: IF DBMS_SQL.IS_OPEN(l_cursor) THEN
3407: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3408: END IF;
3409: RAISE;
3410: END Check_Item_Number;

Line 3407: DBMS_SQL.CLOSE_CURSOR(l_cursor);

3403:
3404: EXCEPTION
3405: WHEN OTHERS THEN
3406: IF DBMS_SQL.IS_OPEN(l_cursor) THEN
3407: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3408: END IF;
3409: RAISE;
3410: END Check_Item_Number;
3411: