[Home] [Help]
1: Package Body per_asg_bus1 as
2: /* $Header: peasgrhi.pkb 120.19.12010000.3 2008/11/12 06:37:24 skura ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_asg_bus1.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- The following two global variables are only to be
12: -- used by the return_legislation_code function.
333: if g_debug then
334: hr_utility.set_location(l_proc, 8);
335: end if;
336: --
337: per_asg_bus1.chk_future_primary
338: (p_assignment_id => p_rec.assignment_id
339: ,p_primary_flag => per_asg_shd.g_old_rec.primary_flag
340: ,p_datetrack_mode => p_datetrack_mode
341: ,p_effective_date => p_effective_date
355: if g_debug then
356: hr_utility.set_location(l_proc, 10);
357: end if;
358: --
359: per_asg_bus1.dt_delete_validate
360:
361: (p_assignment_id => p_rec.assignment_id
362: ,p_datetrack_mode => p_datetrack_mode
363: ,p_validation_start_date => p_validation_start_date
383: if g_debug then
384: hr_utility.set_location(l_proc, 30);
385: end if;
386: --
387: per_asg_bus1.chk_del_organization_id
388: (p_assignment_id => p_rec.assignment_id
389: ,p_effective_date => p_effective_date
390: ,p_manager_flag => p_rec.manager_flag
391:
1055: if g_debug then
1056: hr_utility.set_location(l_proc, 27);
1057: end if;
1058: --
1059: per_asg_bus1.chk_assignment_type
1060: (p_assignment_id => p_rec.assignment_id
1061: ,p_assignment_type => p_rec.assignment_type
1062: ,p_person_id => p_rec.person_id
1063: ,p_effective_date => p_effective_date
1131: if g_debug then
1132: hr_utility.set_location(l_proc, 70);
1133: end if;
1134: --
1135: per_asg_bus1.chk_date_probation_end
1136: (p_assignment_id => p_rec.assignment_id
1137: ,p_date_probation_end => p_rec.date_probation_end
1138: ,p_assignment_type => p_rec.assignment_type
1139: ,p_probation_period => p_rec.probation_period
1156: if g_debug then
1157: hr_utility.set_location(l_proc, 90);
1158: end if;
1159: --
1160: per_asg_bus1.chk_change_reason
1161: (p_assignment_id => p_rec.assignment_id
1162: ,p_assignment_type => p_rec.assignment_type
1163: ,p_change_reason => p_rec.change_reason
1164: ,p_effective_date => p_effective_date
1169: if g_debug then
1170: hr_utility.set_location(l_proc, 100);
1171: end if;
1172: --
1173: per_asg_bus1.chk_default_code_comb_id
1174: (p_assignment_id => p_rec.assignment_id
1175: ,p_default_code_comb_id => p_rec.default_code_comb_id
1176: ,p_assignment_type => p_rec.assignment_type
1177: ,p_effective_date => p_effective_date
1181: if g_debug then
1182: hr_utility.set_location(l_proc, 110);
1183: end if;
1184: --
1185: per_asg_bus1.chk_employment_category
1186: (p_assignment_id => p_rec.assignment_id
1187: ,p_assignment_type => p_rec.assignment_type
1188: ,p_employment_category => p_rec.employment_category
1189: ,p_effective_date => p_effective_date
1264: if g_debug then
1265: hr_utility.set_location(l_proc, 180);
1266: end if;
1267: --
1268: per_asg_bus1.chk_frequency
1269: (p_assignment_id => p_rec.assignment_id
1270: ,p_frequency => p_rec.frequency
1271: ,p_effective_date => p_effective_date
1272: ,p_validation_start_date => p_validation_start_date
1276: if g_debug then
1277: hr_utility.set_location(l_proc, 190);
1278: end if;
1279: --
1280: per_asg_bus1.chk_frequency_normal_hours
1281: (p_assignment_id => p_rec.assignment_id
1282: ,p_frequency => p_rec.frequency
1283: ,p_normal_hours => p_rec.normal_hours
1284: ,p_effective_date => p_effective_date
1368: if g_debug then
1369: hr_utility.set_location(l_proc, 270);
1370: end if;
1371: --
1372: per_asg_bus1.chk_location_id
1373: (p_assignment_id => p_rec.assignment_id
1374: ,p_location_id => p_rec.location_id
1375: ,p_assignment_type => p_rec.assignment_type
1376: ,p_vacancy_id => p_rec.vacancy_id
1418: if g_debug then
1419: hr_utility.set_location(l_proc, 300);
1420: end if;
1421: -- fix for 6331872 starts here
1422: per_asg_bus1.chk_frozen_single_pos
1423: (p_assignment_id => p_rec.assignment_id
1424: ,p_position_id => p_rec.position_id
1425: ,p_effective_date => p_effective_date
1426: );
1428: if g_debug then
1429: hr_utility.set_location(p_validation_end_date, 305);
1430: end if;
1431: -- fix for 6331872 ends here
1432: per_asg_bus1.chk_job_id
1433: (p_assignment_id => p_rec.assignment_id
1434: ,p_business_group_id => p_rec.business_group_id
1435: ,p_assignment_type => p_rec.assignment_type
1436: ,p_job_id => p_rec.job_id
1456: if g_debug then
1457: hr_utility.set_location(l_proc, 320);
1458: end if;
1459: --
1460: per_asg_bus1.chk_grade_id
1461: (p_assignment_id => p_rec.assignment_id
1462: ,p_business_group_id => p_rec.business_group_id
1463: ,p_assignment_type => p_rec.assignment_type
1464: ,p_grade_id => p_rec.grade_id
1501: if g_debug then
1502: hr_utility.set_location(l_proc, 350);
1503: end if;
1504: --
1505: per_asg_bus1.chk_job_id_grade_id
1506: (p_assignment_id => p_rec.assignment_id
1507: ,p_job_id => p_rec.job_id
1508: ,p_grade_id => p_rec.grade_id
1509: ,p_validation_start_date => p_validation_start_date
1604: if g_debug then
1605: hr_utility.set_location(l_proc, 410);
1606: end if;
1607: --
1608: per_asg_bus1.gen_chk_assignment_number
1609: (p_assignment_id => p_rec.assignment_id
1610: ,p_business_group_id => p_rec.business_group_id
1611: ,p_assignment_type => p_rec.assignment_type
1612: ,p_assignment_sequence => p_rec.assignment_sequence
1648: ,p_assignment_id => p_rec.assignment_id
1649: ,p_object_version_number => p_rec.object_version_number
1650: ,p_effective_date => p_effective_date);
1651:
1652: per_asg_bus1.chk_manager_flag
1653: (p_assignment_id => p_rec.assignment_id
1654: ,p_assignment_type => p_rec.assignment_type
1655: ,p_organization_id => p_rec.organization_id
1656: ,p_manager_flag => p_rec.manager_flag
1662: if g_debug then
1663: hr_utility.set_location(l_proc, 440);
1664: end if;
1665: --
1666: per_asg_bus1.chk_organization_id
1667: (p_assignment_id => p_rec.assignment_id
1668: ,p_primary_flag => p_rec.primary_flag
1669: ,p_organization_id => p_rec.organization_id
1670: ,p_business_group_id => p_rec.business_group_id
1694: if g_debug then
1695: hr_utility.set_location(l_proc, 460);
1696: end if;
1697: --
1698: per_asg_bus1.chk_application_id
1699: (p_assignment_id => p_rec.assignment_id
1700: ,p_assignment_type => p_rec.assignment_type
1701: ,p_business_group_id => p_rec.business_group_id
1702: ,p_assignment_sequence => p_rec.assignment_sequence
1725: if g_debug then
1726: hr_utility.set_location(l_proc, 490);
1727: end if;
1728: --
1729: per_asg_bus1.chk_assignment_status_type_id
1730: (p_rec => p_rec
1731: ,p_effective_date => p_effective_date
1732: ,p_validation_start_date => p_validation_start_date
1733: );
1734: if g_debug then
1735: hr_utility.set_location(l_proc, 500);
1736: end if;
1737: --
1738: per_asg_bus1.chk_bargaining_unit_code
1739: (p_assignment_id => p_rec.assignment_id
1740: ,p_bargaining_unit_code => p_rec.bargaining_unit_code
1741: ,p_effective_date => p_effective_date
1742: ,p_object_version_number => p_rec.object_version_number
1746: if g_debug then
1747: hr_utility.set_location(l_proc, 511);
1748: end if;
1749: --
1750: per_asg_bus1.chk_hourly_salaried_code
1751: (p_assignment_id => p_rec.assignment_id
1752: ,p_hourly_salaried_code => p_rec.hourly_salaried_code
1753: ,p_effective_date => p_effective_date
1754: ,p_object_version_number => p_rec.object_version_number
1757: ,p_pay_basis_id => p_rec.pay_basis_id
1758: ,p_hourly_salaried_warning => l_hourly_salaried_warning
1759: ,p_assignment_type => p_rec.assignment_type);
1760: --
1761: per_asg_bus1.chk_single_position
1762: (p_assignment_id => p_rec.assignment_id
1763: ,p_position_id => p_rec.position_id
1764: ,p_effective_date => p_effective_date
1765: ,p_object_version_number => p_rec.object_version_number
1859: if g_debug then
1860: hr_utility.set_location(l_proc, 600);
1861: end if;
1862: --
1863: per_asg_bus1.chk_assignment_category
1864: (p_assignment_id => p_rec.assignment_id
1865: ,p_assignment_type => p_rec.assignment_type
1866: ,p_effective_date => p_effective_date
1867: ,p_assignment_category => p_rec.assignment_category
2023: --
2024: --
2025: -- Call descriptive flexfield validation routines
2026: --
2027: per_asg_bus1.chk_df(p_rec => p_rec
2028: ,p_validate_df_flex => p_validate_df_flex);
2029: --
2030: p_other_manager_warning := l_other_manager_warning;
2031: p_hourly_salaried_warning := l_hourly_salaried_warning;
2133: -- CHK_PERSON_ID / c
2134: -- GEN_ASSIGNMENT_SEQUENCE / c
2135: -- CHK_ASSIGNMENT_ID / e
2136: --
2137: per_asg_bus1.check_non_updateable_args
2138: (p_rec => p_rec
2139: ,p_effective_date => p_effective_date
2140: );
2141: if g_debug then
2178: if g_debug then
2179: hr_utility.set_location(l_proc, 30);
2180: end if;
2181: --
2182: per_asg_bus1.chk_assignment_type
2183: (p_assignment_id => p_rec.assignment_id
2184: ,p_assignment_type => p_rec.assignment_type
2185: ,p_person_id => p_rec.person_id
2186: ,p_effective_date => p_effective_date
2239: if g_debug then
2240: hr_utility.set_location(l_proc, 70);
2241: end if;
2242: --
2243: per_asg_bus1.chk_date_probation_end
2244: (p_assignment_id => p_rec.assignment_id
2245: ,p_date_probation_end => p_rec.date_probation_end
2246: ,p_assignment_type => p_rec.assignment_type
2247: ,p_probation_period => p_rec.probation_period
2266: if g_debug then
2267: hr_utility.set_location(l_proc, 90);
2268: end if;
2269: --
2270: per_asg_bus1.chk_change_reason
2271: (p_assignment_id => p_rec.assignment_id
2272: ,p_assignment_type => p_rec.assignment_type
2273: ,p_change_reason => p_rec.change_reason
2274: ,p_effective_date => p_effective_date
2280: hr_utility.set_location(l_proc, 100);
2281: end if;
2282: --
2283:
2284: per_asg_bus1.chk_default_code_comb_id
2285: (p_assignment_id => p_rec.assignment_id
2286: ,p_default_code_comb_id => p_rec.default_code_comb_id
2287: ,p_assignment_type => p_rec.assignment_type
2288: ,p_effective_date => p_effective_date
2292: if g_debug then
2293: hr_utility.set_location(l_proc, 110);
2294: end if;
2295: --
2296: per_asg_bus1.chk_employment_category
2297: (p_assignment_id => p_rec.assignment_id
2298: ,p_assignment_type => p_rec.assignment_type
2299:
2300: ,p_employment_category => p_rec.employment_category
2381: hr_utility.set_location(l_proc, 180);
2382: end if;
2383:
2384: --
2385: per_asg_bus1.chk_frequency
2386: (p_assignment_id => p_rec.assignment_id
2387: ,p_frequency => p_rec.frequency
2388: ,p_effective_date => p_effective_date
2389: ,p_validation_start_date => p_validation_start_date
2393: if g_debug then
2394: hr_utility.set_location(l_proc, 190);
2395: end if;
2396: --
2397: per_asg_bus1.chk_frequency_normal_hours
2398: (p_assignment_id => p_rec.assignment_id
2399:
2400: ,p_frequency => p_rec.frequency
2401: ,p_normal_hours => p_rec.normal_hours
2490: if g_debug then
2491: hr_utility.set_location(l_proc, 260);
2492: end if;
2493: --
2494: per_asg_bus1.chk_location_id
2495: (p_assignment_id => p_rec.assignment_id
2496: ,p_location_id => p_rec.location_id
2497: ,p_assignment_type => p_rec.assignment_type
2498:
2543: if g_debug then
2544: hr_utility.set_location(l_proc, 290);
2545: end if;
2546: --
2547: per_asg_bus1.chk_job_id
2548: (p_assignment_id => p_rec.assignment_id
2549: ,p_business_group_id => p_rec.business_group_id
2550: ,p_assignment_type => p_rec.assignment_type
2551: ,p_job_id => p_rec.job_id
2573: if g_debug then
2574: hr_utility.set_location(l_proc, 310);
2575: end if;
2576: --
2577: per_asg_bus1.chk_grade_id
2578: (p_assignment_id => p_rec.assignment_id
2579: ,p_business_group_id => p_rec.business_group_id
2580: ,p_assignment_type => p_rec.assignment_type
2581: ,p_grade_id => p_rec.grade_id
2621: if g_debug then
2622: hr_utility.set_location(l_proc, 340);
2623: end if;
2624: --
2625: per_asg_bus1.chk_job_id_grade_id
2626: (p_assignment_id => p_rec.assignment_id
2627: ,p_job_id => p_rec.job_id
2628: ,p_grade_id => p_rec.grade_id
2629: ,p_validation_start_date => p_validation_start_date
2730: end if;
2731: if ( l_assignment_sequence =1 ) then
2732: hr_utility.set_location(l_proc, 386);
2733: p_rec.assignment_sequence:=1;
2734: per_asg_bus1.gen_chk_assignment_number
2735: (p_assignment_id => p_rec.assignment_id
2736: ,p_business_group_id => p_rec.business_group_id
2737: ,p_assignment_type => p_rec.assignment_type
2738: ,p_assignment_sequence => p_rec.assignment_sequence
2743: );
2744: hr_utility.set_location(l_proc, 387);
2745: else
2746: hr_utility.set_location(l_proc, 388);
2747: per_asg_bus1.gen_chk_assignment_number
2748: (p_assignment_id => p_rec.assignment_id
2749: ,p_business_group_id => p_rec.business_group_id
2750: ,p_assignment_type => p_rec.assignment_type
2751: ,p_assignment_sequence => p_rec.assignment_sequence
2778: if g_debug then
2779: hr_utility.set_location(l_proc, 430);
2780: end if;
2781: --
2782: per_asg_bus1.chk_manager_flag
2783: (p_assignment_id => p_rec.assignment_id
2784: ,p_assignment_type => p_rec.assignment_type
2785: ,p_organization_id => p_rec.organization_id
2786: ,p_manager_flag => p_rec.manager_flag
2793: if g_debug then
2794: hr_utility.set_location(l_proc, 400);
2795: end if;
2796: --
2797: per_asg_bus1.chk_organization_id
2798: (p_assignment_id => p_rec.assignment_id
2799: ,p_primary_flag => p_rec.primary_flag
2800: ,p_organization_id => p_rec.organization_id
2801: ,p_business_group_id => p_rec.business_group_id
2827: if g_debug then
2828: hr_utility.set_location(l_proc, 420);
2829: end if;
2830: --
2831: per_asg_bus1.chk_application_id
2832: (p_assignment_id => p_rec.assignment_id
2833: ,p_assignment_type => p_rec.assignment_type
2834: ,p_business_group_id => p_rec.business_group_id
2835: ,p_assignment_sequence => p_rec.assignment_sequence
2860: if g_debug then
2861: hr_utility.set_location(l_proc, 440);
2862: end if;
2863: --
2864: per_asg_bus1.chk_assignment_status_type_id
2865: (p_rec => p_rec
2866: ,p_effective_date => p_effective_date
2867: ,p_validation_start_date => p_validation_start_date
2868: );
2869: if g_debug then
2870: hr_utility.set_location(l_proc, 450);
2871: end if;
2872: --
2873: per_asg_bus1.chk_bargaining_unit_code
2874: (p_assignment_id => p_rec.assignment_id
2875: ,p_bargaining_unit_code => p_rec.bargaining_unit_code
2876: ,p_effective_date => p_effective_date
2877: ,p_object_version_number => p_rec.object_version_number
2881: if g_debug then
2882: hr_utility.set_location(l_proc, 451);
2883: end if;
2884: --
2885: per_asg_bus1.chk_hourly_salaried_code
2886: (p_assignment_id => p_rec.assignment_id
2887: ,p_hourly_salaried_code => p_rec.hourly_salaried_code
2888: ,p_effective_date => p_effective_date
2889: ,p_object_version_number => p_rec.object_version_number
2896: if g_debug then
2897: hr_utility.set_location(l_proc, 452);
2898: end if;
2899: --
2900: per_asg_bus1.chk_single_position
2901: (p_assignment_id => p_rec.assignment_id
2902: ,p_position_id => p_rec.position_id
2903: ,p_effective_date => p_effective_date
2904: ,p_object_version_number => p_rec.object_version_number
2999: if g_debug then
3000: hr_utility.set_location(l_proc, 600);
3001: end if;
3002: --
3003: per_asg_bus1.chk_assignment_category
3004: (p_assignment_id => p_rec.assignment_id
3005: ,p_assignment_type => p_rec.assignment_type
3006: ,p_effective_date => p_effective_date
3007: ,p_assignment_category => p_rec.assignment_category
3181: --
3182: --
3183: -- Call descriptive flexfield validation routines
3184: --
3185: per_asg_bus1.chk_df(p_rec => p_rec);
3186:
3187: if g_debug then
3188: hr_utility.set_location(l_proc, 750);
3189: end if;
3189: end if;
3190: --
3191: -- Call the datetrack update integrity operation
3192: --
3193: per_asg_bus1.dt_update_validate
3194: (p_payroll_id => p_rec.payroll_id,
3195: p_person_id => p_rec.person_id,
3196: p_datetrack_mode => p_datetrack_mode,
3197: p_validation_start_date => p_validation_start_date,
5522: if g_debug then
5523: hr_utility.set_location(l_proc, 65);
5524: end if;
5525:
5526: per_asg_bus1.chk_assignment_category
5527: (p_assignment_id => p_assignment_id
5528: ,p_assignment_type => p_assignment_type
5529: ,p_effective_date => p_effective_date
5530: ,p_assignment_category => p_employment_category
7338: if not l_asg_in_overlap_dates then
7339: -- Check whether there are any assignments attached to a Single Position
7340: if (p_assignment_type = 'E' or p_assignment_type = 'C') then -- 6397484(forward port of 6356978)
7341: /*---- Start change for the bug 5854568 ----(modified for the bug 6331872)*/
7342: if (per_asg_bus1.pos_assignments_exists(p_position_id, p_effective_date, p_assignment_id) and p_assignment_type in ('E','C'))
7343: /*---- End change for the bug 5854568 ----(modified for the bug 6331872)*/
7344: then
7345: hr_utility.set_message(800, 'PER_ASG_EXISTS_FOR_SINGLE_POS');
7346: hr_multi_message.add
7405: nvl(p_position_id, hr_api.g_number)))
7406: or
7407: (NOT l_api_updating)
7408: then
7409: per_asg_bus1.chk_frozen_single_pos
7410: (p_assignment_id => p_assignment_id
7411: ,p_position_id => p_position_id
7412: ,p_effective_date => p_effective_date
7413: ,p_assignment_type => p_assignment_type
7473: return(false);
7474: end if;
7475: end;
7476: --
7477: end per_asg_bus1;