[Home] [Help]
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
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
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) ;
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 ;
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
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
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: --
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
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 ;
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: );
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);
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: );
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);
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: );
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);
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: );
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
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: );
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
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: );
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
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: --
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
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
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: --
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
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: --
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,
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: --
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: );
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
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: );
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
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: --
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
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: --
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
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: );
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: --
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: --
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
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: --
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
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
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: --
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
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
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: );
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);
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: --
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
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: --
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
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: --
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.
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: --
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.
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: --
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.
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: --
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.
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: --
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.
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: --
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.
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: --
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.
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: --
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.
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: --
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.
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: --
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.
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: --
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.
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: --
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.
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: --
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.
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: --
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.
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: --
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.
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: --
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.
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: --
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.
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: --
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: --
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
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
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: --
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: --
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')
4888: (p_api_name => l_proc
4889: ,p_argument => 'effective date'
4890: ,p_argument_value => p_effective_date);
4891: --
4892: l_api_updating := hr_psf_shd.api_updating
4893: (p_position_id => p_position_id
4894: ,p_effective_date => p_effective_date
4895: ,p_object_version_number => p_object_version_number);
4896: --
4896: --
4897:
4898: if (l_api_updating
4899: and p_fte
4900: <> nvl(hr_psf_shd.g_old_rec.fte,hr_api.g_number)
4901: ) then
4902: --
4903: for r2 in csr_valid_eff_date(p_position_id, p_validation_start_date, p_validation_end_date) loop
4904: if p_position_type ='SHARED' or p_position_type ='SINGLE' then
5043: from per_position_extra_info
5044: where position_id = p_position_id
5045: and information_type = 'PER_SEASONAL';
5046: begin
5047: l_api_updating := hr_psf_shd.api_updating
5048: (p_position_id => p_position_id
5049: ,p_effective_date => p_effective_date
5050: ,p_object_version_number => p_object_version_number);
5051:
5050: ,p_object_version_number => p_object_version_number);
5051:
5052: if (l_api_updating
5053: and p_seasonal_flag
5054: <> nvl(hr_psf_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)
5055: and (p_seasonal_flag='N' or p_seasonal_flag is null)) then
5056: open c_seasonal;
5057: fetch c_seasonal into l_dummy;
5058: if c_seasonal%found then
5086: if g_debug then
5087: l_proc :='chk_overlap_poi';
5088: hr_utility.set_location('Entering:'||l_proc,10);
5089: end if;
5090: l_api_updating := hr_psf_shd.api_updating
5091: (p_position_id => p_position_id
5092: ,p_effective_date => p_effective_date
5093: ,p_object_version_number => p_object_version_number);
5094:
5093: ,p_object_version_number => p_object_version_number);
5094:
5095: if (l_api_updating
5096: and nvl(p_overlap_period,-1)
5097: <> nvl(hr_psf_shd.g_old_rec.overlap_period,hr_api.g_number)
5098: and p_overlap_period is null) then
5099: if g_debug then
5100: hr_utility.set_location('Checking for Overlap Dates in Position Extra Info:'||l_proc,20);
5101: end if;
5180: if g_debug then
5181: l_proc :='chk_extended_pay_permit';
5182: hr_utility.set_location('Entering:'||l_proc,10);
5183: end if;
5184: l_api_updating := hr_psf_shd.api_updating
5185: (p_position_id => p_position_id
5186: ,p_effective_date => p_effective_date
5187: ,p_object_version_number => p_object_version_number);
5188:
5186: ,p_effective_date => p_effective_date
5187: ,p_object_version_number => p_object_version_number);
5188:
5189: if (((l_api_updating and p_work_period_type_cd
5190: <> nvl(hr_psf_shd.g_old_rec.work_period_type_cd,hr_api.g_varchar2)) or not l_api_updating)
5191: and nvl(p_WORK_PERIOD_TYPE_CD,'N') = 'Y') then
5192: if g_debug then
5193: hr_utility.set_location('Check permit_extended_pay:'||l_proc,10);
5194: end if;
5307: l_proc := g_package||'chk_position_type_single';
5308: hr_utility.set_location('Entering:'||l_proc, 5);
5309: end if;
5310: --
5311: l_api_updating := hr_psf_shd.api_updating
5312: (p_position_id => p_position_id
5313: ,p_effective_date => p_effective_date
5314: ,p_object_version_number => p_object_version_number);
5315: --
5314: ,p_object_version_number => p_object_version_number);
5315: --
5316: if (l_api_updating
5317: and p_position_type
5318: <> nvl(hr_psf_shd.g_old_rec.position_type,hr_api.g_varchar2))
5319: then
5320: --sqlpl
5321: -- check if value of lookup falls within lookup type.
5322: --
5320: --sqlpl
5321: -- check if value of lookup falls within lookup type.
5322: --
5323: if ((p_position_type = 'SINGLE')
5324: and (nvl(hr_psf_shd.g_old_rec.position_type,hr_api.g_varchar2)
5325: <> 'SINGLE' )) then
5326: -- Start changes for bug 13519283
5327: if g_debug then
5328: hr_utility.set_location('Converting the position into Single Incumbent', 10);
5776: l_proc := g_package||'chk_proposed_status';
5777: hr_utility.set_location('Entering:'||l_proc, 5);
5778: end if;
5779: --
5780: l_api_updating := hr_psf_shd.api_updating
5781: (p_position_id => p_position_id
5782: ,p_effective_date => p_effective_date
5783: ,p_object_version_number => p_object_version_number);
5784: --
5787: end if;
5788: if p_datetrack_mode = 'CORRECTION' then
5789: if (l_api_updating
5790: and p_availability_status_id
5791: <> nvl(hr_psf_shd.g_old_rec.availability_status_id,hr_api.g_number))
5792: then
5793: if g_debug then
5794: hr_utility.set_location('Availability_status id:'||p_availability_status_id, 5);
5795: hr_utility.set_location('position id:'||p_position_id, 5);
5792: then
5793: if g_debug then
5794: hr_utility.set_location('Availability_status id:'||p_availability_status_id, 5);
5795: hr_utility.set_location('position id:'||p_position_id, 5);
5796: hr_utility.set_location('get avail '||hr_psf_shd.get_availability_status(p_availability_status_id,p_business_group_id),6);
5797: end if;
5798: if hr_psf_shd.get_availability_status(p_availability_status_id,p_business_group_id) = 'PROPOSED' then
5799: if g_debug then
5800: hr_utility.set_location('Entering:'||l_proc, 5);
5794: hr_utility.set_location('Availability_status id:'||p_availability_status_id, 5);
5795: hr_utility.set_location('position id:'||p_position_id, 5);
5796: hr_utility.set_location('get avail '||hr_psf_shd.get_availability_status(p_availability_status_id,p_business_group_id),6);
5797: end if;
5798: if hr_psf_shd.get_availability_status(p_availability_status_id,p_business_group_id) = 'PROPOSED' then
5799: if g_debug then
5800: hr_utility.set_location('Entering:'||l_proc, 5);
5801: end if;
5802: open c1;
5820: -- ----------------------------------------------------------------------------
5821: -- |---------------------------< insert_validate >----------------------------|
5822: -- ----------------------------------------------------------------------------
5823: Procedure insert_validate
5824: (p_rec in hr_psf_shd.g_rec_type,
5825: p_effective_date in date,
5826: p_datetrack_mode in varchar2,
5827: p_validation_start_date in date,
5828: p_validation_end_date in date) is
6304: chk_availability_status_id
6305: (p_position_id => p_rec.position_id
6306: ,p_validation_start_date => p_validation_start_date
6307: ,p_availability_status_id => p_rec.availability_status_id
6308: ,p_old_avail_status_id => hr_psf_shd.g_old_rec.availability_status_id
6309: ,p_effective_date => p_effective_date
6310: ,p_date_effective => p_rec.date_effective
6311: ,p_business_group_id => p_rec.business_group_id
6312: ,p_object_version_number => p_rec.object_version_number
6476: -- ----------------------------------------------------------------------------
6477: -- |---------------------------< update_validate >----------------------------|
6478: -- ----------------------------------------------------------------------------
6479: Procedure update_validate
6480: (p_rec in hr_psf_shd.g_rec_type,
6481: p_effective_date in date,
6482: p_datetrack_mode in varchar2,
6483: p_validation_start_date in date,
6484: p_validation_end_date in date) is
6947: chk_availability_status_id
6948: (p_position_id => p_rec.position_id
6949: ,p_validation_start_date => p_validation_start_date
6950: ,p_availability_status_id => p_rec.availability_status_id
6951: ,p_old_avail_status_id => hr_psf_shd.g_old_rec.availability_status_id
6952: ,p_effective_date => p_effective_date
6953: ,p_date_effective => p_rec.date_effective
6954: ,p_business_group_id => p_rec.business_group_id
6955: ,p_object_version_number => p_rec.object_version_number
7258: l_eot date := to_date('31/12/4712','dd/mm/yyyy');
7259: -- fetches the next row info. given effective start date
7260: cursor next_row(p_effective_start_date date) is
7261: select effective_start_date,effective_end_date
7262: ,hr_psf_shd.get_availability_status(availability_status_id,p_business_group_id)
7263: from hr_all_positions_f
7264: where position_id = p_position_id
7265: and effective_start_date > p_effective_start_date
7266: order by effective_start_date ;
7731: -- ----------------------------------------------------------------------------
7732: -- |---------------------------< delete_validate >----------------------------|
7733: -- ----------------------------------------------------------------------------
7734: Procedure delete_validate
7735: (p_rec in hr_psf_shd.g_rec_type,
7736: p_effective_date in date,
7737: p_datetrack_mode in varchar2,
7738: p_validation_start_date in date,
7739: p_validation_end_date in date) is
7763: chk_availability_status_id
7764: (p_position_id => p_rec.position_id
7765: ,p_validation_start_date => p_validation_start_date
7766: ,p_availability_status_id => p_rec.availability_status_id
7767: ,p_old_avail_status_id => hr_psf_shd.g_old_rec.availability_status_id
7768: ,p_effective_date => p_effective_date
7769: ,p_date_effective => p_rec.date_effective
7770: ,p_business_group_id => p_rec.business_group_id
7771: ,p_object_version_number => p_rec.object_version_number
7799: -- |-------------------------------< chk_ddf >---------------------------------|
7800: -- -----------------------------------------------------------------------------
7801: --
7802: procedure chk_ddf
7803: (p_rec in hr_psf_shd.g_rec_type) is
7804: --
7805: l_proc varchar2(72) ;
7806: l_error exception;
7807: --
7817: --
7818: if (p_rec.position_id is null)
7819: or ((p_rec.position_id is not null)
7820: and
7821: nvl(hr_psf_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
7822: nvl(p_rec.information_category, hr_api.g_varchar2) or
7823: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7824: nvl(p_rec.information1, hr_api.g_varchar2) or
7825: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7819: or ((p_rec.position_id is not null)
7820: and
7821: nvl(hr_psf_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
7822: nvl(p_rec.information_category, hr_api.g_varchar2) or
7823: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7824: nvl(p_rec.information1, hr_api.g_varchar2) or
7825: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7826: nvl(p_rec.information2, hr_api.g_varchar2) or
7827: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7821: nvl(hr_psf_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
7822: nvl(p_rec.information_category, hr_api.g_varchar2) or
7823: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7824: nvl(p_rec.information1, hr_api.g_varchar2) or
7825: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7826: nvl(p_rec.information2, hr_api.g_varchar2) or
7827: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7828: nvl(p_rec.information3, hr_api.g_varchar2) or
7829: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7823: nvl(hr_psf_shd.g_old_rec.information1, hr_api.g_varchar2) <>
7824: nvl(p_rec.information1, hr_api.g_varchar2) or
7825: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7826: nvl(p_rec.information2, hr_api.g_varchar2) or
7827: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7828: nvl(p_rec.information3, hr_api.g_varchar2) or
7829: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7830: nvl(p_rec.information4, hr_api.g_varchar2) or
7831: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7825: nvl(hr_psf_shd.g_old_rec.information2, hr_api.g_varchar2) <>
7826: nvl(p_rec.information2, hr_api.g_varchar2) or
7827: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7828: nvl(p_rec.information3, hr_api.g_varchar2) or
7829: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7830: nvl(p_rec.information4, hr_api.g_varchar2) or
7831: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7832: nvl(p_rec.information5, hr_api.g_varchar2) or
7833: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7827: nvl(hr_psf_shd.g_old_rec.information3, hr_api.g_varchar2) <>
7828: nvl(p_rec.information3, hr_api.g_varchar2) or
7829: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7830: nvl(p_rec.information4, hr_api.g_varchar2) or
7831: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7832: nvl(p_rec.information5, hr_api.g_varchar2) or
7833: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7834: nvl(p_rec.information6, hr_api.g_varchar2) or
7835: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7829: nvl(hr_psf_shd.g_old_rec.information4, hr_api.g_varchar2) <>
7830: nvl(p_rec.information4, hr_api.g_varchar2) or
7831: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7832: nvl(p_rec.information5, hr_api.g_varchar2) or
7833: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7834: nvl(p_rec.information6, hr_api.g_varchar2) or
7835: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7836: nvl(p_rec.information7, hr_api.g_varchar2) or
7837: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7831: nvl(hr_psf_shd.g_old_rec.information5, hr_api.g_varchar2) <>
7832: nvl(p_rec.information5, hr_api.g_varchar2) or
7833: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7834: nvl(p_rec.information6, hr_api.g_varchar2) or
7835: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7836: nvl(p_rec.information7, hr_api.g_varchar2) or
7837: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7838: nvl(p_rec.information8, hr_api.g_varchar2) or
7839: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7833: nvl(hr_psf_shd.g_old_rec.information6, hr_api.g_varchar2) <>
7834: nvl(p_rec.information6, hr_api.g_varchar2) or
7835: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7836: nvl(p_rec.information7, hr_api.g_varchar2) or
7837: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7838: nvl(p_rec.information8, hr_api.g_varchar2) or
7839: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7840: nvl(p_rec.information9, hr_api.g_varchar2) or
7841: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7835: nvl(hr_psf_shd.g_old_rec.information7, hr_api.g_varchar2) <>
7836: nvl(p_rec.information7, hr_api.g_varchar2) or
7837: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7838: nvl(p_rec.information8, hr_api.g_varchar2) or
7839: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7840: nvl(p_rec.information9, hr_api.g_varchar2) or
7841: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7842: nvl(p_rec.information10, hr_api.g_varchar2) or
7843: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7837: nvl(hr_psf_shd.g_old_rec.information8, hr_api.g_varchar2) <>
7838: nvl(p_rec.information8, hr_api.g_varchar2) or
7839: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7840: nvl(p_rec.information9, hr_api.g_varchar2) or
7841: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7842: nvl(p_rec.information10, hr_api.g_varchar2) or
7843: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7844: nvl(p_rec.information11, hr_api.g_varchar2) or
7845: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7839: nvl(hr_psf_shd.g_old_rec.information9, hr_api.g_varchar2) <>
7840: nvl(p_rec.information9, hr_api.g_varchar2) or
7841: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7842: nvl(p_rec.information10, hr_api.g_varchar2) or
7843: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7844: nvl(p_rec.information11, hr_api.g_varchar2) or
7845: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7846: nvl(p_rec.information12, hr_api.g_varchar2) or
7847: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7841: nvl(hr_psf_shd.g_old_rec.information10, hr_api.g_varchar2) <>
7842: nvl(p_rec.information10, hr_api.g_varchar2) or
7843: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7844: nvl(p_rec.information11, hr_api.g_varchar2) or
7845: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7846: nvl(p_rec.information12, hr_api.g_varchar2) or
7847: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7848: nvl(p_rec.information13, hr_api.g_varchar2) or
7849: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7843: nvl(hr_psf_shd.g_old_rec.information11, hr_api.g_varchar2) <>
7844: nvl(p_rec.information11, hr_api.g_varchar2) or
7845: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7846: nvl(p_rec.information12, hr_api.g_varchar2) or
7847: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7848: nvl(p_rec.information13, hr_api.g_varchar2) or
7849: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7850: nvl(p_rec.information14, hr_api.g_varchar2) or
7851: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7845: nvl(hr_psf_shd.g_old_rec.information12, hr_api.g_varchar2) <>
7846: nvl(p_rec.information12, hr_api.g_varchar2) or
7847: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7848: nvl(p_rec.information13, hr_api.g_varchar2) or
7849: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7850: nvl(p_rec.information14, hr_api.g_varchar2) or
7851: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7852: nvl(p_rec.information15, hr_api.g_varchar2) or
7853: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7847: nvl(hr_psf_shd.g_old_rec.information13, hr_api.g_varchar2) <>
7848: nvl(p_rec.information13, hr_api.g_varchar2) or
7849: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7850: nvl(p_rec.information14, hr_api.g_varchar2) or
7851: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7852: nvl(p_rec.information15, hr_api.g_varchar2) or
7853: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7854: nvl(p_rec.information16, hr_api.g_varchar2) or
7855: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7849: nvl(hr_psf_shd.g_old_rec.information14, hr_api.g_varchar2) <>
7850: nvl(p_rec.information14, hr_api.g_varchar2) or
7851: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7852: nvl(p_rec.information15, hr_api.g_varchar2) or
7853: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7854: nvl(p_rec.information16, hr_api.g_varchar2) or
7855: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7856: nvl(p_rec.information17, hr_api.g_varchar2) or
7857: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7851: nvl(hr_psf_shd.g_old_rec.information15, hr_api.g_varchar2) <>
7852: nvl(p_rec.information15, hr_api.g_varchar2) or
7853: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7854: nvl(p_rec.information16, hr_api.g_varchar2) or
7855: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7856: nvl(p_rec.information17, hr_api.g_varchar2) or
7857: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7858: nvl(p_rec.information18, hr_api.g_varchar2) or
7859: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7853: nvl(hr_psf_shd.g_old_rec.information16, hr_api.g_varchar2) <>
7854: nvl(p_rec.information16, hr_api.g_varchar2) or
7855: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7856: nvl(p_rec.information17, hr_api.g_varchar2) or
7857: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7858: nvl(p_rec.information18, hr_api.g_varchar2) or
7859: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7860: nvl(p_rec.information19, hr_api.g_varchar2) or
7861: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7855: nvl(hr_psf_shd.g_old_rec.information17, hr_api.g_varchar2) <>
7856: nvl(p_rec.information17, hr_api.g_varchar2) or
7857: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7858: nvl(p_rec.information18, hr_api.g_varchar2) or
7859: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7860: nvl(p_rec.information19, hr_api.g_varchar2) or
7861: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7862: nvl(p_rec.information20, hr_api.g_varchar2) or
7863: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7857: nvl(hr_psf_shd.g_old_rec.information18, hr_api.g_varchar2) <>
7858: nvl(p_rec.information18, hr_api.g_varchar2) or
7859: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7860: nvl(p_rec.information19, hr_api.g_varchar2) or
7861: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7862: nvl(p_rec.information20, hr_api.g_varchar2) or
7863: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7864: nvl(p_rec.information21, hr_api.g_varchar2) or
7865: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7859: nvl(hr_psf_shd.g_old_rec.information19, hr_api.g_varchar2) <>
7860: nvl(p_rec.information19, hr_api.g_varchar2) or
7861: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7862: nvl(p_rec.information20, hr_api.g_varchar2) or
7863: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7864: nvl(p_rec.information21, hr_api.g_varchar2) or
7865: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7866: nvl(p_rec.information22, hr_api.g_varchar2) or
7867: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7861: nvl(hr_psf_shd.g_old_rec.information20, hr_api.g_varchar2) <>
7862: nvl(p_rec.information20, hr_api.g_varchar2) or
7863: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7864: nvl(p_rec.information21, hr_api.g_varchar2) or
7865: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7866: nvl(p_rec.information22, hr_api.g_varchar2) or
7867: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7868: nvl(p_rec.information23, hr_api.g_varchar2) or
7869: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7863: nvl(hr_psf_shd.g_old_rec.information21, hr_api.g_varchar2) <>
7864: nvl(p_rec.information21, hr_api.g_varchar2) or
7865: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7866: nvl(p_rec.information22, hr_api.g_varchar2) or
7867: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7868: nvl(p_rec.information23, hr_api.g_varchar2) or
7869: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7870: nvl(p_rec.information24, hr_api.g_varchar2) or
7871: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7865: nvl(hr_psf_shd.g_old_rec.information22, hr_api.g_varchar2) <>
7866: nvl(p_rec.information22, hr_api.g_varchar2) or
7867: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7868: nvl(p_rec.information23, hr_api.g_varchar2) or
7869: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7870: nvl(p_rec.information24, hr_api.g_varchar2) or
7871: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7872: nvl(p_rec.information25, hr_api.g_varchar2) or
7873: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7867: nvl(hr_psf_shd.g_old_rec.information23, hr_api.g_varchar2) <>
7868: nvl(p_rec.information23, hr_api.g_varchar2) or
7869: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7870: nvl(p_rec.information24, hr_api.g_varchar2) or
7871: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7872: nvl(p_rec.information25, hr_api.g_varchar2) or
7873: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7874: nvl(p_rec.information26, hr_api.g_varchar2) or
7875: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7869: nvl(hr_psf_shd.g_old_rec.information24, hr_api.g_varchar2) <>
7870: nvl(p_rec.information24, hr_api.g_varchar2) or
7871: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7872: nvl(p_rec.information25, hr_api.g_varchar2) or
7873: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7874: nvl(p_rec.information26, hr_api.g_varchar2) or
7875: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7876: nvl(p_rec.information27, hr_api.g_varchar2) or
7877: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7871: nvl(hr_psf_shd.g_old_rec.information25, hr_api.g_varchar2) <>
7872: nvl(p_rec.information25, hr_api.g_varchar2) or
7873: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7874: nvl(p_rec.information26, hr_api.g_varchar2) or
7875: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7876: nvl(p_rec.information27, hr_api.g_varchar2) or
7877: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7878: nvl(p_rec.information28, hr_api.g_varchar2) or
7879: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7873: nvl(hr_psf_shd.g_old_rec.information26, hr_api.g_varchar2) <>
7874: nvl(p_rec.information26, hr_api.g_varchar2) or
7875: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7876: nvl(p_rec.information27, hr_api.g_varchar2) or
7877: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7878: nvl(p_rec.information28, hr_api.g_varchar2) or
7879: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7880: nvl(p_rec.information29, hr_api.g_varchar2) or
7881: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>
7875: nvl(hr_psf_shd.g_old_rec.information27, hr_api.g_varchar2) <>
7876: nvl(p_rec.information27, hr_api.g_varchar2) or
7877: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7878: nvl(p_rec.information28, hr_api.g_varchar2) or
7879: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7880: nvl(p_rec.information29, hr_api.g_varchar2) or
7881: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>
7882: nvl(p_rec.information30, hr_api.g_varchar2))
7883: then
7877: nvl(hr_psf_shd.g_old_rec.information28, hr_api.g_varchar2) <>
7878: nvl(p_rec.information28, hr_api.g_varchar2) or
7879: nvl(hr_psf_shd.g_old_rec.information29, hr_api.g_varchar2) <>
7880: nvl(p_rec.information29, hr_api.g_varchar2) or
7881: nvl(hr_psf_shd.g_old_rec.information30, hr_api.g_varchar2) <>
7882: nvl(p_rec.information30, hr_api.g_varchar2))
7883: then
7884: --
7885: hr_dflex_utility.ins_or_upd_descflex_attribs
7989: -- Access Status:
7990: -- Internal Row Handler Use Only.
7991: --
7992: procedure chk_df
7993: (p_rec in hr_psf_shd.g_rec_type) is
7994: --
7995: l_proc varchar2(72);
7996: --
7997: begin
8001: hr_utility.set_location('Entering:'||l_proc, 10);
8002: end if;
8003: --
8004: if ((p_rec.position_id is not null) and (
8005: nvl(hr_psf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
8006: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
8007: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
8008: nvl(p_rec.attribute1, hr_api.g_varchar2) or
8009: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
8003: --
8004: if ((p_rec.position_id is not null) and (
8005: nvl(hr_psf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
8006: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
8007: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
8008: nvl(p_rec.attribute1, hr_api.g_varchar2) or
8009: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
8010: nvl(p_rec.attribute2, hr_api.g_varchar2) or
8011: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
8005: nvl(hr_psf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
8006: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
8007: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
8008: nvl(p_rec.attribute1, hr_api.g_varchar2) or
8009: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
8010: nvl(p_rec.attribute2, hr_api.g_varchar2) or
8011: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
8012: nvl(p_rec.attribute3, hr_api.g_varchar2) or
8013: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
8007: nvl(hr_psf_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
8008: nvl(p_rec.attribute1, hr_api.g_varchar2) or
8009: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
8010: nvl(p_rec.attribute2, hr_api.g_varchar2) or
8011: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
8012: nvl(p_rec.attribute3, hr_api.g_varchar2) or
8013: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
8014: nvl(p_rec.attribute4, hr_api.g_varchar2) or
8015: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
8009: nvl(hr_psf_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
8010: nvl(p_rec.attribute2, hr_api.g_varchar2) or
8011: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
8012: nvl(p_rec.attribute3, hr_api.g_varchar2) or
8013: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
8014: nvl(p_rec.attribute4, hr_api.g_varchar2) or
8015: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
8016: nvl(p_rec.attribute5, hr_api.g_varchar2) or
8017: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
8011: nvl(hr_psf_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
8012: nvl(p_rec.attribute3, hr_api.g_varchar2) or
8013: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
8014: nvl(p_rec.attribute4, hr_api.g_varchar2) or
8015: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
8016: nvl(p_rec.attribute5, hr_api.g_varchar2) or
8017: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
8018: nvl(p_rec.attribute6, hr_api.g_varchar2) or
8019: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
8013: nvl(hr_psf_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
8014: nvl(p_rec.attribute4, hr_api.g_varchar2) or
8015: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
8016: nvl(p_rec.attribute5, hr_api.g_varchar2) or
8017: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
8018: nvl(p_rec.attribute6, hr_api.g_varchar2) or
8019: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
8020: nvl(p_rec.attribute7, hr_api.g_varchar2) or
8021: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
8015: nvl(hr_psf_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
8016: nvl(p_rec.attribute5, hr_api.g_varchar2) or
8017: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
8018: nvl(p_rec.attribute6, hr_api.g_varchar2) or
8019: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
8020: nvl(p_rec.attribute7, hr_api.g_varchar2) or
8021: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
8022: nvl(p_rec.attribute8, hr_api.g_varchar2) or
8023: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
8017: nvl(hr_psf_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
8018: nvl(p_rec.attribute6, hr_api.g_varchar2) or
8019: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
8020: nvl(p_rec.attribute7, hr_api.g_varchar2) or
8021: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
8022: nvl(p_rec.attribute8, hr_api.g_varchar2) or
8023: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
8024: nvl(p_rec.attribute9, hr_api.g_varchar2) or
8025: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
8019: nvl(hr_psf_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
8020: nvl(p_rec.attribute7, hr_api.g_varchar2) or
8021: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
8022: nvl(p_rec.attribute8, hr_api.g_varchar2) or
8023: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
8024: nvl(p_rec.attribute9, hr_api.g_varchar2) or
8025: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
8026: nvl(p_rec.attribute10, hr_api.g_varchar2) or
8027: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
8021: nvl(hr_psf_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
8022: nvl(p_rec.attribute8, hr_api.g_varchar2) or
8023: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
8024: nvl(p_rec.attribute9, hr_api.g_varchar2) or
8025: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
8026: nvl(p_rec.attribute10, hr_api.g_varchar2) or
8027: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
8028: nvl(p_rec.attribute11, hr_api.g_varchar2) or
8029: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
8023: nvl(hr_psf_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
8024: nvl(p_rec.attribute9, hr_api.g_varchar2) or
8025: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
8026: nvl(p_rec.attribute10, hr_api.g_varchar2) or
8027: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
8028: nvl(p_rec.attribute11, hr_api.g_varchar2) or
8029: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
8030: nvl(p_rec.attribute12, hr_api.g_varchar2) or
8031: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
8025: nvl(hr_psf_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
8026: nvl(p_rec.attribute10, hr_api.g_varchar2) or
8027: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
8028: nvl(p_rec.attribute11, hr_api.g_varchar2) or
8029: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
8030: nvl(p_rec.attribute12, hr_api.g_varchar2) or
8031: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
8032: nvl(p_rec.attribute13, hr_api.g_varchar2) or
8033: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
8027: nvl(hr_psf_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
8028: nvl(p_rec.attribute11, hr_api.g_varchar2) or
8029: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
8030: nvl(p_rec.attribute12, hr_api.g_varchar2) or
8031: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
8032: nvl(p_rec.attribute13, hr_api.g_varchar2) or
8033: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
8034: nvl(p_rec.attribute14, hr_api.g_varchar2) or
8035: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
8029: nvl(hr_psf_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
8030: nvl(p_rec.attribute12, hr_api.g_varchar2) or
8031: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
8032: nvl(p_rec.attribute13, hr_api.g_varchar2) or
8033: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
8034: nvl(p_rec.attribute14, hr_api.g_varchar2) or
8035: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
8036: nvl(p_rec.attribute15, hr_api.g_varchar2) or
8037: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
8031: nvl(hr_psf_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
8032: nvl(p_rec.attribute13, hr_api.g_varchar2) or
8033: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
8034: nvl(p_rec.attribute14, hr_api.g_varchar2) or
8035: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
8036: nvl(p_rec.attribute15, hr_api.g_varchar2) or
8037: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
8038: nvl(p_rec.attribute16, hr_api.g_varchar2) or
8039: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
8033: nvl(hr_psf_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
8034: nvl(p_rec.attribute14, hr_api.g_varchar2) or
8035: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
8036: nvl(p_rec.attribute15, hr_api.g_varchar2) or
8037: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
8038: nvl(p_rec.attribute16, hr_api.g_varchar2) or
8039: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
8040: nvl(p_rec.attribute17, hr_api.g_varchar2) or
8041: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
8035: nvl(hr_psf_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
8036: nvl(p_rec.attribute15, hr_api.g_varchar2) or
8037: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
8038: nvl(p_rec.attribute16, hr_api.g_varchar2) or
8039: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
8040: nvl(p_rec.attribute17, hr_api.g_varchar2) or
8041: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
8042: nvl(p_rec.attribute18, hr_api.g_varchar2) or
8043: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
8037: nvl(hr_psf_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
8038: nvl(p_rec.attribute16, hr_api.g_varchar2) or
8039: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
8040: nvl(p_rec.attribute17, hr_api.g_varchar2) or
8041: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
8042: nvl(p_rec.attribute18, hr_api.g_varchar2) or
8043: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
8044: nvl(p_rec.attribute19, hr_api.g_varchar2) or
8045: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
8039: nvl(hr_psf_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
8040: nvl(p_rec.attribute17, hr_api.g_varchar2) or
8041: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
8042: nvl(p_rec.attribute18, hr_api.g_varchar2) or
8043: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
8044: nvl(p_rec.attribute19, hr_api.g_varchar2) or
8045: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
8046: nvl(p_rec.attribute20, hr_api.g_varchar2) or
8047: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
8041: nvl(hr_psf_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
8042: nvl(p_rec.attribute18, hr_api.g_varchar2) or
8043: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
8044: nvl(p_rec.attribute19, hr_api.g_varchar2) or
8045: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
8046: nvl(p_rec.attribute20, hr_api.g_varchar2) or
8047: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
8048: nvl(p_rec.attribute21, hr_api.g_varchar2) or
8049: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
8043: nvl(hr_psf_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
8044: nvl(p_rec.attribute19, hr_api.g_varchar2) or
8045: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
8046: nvl(p_rec.attribute20, hr_api.g_varchar2) or
8047: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
8048: nvl(p_rec.attribute21, hr_api.g_varchar2) or
8049: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
8050: nvl(p_rec.attribute22, hr_api.g_varchar2) or
8051: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
8045: nvl(hr_psf_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
8046: nvl(p_rec.attribute20, hr_api.g_varchar2) or
8047: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
8048: nvl(p_rec.attribute21, hr_api.g_varchar2) or
8049: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
8050: nvl(p_rec.attribute22, hr_api.g_varchar2) or
8051: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
8052: nvl(p_rec.attribute23, hr_api.g_varchar2) or
8053: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
8047: nvl(hr_psf_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
8048: nvl(p_rec.attribute21, hr_api.g_varchar2) or
8049: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
8050: nvl(p_rec.attribute22, hr_api.g_varchar2) or
8051: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
8052: nvl(p_rec.attribute23, hr_api.g_varchar2) or
8053: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
8054: nvl(p_rec.attribute24, hr_api.g_varchar2) or
8055: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
8049: nvl(hr_psf_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
8050: nvl(p_rec.attribute22, hr_api.g_varchar2) or
8051: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
8052: nvl(p_rec.attribute23, hr_api.g_varchar2) or
8053: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
8054: nvl(p_rec.attribute24, hr_api.g_varchar2) or
8055: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
8056: nvl(p_rec.attribute25, hr_api.g_varchar2) or
8057: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
8051: nvl(hr_psf_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
8052: nvl(p_rec.attribute23, hr_api.g_varchar2) or
8053: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
8054: nvl(p_rec.attribute24, hr_api.g_varchar2) or
8055: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
8056: nvl(p_rec.attribute25, hr_api.g_varchar2) or
8057: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
8058: nvl(p_rec.attribute26, hr_api.g_varchar2) or
8059: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
8053: nvl(hr_psf_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
8054: nvl(p_rec.attribute24, hr_api.g_varchar2) or
8055: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
8056: nvl(p_rec.attribute25, hr_api.g_varchar2) or
8057: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
8058: nvl(p_rec.attribute26, hr_api.g_varchar2) or
8059: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
8060: nvl(p_rec.attribute27, hr_api.g_varchar2) or
8061: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
8055: nvl(hr_psf_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
8056: nvl(p_rec.attribute25, hr_api.g_varchar2) or
8057: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
8058: nvl(p_rec.attribute26, hr_api.g_varchar2) or
8059: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
8060: nvl(p_rec.attribute27, hr_api.g_varchar2) or
8061: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
8062: nvl(p_rec.attribute28, hr_api.g_varchar2) or
8063: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
8057: nvl(hr_psf_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
8058: nvl(p_rec.attribute26, hr_api.g_varchar2) or
8059: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
8060: nvl(p_rec.attribute27, hr_api.g_varchar2) or
8061: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
8062: nvl(p_rec.attribute28, hr_api.g_varchar2) or
8063: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
8064: nvl(p_rec.attribute29, hr_api.g_varchar2) or
8065: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
8059: nvl(hr_psf_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
8060: nvl(p_rec.attribute27, hr_api.g_varchar2) or
8061: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
8062: nvl(p_rec.attribute28, hr_api.g_varchar2) or
8063: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
8064: nvl(p_rec.attribute29, hr_api.g_varchar2) or
8065: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
8066: nvl(p_rec.attribute30, hr_api.g_varchar2)))
8067: or (p_rec.position_id is null) then
8061: nvl(hr_psf_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
8062: nvl(p_rec.attribute28, hr_api.g_varchar2) or
8063: nvl(hr_psf_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
8064: nvl(p_rec.attribute29, hr_api.g_varchar2) or
8065: nvl(hr_psf_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
8066: nvl(p_rec.attribute30, hr_api.g_varchar2)))
8067: or (p_rec.position_id is null) then
8068: --
8069: -- Only execute the validation if absolutely necessary:
8268: select min(psf.effective_start_date)
8269: from
8270: hr_all_positions_f psf
8271: where psf.position_id = p_position_id
8272: and hr_psf_shd.get_availability_status(psf.availability_status_id
8273: ,psf.business_group_id) = 'ACTIVE';
8274:
8275: --
8276: l_minesd date;
8327: select count(*)
8328: from
8329: hr_all_positions_f psf
8330: where psf.position_id = p_position_id
8331: and hr_psf_shd.get_availability_status(psf.availability_status_id
8332: ,psf.business_group_id) <> 'PROPOSED';
8333: --
8334: cursor c2 is
8335: select min(psf.effective_Start_Date)
8387: select count(*)
8388: from
8389: hr_all_positions_f psf
8390: where psf.position_id = p_position_id
8391: and hr_psf_shd.get_availability_status(psf.availability_status_id
8392: ,psf.business_group_id) <> 'PROPOSED';
8393: --
8394: Begin
8395: --
8642: l_proc := g_package||'chk_permanent_seasonal_flag';
8643: hr_utility.set_location('Entering:'||l_proc, 5);
8644: end if;
8645: --
8646: l_api_updating := hr_psf_shd.api_updating
8647: (p_position_id => p_position_id
8648: ,p_effective_date => p_effective_date
8649: ,p_object_version_number => p_object_version_number);
8650: --
8648: ,p_effective_date => p_effective_date
8649: ,p_object_version_number => p_object_version_number);
8650: --
8651: if ((l_api_updating and
8652: (p_permanent_temporary_flag <> nvl(hr_psf_shd.g_old_rec.permanent_temporary_flag,hr_api.g_varchar2)
8653: or p_seasonal_flag <> nvl(hr_psf_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)))
8654: or not l_api_updating) then
8655: if (p_permanent_temporary_flag is not null and p_seasonal_flag is not null) then
8656: if(p_seasonal_flag = 'Y' and p_permanent_temporary_flag = 'Y') then
8649: ,p_object_version_number => p_object_version_number);
8650: --
8651: if ((l_api_updating and
8652: (p_permanent_temporary_flag <> nvl(hr_psf_shd.g_old_rec.permanent_temporary_flag,hr_api.g_varchar2)
8653: or p_seasonal_flag <> nvl(hr_psf_shd.g_old_rec.seasonal_flag,hr_api.g_varchar2)))
8654: or not l_api_updating) then
8655: if (p_permanent_temporary_flag is not null and p_seasonal_flag is not null) then
8656: if(p_seasonal_flag = 'Y' and p_permanent_temporary_flag = 'Y') then
8657: -- raise error as both flags are set to Y.