APPS.CSI_TRANSACTIONS_PVT dependencies on CSI_TXN_TYPES

Line 773: FROM csi_txn_types

769: BEGIN
770:
771: SELECT source_txn_type_name
772: INTO l_txn_rec.transaction_type_name
773: FROM csi_txn_types
774: WHERE transaction_type_id = l_txn_rec.transaction_type_id;
775:
776: EXCEPTION
777: WHEN others THEN

Line 800: FROM csi_txn_types

796: SELECT application_name
797: INTO l_txn_rec.source_application_name
798: FROM fnd_application_vl
799: WHERE application_id IN (SELECT source_application_id
800: FROM csi_txn_types
801: WHERE transaction_type_id = l_txn_rec.transaction_type_id);
802:
803: EXCEPTION
804: WHEN others THEN

Line 1769: /* --- 2. for not null check for the exsistence in the csi_txn_types table --- */

1765:
1766: /* ---------------------------------------------------------------------------------- */
1767: /* --- This procedure is used to validate transaction_type_id --- */
1768: /* --- 1. for null return error status --- */
1769: /* --- 2. for not null check for the exsistence in the csi_txn_types table --- */
1770: /* ---------------------------------------------------------------------------------- */
1771:
1772: PROCEDURE validate_transaction_type_id (
1773: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

Line 1802: FROM csi_txn_types

1798: ELSE
1799: BEGIN
1800: SELECT 'x'
1801: INTO l_dummy
1802: FROM csi_txn_types
1803: WHERE transaction_type_id=p_transaction_type_id;
1804:
1805: EXCEPTION
1806: WHEN no_data_found THEN

Line 1872: FROM csi_txn_types

1868: l_flag:='t';
1869: END IF;
1870: SELECT source_object_code
1871: INTO l_source_code
1872: FROM csi_txn_types
1873: WHERE transaction_type_id=p_transaction_type_id;
1874: EXCEPTION
1875: WHEN no_data_found THEN
1876: l_flag:='f';