APPS.CSI_DEBUG_PKG dependencies on DUAL

Line 33: FROM sys.dual;

29: g_utl_check_done := 'Y';
30:
31: SELECT fnd_profile.value('csi_debug_level')
32: INTO l_debug_level
33: FROM sys.dual;
34:
35: IF nvl(l_debug_level, 0) = 0 THEN
36: csi_t_gen_utility_pvt.g_debug_level := 10;
37: END IF;

Line 41: FROM sys.dual;

37: END IF;
38:
39: SELECT fnd_profile.value('csi_logfile_path')
40: INTO l_debug_path
41: FROM sys.dual;
42:
43: SELECT value
44: INTO l_utl_file_dir
45: FROM v$parameter

Line 53: FROM sys.dual;

49: SELECT substr(l_utl_file_dir, 1,
50: decode(instr(l_utl_file_dir, ',', 1), 0,
51: length(l_utl_file_dir), instr(l_utl_file_dir, ',', 1)-1 ))
52: INTO l_debug_path
53: FROM sys.dual;
54: END IF;
55:
56: csi_t_gen_utility_pvt.g_dir := l_debug_path;
57:

Line 388: FROM sys.dual;

384: BEGIN
385:
386: SELECT decode(p_order_line.ib_trackable_flag, 'Y', '*', ' ')
387: INTO l_ib_ind
388: FROM sys.dual;
389:
390: l_line := l_ib_ind||fill(p_order_line.line_id, 9)||
391: fill(p_order_line.line_number, 8)||
392: fill(lpad(' ', p_order_line.level*2, ' ')||p_order_line.item_number, 25)||

Line 1520: FROM sys.dual;

1516: x_item_rec => l_item_rec);
1517:
1518: SELECT decode(l_item_rec.ib_trackable_flag, 'Y', '*', ' ')
1519: INTO l_ib_ind
1520: FROM sys.dual;
1521:
1522: l_wip_req_tbl(l_ind).comp_item := l_ib_ind||req_rec.segment1;
1523: l_wip_req_tbl(l_ind).comp_item_id := req_rec.inventory_item_id;
1524: l_wip_req_tbl(l_ind).oper_seq_num := req_rec.operation_seq_num;

Line 2033: FROM sys.dual

2029: IF p_ato_line_id is not null THEN
2030: BEGIN
2031: SELECT 'Y'
2032: INTO l_sub_model_flag
2033: FROM sys.dual
2034: WHERE exists (
2035: SELECT 'X'
2036: FROM bom_cto_order_lines
2037: WHERE ato_line_id = p_ato_line_id