APPS.CSI_ML_INTERFACE_TXN_PVT dependencies on FND_PROFILE

Line 89: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));

85: FROM csi_ii_relationships
86: WHERE subject_id = p_sub_id
87: AND object_id = p_ob_id;
88: t_rel_rec rel_cur%ROWTYPE;
89: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));
90: BEGIN
91: x_exists := FALSE;
92: OPEN rel_cur(p_subect_id,p_object_id);
93: FETCH rel_cur INTO t_rel_rec;

Line 177: l_debug_level NUMBER:= to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));

173: prty_contact_idx PLS_INTEGER;
174: u_inst_idx PLS_INTEGER; --Added for open
175: asset_idx PLS_INTEGER; -- Asset Index
176:
177: l_debug_level NUMBER:= to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));
178:
179:
180: l_commit VARCHAR2(1) ;
181: l_init_msg_list VARCHAR2(1);

Line 200: l_enable_contracts_oi VARCHAR2(1) := NVL(FND_PROFILE.VALUE('CSI_ENABLE_CONTRACTS_FOR_MASS_LOAD'),'Y'); --bug#13072088

196: l_failure_count NUMBER:=0;
197: -- Bug 9526806
198: l_txn_from_date DATE := trunc(to_date(p_txn_from_date, 'YYYY/MM/DD HH24:MI:SS'));
199: l_txn_to_date DATE := trunc(to_date(p_txn_to_date, 'YYYY/MM/DD HH24:MI:SS'));
200: l_enable_contracts_oi VARCHAR2(1) := NVL(FND_PROFILE.VALUE('CSI_ENABLE_CONTRACTS_FOR_MASS_LOAD'),'Y'); --bug#13072088
201:
202:
203: -- Bug 9526806
204: CURSOR get_txns_cur( p_source_system IN VARCHAR2,