APPS.PAY_BALANCE_PKG dependencies on FND_DATE

Line 1489: l_text := 'SELECT fnd_date.date_to_canonical(' ||

1485: -- now build up the full SQL statement:
1486: --
1487: if (l_data_type = 'D') then
1488: if (l_o_hint is null) then
1489: l_text := 'SELECT fnd_date.date_to_canonical(' ||
1490: l_definition_text || ') FROM ' || l_text;
1491: else
1492: l_text := 'SELECT /*+ '||l_o_hint||
1493: ' */ fnd_date.date_to_canonical(' ||

Line 1493: ' */ fnd_date.date_to_canonical(' ||

1489: l_text := 'SELECT fnd_date.date_to_canonical(' ||
1490: l_definition_text || ') FROM ' || l_text;
1491: else
1492: l_text := 'SELECT /*+ '||l_o_hint||
1493: ' */ fnd_date.date_to_canonical(' ||
1494: l_definition_text || ') FROM ' || l_text;
1495: end if;
1496: elsif (l_data_type = 'N') then
1497:

Line 1590: fnd_date.canonical_to_date(ltrim(rtrim(con_value_tab (l_count)))));

1586: -- Found a bind variable
1587: --
1588: if (con_type_tab (l_count) = 'D') then
1589: dbms_sql.bind_variable (sql_cursor, con_name_tab (l_count),
1590: fnd_date.canonical_to_date(ltrim(rtrim(con_value_tab (l_count)))));
1591: else
1592: dbms_sql.bind_variable (sql_cursor, con_name_tab (l_count),
1593: ltrim(rtrim(con_value_tab (l_count))));
1594: end if;

Line 2112: fnd_date.canonical_to_date(ltrim(rtrim(con_value_tab (l_count)))));

2108: end if;
2109: dbms_sql.bind_variable
2110: (sql_cursor,
2111: con_name_tab(l_count),
2112: fnd_date.canonical_to_date(ltrim(rtrim(con_value_tab (l_count)))));
2113: else
2114: if g_debug then
2115: hr_utility.set_location ('pay_balance_pkg.process_balance_statement', 55);
2116: end if;

Line 2846: fnd_date.canonical_to_date(ltrim(rtrim(con_value_tab (l_count)))));

2842: end if;
2843: dbms_sql.bind_variable
2844: (sql_cursor,
2845: con_name_tab(l_count),
2846: fnd_date.canonical_to_date(ltrim(rtrim(con_value_tab (l_count)))));
2847: else
2848: if g_debug then
2849: hr_utility.set_location ('pay_balance_pkg.get_run_balance', 55);
2850: end if;

Line 7608: ,fnd_date.date_to_canonical(p_contexts.balance_date));

7604: end if;
7605: end if;
7606: if (nvl(p_contexts.balance_date, to_date('0001/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS')) <> nvl(p_contexts.prv_balance_date, to_date('0001/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS'))) then
7607: set_context('BALANCE_DATE'
7608: ,fnd_date.date_to_canonical(p_contexts.balance_date));
7609: p_contexts.prv_balance_date := p_contexts.balance_date;
7610: if p_contexts.balance_date is null then
7611: p_contexts.bd_set := FALSE;
7612: else

Line 10801: select nvl((max(ppa.effective_date)+1),fnd_date.canonical_to_date('0001/01/01')) bal_load_date

10797: -- Bug 3364019 added the + 1 to get the correct balance_load_date
10798: --
10799: cursor bal_load_date(p_business_group_id number)
10800: is
10801: select nvl((max(ppa.effective_date)+1),fnd_date.canonical_to_date('0001/01/01')) bal_load_date
10802: from pay_payroll_actions ppa
10803: , pay_action_classifications pac
10804: where ppa.action_type = pac.action_type
10805: and pac.classification_name = 'SEQUENCED'

Line 10864: l_bal_load_date := fnd_date.canonical_to_date('0001/01/01');

10860: open bal_load_date(each_bg.business_group_id);
10861: fetch bal_load_date into l_bal_load_date;
10862: close bal_load_date;
10863: else
10864: l_bal_load_date := fnd_date.canonical_to_date('0001/01/01');
10865: end if;
10866: --
10867: hr_utility.set_location('pay_balance_pkg.initialise_run_balance', 80);
10868: hr_utility.trace('def_bal: '||to_char(p_defbal_id));