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 11752: from CSI_TXN_TYPES

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

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

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

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

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

Line 12234: from CSI_TXN_TYPES

12230: -- Get the Transaction Type ID for Txn Type MIGRATED
12231: Begin
12232: select transaction_type_id
12233: into v_txn_type_id
12234: from CSI_TXN_TYPES
12235: where SOURCE_TRANSACTION_TYPE = 'DATA_CORRECTION';
12236: Exception
12237: when no_data_found then
12238: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';

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

12234: from CSI_TXN_TYPES
12235: where SOURCE_TRANSACTION_TYPE = 'DATA_CORRECTION';
12236: Exception
12237: when no_data_found then
12238: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';
12239: Raise comp_error;
12240: when others then
12241: v_err_msg := 'Unable to get the ID for Txn Type DATA_CORRECTION from CSI_TXN_TYPES';
12242: Raise comp_error;

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

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

Line 13662: from CSI_TXN_TYPES

13658: -- Get the Transaction Type ID for Txn Type MIGRATED
13659: Begin
13660: select transaction_type_id
13661: into v_txn_type_id
13662: from CSI_TXN_TYPES
13663: where SOURCE_TRANSACTION_TYPE = 'DATA_CORRECTION';
13664: Exception
13665: when no_data_found then
13666: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';

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

13662: from CSI_TXN_TYPES
13663: where SOURCE_TRANSACTION_TYPE = 'DATA_CORRECTION';
13664: Exception
13665: when no_data_found then
13666: v_err_msg := 'Txn Type DATA_CORRECTION not defined in CSI_TXN_TYPES';
13667: Raise comp_error;
13668: when others then
13669: v_err_msg := 'Unable to get the ID for Txn Type DATA_CORRECTION from CSI_TXN_TYPES';
13670: Raise comp_error;

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

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

Line 14437: FROM csi_txn_types

14433: -- Get the Transaction Type ID for Txn Type MIGRATED
14434: BEGIN
14435: SELECT transaction_type_id
14436: INTO v_txn_type_id
14437: FROM csi_txn_types
14438: WHERE source_transaction_type = 'DATA_CORRECTION';
14439: EXCEPTION
14440: WHEN no_data_found THEN
14441: RAISE comp_error;

Line 14591: from CSI_TXN_TYPES

14587: -- Get the Transaction Type ID for Txn Type MIGRATED
14588: Begin
14589: select transaction_type_id
14590: into v_txn_type_id
14591: from CSI_TXN_TYPES
14592: where SOURCE_TRANSACTION_TYPE = 'DATA_CORRECTION';
14593: Exception
14594: when no_data_found then
14595: Raise comp_error;