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 817: || fnd_date.date_to_canonical(p_virtual_date));

813: l_virtual_date := get_virtual_date(l_asg_id, p_virtual_date,
814: l_asg_balance_time,
815: l_asg_vdate_cursor);
816: pay_us_balance_view_pkg.debug_msg(' got l_virtual_date: '
817: || fnd_date.date_to_canonical(p_virtual_date));
818: --
819: -- Dont cache on this get_value call because assignment_id
820: -- is changing.
821: --

Line 1572: fnd_date.date_to_canonical(p_virtual_date));

1568: -- TODO - verify non-null p_gre_id and p_virtual_date??
1569: --
1570: if l_asg_type = 'GRE' then
1571: pay_us_balance_view_pkg.set_context('DATE_EARNED',
1572: fnd_date.date_to_canonical(p_virtual_date));
1573: if (pay_us_balance_view_pkg.get_context('BALANCE_DATE') is NULL)
1574: then
1575: pay_us_balance_view_pkg.set_context('BALANCE_DATE',
1576: fnd_date.date_to_canonical(p_virtual_date));

Line 1576: fnd_date.date_to_canonical(p_virtual_date));

1572: fnd_date.date_to_canonical(p_virtual_date));
1573: if (pay_us_balance_view_pkg.get_context('BALANCE_DATE') is NULL)
1574: then
1575: pay_us_balance_view_pkg.set_context('BALANCE_DATE',
1576: fnd_date.date_to_canonical(p_virtual_date));
1577: end if;
1578: pay_us_balance_view_pkg.debug_msg(
1579: 'us_named_balance_vm GRE mode, set DATE_EARNED context to '
1580: || fnd_date.date_to_canonical(p_virtual_date));

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

1576: fnd_date.date_to_canonical(p_virtual_date));
1577: end if;
1578: pay_us_balance_view_pkg.debug_msg(
1579: 'us_named_balance_vm GRE mode, set DATE_EARNED context to '
1580: || fnd_date.date_to_canonical(p_virtual_date));
1581: end if;
1582: --
1583: -- now we can finally call the balance!
1584: --

Line 1760: fnd_date.date_to_canonical(p_virtual_date));

1756: -- TODO - verify non-null p_gre_id and p_virtual_date??
1757: --
1758: if l_asg_type = 'GRE' then
1759: pay_us_balance_view_pkg.set_context('DATE_EARNED',
1760: fnd_date.date_to_canonical(p_virtual_date));
1761: if (pay_us_balance_view_pkg.get_context('BALANCE_DATE') is NULL)
1762: then
1763: pay_us_balance_view_pkg.set_context('BALANCE_DATE',
1764: fnd_date.date_to_canonical(p_virtual_date));

Line 1764: fnd_date.date_to_canonical(p_virtual_date));

1760: fnd_date.date_to_canonical(p_virtual_date));
1761: if (pay_us_balance_view_pkg.get_context('BALANCE_DATE') is NULL)
1762: then
1763: pay_us_balance_view_pkg.set_context('BALANCE_DATE',
1764: fnd_date.date_to_canonical(p_virtual_date));
1765: end if;
1766: pay_us_balance_view_pkg.debug_msg(
1767: 'us_named_balance_vm GRE mode, set DATE_EARNED context to '
1768: || fnd_date.date_to_canonical(p_virtual_date));

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

1764: fnd_date.date_to_canonical(p_virtual_date));
1765: end if;
1766: pay_us_balance_view_pkg.debug_msg(
1767: 'us_named_balance_vm GRE mode, set DATE_EARNED context to '
1768: || fnd_date.date_to_canonical(p_virtual_date));
1769: end if;
1770: --
1771: -- now we can get the balance!
1772: --

Line 2142: fnd_date.date_to_canonical(l_virtual_date));

2138: l_found boolean;
2139: check_asg number;
2140: begin
2141: pay_us_balance_view_pkg.set_context('DATE_EARNED',
2142: fnd_date.date_to_canonical(l_virtual_date));
2143: if (pay_us_balance_view_pkg.get_context('BALANCE_DATE') is NULL)
2144: then
2145: pay_us_balance_view_pkg.set_context('BALANCE_DATE',
2146: fnd_date.date_to_canonical(p_virtual_date));

Line 2146: fnd_date.date_to_canonical(p_virtual_date));

2142: fnd_date.date_to_canonical(l_virtual_date));
2143: if (pay_us_balance_view_pkg.get_context('BALANCE_DATE') is NULL)
2144: then
2145: pay_us_balance_view_pkg.set_context('BALANCE_DATE',
2146: fnd_date.date_to_canonical(p_virtual_date));
2147: end if;
2148:
2149: select business_group_id
2150: into l_bg_id