APPS.CSI_ML_CREATE_PUB dependencies on FND_PROFILE

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

49: c PLS_INTEGER;
50: l_tbl_count NUMBER :=0;
51: l_txn_from_date DATE;
52: l_txn_to_date DATE;
53: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));
54:
55: CURSOR c_id is
56: SELECT a.inst_interface_id
57: FROM csi_instance_interface a

Line 70: SELECT nvl(FND_PROFILE.VALUE('CSI_OPEN_INTERFACE_COMMIT_RECS'),1000)

66:
67: -- Get the number of recs that should be processed before doing a
68: -- commit;
69:
70: SELECT nvl(FND_PROFILE.VALUE('CSI_OPEN_INTERFACE_COMMIT_RECS'),1000)
71: INTO l_commit_recs
72: FROM dual;
73: l_txn_from_date := to_date(p_txn_from_date, 'YYYY/MM/DD HH24:MI:SS');
74: l_txn_to_date := to_date(p_txn_to_date, 'YYYY/MM/DD HH24:MI:SS');

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

317: c PLS_INTEGER;
318: l_tbl_count NUMBER :=0;
319: l_source_flag VARCHAR2(1);
320: l_count1 NUMBER;
321: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));
322:
323: CURSOR c_id (pc_parallel_worker_id IN NUMBER) is
324: SELECT inst_interface_id,process_status
325: FROM csi_instance_interface

Line 346: SELECT nvl(FND_PROFILE.VALUE('CSI_OPEN_INTERFACE_COMMIT_RECS'),1000)

342:
343: -- Get the number of recs that should be processed before doing a
344: -- commit;
345:
346: SELECT nvl(FND_PROFILE.VALUE('CSI_OPEN_INTERFACE_COMMIT_RECS'),1000)
347: INTO l_commit_recs
348: FROM dual;
349:
350: FND_File.Put_Line(Fnd_File.LOG,'After Commit Profile: '||

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

683: x_count NUMBER := 0;
684: l_count NUMBER := 0;
685: l_commit_recs NUMBER := 0;
686: l_relationship_count NUMBER := 0;
687: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));
688:
689: BEGIN
690:
691: IF(l_debug_level>1) THEN