DBA Data[Home] [Help]

APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on HR_API

Line 483: /* Above procedure returns hr_api.g_sot if no records are found in

479: p_attribute18 => NULL,
480: p_attribute19 => NULL,
481: p_attribute20 => NULL);
482:
483: /* Above procedure returns hr_api.g_sot if no records are found in
484: pay_recorded_requests. So, use the implementation date if date
485: fetched above is equal to hr_api.g_sot */
486:
487: IF NVL( ld_start_date, hr_api.g_sot ) <> hr_api.g_sot THEN

Line 485: fetched above is equal to hr_api.g_sot */

481: p_attribute20 => NULL);
482:
483: /* Above procedure returns hr_api.g_sot if no records are found in
484: pay_recorded_requests. So, use the implementation date if date
485: fetched above is equal to hr_api.g_sot */
486:
487: IF NVL( ld_start_date, hr_api.g_sot ) <> hr_api.g_sot THEN
488:
489: lv_start_date := fnd_date.date_to_canonical( ld_start_date );

Line 487: IF NVL( ld_start_date, hr_api.g_sot ) <> hr_api.g_sot THEN

483: /* Above procedure returns hr_api.g_sot if no records are found in
484: pay_recorded_requests. So, use the implementation date if date
485: fetched above is equal to hr_api.g_sot */
486:
487: IF NVL( ld_start_date, hr_api.g_sot ) <> hr_api.g_sot THEN
488:
489: lv_start_date := fnd_date.date_to_canonical( ld_start_date );
490:
491: ELSE

Line 561: END IF; -- ld_start_date <> hr_api.g_sot

557: FROM DUAL;
558:
559: END IF; -- p_gre_id IS NOT NULL
560:
561: END IF; -- ld_start_date <> hr_api.g_sot
562:
563: hr_utility_trace('lv_start_date '||lv_start_date);
564:
565: RETURN lv_start_date ;