DBA Data[Home] [Help]

APPS.HR_H2PI_DOWNLOAD dependencies on FND_DATE

Line 312: l_start_date CONSTANT DATE := fnd_date.canonical_to_date(p_transfer_start_date);

308: --
309: x varchar2(10000);
310: y number(20);
311: --
312: l_start_date CONSTANT DATE := fnd_date.canonical_to_date(p_transfer_start_date);
313: l_end_date CONSTANT DATE := fnd_date.canonical_to_date(p_transfer_end_date);
314: l_request_id NUMBER(15);
315: lengthtoread NUMBER(10);
316: cloblength NUMBER(20);

Line 313: l_end_date CONSTANT DATE := fnd_date.canonical_to_date(p_transfer_end_date);

309: x varchar2(10000);
310: y number(20);
311: --
312: l_start_date CONSTANT DATE := fnd_date.canonical_to_date(p_transfer_start_date);
313: l_end_date CONSTANT DATE := fnd_date.canonical_to_date(p_transfer_end_date);
314: l_request_id NUMBER(15);
315: lengthtoread NUMBER(10);
316: cloblength NUMBER(20);
317: l_query_string varchar2(10000);