DBA Data[Home] [Help]

APPS.PN_REC_EXP_EXTR_FROM_GL_PKG dependencies on FND_DATE

Line 1901: l_as_of_date DATE := fnd_date.canonical_to_date(p_as_of_date);

1897: l_info VARCHAR2(240);
1898: l_counter BINARY_INTEGER := 0;
1899:
1900: /* variables for dates for calling export to Rec pgm */
1901: l_as_of_date DATE := fnd_date.canonical_to_date(p_as_of_date);
1902: l_period_start_date DATE := fnd_date.canonical_to_date(p_period_start_date);
1903: l_period_end_date DATE := fnd_date.canonical_to_date(p_period_end_date);
1904:
1905: /* cursor for currency code */

Line 1902: l_period_start_date DATE := fnd_date.canonical_to_date(p_period_start_date);

1898: l_counter BINARY_INTEGER := 0;
1899:
1900: /* variables for dates for calling export to Rec pgm */
1901: l_as_of_date DATE := fnd_date.canonical_to_date(p_as_of_date);
1902: l_period_start_date DATE := fnd_date.canonical_to_date(p_period_start_date);
1903: l_period_end_date DATE := fnd_date.canonical_to_date(p_period_end_date);
1904:
1905: /* cursor for currency code */
1906: CURSOR curr_code(sob_id NUMBER) IS

Line 1903: l_period_end_date DATE := fnd_date.canonical_to_date(p_period_end_date);

1899:
1900: /* variables for dates for calling export to Rec pgm */
1901: l_as_of_date DATE := fnd_date.canonical_to_date(p_as_of_date);
1902: l_period_start_date DATE := fnd_date.canonical_to_date(p_period_start_date);
1903: l_period_end_date DATE := fnd_date.canonical_to_date(p_period_end_date);
1904:
1905: /* cursor for currency code */
1906: CURSOR curr_code(sob_id NUMBER) IS
1907: select gl_sob.currency_code as CURRENCY_CODE