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.CSI_DIAGNOSTICS_PKG dependencies on CSI_TXN_TYPES

Line 240: FROM csi_txn_types

236:
237: BEGIN
238: SELECT transaction_type_id
239: INTO l_txn_type_id
240: FROM csi_txn_types
241: WHERE source_transaction_type = 'DATA_CORRECTION';
242: EXCEPTION
243: WHEN no_data_found THEN
244: l_txn_type_id := 2;

Line 10717: from CSI_TXN_TYPES

10713: --
10714: Begin
10715: select transaction_type_id
10716: into v_txn_type_id
10717: from CSI_TXN_TYPES
10718: where SOURCE_TRANSACTION_TYPE = 'DATA_CORRECTION';
10719: Exception
10720: when no_data_found then
10721: Raise comp_error;

Line 11312: from CSI_TXN_TYPES

11308: -- Get the Transaction Type ID for Txn Type MIGRATED
11309: Begin
11310: select transaction_type_id
11311: into v_txn_type_id
11312: from CSI_TXN_TYPES
11313: where SOURCE_TRANSACTION_TYPE = 'DATA_CORRECTION';
11314: Exception
11315: when no_data_found then
11316: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';

Line 11316: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';

11312: from CSI_TXN_TYPES
11313: where SOURCE_TRANSACTION_TYPE = 'DATA_CORRECTION';
11314: Exception
11315: when no_data_found then
11316: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';
11317: Raise comp_error;
11318: when others then
11319: v_err_msg := 'Unable to get the ID for Txn Type DATA_CORRECTION from CSI_TXN_TYPES';
11320: Raise comp_error;

Line 11319: v_err_msg := 'Unable to get the ID for Txn Type DATA_CORRECTION from CSI_TXN_TYPES';

11315: when no_data_found then
11316: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';
11317: Raise comp_error;
11318: when others then
11319: v_err_msg := 'Unable to get the ID for Txn Type DATA_CORRECTION from CSI_TXN_TYPES';
11320: Raise comp_error;
11321: End;
11322: -- End data the relationships
11323: OPEN REL_CUR;

Line 11753: from CSI_TXN_TYPES

11749: -- Get the Transaction Type ID for Txn Type DATA_CORRECTION
11750: Begin
11751: select transaction_type_id
11752: into v_txn_type_id
11753: from CSI_TXN_TYPES
11754: where SOURCE_TRANSACTION_TYPE = 'DATA_CORRECTION';
11755: Exception
11756: when no_data_found then
11757: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';

Line 11757: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';

11753: from CSI_TXN_TYPES
11754: where SOURCE_TRANSACTION_TYPE = 'DATA_CORRECTION';
11755: Exception
11756: when no_data_found then
11757: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';
11758: Raise comp_error;
11759: when others then
11760: v_err_msg := 'Unable to get the ID for Txn Type DATA_CORRECTION from CSI_TXN_TYPES';
11761: Raise comp_error;

Line 11760: v_err_msg := 'Unable to get the ID for Txn Type DATA_CORRECTION from CSI_TXN_TYPES';

11756: when no_data_found then
11757: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';
11758: Raise comp_error;
11759: when others then
11760: v_err_msg := 'Unable to get the ID for Txn Type DATA_CORRECTION from CSI_TXN_TYPES';
11761: Raise comp_error;
11762: End;
11763: --
11764: select CSI_TRANSACTIONS_S.nextval

Line 12239: from CSI_TXN_TYPES

12235: -- Get the Transaction Type ID for Txn Type MIGRATED
12236: Begin
12237: select transaction_type_id
12238: into v_txn_type_id
12239: from CSI_TXN_TYPES
12240: where SOURCE_TRANSACTION_TYPE = 'DATA_CORRECTION';
12241: Exception
12242: when no_data_found then
12243: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';

Line 12243: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';

12239: from CSI_TXN_TYPES
12240: where SOURCE_TRANSACTION_TYPE = 'DATA_CORRECTION';
12241: Exception
12242: when no_data_found then
12243: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';
12244: Raise comp_error;
12245: when others then
12246: v_err_msg := 'Unable to get the ID for Txn Type DATA_CORRECTION from CSI_TXN_TYPES';
12247: Raise comp_error;

Line 12246: v_err_msg := 'Unable to get the ID for Txn Type DATA_CORRECTION from CSI_TXN_TYPES';

12242: when no_data_found then
12243: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';
12244: Raise comp_error;
12245: when others then
12246: v_err_msg := 'Unable to get the ID for Txn Type DATA_CORRECTION from CSI_TXN_TYPES';
12247: Raise comp_error;
12248: End;
12249: --
12250: -- Get the LATEST Status ID. This will be used for all INV records.

Line 13667: from CSI_TXN_TYPES

13663: -- Get the Transaction Type ID for Txn Type MIGRATED
13664: Begin
13665: select transaction_type_id
13666: into v_txn_type_id
13667: from CSI_TXN_TYPES
13668: where SOURCE_TRANSACTION_TYPE = 'DATA_CORRECTION';
13669: Exception
13670: when no_data_found then
13671: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';

Line 13671: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';

13667: from CSI_TXN_TYPES
13668: where SOURCE_TRANSACTION_TYPE = 'DATA_CORRECTION';
13669: Exception
13670: when no_data_found then
13671: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';
13672: Raise comp_error;
13673: when others then
13674: v_err_msg := 'Unable to get the ID for Txn Type DATA_CORRECTION from CSI_TXN_TYPES';
13675: Raise comp_error;

Line 13674: v_err_msg := 'Unable to get the ID for Txn Type DATA_CORRECTION from CSI_TXN_TYPES';

13670: when no_data_found then
13671: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';
13672: Raise comp_error;
13673: when others then
13674: v_err_msg := 'Unable to get the ID for Txn Type DATA_CORRECTION from CSI_TXN_TYPES';
13675: Raise comp_error;
13676: End;
13677: --
13678: -- Get the LATEST Status ID. This will be used for all INV records.

Line 14442: FROM csi_txn_types

14438: -- Get the Transaction Type ID for Txn Type MIGRATED
14439: BEGIN
14440: SELECT transaction_type_id
14441: INTO v_txn_type_id
14442: FROM csi_txn_types
14443: WHERE source_transaction_type = 'DATA_CORRECTION';
14444: EXCEPTION
14445: WHEN no_data_found THEN
14446: RAISE comp_error;

Line 14596: from CSI_TXN_TYPES

14592: -- Get the Transaction Type ID for Txn Type MIGRATED
14593: Begin
14594: select transaction_type_id
14595: into v_txn_type_id
14596: from CSI_TXN_TYPES
14597: where SOURCE_TRANSACTION_TYPE = 'DATA_CORRECTION';
14598: Exception
14599: when no_data_found then
14600: Raise comp_error;