eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PSF_BUS dependencies on HR_PSF_SHD

Line 270: and hr_psf_shd.get_availability_status(pos.availability_status_id,p_business_group_id) ='ACTIVE';

266: select count(*)
267: from hr_all_positions_f pos, per_shared_types sht
268: where pos.position_id = p_position_id
269: and pos.effective_start_date < p_effective_start_date
270: and hr_psf_shd.get_availability_status(pos.availability_status_id,p_business_group_id) ='ACTIVE';
271: -- cursor to find out the next active row's effective start date
272: cursor next_active_row(p_position_id number,p_effective_start_date date) is
273: select effective_start_date
274: from hr_all_positions_f pos, per_shared_types sht

Line 277: and hr_psf_shd.get_availability_status(pos.availability_status_id,p_business_group_id) ='ACTIVE';

273: select effective_start_date
274: from hr_all_positions_f pos, per_shared_types sht
275: where pos.position_id = p_position_id
276: and pos.effective_start_date > p_effective_start_date
277: and hr_psf_shd.get_availability_status(pos.availability_status_id,p_business_group_id) ='ACTIVE';
278: -- cursor to find the first active row
279: cursor valid_first_active_row(p_position_id number,p_effective_end_date date) is
280: select min(effective_start_date)
281: from hr_all_positions_f pos

Line 283: and hr_psf_shd.get_availability_status(pos.availability_status_id,p_business_group_id) ='ACTIVE';

279: cursor valid_first_active_row(p_position_id number,p_effective_end_date date) is
280: select min(effective_start_date)
281: from hr_all_positions_f pos
282: where effective_start_date > p_effective_end_date + 1
283: and hr_psf_shd.get_availability_status(pos.availability_status_id,p_business_group_id) ='ACTIVE';
284: l_active_rows number;
285: l_current_row_stat varchar2(30);
286: l_next_active_date date;
287: l_proc varchar2(72) ;

Line 336: l_current_row_stat := hr_psf_shd.get_availability_status(p_availability_status_id,p_business_group_id);

332: fetch pos_active_rows into l_active_rows ;
333: close pos_active_rows ;
334: if l_active_rows = 0 then
335: -- status of the current row is found
336: l_current_row_stat := hr_psf_shd.get_availability_status(p_availability_status_id,p_business_group_id);
337: if l_current_row_stat ='ACTIVE' then
338: -- current row is going to be first active row date effective is to be changed
339: -- to the effective start date of the first active row
340: p_new_date_effective := p_effective_start_date ;

Line 371: l_current_row_stat := hr_psf_shd.get_availability_status(p_availability_status_id,p_business_group_id);

367: -- nothing should be done as first active row is not going to be deleted
368: null;
369: else
370: -- status of the current row is found
371: l_current_row_stat := hr_psf_shd.get_availability_status(p_availability_status_id,p_business_group_id);
372: if l_current_row_stat ='ACTIVE' then
373: -- current row is active row itself, so nothing is to be changed
374: p_chg_date_effective := FALSE;
375: else

Line 442: select hr_psf_shd.get_availability_status(pos.availability_status_id,p_business_group_id)

438: TYPE tran_stat IS table of stat_matrix
439: index by binary_integer ;
440: chk_stat tran_stat;
441: cursor csr_stat(p_position_id number,p_effective_start_date date,p_business_group_id number) is
442: select hr_psf_shd.get_availability_status(pos.availability_status_id,p_business_group_id)
443: from hr_all_positions_f pos
444: where pos.position_id = p_position_id
445: and pos.effective_start_date = p_effective_start_date;
446: cursor csr_prev(p_position_id number, p_effective_start_date date) is

Line 496: l_present_stat := hr_psf_shd.get_availability_status(p_availability_status_id

492: l_proc := g_package||'chk_avail_stat';
493: --
494: end if;
495: --
496: l_present_stat := hr_psf_shd.get_availability_status(p_availability_status_id
497: ,p_business_group_id);
498: --
499: -- populating the status transition matrix
500: --

Line 575: l_prev_stat := hr_psf_shd.get_availability_status( p_old_avail_status_id,

571: elsif p_datetrack_mode = 'UPDATE' or
572: p_datetrack_mode = 'UPDATE_OVERRIDE' then
573: -- old rec values are used for previous status and future stat is
574: -- fetched from the database
575: l_prev_stat := hr_psf_shd.get_availability_status( p_old_avail_status_id,
576: p_business_group_id) ;
577: l_future_stat := NULL ;
578: elsif p_datetrack_mode = 'UPDATE_CHANGE_INSERT' then -- 'INSERT after UPDATE' as seen on GUI
579: -- old rec values are used for previous status and future stat is

Line 581: l_prev_stat := hr_psf_shd.get_availability_status( p_old_avail_status_id,

577: l_future_stat := NULL ;
578: elsif p_datetrack_mode = 'UPDATE_CHANGE_INSERT' then -- 'INSERT after UPDATE' as seen on GUI
579: -- old rec values are used for previous status and future stat is
580: -- fetched from the database
581: l_prev_stat := hr_psf_shd.get_availability_status( p_old_avail_status_id,
582: p_business_group_id) ;
583:
584: open csr_future(p_position_id,p_validation_start_date) ;
585: fetch csr_future into l_future_esd ;

Line 761: l_api_updating := hr_psf_shd.api_updating

757: -- Only proceed with validation if :
758: -- a) The current g_old_rec is current and
759: -- b) The value for special ceiling step has changed
760: --
761: l_api_updating := hr_psf_shd.api_updating
762: (p_position_id => p_position_id
763: ,p_effective_date => p_effective_date
764: ,p_object_version_number => p_object_version_number
765: );

Line 771: nvl(hr_psf_shd.g_old_rec.entry_step_id, hr_api.g_number) <>

767: hr_utility.set_location(l_proc, 30);
768: end if;
769: --
770: if ((l_api_updating and
771: nvl(hr_psf_shd.g_old_rec.entry_step_id, hr_api.g_number) <>
772: nvl(p_entry_step_id, hr_api.g_number)) or
773: (NOT l_api_updating)) then
774: if g_debug then
775: hr_utility.set_location(l_proc, 40);

Line 917: l_api_updating := hr_psf_shd.api_updating

913: -- Only proceed with validation if :
914: -- a) The current g_old_rec is current and
915: -- b) The value for grade has changed
916: --
917: l_api_updating := hr_psf_shd.api_updating
918: (p_position_id => p_position_id
919: ,p_effective_date => p_effective_date
920: ,p_object_version_number => p_object_version_number
921: );

Line 927: nvl(hr_psf_shd.g_old_rec.entry_grade_id, hr_api.g_number) <>

923: hr_utility.set_location(l_proc, 30);
924: end if;
925: --
926: if ((l_api_updating and
927: nvl(hr_psf_shd.g_old_rec.entry_grade_id, hr_api.g_number) <>
928: nvl(p_entry_grade_id, hr_api.g_number)) or
929: (NOT l_api_updating)) then
930: if g_debug then
931: hr_utility.set_location(l_proc, 40);

Line 1047: l_api_updating := hr_psf_shd.api_updating

1043: -- Only proceed with validation if :
1044: -- a) The current g_old_rec is current and
1045: -- b) The value for grade has changed
1046: --
1047: l_api_updating := hr_psf_shd.api_updating
1048: (p_position_id => p_position_id
1049: ,p_effective_date => p_effective_date
1050: ,p_object_version_number => p_object_version_number
1051: );

Line 1057: nvl(hr_psf_shd.g_old_rec.entry_grade_rule_id, hr_api.g_number) <>

1053: hr_utility.set_location(l_proc, 30);
1054: end if;
1055: --
1056: if ((l_api_updating and
1057: nvl(hr_psf_shd.g_old_rec.entry_grade_rule_id, hr_api.g_number) <>
1058: nvl(p_entry_grade_rule_id, hr_api.g_number)) or
1059: (NOT l_api_updating)) then
1060: if g_debug then
1061: hr_utility.set_location(l_proc, 40);

Line 1185: l_api_updating := hr_psf_shd.api_updating

1181: if g_debug then
1182: hr_utility.set_location(l_proc, 20);
1183: end if;
1184: --
1185: l_api_updating := hr_psf_shd.api_updating
1186: (p_position_id => p_position_id
1187: ,p_effective_date => p_effective_date
1188: ,p_object_version_number => p_object_version_number
1189: );

Line 1195: (nvl(hr_psf_shd.g_old_rec.pay_freq_payroll_id, hr_api.g_number)

1191: hr_utility.set_location(l_proc, 30);
1192: end if;
1193: --
1194: if (l_api_updating and
1195: (nvl(hr_psf_shd.g_old_rec.pay_freq_payroll_id, hr_api.g_number)
1196: <> nvl(p_pay_freq_payroll_id, hr_api.g_number))
1197: )
1198: or NOT l_api_updating
1199: then

Line 1365: l_api_updating := hr_psf_shd.api_updating

1361: if g_debug then
1362: hr_utility.set_location(l_proc, 60);
1363: end if;
1364: --
1365: l_api_updating := hr_psf_shd.api_updating
1366: (p_position_id => p_position_id
1367: ,p_effective_date => p_effective_date
1368: ,p_object_version_number => p_object_version_number
1369: );

Line 1375: (nvl(hr_psf_shd.g_old_rec.position_definition_id, hr_api.g_number)

1371: hr_utility.set_location(l_proc, 70);
1372: end if;
1373: --
1374: if (l_api_updating and
1375: (nvl(hr_psf_shd.g_old_rec.position_definition_id, hr_api.g_number)
1376: <> nvl(p_position_definition_id, hr_api.g_number))
1377: )
1378: or NOT l_api_updating
1379: then

Line 1494: l_api_updating := hr_psf_shd.api_updating

1490: if g_debug then
1491: hr_utility.set_location(l_proc, 20);
1492: end if;
1493: --
1494: l_api_updating := hr_psf_shd.api_updating
1495: (p_position_id => p_position_id
1496: ,p_effective_date => p_effective_date
1497: ,p_object_version_number => p_object_version_number
1498: );

Line 1504: (nvl(hr_psf_shd.g_old_rec.name, hr_api.g_varchar2)

1500: hr_utility.set_location(l_proc, 30);
1501: end if;
1502: --
1503: if (l_api_updating and
1504: (nvl(hr_psf_shd.g_old_rec.name, hr_api.g_varchar2)
1505: <> nvl(p_name, hr_api.g_varchar2))
1506: )
1507: or NOT l_api_updating
1508: then

Line 1617: l_api_updating := hr_psf_shd.api_updating

1613: -- b) The working hours value has changed or
1614: -- c) The frequency value has changed
1615: --
1616: --
1617: l_api_updating := hr_psf_shd.api_updating
1618: (p_position_id => p_position_id
1619: ,p_effective_date => p_effective_date
1620: ,p_object_version_number => p_object_version_number);
1621: --

Line 1623: (nvl(hr_psf_shd.g_old_rec.working_hours,hr_api.g_number) <>

1619: ,p_effective_date => p_effective_date
1620: ,p_object_version_number => p_object_version_number);
1621: --
1622: if ((l_api_updating and
1623: (nvl(hr_psf_shd.g_old_rec.working_hours,hr_api.g_number) <>
1624: nvl(p_working_hours,hr_api.g_number) or
1625: (nvl(hr_psf_shd.g_old_rec.frequency,hr_api.g_varchar2) <>
1626: nvl(p_frequency,hr_api.g_varchar2)))) or
1627: (NOT l_api_updating)) then

Line 1625: (nvl(hr_psf_shd.g_old_rec.frequency,hr_api.g_varchar2) <>

1621: --
1622: if ((l_api_updating and
1623: (nvl(hr_psf_shd.g_old_rec.working_hours,hr_api.g_number) <>
1624: nvl(p_working_hours,hr_api.g_number) or
1625: (nvl(hr_psf_shd.g_old_rec.frequency,hr_api.g_varchar2) <>
1626: nvl(p_frequency,hr_api.g_varchar2)))) or
1627: (NOT l_api_updating)) then
1628: --
1629: -- Check for values consistency

Line 1902: l_api_updating := hr_psf_shd.api_updating

1898: -- Only proceed with validation if :
1899: -- a) The current g_old_rec is current and
1900: -- b) The date_end value has changed
1901: --
1902: l_api_updating := hr_psf_shd.api_updating
1903: (p_position_id => p_position_id
1904: ,p_effective_date => p_effective_date
1905: ,p_object_version_number => p_object_version_number);
1906: --

Line 1940: (hr_psf_shd.g_old_rec.date_end <> p_date_end) or

1936: hr_utility.raise_error;
1937: end if;
1938: --
1939: if (((l_api_updating and
1940: (hr_psf_shd.g_old_rec.date_end <> p_date_end) or
1941: (hr_psf_shd.g_old_rec.date_effective <> p_date_effective)) or
1942: (NOT l_api_updating))) then
1943: --
1944: -- Check that date_effective <= date_end

Line 1941: (hr_psf_shd.g_old_rec.date_effective <> p_date_effective)) or

1937: end if;
1938: --
1939: if (((l_api_updating and
1940: (hr_psf_shd.g_old_rec.date_end <> p_date_end) or
1941: (hr_psf_shd.g_old_rec.date_effective <> p_date_effective)) or
1942: (NOT l_api_updating))) then
1943: --
1944: -- Check that date_effective <= date_end
1945: --

Line 1980: nvl(hr_psf_shd.g_old_rec.effective_start_date, hr_api.g_date)) then

1976: hr_utility.raise_error;
1977: end if;
1978: --
1979: if (nvl(p_date_effective, hr_api.g_date) <>
1980: nvl(hr_psf_shd.g_old_rec.effective_start_date, hr_api.g_date)) then
1981: -- find if date_Effective can be modified
1982: --
1983: DE_Update_properties(
1984: p_position_id => p_position_id,

Line 1985: p_effective_Start_Date => hr_psf_shd.g_old_rec.effective_start_date,

1981: -- find if date_Effective can be modified
1982: --
1983: DE_Update_properties(
1984: p_position_id => p_position_id,
1985: p_effective_Start_Date => hr_psf_shd.g_old_rec.effective_start_date,
1986: p_updateable => l_updateable,
1987: p_lower_limit => l_ll,
1988: p_upper_limit => l_ul);
1989: --

Line 2085: l_api_updating := hr_psf_shd.api_updating

2081: end if;
2082: --
2083: -- Check if the position is being updated.
2084: --
2085: l_api_updating := hr_psf_shd.api_updating
2086: (p_position_id => p_position_id
2087: ,p_effective_date => p_effective_date
2088: ,p_object_version_number => p_object_version_number
2089: );

Line 2099: nvl(hr_psf_shd.g_old_rec.job_id,

2095: -- a) The current g_old_rec is current and
2096: -- b) The value for job has changed
2097: --
2098: if ((l_api_updating and
2099: nvl(hr_psf_shd.g_old_rec.job_id,
2100: hr_api.g_number) <> nvl(p_job_id, hr_api.g_number))
2101: or
2102: NOT l_api_updating) then
2103: if g_debug then

Line 2222: l_api_updating := hr_psf_shd.api_updating

2218: -- Only proceed with validation if :
2219: -- a) The current g_old_rec is current and
2220: -- b) The value for organization_id has changed
2221: --
2222: l_api_updating := hr_psf_shd.api_updating
2223: (p_position_id => p_position_id
2224: ,p_effective_date => p_effective_date
2225: ,p_object_version_number => p_object_version_number
2226: );

Line 2232: hr_psf_shd.g_old_rec.organization_id <> p_organization_id)

2228: hr_utility.set_location(l_proc, 30);
2229: end if;
2230: --
2231: if (l_api_updating and
2232: hr_psf_shd.g_old_rec.organization_id <> p_organization_id)
2233: or
2234: NOT l_api_updating
2235: then
2236: if g_debug then

Line 2361: l_api_updating := hr_psf_shd.api_updating

2357: (p_api_name => l_proc
2358: ,p_argument => 'validation end date'
2359: ,p_argument_value => p_validation_end_date);
2360: --
2361: l_api_updating := hr_psf_shd.api_updating
2362: (p_position_id => p_position_id
2363: ,p_effective_date => p_effective_date
2364: ,p_object_version_number => p_object_version_number);
2365: --

Line 2370: hr_psf_shd.g_old_rec.successor_position_id <>

2366: --
2367: -- Check for valid successor position id
2368: --
2369: if ((l_api_updating and
2370: hr_psf_shd.g_old_rec.successor_position_id <>
2371: p_successor_position_id) or
2372: (NOT l_api_updating)) then
2373: --
2374: if g_debug then

Line 2477: l_api_updating := hr_psf_shd.api_updating

2473: (p_api_name => l_proc
2474: ,p_argument => 'effective date'
2475: ,p_argument_value => p_effective_date);
2476: --
2477: l_api_updating := hr_psf_shd.api_updating
2478: (p_position_id => p_position_id
2479: ,p_effective_date => p_effective_date
2480: ,p_object_version_number => p_object_version_number);
2481: --

Line 2496: hr_psf_shd.g_old_rec.relief_position_id <>

2492: --
2493: -- Check for valid successor position id
2494: --
2495: if ((l_api_updating and
2496: hr_psf_shd.g_old_rec.relief_position_id <>
2497: p_relief_position_id) or
2498: (NOT l_api_updating)) then
2499: --
2500: if g_debug then

Line 2587: l_api_updating := hr_psf_shd.api_updating

2583: -- Only proceed with validation if :
2584: -- a) The current g_old_rec is current and
2585: -- b) The value for location_id has changed
2586: --
2587: l_api_updating := hr_psf_shd.api_updating
2588: (p_position_id => p_position_id
2589: ,p_effective_date => p_effective_date
2590: ,p_object_version_number => p_object_version_number
2591: );

Line 2597: nvl(hr_psf_shd.g_old_rec.location_id, hr_api.g_number) <>

2593: hr_utility.set_location('Entering:'|| l_proc, 30);
2594: end if;
2595: --
2596: if ((l_api_updating and
2597: nvl(hr_psf_shd.g_old_rec.location_id, hr_api.g_number) <>
2598: nvl(p_location_id, hr_api.g_number)) or
2599: (NOT l_api_updating))
2600: then
2601: --

Line 2694: l_api_updating := hr_psf_shd.api_updating

2690: if g_debug then
2691: hr_utility.set_location(l_proc, 2);
2692: end if;
2693: --
2694: l_api_updating := hr_psf_shd.api_updating
2695: (p_position_id => p_position_id
2696: ,p_effective_date => p_effective_date
2697: ,p_object_version_number => p_object_version_number);
2698: --

Line 2704: (hr_psf_shd.g_old_rec.position_definition_id <>

2700: hr_utility.set_location(l_proc, 3);
2701: end if;
2702: --
2703: if ((l_api_updating and
2704: (hr_psf_shd.g_old_rec.position_definition_id <>
2705: p_position_definition_id)) or
2706: (NOT l_api_updating)) then
2707: --
2708: if g_debug then

Line 2791: l_api_updating := hr_psf_shd.api_updating

2787: -- a) The current g_old_rec is current and
2788: -- b) The probation_period value has changed
2789: -- c) The probation_period_unit_cd value has changed
2790: --
2791: l_api_updating := hr_psf_shd.api_updating
2792: (p_position_id => p_position_id
2793: ,p_effective_date => p_effective_date
2794: ,p_object_version_number => p_object_version_number);
2795: --

Line 2797: (nvl(hr_psf_shd.g_old_rec.probation_period,hr_api.g_number) <>

2793: ,p_effective_date => p_effective_date
2794: ,p_object_version_number => p_object_version_number);
2795: --
2796: if ((l_api_updating and
2797: (nvl(hr_psf_shd.g_old_rec.probation_period,hr_api.g_number) <>
2798: nvl(p_probation_period,hr_api.g_number)) or
2799: (nvl(hr_psf_shd.g_old_rec.probation_period_unit_cd,hr_api.g_varchar2) <>
2800: nvl(p_probation_period_unit_cd,hr_api.g_varchar2))) or
2801: (NOT l_api_updating)) then

Line 2799: (nvl(hr_psf_shd.g_old_rec.probation_period_unit_cd,hr_api.g_varchar2) <>

2795: --
2796: if ((l_api_updating and
2797: (nvl(hr_psf_shd.g_old_rec.probation_period,hr_api.g_number) <>
2798: nvl(p_probation_period,hr_api.g_number)) or
2799: (nvl(hr_psf_shd.g_old_rec.probation_period_unit_cd,hr_api.g_varchar2) <>
2800: nvl(p_probation_period_unit_cd,hr_api.g_varchar2))) or
2801: (NOT l_api_updating)) then
2802: --
2803: -- Check for values consistency

Line 2903: l_api_updating := hr_psf_shd.api_updating

2899: -- a) The current g_old_rec is current and
2900: -- b) The time_normal_start value has changed
2901: -- c) The time_normal_finish value has changed
2902: --
2903: l_api_updating := hr_psf_shd.api_updating
2904: (p_position_id => p_position_id
2905: ,p_effective_Date => p_effective_date
2906: ,p_object_version_number => p_object_version_number);
2907: --

Line 2909: (nvl(hr_psf_shd.g_old_rec.time_normal_start,hr_api.g_varchar2) <>

2905: ,p_effective_Date => p_effective_date
2906: ,p_object_version_number => p_object_version_number);
2907: --
2908: if ((l_api_updating and
2909: (nvl(hr_psf_shd.g_old_rec.time_normal_start,hr_api.g_varchar2) <>
2910: nvl(p_time_normal_start,hr_api.g_varchar2) or
2911: (nvl(hr_psf_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
2912: nvl(p_time_normal_finish,hr_api.g_varchar2)))) or
2913: (NOT l_api_updating)) then

Line 2911: (nvl(hr_psf_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>

2907: --
2908: if ((l_api_updating and
2909: (nvl(hr_psf_shd.g_old_rec.time_normal_start,hr_api.g_varchar2) <>
2910: nvl(p_time_normal_start,hr_api.g_varchar2) or
2911: (nvl(hr_psf_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
2912: nvl(p_time_normal_finish,hr_api.g_varchar2)))) or
2913: (NOT l_api_updating)) then
2914: --
2915: -- Check for values consistency

Line 3019: l_api_updating := hr_psf_shd.api_updating

3015: -- Only proceed with validation if :
3016: -- a) The current g_old_rec is current and
3017: -- b) The value for position_transaction_id has changed
3018: --
3019: l_api_updating := hr_psf_shd.api_updating
3020: (p_position_id => p_position_id
3021: ,p_effective_date => p_effective_date
3022: ,p_object_version_number => p_object_version_number
3023: );

Line 3029: nvl(hr_psf_shd.g_old_rec.position_transaction_id, hr_api.g_number) <>

3025: hr_utility.set_location(l_proc, 30);
3026: end if;
3027: --
3028: if ((l_api_updating and
3029: nvl(hr_psf_shd.g_old_rec.position_transaction_id, hr_api.g_number) <>
3030: nvl(p_position_transaction_id, hr_api.g_number)) or
3031: (NOT l_api_updating)) then
3032: if g_debug then
3033: hr_utility.set_location(l_proc, 40);

Line 3149: l_api_updating := hr_psf_shd.api_updating

3145: (p_api_name => l_proc
3146: ,p_argument => 'validation end date'
3147: ,p_argument_value => p_validation_end_date);
3148: --
3149: l_api_updating := hr_psf_shd.api_updating
3150: (p_position_id => p_position_id
3151: ,p_effective_date => p_effective_date
3152: ,p_object_version_number => p_object_version_number);
3153: --

Line 3158: hr_psf_shd.g_old_rec.supervisor_position_id <>

3154: --
3155: -- Check for valid successor position id
3156: --
3157: if ((l_api_updating and
3158: hr_psf_shd.g_old_rec.supervisor_position_id <>
3159: p_supervisor_position_id) or
3160: (NOT l_api_updating)) then
3161: --
3162: if g_debug then

Line 3275: l_api_updating := hr_psf_shd.api_updating

3271: (p_api_name => l_proc
3272: ,p_argument => 'validation end date'
3273: ,p_argument_value => p_validation_end_date);
3274: --
3275: l_api_updating := hr_psf_shd.api_updating
3276: (p_position_id => p_position_id
3277: ,p_effective_date => p_effective_date
3278: ,p_object_version_number => p_object_version_number);
3279: --

Line 3284: hr_psf_shd.g_old_rec.prior_position_id <>

3280: --
3281: -- Check for valid successor position id
3282: --
3283: if ((l_api_updating and
3284: hr_psf_shd.g_old_rec.prior_position_id <>
3285: p_prior_position_id) or
3286: (NOT l_api_updating)) then
3287: --
3288: if g_debug then

Line 3355: l_api_updating := hr_psf_shd.api_updating

3351: l_proc := g_package||'chk_work_term_end_month_cd';
3352: hr_utility.set_location('Entering:'||l_proc, 5);
3353: end if;
3354: --
3355: l_api_updating := hr_psf_shd.api_updating
3356: (p_position_id => p_position_id
3357: ,p_effective_date => p_effective_date
3358: ,p_object_version_number => p_object_version_number);
3359: --

Line 3362: <> nvl(hr_psf_shd.g_old_rec.work_term_end_month_cd,hr_api.g_varchar2)

3358: ,p_object_version_number => p_object_version_number);
3359: --
3360: if (l_api_updating
3361: and p_work_term_end_month_cd
3362: <> nvl(hr_psf_shd.g_old_rec.work_term_end_month_cd,hr_api.g_varchar2)
3363: or not l_api_updating)
3364: and p_work_term_end_month_cd is not null then
3365: --
3366: -- check if value of lookup falls within lookup type.

Line 3438: l_api_updating := hr_psf_shd.api_updating

3434: l_proc := g_package||'chk_work_term_end_day_cd';
3435: hr_utility.set_location('Entering:'||l_proc, 5);
3436: end if;
3437: --
3438: l_api_updating := hr_psf_shd.api_updating
3439: (p_position_id => p_position_id
3440: ,p_effective_date => p_effective_date
3441: ,p_object_version_number => p_object_version_number);
3442: --

Line 3445: <> nvl(hr_psf_shd.g_old_rec.work_term_end_day_cd,hr_api.g_varchar2)

3441: ,p_object_version_number => p_object_version_number);
3442: --
3443: if (l_api_updating
3444: and p_work_term_end_day_cd
3445: <> nvl(hr_psf_shd.g_old_rec.work_term_end_day_cd,hr_api.g_varchar2)
3446: or not l_api_updating)
3447: and p_work_term_end_day_cd is not null then
3448: --
3449: -- check if value of lookup falls within lookup type.

Line 3510: l_api_updating := hr_psf_shd.api_updating

3506: (p_api_name => l_proc
3507: ,p_argument => 'effective date'
3508: ,p_argument_value => p_effective_date);
3509: --
3510: l_api_updating := hr_psf_shd.api_updating
3511: (p_position_id => p_position_id
3512: ,p_effective_date => p_effective_date
3513: ,p_object_version_number => p_object_version_number);
3514: --

Line 3517: <> nvl(hr_psf_shd.g_old_rec.position_type,hr_api.g_varchar2)

3513: ,p_object_version_number => p_object_version_number);
3514: --
3515: if (l_api_updating
3516: and p_position_type
3517: <> nvl(hr_psf_shd.g_old_rec.position_type,hr_api.g_varchar2)
3518: or not l_api_updating)
3519: and p_position_type is not null then
3520: --
3521: -- check if value of lookup falls within lookup type.

Line 3592: l_api_updating := hr_psf_shd.api_updating

3588: l_proc := g_package||'chk_work_period_type_cd';
3589: hr_utility.set_location('Entering:'||l_proc, 5);
3590: end if;
3591: --
3592: l_api_updating := hr_psf_shd.api_updating
3593: (p_position_id => p_position_id
3594: ,p_effective_date => p_effective_date
3595: ,p_object_version_number => p_object_version_number);
3596: --

Line 3599: <> nvl(hr_psf_shd.g_old_rec.work_period_type_cd,hr_api.g_varchar2)

3595: ,p_object_version_number => p_object_version_number);
3596: --
3597: if (l_api_updating
3598: and p_work_period_type_cd
3599: <> nvl(hr_psf_shd.g_old_rec.work_period_type_cd,hr_api.g_varchar2)
3600: or not l_api_updating)
3601: and p_work_period_type_cd is not null then
3602: --
3603: -- check if value of lookup falls within lookup type.

Line 3674: l_api_updating := hr_psf_shd.api_updating

3670: l_proc := g_package||'chk_works_council_approval_flg';
3671: hr_utility.set_location('Entering:'||l_proc, 5);
3672: end if;
3673: --
3674: l_api_updating := hr_psf_shd.api_updating
3675: (p_position_id => p_position_id
3676: ,p_effective_date => p_effective_date
3677: ,p_object_version_number => p_object_version_number);
3678: --

Line 3681: <> nvl(hr_psf_shd.g_old_rec.works_council_approval_flag,hr_api.g_varchar2)

3677: ,p_object_version_number => p_object_version_number);
3678: --
3679: if (l_api_updating
3680: and p_works_council_approval_flag
3681: <> nvl(hr_psf_shd.g_old_rec.works_council_approval_flag,hr_api.g_varchar2)
3682: or not l_api_updating)
3683: and p_works_council_approval_flag is not null then
3684: --
3685: -- check if value of lookup falls within lookup type.

Line 3757: l_api_updating := hr_psf_shd.api_updating

3753: l_proc := g_package||'chk_term_start_month_cd';
3754: hr_utility.set_location('Entering:'||l_proc, 5);
3755: end if;
3756: --
3757: l_api_updating := hr_psf_shd.api_updating
3758: (p_position_id => p_position_id
3759: ,p_effective_date => p_effective_date
3760: ,p_object_version_number => p_object_version_number);
3761: --

Line 3764: <> nvl(hr_psf_shd.g_old_rec.term_start_month_cd,hr_api.g_varchar2)

3760: ,p_object_version_number => p_object_version_number);
3761: --
3762: if (l_api_updating
3763: and p_term_start_month_cd
3764: <> nvl(hr_psf_shd.g_old_rec.term_start_month_cd,hr_api.g_varchar2)
3765: or not l_api_updating)
3766: and p_term_start_month_cd is not null then
3767: --
3768: -- check if value of lookup falls within lookup type.

Line 3840: l_api_updating := hr_psf_shd.api_updating

3836: l_proc := g_package||'chk_term_start_day_cd';
3837: hr_utility.set_location('Entering:'||l_proc, 5);
3838: end if;
3839: --
3840: l_api_updating := hr_psf_shd.api_updating
3841: (p_position_id => p_position_id
3842: ,p_effective_date => p_effective_date
3843: ,p_object_version_number => p_object_version_number);
3844: --

Line 3847: <> nvl(hr_psf_shd.g_old_rec.term_start_day_cd,hr_api.g_varchar2)

3843: ,p_object_version_number => p_object_version_number);
3844: --
3845: if (l_api_updating
3846: and p_term_start_day_cd
3847: <> nvl(hr_psf_shd.g_old_rec.term_start_day_cd,hr_api.g_varchar2)
3848: or not l_api_updating)
3849: and p_term_start_day_cd is not null then
3850: --
3851: -- check if value of lookup falls within lookup type.

Line 3923: l_api_updating := hr_psf_shd.api_updating

3919: l_proc := g_package||'chk_seasonal_flag';
3920: hr_utility.set_location('Entering:'||l_proc, 5);
3921: end if;
3922: --
3923: l_api_updating := hr_psf_shd.api_updating
3924: (p_position_id => p_position_id
3925: ,p_effective_date => p_effective_date
3926: ,p_object_version_number => p_object_version_number);
3927: --

Line 3930: <> nvl(hr_psf_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)

3926: ,p_object_version_number => p_object_version_number);
3927: --
3928: if (l_api_updating
3929: and p_seasonal_flag
3930: <> nvl(hr_psf_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)
3931: or not l_api_updating)
3932: and p_seasonal_flag is not null then
3933: --
3934: -- check if value of lookup falls within lookup type.

Line 4005: l_api_updating := hr_psf_shd.api_updating

4001: l_proc := g_package||'chk_review_flag';
4002: hr_utility.set_location('Entering:'||l_proc, 5);
4003: end if;
4004: --
4005: l_api_updating := hr_psf_shd.api_updating
4006: (p_position_id => p_position_id
4007: ,p_effective_date => p_effective_date
4008: ,p_object_version_number => p_object_version_number);
4009: --

Line 4012: <> nvl(hr_psf_shd.g_old_rec.review_flag,hr_api.g_varchar2)

4008: ,p_object_version_number => p_object_version_number);
4009: --
4010: if (l_api_updating
4011: and p_review_flag
4012: <> nvl(hr_psf_shd.g_old_rec.review_flag,hr_api.g_varchar2)
4013: or not l_api_updating)
4014: and p_review_flag is not null then
4015: --
4016: -- check if value of lookup falls within lookup type.

Line 4087: l_api_updating := hr_psf_shd.api_updating

4083: l_proc := g_package||'chk_replacement_required_flag';
4084: hr_utility.set_location('Entering:'||l_proc, 5);
4085: end if;
4086: --
4087: l_api_updating := hr_psf_shd.api_updating
4088: (p_position_id => p_position_id
4089: ,p_effective_date => p_effective_date
4090: ,p_object_version_number => p_object_version_number);
4091: --

Line 4094: <> nvl(hr_psf_shd.g_old_rec.replacement_required_flag,hr_api.g_varchar2)

4090: ,p_object_version_number => p_object_version_number);
4091: --
4092: if (l_api_updating
4093: and p_replacement_required_flag
4094: <> nvl(hr_psf_shd.g_old_rec.replacement_required_flag,hr_api.g_varchar2)
4095: or not l_api_updating)
4096: and p_replacement_required_flag is not null then
4097: --
4098: -- check if value of lookup falls within lookup type.

Line 4169: l_api_updating := hr_psf_shd.api_updating

4165: l_proc := g_package||'chk_probation_period_unit_cd';
4166: hr_utility.set_location('Entering:'||l_proc, 5);
4167: end if;
4168: --
4169: l_api_updating := hr_psf_shd.api_updating
4170: (p_position_id => p_position_id
4171: ,p_effective_date => p_effective_date
4172: ,p_object_version_number => p_object_version_number);
4173: --

Line 4176: <> nvl(hr_psf_shd.g_old_rec.probation_period_unit_cd,hr_api.g_varchar2)

4172: ,p_object_version_number => p_object_version_number);
4173: --
4174: if (l_api_updating
4175: and p_probation_period_unit_cd
4176: <> nvl(hr_psf_shd.g_old_rec.probation_period_unit_cd,hr_api.g_varchar2)
4177: or not l_api_updating)
4178: and p_probation_period_unit_cd is not null then
4179: --
4180: -- check if value of lookup falls within lookup type.

Line 4251: l_api_updating := hr_psf_shd.api_updating

4247: l_proc := g_package||'chk_permit_recruitment_flag';
4248: hr_utility.set_location('Entering:'||l_proc, 5);
4249: end if;
4250: --
4251: l_api_updating := hr_psf_shd.api_updating
4252: (p_position_id => p_position_id
4253: ,p_effective_date => p_effective_date
4254: ,p_object_version_number => p_object_version_number);
4255: --

Line 4258: <> nvl(hr_psf_shd.g_old_rec.permit_recruitment_flag,hr_api.g_varchar2)

4254: ,p_object_version_number => p_object_version_number);
4255: --
4256: if (l_api_updating
4257: and p_permit_recruitment_flag
4258: <> nvl(hr_psf_shd.g_old_rec.permit_recruitment_flag,hr_api.g_varchar2)
4259: or not l_api_updating)
4260: and p_permit_recruitment_flag is not null then
4261: --
4262: -- check if value of lookup falls within lookup type.

Line 4333: l_api_updating := hr_psf_shd.api_updating

4329: l_proc := g_package||'chk_permanent_temporary_flag';
4330: hr_utility.set_location('Entering:'||l_proc, 5);
4331: end if;
4332: --
4333: l_api_updating := hr_psf_shd.api_updating
4334: (p_position_id => p_position_id
4335: ,p_effective_date => p_effective_date
4336: ,p_object_version_number => p_object_version_number);
4337: --

Line 4340: <> nvl(hr_psf_shd.g_old_rec.permanent_temporary_flag,hr_api.g_varchar2)

4336: ,p_object_version_number => p_object_version_number);
4337: --
4338: if (l_api_updating
4339: and p_permanent_temporary_flag
4340: <> nvl(hr_psf_shd.g_old_rec.permanent_temporary_flag,hr_api.g_varchar2)
4341: or not l_api_updating)
4342: and p_permanent_temporary_flag is not null then
4343: --
4344: -- check if value of lookup falls within lookup type.

Line 4415: l_api_updating := hr_psf_shd.api_updating

4411: l_proc := g_package||'chk_pay_term_end_month_cd';
4412: hr_utility.set_location('Entering:'||l_proc, 5);
4413: end if;
4414: --
4415: l_api_updating := hr_psf_shd.api_updating
4416: (p_position_id => p_position_id
4417: ,p_effective_date => p_effective_date
4418: ,p_object_version_number => p_object_version_number);
4419: --

Line 4422: <> nvl(hr_psf_shd.g_old_rec.pay_term_end_month_cd,hr_api.g_varchar2)

4418: ,p_object_version_number => p_object_version_number);
4419: --
4420: if (l_api_updating
4421: and p_pay_term_end_month_cd
4422: <> nvl(hr_psf_shd.g_old_rec.pay_term_end_month_cd,hr_api.g_varchar2)
4423: or not l_api_updating)
4424: and p_pay_term_end_month_cd is not null then
4425: --
4426: -- check if value of lookup falls within lookup type.

Line 4497: l_api_updating := hr_psf_shd.api_updating

4493: l_proc := g_package||'chk_pay_term_end_day_cd';
4494: hr_utility.set_location('Entering:'||l_proc, 5);
4495: end if;
4496: --
4497: l_api_updating := hr_psf_shd.api_updating
4498: (p_position_id => p_position_id
4499: ,p_effective_date => p_effective_date
4500: ,p_object_version_number => p_object_version_number);
4501: --

Line 4504: <> nvl(hr_psf_shd.g_old_rec.pay_term_end_day_cd,hr_api.g_varchar2)

4500: ,p_object_version_number => p_object_version_number);
4501: --
4502: if (l_api_updating
4503: and p_pay_term_end_day_cd
4504: <> nvl(hr_psf_shd.g_old_rec.pay_term_end_day_cd,hr_api.g_varchar2)
4505: or not l_api_updating)
4506: and p_pay_term_end_day_cd is not null then
4507: --
4508: -- check if value of lookup falls within lookup type.

Line 4579: l_api_updating := hr_psf_shd.api_updating

4575: l_proc := g_package||'chk_overlap_unit_cd';
4576: hr_utility.set_location('Entering:'||l_proc, 5);
4577: end if;
4578: --
4579: l_api_updating := hr_psf_shd.api_updating
4580: (p_position_id => p_position_id
4581: ,p_effective_date => p_effective_date
4582: ,p_object_version_number => p_object_version_number);
4583: --

Line 4586: <> nvl(hr_psf_shd.g_old_rec.overlap_unit_cd,hr_api.g_varchar2)

4582: ,p_object_version_number => p_object_version_number);
4583: --
4584: if (l_api_updating
4585: and p_overlap_unit_cd
4586: <> nvl(hr_psf_shd.g_old_rec.overlap_unit_cd,hr_api.g_varchar2)
4587: or not l_api_updating)
4588: and p_overlap_unit_cd is not null then
4589: --
4590: -- check if value of lookup falls within lookup type.

Line 4661: l_api_updating := hr_psf_shd.api_updating

4657: l_proc := g_package||'chk_bargaining_unit_cd';
4658: hr_utility.set_location('Entering:'||l_proc, 5);
4659: end if;
4660: --
4661: l_api_updating := hr_psf_shd.api_updating
4662: (p_position_id => p_position_id
4663: ,p_effective_date => p_effective_date
4664: ,p_object_version_number => p_object_version_number);
4665: --

Line 4668: <> nvl(hr_psf_shd.g_old_rec.bargaining_unit_cd,hr_api.g_varchar2)

4664: ,p_object_version_number => p_object_version_number);
4665: --
4666: if (l_api_updating
4667: and p_bargaining_unit_cd
4668: <> nvl(hr_psf_shd.g_old_rec.bargaining_unit_cd,hr_api.g_varchar2)
4669: or not l_api_updating)
4670: and p_bargaining_unit_cd is not null then
4671: --
4672: -- check if value of lookup falls within lookup type.

Line 4734: l_api_updating := hr_psf_shd.api_updating

4730: (p_api_name => l_proc
4731: ,p_argument => 'effective date'
4732: ,p_argument_value => p_effective_date);
4733: --
4734: l_api_updating := hr_psf_shd.api_updating
4735: (p_position_id => p_position_id
4736: ,p_effective_date => p_effective_date
4737: ,p_object_version_number => p_object_version_number);
4738: --

Line 4740: and ((p_fte <> nvl(hr_psf_shd.g_old_rec.fte,hr_api.g_number))

4736: ,p_effective_date => p_effective_date
4737: ,p_object_version_number => p_object_version_number);
4738: --
4739: if ((l_api_updating
4740: and ((p_fte <> nvl(hr_psf_shd.g_old_rec.fte,hr_api.g_number))
4741: or (p_position_type <> nvl(hr_psf_shd.g_old_rec.position_type,
4742: hr_api.g_varchar2))))
4743: or not l_api_updating) then
4744: --

Line 4741: or (p_position_type <> nvl(hr_psf_shd.g_old_rec.position_type,

4737: ,p_object_version_number => p_object_version_number);
4738: --
4739: if ((l_api_updating
4740: and ((p_fte <> nvl(hr_psf_shd.g_old_rec.fte,hr_api.g_number))
4741: or (p_position_type <> nvl(hr_psf_shd.g_old_rec.position_type,
4742: hr_api.g_varchar2))))
4743: or not l_api_updating) then
4744: --
4745: if p_position_type <> 'NONE' then

Line 4781: nvl(hr_psf_shd.g_old_rec.max_persons,hr_api.g_number),3);

4777: hr_utility.set_location('Entering:'||l_proc, 5);
4778: hr_utility.set_location('Entering:'||p_max_persons, 2);
4779:
4780: hr_utility.set_location('Entering:'||
4781: nvl(hr_psf_shd.g_old_rec.max_persons,hr_api.g_number),3);
4782: end if;
4783: --
4784: hr_api.mandatory_arg_error
4785: (p_api_name => l_proc

Line 4794: l_api_updating := hr_psf_shd.api_updating

4790: (p_api_name => l_proc
4791: ,p_argument => 'effective date'
4792: ,p_argument_value => p_effective_date);
4793: --
4794: l_api_updating := hr_psf_shd.api_updating
4795: (p_position_id => p_position_id
4796: ,p_effective_date => p_effective_date
4797: ,p_object_version_number => p_object_version_number);
4798: --

Line 4801: nvl(hr_psf_shd.g_old_rec.max_persons,hr_api.g_number))

4797: ,p_object_version_number => p_object_version_number);
4798: --
4799: if ((l_api_updating
4800: and ((nvl(p_max_persons,hr_api.g_number) <>
4801: nvl(hr_psf_shd.g_old_rec.max_persons,hr_api.g_number))
4802: or (p_position_type <> nvl(hr_psf_shd.g_old_rec.position_type,
4803: hr_api.g_varchar2))))
4804: or not l_api_updating) then
4805: --

Line 4802: or (p_position_type <> nvl(hr_psf_shd.g_old_rec.position_type,

4798: --
4799: if ((l_api_updating
4800: and ((nvl(p_max_persons,hr_api.g_number) <>
4801: nvl(hr_psf_shd.g_old_rec.max_persons,hr_api.g_number))
4802: or (p_position_type <> nvl(hr_psf_shd.g_old_rec.position_type,
4803: hr_api.g_varchar2))))
4804: or not l_api_updating) then
4805: --
4806: if (p_position_type = 'SINGLE')

Line 4891: l_api_updating := hr_psf_shd.api_updating

4887: (p_api_name => l_proc
4888: ,p_argument => 'effective date'
4889: ,p_argument_value => p_effective_date);
4890: --
4891: l_api_updating := hr_psf_shd.api_updating
4892: (p_position_id => p_position_id
4893: ,p_effective_date => p_effective_date
4894: ,p_object_version_number => p_object_version_number);
4895: --

Line 4899: <> nvl(hr_psf_shd.g_old_rec.fte,hr_api.g_number)

4895: --
4896:
4897: if (l_api_updating
4898: and p_fte
4899: <> nvl(hr_psf_shd.g_old_rec.fte,hr_api.g_number)
4900: ) then
4901: --
4902: for r2 in csr_valid_eff_date(p_position_id, p_validation_start_date, p_validation_end_date) loop
4903: if p_position_type ='SHARED' or p_position_type ='SINGLE' then

Line 5046: l_api_updating := hr_psf_shd.api_updating

5042: from per_position_extra_info
5043: where position_id = p_position_id
5044: and information_type = 'PER_SEASONAL';
5045: begin
5046: l_api_updating := hr_psf_shd.api_updating
5047: (p_position_id => p_position_id
5048: ,p_effective_date => p_effective_date
5049: ,p_object_version_number => p_object_version_number);
5050:

Line 5053: <> nvl(hr_psf_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)

5049: ,p_object_version_number => p_object_version_number);
5050:
5051: if (l_api_updating
5052: and p_seasonal_flag
5053: <> nvl(hr_psf_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)
5054: and (p_seasonal_flag='N' or p_seasonal_flag is null)) then
5055: open c_seasonal;
5056: fetch c_seasonal into l_dummy;
5057: if c_seasonal%found then

Line 5089: l_api_updating := hr_psf_shd.api_updating

5085: if g_debug then
5086: l_proc :='chk_overlap_poi';
5087: hr_utility.set_location('Entering:'||l_proc,10);
5088: end if;
5089: l_api_updating := hr_psf_shd.api_updating
5090: (p_position_id => p_position_id
5091: ,p_effective_date => p_effective_date
5092: ,p_object_version_number => p_object_version_number);
5093:

Line 5096: <> nvl(hr_psf_shd.g_old_rec.overlap_period,hr_api.g_number)

5092: ,p_object_version_number => p_object_version_number);
5093:
5094: if (l_api_updating
5095: and nvl(p_overlap_period,-1)
5096: <> nvl(hr_psf_shd.g_old_rec.overlap_period,hr_api.g_number)
5097: and p_overlap_period is null) then
5098: if g_debug then
5099: hr_utility.set_location('Checking for Overlap Dates in Position Extra Info:'||l_proc,20);
5100: end if;

Line 5183: l_api_updating := hr_psf_shd.api_updating

5179: if g_debug then
5180: l_proc :='chk_extended_pay_permit';
5181: hr_utility.set_location('Entering:'||l_proc,10);
5182: end if;
5183: l_api_updating := hr_psf_shd.api_updating
5184: (p_position_id => p_position_id
5185: ,p_effective_date => p_effective_date
5186: ,p_object_version_number => p_object_version_number);
5187:

Line 5189: <> nvl(hr_psf_shd.g_old_rec.work_period_type_cd,hr_api.g_varchar2)) or not l_api_updating)

5185: ,p_effective_date => p_effective_date
5186: ,p_object_version_number => p_object_version_number);
5187:
5188: if (((l_api_updating and p_work_period_type_cd
5189: <> nvl(hr_psf_shd.g_old_rec.work_period_type_cd,hr_api.g_varchar2)) or not l_api_updating)
5190: and nvl(p_WORK_PERIOD_TYPE_CD,'N') = 'Y') then
5191: if g_debug then
5192: hr_utility.set_location('Check permit_extended_pay:'||l_proc,10);
5193: end if;

Line 5265: l_api_updating := hr_psf_shd.api_updating

5261: l_proc := g_package||'chk_position_type_single';
5262: hr_utility.set_location('Entering:'||l_proc, 5);
5263: end if;
5264: --
5265: l_api_updating := hr_psf_shd.api_updating
5266: (p_position_id => p_position_id
5267: ,p_effective_date => p_effective_date
5268: ,p_object_version_number => p_object_version_number);
5269: --

Line 5272: <> nvl(hr_psf_shd.g_old_rec.position_type,hr_api.g_varchar2))

5268: ,p_object_version_number => p_object_version_number);
5269: --
5270: if (l_api_updating
5271: and p_position_type
5272: <> nvl(hr_psf_shd.g_old_rec.position_type,hr_api.g_varchar2))
5273: then
5274: --
5275: -- check if value of lookup falls within lookup type.
5276: --

Line 5278: and (nvl(hr_psf_shd.g_old_rec.position_type,hr_api.g_varchar2)

5274: --
5275: -- check if value of lookup falls within lookup type.
5276: --
5277: if ((p_position_type = 'SINGLE')
5278: and (nvl(hr_psf_shd.g_old_rec.position_type,hr_api.g_varchar2)
5279: <> 'SINGLE' )) then
5280: open c_no_assignments(p_position_id, p_effective_date);
5281: fetch c_no_assignments into l_no_assignments;
5282: close c_no_assignments;

Line 5663: l_api_updating := hr_psf_shd.api_updating

5659: l_proc := g_package||'chk_proposed_status';
5660: hr_utility.set_location('Entering:'||l_proc, 5);
5661: end if;
5662: --
5663: l_api_updating := hr_psf_shd.api_updating
5664: (p_position_id => p_position_id
5665: ,p_effective_date => p_effective_date
5666: ,p_object_version_number => p_object_version_number);
5667: --

Line 5674: <> nvl(hr_psf_shd.g_old_rec.availability_status_id,hr_api.g_number))

5670: end if;
5671: if p_datetrack_mode = 'CORRECTION' then
5672: if (l_api_updating
5673: and p_availability_status_id
5674: <> nvl(hr_psf_shd.g_old_rec.availability_status_id,hr_api.g_number))
5675: then
5676: if g_debug then
5677: hr_utility.set_location('Availability_status id:'||p_availability_status_id, 5);
5678: hr_utility.set_location('position id:'||p_position_id, 5);

Line 5679: hr_utility.set_location('get avail '||hr_psf_shd.get_availability_status(p_availability_status_id,p_business_group_id),6);

5675: then
5676: if g_debug then
5677: hr_utility.set_location('Availability_status id:'||p_availability_status_id, 5);
5678: hr_utility.set_location('position id:'||p_position_id, 5);
5679: hr_utility.set_location('get avail '||hr_psf_shd.get_availability_status(p_availability_status_id,p_business_group_id),6);
5680: end if;
5681: if hr_psf_shd.get_availability_status(p_availability_status_id,p_business_group_id) = 'PROPOSED' then
5682: if g_debug then
5683: hr_utility.set_location('Entering:'||l_proc, 5);

Line 5681: if hr_psf_shd.get_availability_status(p_availability_status_id,p_business_group_id) = 'PROPOSED' then

5677: hr_utility.set_location('Availability_status id:'||p_availability_status_id, 5);
5678: hr_utility.set_location('position id:'||p_position_id, 5);
5679: hr_utility.set_location('get avail '||hr_psf_shd.get_availability_status(p_availability_status_id,p_business_group_id),6);
5680: end if;
5681: if hr_psf_shd.get_availability_status(p_availability_status_id,p_business_group_id) = 'PROPOSED' then
5682: if g_debug then
5683: hr_utility.set_location('Entering:'||l_proc, 5);
5684: end if;
5685: open c1;

Line 5707: (p_rec in hr_psf_shd.g_rec_type,

5703: -- ----------------------------------------------------------------------------
5704: -- |---------------------------< insert_validate >----------------------------|
5705: -- ----------------------------------------------------------------------------
5706: Procedure insert_validate
5707: (p_rec in hr_psf_shd.g_rec_type,
5708: p_effective_date in date,
5709: p_datetrack_mode in varchar2,
5710: p_validation_start_date in date,
5711: p_validation_end_date in date) is

Line 6191: ,p_old_avail_status_id => hr_psf_shd.g_old_rec.availability_status_id

6187: chk_availability_status_id
6188: (p_position_id => p_rec.position_id
6189: ,p_validation_start_date => p_validation_start_date
6190: ,p_availability_status_id => p_rec.availability_status_id
6191: ,p_old_avail_status_id => hr_psf_shd.g_old_rec.availability_status_id
6192: ,p_effective_date => p_effective_date
6193: ,p_date_effective => p_rec.date_effective
6194: ,p_business_group_id => p_rec.business_group_id
6195: ,p_object_version_number => p_rec.object_version_number

Line 6363: (p_rec in hr_psf_shd.g_rec_type,

6359: -- ----------------------------------------------------------------------------
6360: -- |---------------------------< update_validate >----------------------------|
6361: -- ----------------------------------------------------------------------------
6362: Procedure update_validate
6363: (p_rec in hr_psf_shd.g_rec_type,
6364: p_effective_date in date,
6365: p_datetrack_mode in varchar2,
6366: p_validation_start_date in date,
6367: p_validation_end_date in date) is

Line 6834: ,p_old_avail_status_id => hr_psf_shd.g_old_rec.availability_status_id

6830: chk_availability_status_id
6831: (p_position_id => p_rec.position_id
6832: ,p_validation_start_date => p_validation_start_date
6833: ,p_availability_status_id => p_rec.availability_status_id
6834: ,p_old_avail_status_id => hr_psf_shd.g_old_rec.availability_status_id
6835: ,p_effective_date => p_effective_date
6836: ,p_date_effective => p_rec.date_effective
6837: ,p_business_group_id => p_rec.business_group_id
6838: ,p_object_version_number => p_rec.object_version_number

Line 7145: ,hr_psf_shd.get_availability_status(availability_status_id,p_business_group_id)

7141: l_eot date := to_date('31/12/4712','dd/mm/yyyy');
7142: -- fetches the next row info. given effective start date
7143: cursor next_row(p_effective_start_date date) is
7144: select effective_start_date,effective_end_date
7145: ,hr_psf_shd.get_availability_status(availability_status_id,p_business_group_id)
7146: from hr_all_positions_f
7147: where position_id = p_position_id
7148: and effective_start_date > p_effective_start_date
7149: order by effective_start_date ;

Line 7610: (p_rec in hr_psf_shd.g_rec_type,

7606: -- ----------------------------------------------------------------------------
7607: -- |---------------------------< delete_validate >----------------------------|
7608: -- ----------------------------------------------------------------------------
7609: Procedure delete_validate
7610: (p_rec in hr_psf_shd.g_rec_type,
7611: p_effective_date in date,
7612: p_datetrack_mode in varchar2,
7613: p_validation_start_date in date,
7614: p_validation_end_date in date) is

Line 7642: ,p_old_avail_status_id => hr_psf_shd.g_old_rec.availability_status_id

7638: chk_availability_status_id
7639: (p_position_id => p_rec.position_id
7640: ,p_validation_start_date => p_validation_start_date
7641: ,p_availability_status_id => p_rec.availability_status_id
7642: ,p_old_avail_status_id => hr_psf_shd.g_old_rec.availability_status_id
7643: ,p_effective_date => p_effective_date
7644: ,p_date_effective => p_rec.date_effective
7645: ,p_business_group_id => p_rec.business_group_id
7646: ,p_object_version_number => p_rec.object_version_number

Line 7676: (p_rec in hr_psf_shd.g_rec_type) is

7672: -- |-------------------------------< chk_ddf >---------------------------------|
7673: -- -----------------------------------------------------------------------------
7674: --
7675: procedure chk_ddf
7676: (p_rec in hr_psf_shd.g_rec_type) is
7677: --
7678: l_proc varchar2(72) ;
7679: l_error exception;
7680: --

Line 7694: nvl(hr_psf_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

7690: --
7691: if (p_rec.position_id is null)
7692: or ((p_rec.position_id is not null)
7693: and
7694: nvl(hr_psf_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
7695: nvl(p_rec.information_category, hr_api.g_varchar2) or
7696: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7697: nvl(p_rec.information1, hr_api.g_varchar2) or
7698: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 7696: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>

7692: or ((p_rec.position_id is not null)
7693: and
7694: nvl(hr_psf_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
7695: nvl(p_rec.information_category, hr_api.g_varchar2) or
7696: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7697: nvl(p_rec.information1, hr_api.g_varchar2) or
7698: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7699: nvl(p_rec.information2, hr_api.g_varchar2) or
7700: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 7698: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>

7694: nvl(hr_psf_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
7695: nvl(p_rec.information_category, hr_api.g_varchar2) or
7696: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7697: nvl(p_rec.information1, hr_api.g_varchar2) or
7698: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7699: nvl(p_rec.information2, hr_api.g_varchar2) or
7700: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7701: nvl(p_rec.information3, hr_api.g_varchar2) or
7702: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 7700: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>

7696: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7697: nvl(p_rec.information1, hr_api.g_varchar2) or
7698: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7699: nvl(p_rec.information2, hr_api.g_varchar2) or
7700: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7701: nvl(p_rec.information3, hr_api.g_varchar2) or
7702: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7703: nvl(p_rec.information4, hr_api.g_varchar2) or
7704: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 7702: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>

7698: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7699: nvl(p_rec.information2, hr_api.g_varchar2) or
7700: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7701: nvl(p_rec.information3, hr_api.g_varchar2) or
7702: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7703: nvl(p_rec.information4, hr_api.g_varchar2) or
7704: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7705: nvl(p_rec.information5, hr_api.g_varchar2) or
7706: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 7704: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>

7700: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7701: nvl(p_rec.information3, hr_api.g_varchar2) or
7702: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7703: nvl(p_rec.information4, hr_api.g_varchar2) or
7704: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7705: nvl(p_rec.information5, hr_api.g_varchar2) or
7706: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7707: nvl(p_rec.information6, hr_api.g_varchar2) or
7708: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 7706: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>

7702: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7703: nvl(p_rec.information4, hr_api.g_varchar2) or
7704: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7705: nvl(p_rec.information5, hr_api.g_varchar2) or
7706: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7707: nvl(p_rec.information6, hr_api.g_varchar2) or
7708: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7709: nvl(p_rec.information7, hr_api.g_varchar2) or
7710: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 7708: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>

7704: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7705: nvl(p_rec.information5, hr_api.g_varchar2) or
7706: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7707: nvl(p_rec.information6, hr_api.g_varchar2) or
7708: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7709: nvl(p_rec.information7, hr_api.g_varchar2) or
7710: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7711: nvl(p_rec.information8, hr_api.g_varchar2) or
7712: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 7710: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>

7706: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7707: nvl(p_rec.information6, hr_api.g_varchar2) or
7708: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7709: nvl(p_rec.information7, hr_api.g_varchar2) or
7710: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7711: nvl(p_rec.information8, hr_api.g_varchar2) or
7712: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7713: nvl(p_rec.information9, hr_api.g_varchar2) or
7714: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 7712: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>

7708: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7709: nvl(p_rec.information7, hr_api.g_varchar2) or
7710: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7711: nvl(p_rec.information8, hr_api.g_varchar2) or
7712: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7713: nvl(p_rec.information9, hr_api.g_varchar2) or
7714: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7715: nvl(p_rec.information10, hr_api.g_varchar2) or
7716: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 7714: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>

7710: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7711: nvl(p_rec.information8, hr_api.g_varchar2) or
7712: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7713: nvl(p_rec.information9, hr_api.g_varchar2) or
7714: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7715: nvl(p_rec.information10, hr_api.g_varchar2) or
7716: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7717: nvl(p_rec.information11, hr_api.g_varchar2) or
7718: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 7716: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>

7712: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7713: nvl(p_rec.information9, hr_api.g_varchar2) or
7714: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7715: nvl(p_rec.information10, hr_api.g_varchar2) or
7716: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7717: nvl(p_rec.information11, hr_api.g_varchar2) or
7718: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7719: nvl(p_rec.information12, hr_api.g_varchar2) or
7720: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 7718: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>

7714: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7715: nvl(p_rec.information10, hr_api.g_varchar2) or
7716: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7717: nvl(p_rec.information11, hr_api.g_varchar2) or
7718: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7719: nvl(p_rec.information12, hr_api.g_varchar2) or
7720: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7721: nvl(p_rec.information13, hr_api.g_varchar2) or
7722: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 7720: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>

7716: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7717: nvl(p_rec.information11, hr_api.g_varchar2) or
7718: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7719: nvl(p_rec.information12, hr_api.g_varchar2) or
7720: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7721: nvl(p_rec.information13, hr_api.g_varchar2) or
7722: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7723: nvl(p_rec.information14, hr_api.g_varchar2) or
7724: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 7722: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>

7718: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7719: nvl(p_rec.information12, hr_api.g_varchar2) or
7720: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7721: nvl(p_rec.information13, hr_api.g_varchar2) or
7722: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7723: nvl(p_rec.information14, hr_api.g_varchar2) or
7724: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7725: nvl(p_rec.information15, hr_api.g_varchar2) or
7726: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 7724: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>

7720: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7721: nvl(p_rec.information13, hr_api.g_varchar2) or
7722: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7723: nvl(p_rec.information14, hr_api.g_varchar2) or
7724: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7725: nvl(p_rec.information15, hr_api.g_varchar2) or
7726: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7727: nvl(p_rec.information16, hr_api.g_varchar2) or
7728: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 7726: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>

7722: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7723: nvl(p_rec.information14, hr_api.g_varchar2) or
7724: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7725: nvl(p_rec.information15, hr_api.g_varchar2) or
7726: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7727: nvl(p_rec.information16, hr_api.g_varchar2) or
7728: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7729: nvl(p_rec.information17, hr_api.g_varchar2) or
7730: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 7728: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>

7724: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7725: nvl(p_rec.information15, hr_api.g_varchar2) or
7726: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7727: nvl(p_rec.information16, hr_api.g_varchar2) or
7728: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7729: nvl(p_rec.information17, hr_api.g_varchar2) or
7730: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7731: nvl(p_rec.information18, hr_api.g_varchar2) or
7732: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 7730: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>

7726: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7727: nvl(p_rec.information16, hr_api.g_varchar2) or
7728: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7729: nvl(p_rec.information17, hr_api.g_varchar2) or
7730: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7731: nvl(p_rec.information18, hr_api.g_varchar2) or
7732: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7733: nvl(p_rec.information19, hr_api.g_varchar2) or
7734: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 7732: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>

7728: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7729: nvl(p_rec.information17, hr_api.g_varchar2) or
7730: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7731: nvl(p_rec.information18, hr_api.g_varchar2) or
7732: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7733: nvl(p_rec.information19, hr_api.g_varchar2) or
7734: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7735: nvl(p_rec.information20, hr_api.g_varchar2) or
7736: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>

Line 7734: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>

7730: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7731: nvl(p_rec.information18, hr_api.g_varchar2) or
7732: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7733: nvl(p_rec.information19, hr_api.g_varchar2) or
7734: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7735: nvl(p_rec.information20, hr_api.g_varchar2) or
7736: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7737: nvl(p_rec.information21, hr_api.g_varchar2) or
7738: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>

Line 7736: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>

7732: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7733: nvl(p_rec.information19, hr_api.g_varchar2) or
7734: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7735: nvl(p_rec.information20, hr_api.g_varchar2) or
7736: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7737: nvl(p_rec.information21, hr_api.g_varchar2) or
7738: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7739: nvl(p_rec.information22, hr_api.g_varchar2) or
7740: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>

Line 7738: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>

7734: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7735: nvl(p_rec.information20, hr_api.g_varchar2) or
7736: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7737: nvl(p_rec.information21, hr_api.g_varchar2) or
7738: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7739: nvl(p_rec.information22, hr_api.g_varchar2) or
7740: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7741: nvl(p_rec.information23, hr_api.g_varchar2) or
7742: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>

Line 7740: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>

7736: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7737: nvl(p_rec.information21, hr_api.g_varchar2) or
7738: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7739: nvl(p_rec.information22, hr_api.g_varchar2) or
7740: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7741: nvl(p_rec.information23, hr_api.g_varchar2) or
7742: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7743: nvl(p_rec.information24, hr_api.g_varchar2) or
7744: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>

Line 7742: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>

7738: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7739: nvl(p_rec.information22, hr_api.g_varchar2) or
7740: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7741: nvl(p_rec.information23, hr_api.g_varchar2) or
7742: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7743: nvl(p_rec.information24, hr_api.g_varchar2) or
7744: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7745: nvl(p_rec.information25, hr_api.g_varchar2) or
7746: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>

Line 7744: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>

7740: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7741: nvl(p_rec.information23, hr_api.g_varchar2) or
7742: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7743: nvl(p_rec.information24, hr_api.g_varchar2) or
7744: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7745: nvl(p_rec.information25, hr_api.g_varchar2) or
7746: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7747: nvl(p_rec.information26, hr_api.g_varchar2) or
7748: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>

Line 7746: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>

7742: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7743: nvl(p_rec.information24, hr_api.g_varchar2) or
7744: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7745: nvl(p_rec.information25, hr_api.g_varchar2) or
7746: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7747: nvl(p_rec.information26, hr_api.g_varchar2) or
7748: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7749: nvl(p_rec.information27, hr_api.g_varchar2) or
7750: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>

Line 7748: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>

7744: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7745: nvl(p_rec.information25, hr_api.g_varchar2) or
7746: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7747: nvl(p_rec.information26, hr_api.g_varchar2) or
7748: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7749: nvl(p_rec.information27, hr_api.g_varchar2) or
7750: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7751: nvl(p_rec.information28, hr_api.g_varchar2) or
7752: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>

Line 7750: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>

7746: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7747: nvl(p_rec.information26, hr_api.g_varchar2) or
7748: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7749: nvl(p_rec.information27, hr_api.g_varchar2) or
7750: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7751: nvl(p_rec.information28, hr_api.g_varchar2) or
7752: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7753: nvl(p_rec.information29, hr_api.g_varchar2) or
7754: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>

Line 7752: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>

7748: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7749: nvl(p_rec.information27, hr_api.g_varchar2) or
7750: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7751: nvl(p_rec.information28, hr_api.g_varchar2) or
7752: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7753: nvl(p_rec.information29, hr_api.g_varchar2) or
7754: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>
7755: nvl(p_rec.information30, hr_api.g_varchar2))
7756: then

Line 7754: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>

7750: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7751: nvl(p_rec.information28, hr_api.g_varchar2) or
7752: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7753: nvl(p_rec.information29, hr_api.g_varchar2) or
7754: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>
7755: nvl(p_rec.information30, hr_api.g_varchar2))
7756: then
7757: --
7758: hr_dflex_utility.ins_or_upd_descflex_attribs

Line 7866: (p_rec in hr_psf_shd.g_rec_type) is

7862: -- Access Status:
7863: -- Internal Row Handler Use Only.
7864: --
7865: procedure chk_df
7866: (p_rec in hr_psf_shd.g_rec_type) is
7867: --
7868: l_proc varchar2(72);
7869: --
7870: begin

Line 7878: nvl(hr_psf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

7874: hr_utility.set_location('Entering:'||l_proc, 10);
7875: end if;
7876: --
7877: if ((p_rec.position_id is not null) and (
7878: nvl(hr_psf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
7879: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7880: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7882: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 7880: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

7876: --
7877: if ((p_rec.position_id is not null) and (
7878: nvl(hr_psf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
7879: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7880: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7882: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7884: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 7882: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

7878: nvl(hr_psf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
7879: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
7880: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7882: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7884: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7886: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 7884: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

7880: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
7881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
7882: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7884: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7886: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7888: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 7886: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

7882: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
7883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
7884: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7886: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7888: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7890: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 7888: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

7884: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
7885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
7886: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7888: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7890: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7892: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 7890: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

7886: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
7887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
7888: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7890: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7892: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7894: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 7892: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

7888: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
7889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
7890: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7892: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7894: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7896: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 7894: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

7890: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
7891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
7892: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7894: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7896: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7898: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 7896: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

7892: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
7893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
7894: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7896: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7898: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7900: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 7898: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

7894: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
7895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
7896: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7898: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7900: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7902: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 7900: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

7896: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
7897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
7898: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7900: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7902: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7904: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 7902: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

7898: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
7899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
7900: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7902: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7904: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7906: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 7904: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

7900: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
7901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
7902: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7904: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7906: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7908: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 7906: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

7902: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
7903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
7904: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7906: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7908: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7910: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 7908: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

7904: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
7905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
7906: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7908: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7910: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7912: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 7910: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

7906: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
7907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
7908: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7910: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7912: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7914: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 7912: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

7908: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
7909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
7910: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7912: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7914: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7916: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 7914: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

7910: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
7911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
7912: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7914: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7916: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7918: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 7916: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

7912: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
7913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
7914: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7916: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7918: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7920: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 7918: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

7914: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
7915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
7916: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7918: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7920: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7922: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 7920: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

7916: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
7917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
7918: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7920: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7922: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7924: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 7922: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

7918: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
7919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
7920: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7922: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7924: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7926: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 7924: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

7920: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
7921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
7922: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7924: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7926: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7928: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 7926: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

7922: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
7923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
7924: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7926: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7928: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7930: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 7928: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

7924: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
7925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
7926: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7928: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7930: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7932: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 7930: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

7926: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
7927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
7928: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7930: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7932: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7934: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 7932: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

7928: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
7929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
7930: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7932: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7934: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7936: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 7934: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

7930: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
7931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
7932: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7934: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7936: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7937: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7938: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 7936: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

7932: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
7933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
7934: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7936: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7937: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7938: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
7939: nvl(p_rec.attribute30, hr_api.g_varchar2)))
7940: or (p_rec.position_id is null) then

Line 7938: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

7934: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
7935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
7936: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
7937: nvl(p_rec.attribute29, hr_api.g_varchar2) or
7938: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
7939: nvl(p_rec.attribute30, hr_api.g_varchar2)))
7940: or (p_rec.position_id is null) then
7941: --
7942: -- Only execute the validation if absolutely necessary:

Line 8145: and hr_psf_shd.get_availability_status(psf.availability_status_id

8141: select min(psf.effective_start_date)
8142: from
8143: hr_all_positions_f psf
8144: where psf.position_id = p_position_id
8145: and hr_psf_shd.get_availability_status(psf.availability_status_id
8146: ,psf.business_group_id) = 'ACTIVE';
8147:
8148: --
8149: l_minesd date;

Line 8204: and hr_psf_shd.get_availability_status(psf.availability_status_id

8200: select count(*)
8201: from
8202: hr_all_positions_f psf
8203: where psf.position_id = p_position_id
8204: and hr_psf_shd.get_availability_status(psf.availability_status_id
8205: ,psf.business_group_id) <> 'PROPOSED';
8206: --
8207: cursor c2 is
8208: select min(psf.effective_Start_Date)

Line 8264: and hr_psf_shd.get_availability_status(psf.availability_status_id

8260: select count(*)
8261: from
8262: hr_all_positions_f psf
8263: where psf.position_id = p_position_id
8264: and hr_psf_shd.get_availability_status(psf.availability_status_id
8265: ,psf.business_group_id) <> 'PROPOSED';
8266: --
8267: Begin
8268: --

Line 8519: l_api_updating := hr_psf_shd.api_updating

8515: l_proc := g_package||'chk_permanent_seasonal_flag';
8516: hr_utility.set_location('Entering:'||l_proc, 5);
8517: end if;
8518: --
8519: l_api_updating := hr_psf_shd.api_updating
8520: (p_position_id => p_position_id
8521: ,p_effective_date => p_effective_date
8522: ,p_object_version_number => p_object_version_number);
8523: --

Line 8525: (p_permanent_temporary_flag <> nvl(hr_psf_shd.g_old_rec.permanent_temporary_flag,hr_api.g_varchar2)

8521: ,p_effective_date => p_effective_date
8522: ,p_object_version_number => p_object_version_number);
8523: --
8524: if ((l_api_updating and
8525: (p_permanent_temporary_flag <> nvl(hr_psf_shd.g_old_rec.permanent_temporary_flag,hr_api.g_varchar2)
8526: or p_seasonal_flag <> nvl(hr_psf_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)))
8527: or not l_api_updating) then
8528: if (p_permanent_temporary_flag is not null and p_seasonal_flag is not null) then
8529: if(p_seasonal_flag = 'Y' and p_permanent_temporary_flag = 'Y') then

Line 8526: or p_seasonal_flag <> nvl(hr_psf_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)))

8522: ,p_object_version_number => p_object_version_number);
8523: --
8524: if ((l_api_updating and
8525: (p_permanent_temporary_flag <> nvl(hr_psf_shd.g_old_rec.permanent_temporary_flag,hr_api.g_varchar2)
8526: or p_seasonal_flag <> nvl(hr_psf_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)))
8527: or not l_api_updating) then
8528: if (p_permanent_temporary_flag is not null and p_seasonal_flag is not null) then
8529: if(p_seasonal_flag = 'Y' and p_permanent_temporary_flag = 'Y') then
8530: -- raise error as both flags are set to Y.