DBA Data[Home] [Help]

APPS.PQP_GB_PSI_FUNCTIONS dependencies on HR_API

Line 1648: --,p_act_start_date => hr_api.g_sot

1644: ,p_eff_start_date => l_eff_start_date
1645: ,p_eff_end_date => l_eff_date
1646: ,p_penserv_date => g_last_app_date
1647: ,p_penserv_mode => l_penserv_mode
1648: --,p_act_start_date => hr_api.g_sot
1649: --,p_act_end_date => l_eff_date
1650: );
1651: END IF; -- p_extract_type <> '1PED'
1652: END IF; -- p_execution_mode = '1REP'

Line 5025: IF NVL(g_person_id, hr_api.g_number) <> ben_ext_person.g_person_id

5021: debug('g_effective_start_date: '||TO_CHAR(g_effective_start_date, 'DD/MON/YYYY'));
5022: debug('g_effective_end_date: '||TO_CHAR(g_effective_end_date, 'DD/MON/YYYY'));
5023: END IF;
5024:
5025: IF NVL(g_person_id, hr_api.g_number) <> ben_ext_person.g_person_id
5026: THEN
5027: g_person_id := ben_ext_person.g_person_id;
5028: g_min_eff_date_exists := 'N';
5029: debug('NVL(g_person_id, hr_api.g_number) <> ben_ext_person.g_person_id',20);

Line 5029: debug('NVL(g_person_id, hr_api.g_number) <> ben_ext_person.g_person_id',20);

5025: IF NVL(g_person_id, hr_api.g_number) <> ben_ext_person.g_person_id
5026: THEN
5027: g_person_id := ben_ext_person.g_person_id;
5028: g_min_eff_date_exists := 'N';
5029: debug('NVL(g_person_id, hr_api.g_number) <> ben_ext_person.g_person_id',20);
5030: END IF;
5031:
5032: -- set the start date of the range to '00:00:00'
5033: -- and set the end date of the range to '23:59:59'