APPS.PAY_BALANCE_PKG dependencies on FND_DATE

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

1398: -- now build up the full SQL statement:
1399: --
1400: if (l_data_type = 'D') then
1401: if (l_o_hint is null) then
1402: l_text := 'SELECT fnd_date.date_to_canonical(' ||
1403: l_definition_text || ') FROM ' || l_text;
1404: else
1405: l_text := 'SELECT /*+ '||l_o_hint||
1406: ' */ fnd_date.date_to_canonical(' ||

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

1402: l_text := 'SELECT fnd_date.date_to_canonical(' ||
1403: l_definition_text || ') FROM ' || l_text;
1404: else
1405: l_text := 'SELECT /*+ '||l_o_hint||
1406: ' */ fnd_date.date_to_canonical(' ||
1407: l_definition_text || ') FROM ' || l_text;
1408: end if;
1409: elsif (l_data_type = 'N') then
1410:

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

1499: -- Found a bind variable
1500: --
1501: if (con_type_tab (l_count) = 'D') then
1502: dbms_sql.bind_variable (sql_cursor, con_name_tab (l_count),
1503: fnd_date.canonical_to_date(ltrim(rtrim(con_value_tab (l_count)))));
1504: else
1505: dbms_sql.bind_variable (sql_cursor, con_name_tab (l_count),
1506: ltrim(rtrim(con_value_tab (l_count))));
1507: end if;

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

1939: end if;
1940: dbms_sql.bind_variable
1941: (sql_cursor,
1942: con_name_tab(l_count),
1943: fnd_date.canonical_to_date(ltrim(rtrim(con_value_tab (l_count)))));
1944: else
1945: if g_debug then
1946: hr_utility.set_location ('pay_balance_pkg.process_balance_statement', 55);
1947: end if;

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

2567: end if;
2568: dbms_sql.bind_variable
2569: (sql_cursor,
2570: con_name_tab(l_count),
2571: fnd_date.canonical_to_date(ltrim(rtrim(con_value_tab (l_count)))));
2572: else
2573: if g_debug then
2574: hr_utility.set_location ('pay_balance_pkg.get_run_balance', 55);
2575: end if;

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

7030: end if;
7031: end if;
7032: 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
7033: set_context('BALANCE_DATE'
7034: ,fnd_date.date_to_canonical(p_contexts.balance_date));
7035: p_contexts.prv_balance_date := p_contexts.balance_date;
7036: if p_contexts.balance_date is null then
7037: p_contexts.bd_set := FALSE;
7038: else

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

10076: -- Bug 3364019 added the + 1 to get the correct balance_load_date
10077: --
10078: cursor bal_load_date(p_business_group_id number)
10079: is
10080: select nvl((max(ppa.effective_date)+1),fnd_date.canonical_to_date('0001/01/01')) bal_load_date
10081: from pay_payroll_actions ppa
10082: , pay_action_classifications pac
10083: where ppa.action_type = pac.action_type
10084: and pac.classification_name = 'SEQUENCED'

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

10139: open bal_load_date(each_bg.business_group_id);
10140: fetch bal_load_date into l_bal_load_date;
10141: close bal_load_date;
10142: else
10143: l_bal_load_date := fnd_date.canonical_to_date('0001/01/01');
10144: end if;
10145: --
10146: hr_utility.set_location('pay_balance_pkg.initialise_run_balance', 80);
10147: hr_utility.trace('def_bal: '||to_char(p_defbal_id));