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_TXN_MANAGER_GRP dependencies on DBMS_SQL

Line 11344: l_sql_p := DBMS_SQL.open_cursor;

11340: || ' AND msn.serial_number = :b_serial_number'
11341: || ' AND msn.inventory_item_id = mti.inventory_item_id '
11342: || ' AND msn.current_organization_id = mti.organization_id ';
11343: */
11344: l_sql_p := DBMS_SQL.open_cursor;
11345:
11346: IF (l_debug = 1)
11347: THEN
11348: mydebug ('breadcrumb 30', 'get_serial_attr_record');

Line 11351: DBMS_SQL.parse (l_sql_p, g_select_stmt, DBMS_SQL.native);

11347: THEN
11348: mydebug ('breadcrumb 30', 'get_serial_attr_record');
11349: END IF;
11350:
11351: DBMS_SQL.parse (l_sql_p, g_select_stmt, DBMS_SQL.native);
11352:
11353: IF (l_debug = 1)
11354: THEN
11355: mydebug ('breadcrumb 40', 'get_serial_attr_record');

Line 11364: DBMS_SQL.bind_variable (l_sql_p, 'B_PARENT_ID', p_transaction_interface_id);

11360: mydebug ('b_item_id ' ||p_item_id , 'get_serial_attr_record');
11361: mydebug ('b_org_id ' ||p_org_id , 'get_serial_attr_record');
11362: END IF;
11363:
11364: DBMS_SQL.bind_variable (l_sql_p, 'B_PARENT_ID', p_transaction_interface_id);
11365: DBMS_SQL.bind_variable (l_sql_p, 'B_FM_SERIAL_NUMBER', p_fm_serial_number);
11366: DBMS_SQL.bind_variable (l_sql_p, 'B_TO_SERIAL_NUMBER', p_to_serial_number);
11367: DBMS_SQL.bind_variable (l_sql_p, 'B_SERIAL_NUMBER', p_serial_number);
11368: DBMS_SQL.bind_variable (l_sql_p, 'B_ITEM_ID', p_item_id);

Line 11365: DBMS_SQL.bind_variable (l_sql_p, 'B_FM_SERIAL_NUMBER', p_fm_serial_number);

11361: mydebug ('b_org_id ' ||p_org_id , 'get_serial_attr_record');
11362: END IF;
11363:
11364: DBMS_SQL.bind_variable (l_sql_p, 'B_PARENT_ID', p_transaction_interface_id);
11365: DBMS_SQL.bind_variable (l_sql_p, 'B_FM_SERIAL_NUMBER', p_fm_serial_number);
11366: DBMS_SQL.bind_variable (l_sql_p, 'B_TO_SERIAL_NUMBER', p_to_serial_number);
11367: DBMS_SQL.bind_variable (l_sql_p, 'B_SERIAL_NUMBER', p_serial_number);
11368: DBMS_SQL.bind_variable (l_sql_p, 'B_ITEM_ID', p_item_id);
11369: DBMS_SQL.bind_variable (l_sql_p, 'B_ORG_ID', p_org_id);

Line 11366: DBMS_SQL.bind_variable (l_sql_p, 'B_TO_SERIAL_NUMBER', p_to_serial_number);

11362: END IF;
11363:
11364: DBMS_SQL.bind_variable (l_sql_p, 'B_PARENT_ID', p_transaction_interface_id);
11365: DBMS_SQL.bind_variable (l_sql_p, 'B_FM_SERIAL_NUMBER', p_fm_serial_number);
11366: DBMS_SQL.bind_variable (l_sql_p, 'B_TO_SERIAL_NUMBER', p_to_serial_number);
11367: DBMS_SQL.bind_variable (l_sql_p, 'B_SERIAL_NUMBER', p_serial_number);
11368: DBMS_SQL.bind_variable (l_sql_p, 'B_ITEM_ID', p_item_id);
11369: DBMS_SQL.bind_variable (l_sql_p, 'B_ORG_ID', p_org_id);
11370:

Line 11367: DBMS_SQL.bind_variable (l_sql_p, 'B_SERIAL_NUMBER', p_serial_number);

11363:
11364: DBMS_SQL.bind_variable (l_sql_p, 'B_PARENT_ID', p_transaction_interface_id);
11365: DBMS_SQL.bind_variable (l_sql_p, 'B_FM_SERIAL_NUMBER', p_fm_serial_number);
11366: DBMS_SQL.bind_variable (l_sql_p, 'B_TO_SERIAL_NUMBER', p_to_serial_number);
11367: DBMS_SQL.bind_variable (l_sql_p, 'B_SERIAL_NUMBER', p_serial_number);
11368: DBMS_SQL.bind_variable (l_sql_p, 'B_ITEM_ID', p_item_id);
11369: DBMS_SQL.bind_variable (l_sql_p, 'B_ORG_ID', p_org_id);
11370:
11371: IF (l_debug = 1)

Line 11368: DBMS_SQL.bind_variable (l_sql_p, 'B_ITEM_ID', p_item_id);

11364: DBMS_SQL.bind_variable (l_sql_p, 'B_PARENT_ID', p_transaction_interface_id);
11365: DBMS_SQL.bind_variable (l_sql_p, 'B_FM_SERIAL_NUMBER', p_fm_serial_number);
11366: DBMS_SQL.bind_variable (l_sql_p, 'B_TO_SERIAL_NUMBER', p_to_serial_number);
11367: DBMS_SQL.bind_variable (l_sql_p, 'B_SERIAL_NUMBER', p_serial_number);
11368: DBMS_SQL.bind_variable (l_sql_p, 'B_ITEM_ID', p_item_id);
11369: DBMS_SQL.bind_variable (l_sql_p, 'B_ORG_ID', p_org_id);
11370:
11371: IF (l_debug = 1)
11372: THEN

Line 11369: DBMS_SQL.bind_variable (l_sql_p, 'B_ORG_ID', p_org_id);

11365: DBMS_SQL.bind_variable (l_sql_p, 'B_FM_SERIAL_NUMBER', p_fm_serial_number);
11366: DBMS_SQL.bind_variable (l_sql_p, 'B_TO_SERIAL_NUMBER', p_to_serial_number);
11367: DBMS_SQL.bind_variable (l_sql_p, 'B_SERIAL_NUMBER', p_serial_number);
11368: DBMS_SQL.bind_variable (l_sql_p, 'B_ITEM_ID', p_item_id);
11369: DBMS_SQL.bind_variable (l_sql_p, 'B_ORG_ID', p_org_id);
11370:
11371: IF (l_debug = 1)
11372: THEN
11373: mydebug ('breadcrumb 50', 'get_serial_attr_record');

Line 11381: DBMS_SQL.define_column (l_sql_p

11377:
11378: FOR i IN 1 .. l_lot_ser_attr_tbl.COUNT
11379: LOOP
11380: l_column_idx := i;
11381: DBMS_SQL.define_column (l_sql_p
11382: , l_column_idx
11383: , l_lot_ser_attr_tbl (i).column_value
11384: , l_lot_ser_attr_tbl (i).column_length
11385: );

Line 11393: l_rows_processed := DBMS_SQL.EXECUTE (l_sql_p);

11389: THEN
11390: mydebug ('breadcrumb 60', 'get_serial_attr_record');
11391: END IF;
11392:
11393: l_rows_processed := DBMS_SQL.EXECUTE (l_sql_p);
11394:
11395: IF (l_debug = 1)
11396: THEN
11397: mydebug ('breadcrumb 70', 'get_serial_attr_record');

Line 11401: IF (DBMS_SQL.fetch_rows (l_sql_p) > 0)

11397: mydebug ('breadcrumb 70', 'get_serial_attr_record');
11398: END IF;
11399:
11400: LOOP
11401: IF (DBMS_SQL.fetch_rows (l_sql_p) > 0)
11402: THEN
11403: l_column_idx := 0;
11404:
11405: FOR i IN 1 .. l_lot_ser_attr_tbl.COUNT

Line 11408: DBMS_SQL.column_value (l_sql_p

11404:
11405: FOR i IN 1 .. l_lot_ser_attr_tbl.COUNT
11406: LOOP
11407: l_column_idx := i;
11408: DBMS_SQL.column_value (l_sql_p
11409: , l_column_idx
11410: , l_lot_ser_attr_tbl (i).column_value
11411: );
11412: END LOOP;

Line 11425: DBMS_SQL.close_cursor (l_sql_p);

11421:
11422: EXIT;
11423: END LOOP;
11424:
11425: DBMS_SQL.close_cursor (l_sql_p);
11426:
11427: IF (l_debug = 1)
11428: THEN
11429: mydebug ('breadcrumb 90', 'get_serial_attr_record');