24:
25: --
26: BEGIN
27: l_function := g_package||'span_start';
28: pay_in_utils.set_location(g_debug,'Entering: '||l_function,10);
29:
30: IF g_debug THEN
31: pay_in_utils.trace ('**************************************************','********************');
32: pay_in_utils.trace ('p_input_date',p_input_date);
27: l_function := g_package||'span_start';
28: pay_in_utils.set_location(g_debug,'Entering: '||l_function,10);
29:
30: IF g_debug THEN
31: pay_in_utils.trace ('**************************************************','********************');
32: pay_in_utils.trace ('p_input_date',p_input_date);
33: pay_in_utils.trace ('p_frequency',p_frequency);
34: pay_in_utils.trace ('p_start_dd_mm',p_start_dd_mm);
35: pay_in_utils.trace ('**************************************************','********************');
28: pay_in_utils.set_location(g_debug,'Entering: '||l_function,10);
29:
30: IF g_debug THEN
31: pay_in_utils.trace ('**************************************************','********************');
32: pay_in_utils.trace ('p_input_date',p_input_date);
33: pay_in_utils.trace ('p_frequency',p_frequency);
34: pay_in_utils.trace ('p_start_dd_mm',p_start_dd_mm);
35: pay_in_utils.trace ('**************************************************','********************');
36: END IF;
29:
30: IF g_debug THEN
31: pay_in_utils.trace ('**************************************************','********************');
32: pay_in_utils.trace ('p_input_date',p_input_date);
33: pay_in_utils.trace ('p_frequency',p_frequency);
34: pay_in_utils.trace ('p_start_dd_mm',p_start_dd_mm);
35: pay_in_utils.trace ('**************************************************','********************');
36: END IF;
37: -- Get the year component of the input date
30: IF g_debug THEN
31: pay_in_utils.trace ('**************************************************','********************');
32: pay_in_utils.trace ('p_input_date',p_input_date);
33: pay_in_utils.trace ('p_frequency',p_frequency);
34: pay_in_utils.trace ('p_start_dd_mm',p_start_dd_mm);
35: pay_in_utils.trace ('**************************************************','********************');
36: END IF;
37: -- Get the year component of the input date
38: l_year := TO_NUMBER(TO_CHAR(p_input_date,'yyyy'));
31: pay_in_utils.trace ('**************************************************','********************');
32: pay_in_utils.trace ('p_input_date',p_input_date);
33: pay_in_utils.trace ('p_frequency',p_frequency);
34: pay_in_utils.trace ('p_start_dd_mm',p_start_dd_mm);
35: pay_in_utils.trace ('**************************************************','********************');
36: END IF;
37: -- Get the year component of the input date
38: l_year := TO_NUMBER(TO_CHAR(p_input_date,'yyyy'));
39: --
63: l_start := TO_DATE(g_chalf_year_start2||TO_CHAR(l_year),'dd-mm-yyyy');
64: END IF;
65: END IF;
66:
67: pay_in_utils.trace('l_month ',l_month);
68: pay_in_utils.set_location(g_debug,l_function,20);
69:
70: pay_in_utils.trace('l_start ',l_start);
71: pay_in_utils.set_location(g_debug,l_function,30);
64: END IF;
65: END IF;
66:
67: pay_in_utils.trace('l_month ',l_month);
68: pay_in_utils.set_location(g_debug,l_function,20);
69:
70: pay_in_utils.trace('l_start ',l_start);
71: pay_in_utils.set_location(g_debug,l_function,30);
72:
66:
67: pay_in_utils.trace('l_month ',l_month);
68: pay_in_utils.set_location(g_debug,l_function,20);
69:
70: pay_in_utils.trace('l_start ',l_start);
71: pay_in_utils.set_location(g_debug,l_function,30);
72:
73: IF g_debug THEN
74: pay_in_utils.trace ('**************************************************','********************');
67: pay_in_utils.trace('l_month ',l_month);
68: pay_in_utils.set_location(g_debug,l_function,20);
69:
70: pay_in_utils.trace('l_start ',l_start);
71: pay_in_utils.set_location(g_debug,l_function,30);
72:
73: IF g_debug THEN
74: pay_in_utils.trace ('**************************************************','********************');
75: pay_in_utils.trace ('l_start',l_start);
70: pay_in_utils.trace('l_start ',l_start);
71: pay_in_utils.set_location(g_debug,l_function,30);
72:
73: IF g_debug THEN
74: pay_in_utils.trace ('**************************************************','********************');
75: pay_in_utils.trace ('l_start',l_start);
76: pay_in_utils.trace ('**************************************************','********************');
77: END IF;
78:
71: pay_in_utils.set_location(g_debug,l_function,30);
72:
73: IF g_debug THEN
74: pay_in_utils.trace ('**************************************************','********************');
75: pay_in_utils.trace ('l_start',l_start);
76: pay_in_utils.trace ('**************************************************','********************');
77: END IF;
78:
79: pay_in_utils.set_location(g_debug,'Leaving: '||l_function,30);
72:
73: IF g_debug THEN
74: pay_in_utils.trace ('**************************************************','********************');
75: pay_in_utils.trace ('l_start',l_start);
76: pay_in_utils.trace ('**************************************************','********************');
77: END IF;
78:
79: pay_in_utils.set_location(g_debug,'Leaving: '||l_function,30);
80: RETURN l_start;
75: pay_in_utils.trace ('l_start',l_start);
76: pay_in_utils.trace ('**************************************************','********************');
77: END IF;
78:
79: pay_in_utils.set_location(g_debug,'Leaving: '||l_function,30);
80: RETURN l_start;
81: --
82: END span_start;
83: END PAY_IN_ROUTES;