DBA Data[Home] [Help]

APPS.CSI_ML_PROGRAM_PUB dependencies on FND_PROFILE

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

18: l_syncup_family_seq NUMBER := 0;
19: l_syncup_vld_flag VARCHAR2(1) := 'Y';
20: l_process_status VARCHAR2(1) := 'R';
21: l_Asset_Error_text VARCHAR2(2000);
22: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));
23:
24: CURSOR syncup_instance_cur IS
25: SELECT csii.inst_interface_id,
26: csii.instance_id,

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

172: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
173: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
174: l_api_name VARCHAR2(255) := 'CSI_ML_CREATE_PUB.EXECUTE_OPENINTERFACE';
175:
176: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));
177:
178: CURSOR purge_cur is
179: SELECT inst_interface_id
180: FROM csi_instance_interface

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

326: ii PLS_INTEGER;
327: j PLS_INTEGER;
328: l_tbl_count NUMBER :=0;
329: l_dummy NUMBER;
330: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));
331: cursor c_id (pc_worker_id IN NUMBER) is
332: SELECT inst_interface_id,parallel_worker_id
333: FROM csi_instance_interface
334: WHERE parallel_worker_id = pc_worker_id