APPS.CSM_IB_TXN_SUB_TYPES_EVENT_PKG dependencies on CSI_IB_TXN_TYPES

Line 28: l_sub_type_id csi_ib_txn_types.sub_type_id%TYPE;

24: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
25: l_mark_dirty boolean;
26: l_access_id CSM_IB_TXN_TYPES_ACC.ACCESS_ID%TYPE;
27: l_language cs_transaction_types_tl.language%TYPE;
28: l_sub_type_id csi_ib_txn_types.sub_type_id%TYPE;
29:
30: l_tl_omfs_palm_resource_list asg_download.user_list;
31: l_single_access_id_list asg_download.access_list;
32: --a null list

Line 52: FROM csi_ib_txn_types cit , csi_source_ib_types cst , csi_txn_types ctt ,

48: SELECT acc.access_id
49: FROM csm_ib_txn_types_acc acc
50: WHERE NOT EXISTS
51: (SELECT cit.sub_type_id
52: FROM csi_ib_txn_types cit , csi_source_ib_types cst , csi_txn_types ctt ,
53: csi_instance_statuses cis , cs_transaction_types_b ttb
54: WHERE acc.sub_type_id = cit.sub_type_id
55: AND cit.cs_transaction_type_id = ttb.transaction_type_id(+)
56: AND ctt.source_application_id = 513

Line 104: cursor record_exists_csr( p_sub_type_id csi_ib_txn_types.sub_type_id%TYPE)

100: SELECT tt_tl.LANGUAGE
101: FROM cs_transaction_types_tl tt_tl
102: WHERE tt_tl.transaction_type_id = p_transaction_type_id;
103:
104: cursor record_exists_csr( p_sub_type_id csi_ib_txn_types.sub_type_id%TYPE)
105: IS
106: SELECT 1
107: FROM csm_ib_txn_types_acc
108: WHERE sub_type_id = p_sub_type_id;

Line 153: csi_ib_txn_types cit,

149: /******* UPDATES **********/
150: --generate sql for updates
151: l_dsql := 'SELECT acc.access_id
152: FROM csm_ib_txn_types_acc acc ,
153: csi_ib_txn_types cit,
154: csi_source_ib_types cst ,
155: csi_txn_types ctt ,
156: csi_instance_statuses cis ,
157: cs_transaction_types_b ttb

Line 238: FROM csi_ib_txn_types cit , csi_source_ib_types cst , csi_txn_types ctt ,

234:
235: /****** INSERTS **********/
236: --generate sql for inserts
237: l_dsql := 'SELECT cit.sub_type_id
238: FROM csi_ib_txn_types cit , csi_source_ib_types cst , csi_txn_types ctt ,
239: csi_instance_statuses cis , cs_transaction_types_b ttb
240: WHERE cit.cs_transaction_type_id = ttb.transaction_type_id(+)
241: AND ctt.source_application_id = 513
242: AND ctt.source_transaction_type = ''FIELD_SERVICE_REPORT''