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 1325: DSQL_c := dbms_sql.open_cursor;

1321: mtl_system_items_interface msii
1322: where msii.rowid = :row_id_bind
1323: AND msi.organization_id = msii.organization_id
1324: and ' || statement_temp;
1325: DSQL_c := dbms_sql.open_cursor;
1326: dbms_sql.parse(DSQL_c, DSQL_statement, dbms_sql.native);
1327: dbms_sql.define_column(DSQL_c,1,DSQL_inventory_item_id);
1328: dbms_sql.bind_variable(DSQL_c, 'row_id_bind', row_id);
1329: DSQL_rows_processed := dbms_sql.execute(DSQL_c);

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

1322: where msii.rowid = :row_id_bind
1323: AND msi.organization_id = msii.organization_id
1324: and ' || statement_temp;
1325: DSQL_c := dbms_sql.open_cursor;
1326: dbms_sql.parse(DSQL_c, DSQL_statement, dbms_sql.native);
1327: dbms_sql.define_column(DSQL_c,1,DSQL_inventory_item_id);
1328: dbms_sql.bind_variable(DSQL_c, 'row_id_bind', row_id);
1329: DSQL_rows_processed := dbms_sql.execute(DSQL_c);
1330: --

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

1323: AND msi.organization_id = msii.organization_id
1324: and ' || statement_temp;
1325: DSQL_c := dbms_sql.open_cursor;
1326: dbms_sql.parse(DSQL_c, DSQL_statement, dbms_sql.native);
1327: dbms_sql.define_column(DSQL_c,1,DSQL_inventory_item_id);
1328: dbms_sql.bind_variable(DSQL_c, 'row_id_bind', row_id);
1329: DSQL_rows_processed := dbms_sql.execute(DSQL_c);
1330: --
1331: if dbms_sql.fetch_rows(DSQL_c) > 0 then -- {

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

1324: and ' || statement_temp;
1325: DSQL_c := dbms_sql.open_cursor;
1326: dbms_sql.parse(DSQL_c, DSQL_statement, dbms_sql.native);
1327: dbms_sql.define_column(DSQL_c,1,DSQL_inventory_item_id);
1328: dbms_sql.bind_variable(DSQL_c, 'row_id_bind', row_id);
1329: DSQL_rows_processed := dbms_sql.execute(DSQL_c);
1330: --
1331: if dbms_sql.fetch_rows(DSQL_c) > 0 then -- {
1332: dbms_sql.column_value(DSQL_c,1,DSQL_inventory_item_id);

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

1325: DSQL_c := dbms_sql.open_cursor;
1326: dbms_sql.parse(DSQL_c, DSQL_statement, dbms_sql.native);
1327: dbms_sql.define_column(DSQL_c,1,DSQL_inventory_item_id);
1328: dbms_sql.bind_variable(DSQL_c, 'row_id_bind', row_id);
1329: DSQL_rows_processed := dbms_sql.execute(DSQL_c);
1330: --
1331: if dbms_sql.fetch_rows(DSQL_c) > 0 then -- {
1332: dbms_sql.column_value(DSQL_c,1,DSQL_inventory_item_id);
1333: --

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

1327: dbms_sql.define_column(DSQL_c,1,DSQL_inventory_item_id);
1328: dbms_sql.bind_variable(DSQL_c, 'row_id_bind', row_id);
1329: DSQL_rows_processed := dbms_sql.execute(DSQL_c);
1330: --
1331: if dbms_sql.fetch_rows(DSQL_c) > 0 then -- {
1332: dbms_sql.column_value(DSQL_c,1,DSQL_inventory_item_id);
1333: --
1334: update MTL_SYSTEM_ITEMS_INTERFACE
1335: set inventory_item_id = DSQL_inventory_item_id

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

1328: dbms_sql.bind_variable(DSQL_c, 'row_id_bind', row_id);
1329: DSQL_rows_processed := dbms_sql.execute(DSQL_c);
1330: --
1331: if dbms_sql.fetch_rows(DSQL_c) > 0 then -- {
1332: dbms_sql.column_value(DSQL_c,1,DSQL_inventory_item_id);
1333: --
1334: update MTL_SYSTEM_ITEMS_INTERFACE
1335: set inventory_item_id = DSQL_inventory_item_id
1336: where rowid = row_id;

Line 1339: dbms_sql.close_cursor(DSQL_c);

1335: set inventory_item_id = DSQL_inventory_item_id
1336: where rowid = row_id;
1337: --
1338: inv_item_id := DSQL_inventory_item_id;
1339: dbms_sql.close_cursor(DSQL_c);
1340: else -- } {
1341: dbms_sql.close_cursor(DSQL_c);
1342: --
1343: return (0);

Line 1341: dbms_sql.close_cursor(DSQL_c);

1337: --
1338: inv_item_id := DSQL_inventory_item_id;
1339: dbms_sql.close_cursor(DSQL_c);
1340: else -- } {
1341: dbms_sql.close_cursor(DSQL_c);
1342: --
1343: return (0);
1344: end if; -- }
1345:

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

1363: IF l_inv_debug_level IN(101, 102) THEN
1364: INVPUTLI.info('when OTHERS exception raised in exists_in_msi');
1365: END IF;
1366:
1367: if dbms_sql.is_open(DSQL_c) then -- {
1368: dbms_sql.close_cursor(DSQL_c);
1369: end if; -- }
1370:
1371: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 1368: dbms_sql.close_cursor(DSQL_c);

1364: INVPUTLI.info('when OTHERS exception raised in exists_in_msi');
1365: END IF;
1366:
1367: if dbms_sql.is_open(DSQL_c) then -- {
1368: dbms_sql.close_cursor(DSQL_c);
1369: end if; -- }
1370:
1371: dumm_status := INVPUOPI.mtl_log_interface_err(
1372: org_id,