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 10773: l_sql_p := DBMS_SQL.open_cursor;

10769: || ' AND msn.serial_number = :b_serial_number'
10770: || ' AND msn.inventory_item_id = mti.inventory_item_id '
10771: || ' AND msn.current_organization_id = mti.organization_id ';
10772: */
10773: l_sql_p := DBMS_SQL.open_cursor;
10774:
10775: IF (l_debug = 1)
10776: THEN
10777: mydebug ('breadcrumb 30', 'get_serial_attr_record');

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

10776: THEN
10777: mydebug ('breadcrumb 30', 'get_serial_attr_record');
10778: END IF;
10779:
10780: DBMS_SQL.parse (l_sql_p, g_select_stmt, DBMS_SQL.native);
10781:
10782: IF (l_debug = 1)
10783: THEN
10784: mydebug ('breadcrumb 40', 'get_serial_attr_record');

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

10789: mydebug ('b_item_id ' ||p_item_id , 'get_serial_attr_record');
10790: mydebug ('b_org_id ' ||p_org_id , 'get_serial_attr_record');
10791: END IF;
10792:
10793: DBMS_SQL.bind_variable (l_sql_p, 'B_PARENT_ID', p_transaction_interface_id);
10794: DBMS_SQL.bind_variable (l_sql_p, 'B_FM_SERIAL_NUMBER', p_fm_serial_number);
10795: DBMS_SQL.bind_variable (l_sql_p, 'B_TO_SERIAL_NUMBER', p_to_serial_number);
10796: DBMS_SQL.bind_variable (l_sql_p, 'B_SERIAL_NUMBER', p_serial_number);
10797: DBMS_SQL.bind_variable (l_sql_p, 'B_ITEM_ID', p_item_id);

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

10790: mydebug ('b_org_id ' ||p_org_id , 'get_serial_attr_record');
10791: END IF;
10792:
10793: DBMS_SQL.bind_variable (l_sql_p, 'B_PARENT_ID', p_transaction_interface_id);
10794: DBMS_SQL.bind_variable (l_sql_p, 'B_FM_SERIAL_NUMBER', p_fm_serial_number);
10795: DBMS_SQL.bind_variable (l_sql_p, 'B_TO_SERIAL_NUMBER', p_to_serial_number);
10796: DBMS_SQL.bind_variable (l_sql_p, 'B_SERIAL_NUMBER', p_serial_number);
10797: DBMS_SQL.bind_variable (l_sql_p, 'B_ITEM_ID', p_item_id);
10798: DBMS_SQL.bind_variable (l_sql_p, 'B_ORG_ID', p_org_id);

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

10791: END IF;
10792:
10793: DBMS_SQL.bind_variable (l_sql_p, 'B_PARENT_ID', p_transaction_interface_id);
10794: DBMS_SQL.bind_variable (l_sql_p, 'B_FM_SERIAL_NUMBER', p_fm_serial_number);
10795: DBMS_SQL.bind_variable (l_sql_p, 'B_TO_SERIAL_NUMBER', p_to_serial_number);
10796: DBMS_SQL.bind_variable (l_sql_p, 'B_SERIAL_NUMBER', p_serial_number);
10797: DBMS_SQL.bind_variable (l_sql_p, 'B_ITEM_ID', p_item_id);
10798: DBMS_SQL.bind_variable (l_sql_p, 'B_ORG_ID', p_org_id);
10799:

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

10792:
10793: DBMS_SQL.bind_variable (l_sql_p, 'B_PARENT_ID', p_transaction_interface_id);
10794: DBMS_SQL.bind_variable (l_sql_p, 'B_FM_SERIAL_NUMBER', p_fm_serial_number);
10795: DBMS_SQL.bind_variable (l_sql_p, 'B_TO_SERIAL_NUMBER', p_to_serial_number);
10796: DBMS_SQL.bind_variable (l_sql_p, 'B_SERIAL_NUMBER', p_serial_number);
10797: DBMS_SQL.bind_variable (l_sql_p, 'B_ITEM_ID', p_item_id);
10798: DBMS_SQL.bind_variable (l_sql_p, 'B_ORG_ID', p_org_id);
10799:
10800: IF (l_debug = 1)

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

10793: DBMS_SQL.bind_variable (l_sql_p, 'B_PARENT_ID', p_transaction_interface_id);
10794: DBMS_SQL.bind_variable (l_sql_p, 'B_FM_SERIAL_NUMBER', p_fm_serial_number);
10795: DBMS_SQL.bind_variable (l_sql_p, 'B_TO_SERIAL_NUMBER', p_to_serial_number);
10796: DBMS_SQL.bind_variable (l_sql_p, 'B_SERIAL_NUMBER', p_serial_number);
10797: DBMS_SQL.bind_variable (l_sql_p, 'B_ITEM_ID', p_item_id);
10798: DBMS_SQL.bind_variable (l_sql_p, 'B_ORG_ID', p_org_id);
10799:
10800: IF (l_debug = 1)
10801: THEN

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

10794: DBMS_SQL.bind_variable (l_sql_p, 'B_FM_SERIAL_NUMBER', p_fm_serial_number);
10795: DBMS_SQL.bind_variable (l_sql_p, 'B_TO_SERIAL_NUMBER', p_to_serial_number);
10796: DBMS_SQL.bind_variable (l_sql_p, 'B_SERIAL_NUMBER', p_serial_number);
10797: DBMS_SQL.bind_variable (l_sql_p, 'B_ITEM_ID', p_item_id);
10798: DBMS_SQL.bind_variable (l_sql_p, 'B_ORG_ID', p_org_id);
10799:
10800: IF (l_debug = 1)
10801: THEN
10802: mydebug ('breadcrumb 50', 'get_serial_attr_record');

Line 10810: DBMS_SQL.define_column (l_sql_p

10806:
10807: FOR i IN 1 .. l_lot_ser_attr_tbl.COUNT
10808: LOOP
10809: l_column_idx := i;
10810: DBMS_SQL.define_column (l_sql_p
10811: , l_column_idx
10812: , l_lot_ser_attr_tbl (i).column_value
10813: , l_lot_ser_attr_tbl (i).column_length
10814: );

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

10818: THEN
10819: mydebug ('breadcrumb 60', 'get_serial_attr_record');
10820: END IF;
10821:
10822: l_rows_processed := DBMS_SQL.EXECUTE (l_sql_p);
10823:
10824: IF (l_debug = 1)
10825: THEN
10826: mydebug ('breadcrumb 70', 'get_serial_attr_record');

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

10826: mydebug ('breadcrumb 70', 'get_serial_attr_record');
10827: END IF;
10828:
10829: LOOP
10830: IF (DBMS_SQL.fetch_rows (l_sql_p) > 0)
10831: THEN
10832: l_column_idx := 0;
10833:
10834: FOR i IN 1 .. l_lot_ser_attr_tbl.COUNT

Line 10837: DBMS_SQL.column_value (l_sql_p

10833:
10834: FOR i IN 1 .. l_lot_ser_attr_tbl.COUNT
10835: LOOP
10836: l_column_idx := i;
10837: DBMS_SQL.column_value (l_sql_p
10838: , l_column_idx
10839: , l_lot_ser_attr_tbl (i).column_value
10840: );
10841: END LOOP;

Line 10854: DBMS_SQL.close_cursor (l_sql_p);

10850:
10851: EXIT;
10852: END LOOP;
10853:
10854: DBMS_SQL.close_cursor (l_sql_p);
10855:
10856: IF (l_debug = 1)
10857: THEN
10858: mydebug ('breadcrumb 90', 'get_serial_attr_record');