DBA Data[Home] [Help]

APPS.PAY_US_TAXBAL_VIEW_PKG dependencies on FND_DATE

Line 47: to fnd_date statements

43: reversal_exists_check, reversal_exists_check_tax.
44: rthakur 11-FEB-1999 40.11 uncommented out nocopy the exit command
45: sdoshi 06-APR-1999 115.3 Flexible Dates Conversion
46: sdoshi 06-APR-1999 115.4 Corrections - closing brackets added
47: to fnd_date statements
48: djoshi 08-apr-1999 Verfied and converted for Canonical
49: Complience of Date
50: AMills 28-Jul-1999 115.7 Added us_gp_multiple_gre_ytd,
51: us_gp_subject_to_tax_gre_ytd

Line 848: || fnd_date.date_to_canonical(p_virtual_date));

844: l_virtual_date := get_virtual_date(l_asg_id, p_virtual_date,
845: l_asg_balance_time,
846: l_asg_vdate_cursor);
847: pay_us_balance_view_pkg.debug_msg(' got l_virtual_date: '
848: || fnd_date.date_to_canonical(p_virtual_date));
849: --
850: -- Dont cache on this get_value call because assignment_id
851: -- is changing.
852: --

Line 1683: fnd_date.date_to_canonical(p_virtual_date));

1679: -- TODO - verify non-null p_gre_id and p_virtual_date??
1680: --
1681: if l_asg_type = 'GRE' then
1682: pay_us_balance_view_pkg.set_context('DATE_EARNED',
1683: fnd_date.date_to_canonical(p_virtual_date));
1684: if (pay_us_balance_view_pkg.get_context('BALANCE_DATE') is NULL)
1685: then
1686: pay_us_balance_view_pkg.set_context('BALANCE_DATE',
1687: fnd_date.date_to_canonical(p_virtual_date));

Line 1687: fnd_date.date_to_canonical(p_virtual_date));

1683: fnd_date.date_to_canonical(p_virtual_date));
1684: if (pay_us_balance_view_pkg.get_context('BALANCE_DATE') is NULL)
1685: then
1686: pay_us_balance_view_pkg.set_context('BALANCE_DATE',
1687: fnd_date.date_to_canonical(p_virtual_date));
1688: end if;
1689: pay_us_balance_view_pkg.debug_msg(
1690: 'us_named_balance_vm GRE mode, set DATE_EARNED context to '
1691: || fnd_date.date_to_canonical(p_virtual_date));

Line 1691: || fnd_date.date_to_canonical(p_virtual_date));

1687: fnd_date.date_to_canonical(p_virtual_date));
1688: end if;
1689: pay_us_balance_view_pkg.debug_msg(
1690: 'us_named_balance_vm GRE mode, set DATE_EARNED context to '
1691: || fnd_date.date_to_canonical(p_virtual_date));
1692: end if;
1693:
1694: /*Bypassed below code for Bug#13512417 for Voluntary Deductions*/
1695:

Line 1941: fnd_date.date_to_canonical(p_virtual_date));

1937: -- TODO - verify non-null p_gre_id and p_virtual_date??
1938: --
1939: if l_asg_type = 'GRE' then
1940: pay_us_balance_view_pkg.set_context('DATE_EARNED',
1941: fnd_date.date_to_canonical(p_virtual_date));
1942: if (pay_us_balance_view_pkg.get_context('BALANCE_DATE') is NULL)
1943: then
1944: pay_us_balance_view_pkg.set_context('BALANCE_DATE',
1945: fnd_date.date_to_canonical(p_virtual_date));

Line 1945: fnd_date.date_to_canonical(p_virtual_date));

1941: fnd_date.date_to_canonical(p_virtual_date));
1942: if (pay_us_balance_view_pkg.get_context('BALANCE_DATE') is NULL)
1943: then
1944: pay_us_balance_view_pkg.set_context('BALANCE_DATE',
1945: fnd_date.date_to_canonical(p_virtual_date));
1946: end if;
1947: pay_us_balance_view_pkg.debug_msg(
1948: 'us_named_balance_vm GRE mode, set DATE_EARNED context to '
1949: || fnd_date.date_to_canonical(p_virtual_date));

Line 1949: || fnd_date.date_to_canonical(p_virtual_date));

1945: fnd_date.date_to_canonical(p_virtual_date));
1946: end if;
1947: pay_us_balance_view_pkg.debug_msg(
1948: 'us_named_balance_vm GRE mode, set DATE_EARNED context to '
1949: || fnd_date.date_to_canonical(p_virtual_date));
1950: end if;
1951: --
1952: -- now we can get the balance!
1953: --

Line 2403: fnd_date.date_to_canonical(l_virtual_date));

2399: l_found boolean;
2400: check_asg number;
2401: begin
2402: pay_us_balance_view_pkg.set_context('DATE_EARNED',
2403: fnd_date.date_to_canonical(l_virtual_date));
2404: if (pay_us_balance_view_pkg.get_context('BALANCE_DATE') is NULL)
2405: then
2406: pay_us_balance_view_pkg.set_context('BALANCE_DATE',
2407: fnd_date.date_to_canonical(p_virtual_date));

Line 2407: fnd_date.date_to_canonical(p_virtual_date));

2403: fnd_date.date_to_canonical(l_virtual_date));
2404: if (pay_us_balance_view_pkg.get_context('BALANCE_DATE') is NULL)
2405: then
2406: pay_us_balance_view_pkg.set_context('BALANCE_DATE',
2407: fnd_date.date_to_canonical(p_virtual_date));
2408: end if;
2409:
2410: select business_group_id
2411: into l_bg_id