APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on FND_DATE

Line 1590: fnd_date.canonical_to_date(p_session_date), -- Bug 6121705, new parameter; needs

1586: IF ((l_retrieval_options <> 'BEE') OR (l_retrieval_options IS NULL))
1587: THEN
1588: process_otlr_employees
1589: (p_bg_id,
1590: fnd_date.canonical_to_date(p_session_date), -- Bug 6121705, new parameter; needs
1591: -- type conversion from VARCHAR2
1592: p_start_date, --fnd_date.canonical_to_date (p_start_date),
1593: p_end_date, --fnd_date.canonical_to_date (p_end_date),
1594: l_where_clause,

Line 1592: p_start_date, --fnd_date.canonical_to_date (p_start_date),

1588: process_otlr_employees
1589: (p_bg_id,
1590: fnd_date.canonical_to_date(p_session_date), -- Bug 6121705, new parameter; needs
1591: -- type conversion from VARCHAR2
1592: p_start_date, --fnd_date.canonical_to_date (p_start_date),
1593: p_end_date, --fnd_date.canonical_to_date (p_end_date),
1594: l_where_clause,
1595: p_retrieval_transaction_code,
1596: l_batch_ref,

Line 1593: p_end_date, --fnd_date.canonical_to_date (p_end_date),

1589: (p_bg_id,
1590: fnd_date.canonical_to_date(p_session_date), -- Bug 6121705, new parameter; needs
1591: -- type conversion from VARCHAR2
1592: p_start_date, --fnd_date.canonical_to_date (p_start_date),
1593: p_end_date, --fnd_date.canonical_to_date (p_end_date),
1594: l_where_clause,
1595: p_retrieval_transaction_code,
1596: l_batch_ref,
1597: l_unique_params,

Line 1608: fnd_date.canonical_to_date (p_start_date),

1604: IF ((l_retrieval_options <> 'OTLR') OR (l_retrieval_options IS NULL))
1605: THEN
1606: process_non_otlr_employees
1607: (p_bg_id,
1608: fnd_date.canonical_to_date (p_start_date),
1609: fnd_date.canonical_to_date (p_end_date),
1610: fnd_date.canonical_to_date (p_session_date),
1611: l_where_clause,
1612: p_retrieval_transaction_code,

Line 1609: fnd_date.canonical_to_date (p_end_date),

1605: THEN
1606: process_non_otlr_employees
1607: (p_bg_id,
1608: fnd_date.canonical_to_date (p_start_date),
1609: fnd_date.canonical_to_date (p_end_date),
1610: fnd_date.canonical_to_date (p_session_date),
1611: l_where_clause,
1612: p_retrieval_transaction_code,
1613: l_batch_ref,

Line 1610: fnd_date.canonical_to_date (p_session_date),

1606: process_non_otlr_employees
1607: (p_bg_id,
1608: fnd_date.canonical_to_date (p_start_date),
1609: fnd_date.canonical_to_date (p_end_date),
1610: fnd_date.canonical_to_date (p_session_date),
1611: l_where_clause,
1612: p_retrieval_transaction_code,
1613: l_batch_ref,
1614: l_unique_params,