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

Line 1309: DSQL_c := dbms_sql.open_cursor;

1305: mtl_system_items_interface msii
1306: where msii.rowid = :row_id_bind
1307: AND msi.organization_id = msii.organization_id
1308: and ' || statement_temp;
1309: DSQL_c := dbms_sql.open_cursor;
1310: dbms_sql.parse(DSQL_c, DSQL_statement, dbms_sql.native);
1311: dbms_sql.define_column(DSQL_c,1,DSQL_inventory_item_id);
1312: dbms_sql.bind_variable(DSQL_c, 'row_id_bind', row_id);
1313: DSQL_rows_processed := dbms_sql.execute(DSQL_c);

Line 1310: dbms_sql.parse(DSQL_c, DSQL_statement, dbms_sql.native);

1306: where msii.rowid = :row_id_bind
1307: AND msi.organization_id = msii.organization_id
1308: and ' || statement_temp;
1309: DSQL_c := dbms_sql.open_cursor;
1310: dbms_sql.parse(DSQL_c, DSQL_statement, dbms_sql.native);
1311: dbms_sql.define_column(DSQL_c,1,DSQL_inventory_item_id);
1312: dbms_sql.bind_variable(DSQL_c, 'row_id_bind', row_id);
1313: DSQL_rows_processed := dbms_sql.execute(DSQL_c);
1314: --

Line 1311: dbms_sql.define_column(DSQL_c,1,DSQL_inventory_item_id);

1307: AND msi.organization_id = msii.organization_id
1308: and ' || statement_temp;
1309: DSQL_c := dbms_sql.open_cursor;
1310: dbms_sql.parse(DSQL_c, DSQL_statement, dbms_sql.native);
1311: dbms_sql.define_column(DSQL_c,1,DSQL_inventory_item_id);
1312: dbms_sql.bind_variable(DSQL_c, 'row_id_bind', row_id);
1313: DSQL_rows_processed := dbms_sql.execute(DSQL_c);
1314: --
1315: if dbms_sql.fetch_rows(DSQL_c) > 0 then -- {

Line 1312: dbms_sql.bind_variable(DSQL_c, 'row_id_bind', row_id);

1308: and ' || statement_temp;
1309: DSQL_c := dbms_sql.open_cursor;
1310: dbms_sql.parse(DSQL_c, DSQL_statement, dbms_sql.native);
1311: dbms_sql.define_column(DSQL_c,1,DSQL_inventory_item_id);
1312: dbms_sql.bind_variable(DSQL_c, 'row_id_bind', row_id);
1313: DSQL_rows_processed := dbms_sql.execute(DSQL_c);
1314: --
1315: if dbms_sql.fetch_rows(DSQL_c) > 0 then -- {
1316: dbms_sql.column_value(DSQL_c,1,DSQL_inventory_item_id);

Line 1313: DSQL_rows_processed := dbms_sql.execute(DSQL_c);

1309: DSQL_c := dbms_sql.open_cursor;
1310: dbms_sql.parse(DSQL_c, DSQL_statement, dbms_sql.native);
1311: dbms_sql.define_column(DSQL_c,1,DSQL_inventory_item_id);
1312: dbms_sql.bind_variable(DSQL_c, 'row_id_bind', row_id);
1313: DSQL_rows_processed := dbms_sql.execute(DSQL_c);
1314: --
1315: if dbms_sql.fetch_rows(DSQL_c) > 0 then -- {
1316: dbms_sql.column_value(DSQL_c,1,DSQL_inventory_item_id);
1317: --

Line 1315: if dbms_sql.fetch_rows(DSQL_c) > 0 then -- {

1311: dbms_sql.define_column(DSQL_c,1,DSQL_inventory_item_id);
1312: dbms_sql.bind_variable(DSQL_c, 'row_id_bind', row_id);
1313: DSQL_rows_processed := dbms_sql.execute(DSQL_c);
1314: --
1315: if dbms_sql.fetch_rows(DSQL_c) > 0 then -- {
1316: dbms_sql.column_value(DSQL_c,1,DSQL_inventory_item_id);
1317: --
1318: update MTL_SYSTEM_ITEMS_INTERFACE
1319: set inventory_item_id = DSQL_inventory_item_id

Line 1316: dbms_sql.column_value(DSQL_c,1,DSQL_inventory_item_id);

1312: dbms_sql.bind_variable(DSQL_c, 'row_id_bind', row_id);
1313: DSQL_rows_processed := dbms_sql.execute(DSQL_c);
1314: --
1315: if dbms_sql.fetch_rows(DSQL_c) > 0 then -- {
1316: dbms_sql.column_value(DSQL_c,1,DSQL_inventory_item_id);
1317: --
1318: update MTL_SYSTEM_ITEMS_INTERFACE
1319: set inventory_item_id = DSQL_inventory_item_id
1320: where rowid = row_id;

Line 1323: dbms_sql.close_cursor(DSQL_c);

1319: set inventory_item_id = DSQL_inventory_item_id
1320: where rowid = row_id;
1321: --
1322: inv_item_id := DSQL_inventory_item_id;
1323: dbms_sql.close_cursor(DSQL_c);
1324: else -- } {
1325: dbms_sql.close_cursor(DSQL_c);
1326: --
1327: return (0);

Line 1325: dbms_sql.close_cursor(DSQL_c);

1321: --
1322: inv_item_id := DSQL_inventory_item_id;
1323: dbms_sql.close_cursor(DSQL_c);
1324: else -- } {
1325: dbms_sql.close_cursor(DSQL_c);
1326: --
1327: return (0);
1328: end if; -- }
1329:

Line 1351: if dbms_sql.is_open(DSQL_c) then -- {

1347: IF l_inv_debug_level IN(101, 102) THEN
1348: INVPUTLI.info('when OTHERS exception raised in exists_in_msi');
1349: END IF;
1350:
1351: if dbms_sql.is_open(DSQL_c) then -- {
1352: dbms_sql.close_cursor(DSQL_c);
1353: end if; -- }
1354:
1355: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 1352: dbms_sql.close_cursor(DSQL_c);

1348: INVPUTLI.info('when OTHERS exception raised in exists_in_msi');
1349: END IF;
1350:
1351: if dbms_sql.is_open(DSQL_c) then -- {
1352: dbms_sql.close_cursor(DSQL_c);
1353: end if; -- }
1354:
1355: dumm_status := INVPUOPI.mtl_log_interface_err(
1356: org_id,