[Home] [Help]
1: Package Body per_asg_bus1 as
2: /* $Header: peasgrhi.pkb 120.44.12020000.3 2013/02/13 07:11:42 srannama 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
373: hr_utility.set_location(l_proc, 11);
374: end if;
375: -- End changes for bug 8687386
376: --
377: per_asg_bus1.dt_delete_validate
378:
379: (p_assignment_id => p_rec.assignment_id
380: ,p_datetrack_mode => p_datetrack_mode
381: ,p_validation_start_date => p_validation_start_date
401: if g_debug then
402: hr_utility.set_location(l_proc, 30);
403: end if;
404: --
405: per_asg_bus1.chk_del_organization_id
406: (p_assignment_id => p_rec.assignment_id
407: ,p_effective_date => p_effective_date
408: ,p_manager_flag => p_rec.manager_flag
409:
1128: if g_debug then
1129: hr_utility.set_location(l_proc, 27);
1130: end if;
1131: --
1132: per_asg_bus1.chk_assignment_type
1133: (p_assignment_id => p_rec.assignment_id
1134: ,p_assignment_type => p_rec.assignment_type
1135: ,p_person_id => p_rec.person_id
1136: ,p_effective_date => p_effective_date
1225: if g_debug then
1226: hr_utility.set_location(l_proc, 70);
1227: end if;
1228: --
1229: per_asg_bus1.chk_date_probation_end
1230: (p_assignment_id => p_rec.assignment_id
1231: ,p_date_probation_end => p_rec.date_probation_end
1232: ,p_assignment_type => p_rec.assignment_type
1233: ,p_probation_period => p_rec.probation_period
1250: if g_debug then
1251: hr_utility.set_location(l_proc, 90);
1252: end if;
1253: --
1254: per_asg_bus1.chk_change_reason
1255: (p_assignment_id => p_rec.assignment_id
1256: ,p_assignment_type => p_rec.assignment_type
1257: ,p_change_reason => p_rec.change_reason
1258: ,p_effective_date => p_effective_date
1263: if g_debug then
1264: hr_utility.set_location(l_proc, 100);
1265: end if;
1266: --
1267: per_asg_bus1.chk_default_code_comb_id
1268: (p_assignment_id => p_rec.assignment_id
1269: ,p_default_code_comb_id => p_rec.default_code_comb_id
1270: ,p_assignment_type => p_rec.assignment_type
1271: ,p_effective_date => p_effective_date
1275: if g_debug then
1276: hr_utility.set_location(l_proc, 110);
1277: end if;
1278: --
1279: per_asg_bus1.chk_employment_category
1280: (p_assignment_id => p_rec.assignment_id
1281: ,p_assignment_type => p_rec.assignment_type
1282: ,p_employment_category => p_rec.employment_category
1283: ,p_effective_date => p_effective_date
1358: if g_debug then
1359: hr_utility.set_location(l_proc, 180);
1360: end if;
1361: --
1362: per_asg_bus1.chk_frequency
1363: (p_assignment_id => p_rec.assignment_id
1364: ,p_frequency => p_rec.frequency
1365: ,p_effective_date => p_effective_date
1366: ,p_validation_start_date => p_validation_start_date
1370: if g_debug then
1371: hr_utility.set_location(l_proc, 190);
1372: end if;
1373: --
1374: per_asg_bus1.chk_frequency_normal_hours
1375: (p_assignment_id => p_rec.assignment_id
1376: ,p_frequency => p_rec.frequency
1377: ,p_normal_hours => p_rec.normal_hours
1378: ,p_effective_date => p_effective_date
1462: if g_debug then
1463: hr_utility.set_location(l_proc, 270);
1464: end if;
1465: --
1466: per_asg_bus1.chk_location_id
1467: (p_assignment_id => p_rec.assignment_id
1468: ,p_location_id => p_rec.location_id
1469: ,p_assignment_type => p_rec.assignment_type
1470: ,p_vacancy_id => p_rec.vacancy_id
1513: if g_debug then
1514: hr_utility.set_location(l_proc, 300);
1515: end if;
1516: -- fix for 6331872 starts here
1517: per_asg_bus1.chk_frozen_single_pos
1518: (p_assignment_id => p_rec.assignment_id
1519: ,p_position_id => p_rec.position_id
1520: ,p_effective_date => p_effective_date
1521: ,p_effective_end_date => p_validation_end_date -- parameter added for bug 10220040
1525: if g_debug then
1526: hr_utility.set_location(p_validation_end_date, 305);
1527: end if;
1528: -- fix for 6331872 ends here
1529: per_asg_bus1.chk_job_id
1530: (p_assignment_id => p_rec.assignment_id
1531: ,p_business_group_id => p_rec.business_group_id
1532: ,p_assignment_type => p_rec.assignment_type
1533: ,p_job_id => p_rec.job_id
1553: if g_debug then
1554: hr_utility.set_location(l_proc, 320);
1555: end if;
1556: --
1557: per_asg_bus1.chk_grade_id
1558: (p_assignment_id => p_rec.assignment_id
1559: ,p_business_group_id => p_rec.business_group_id
1560: ,p_assignment_type => p_rec.assignment_type
1561: ,p_grade_id => p_rec.grade_id
1598: if g_debug then
1599: hr_utility.set_location(l_proc, 350);
1600: end if;
1601: --
1602: per_asg_bus1.chk_job_id_grade_id
1603: (p_assignment_id => p_rec.assignment_id
1604: ,p_job_id => p_rec.job_id
1605: ,p_grade_id => p_rec.grade_id
1606: ,p_validation_start_date => p_validation_start_date
1701: if g_debug then
1702: hr_utility.set_location(l_proc, 410);
1703: end if;
1704: --
1705: per_asg_bus1.gen_chk_assignment_number
1706: (p_assignment_id => p_rec.assignment_id
1707: ,p_business_group_id => p_rec.business_group_id
1708: ,p_assignment_type => p_rec.assignment_type
1709: ,p_assignment_sequence => p_rec.assignment_sequence
1745: ,p_assignment_id => p_rec.assignment_id
1746: ,p_object_version_number => p_rec.object_version_number
1747: ,p_effective_date => p_effective_date);
1748:
1749: per_asg_bus1.chk_manager_flag
1750: (p_assignment_id => p_rec.assignment_id
1751: ,p_assignment_type => p_rec.assignment_type
1752: ,p_organization_id => p_rec.organization_id
1753: ,p_manager_flag => p_rec.manager_flag
1759: if g_debug then
1760: hr_utility.set_location(l_proc, 440);
1761: end if;
1762: --
1763: per_asg_bus1.chk_organization_id
1764: (p_assignment_id => p_rec.assignment_id
1765: ,p_primary_flag => p_rec.primary_flag
1766: ,p_organization_id => p_rec.organization_id
1767: ,p_business_group_id => p_rec.business_group_id
1791: if g_debug then
1792: hr_utility.set_location(l_proc, 460);
1793: end if;
1794: --
1795: per_asg_bus1.chk_application_id
1796: (p_assignment_id => p_rec.assignment_id
1797: ,p_assignment_type => p_rec.assignment_type
1798: ,p_business_group_id => p_rec.business_group_id
1799: ,p_assignment_sequence => p_rec.assignment_sequence
1822: if g_debug then
1823: hr_utility.set_location(l_proc, 490);
1824: end if;
1825: --
1826: per_asg_bus1.chk_assignment_status_type_id
1827: (p_rec => p_rec
1828: ,p_effective_date => p_effective_date
1829: ,p_validation_start_date => p_validation_start_date
1830: );
1831: if g_debug then
1832: hr_utility.set_location(l_proc, 500);
1833: end if;
1834: --
1835: per_asg_bus1.chk_bargaining_unit_code
1836: (p_assignment_id => p_rec.assignment_id
1837: ,p_bargaining_unit_code => p_rec.bargaining_unit_code
1838: ,p_effective_date => p_effective_date
1839: ,p_object_version_number => p_rec.object_version_number
1843: if g_debug then
1844: hr_utility.set_location(l_proc, 511);
1845: end if;
1846: --
1847: per_asg_bus1.chk_hourly_salaried_code
1848: (p_assignment_id => p_rec.assignment_id
1849: ,p_hourly_salaried_code => p_rec.hourly_salaried_code
1850: ,p_effective_date => p_effective_date
1851: ,p_object_version_number => p_rec.object_version_number
1854: ,p_pay_basis_id => p_rec.pay_basis_id
1855: ,p_hourly_salaried_warning => l_hourly_salaried_warning
1856: ,p_assignment_type => p_rec.assignment_type);
1857: --
1858: per_asg_bus1.chk_single_position
1859: (p_assignment_id => p_rec.assignment_id
1860: ,p_position_id => p_rec.position_id
1861: ,p_effective_date => p_effective_date
1862: ,p_effective_end_date => p_validation_end_date -- added for bug 10220040
1957: if g_debug then
1958: hr_utility.set_location(l_proc, 600);
1959: end if;
1960: --
1961: per_asg_bus1.chk_assignment_category
1962: (p_assignment_id => p_rec.assignment_id
1963: ,p_assignment_type => p_rec.assignment_type
1964: ,p_effective_date => p_effective_date
1965: ,p_assignment_category => p_rec.assignment_category
2121: --
2122: --
2123: -- Call descriptive flexfield validation routines
2124: --
2125: per_asg_bus1.chk_df(p_rec => p_rec
2126: ,p_validate_df_flex => p_validate_df_flex);
2127: --
2128: p_other_manager_warning := l_other_manager_warning;
2129: p_hourly_salaried_warning := l_hourly_salaried_warning;
2231: -- CHK_PERSON_ID / c
2232: -- GEN_ASSIGNMENT_SEQUENCE / c
2233: -- CHK_ASSIGNMENT_ID / e
2234: --
2235: per_asg_bus1.check_non_updateable_args
2236: (p_rec => p_rec
2237: ,p_effective_date => p_effective_date
2238: );
2239: if g_debug then
2298: if g_debug then
2299: hr_utility.set_location(l_proc, 30);
2300: end if;
2301: --
2302: per_asg_bus1.chk_assignment_type
2303: (p_assignment_id => p_rec.assignment_id
2304: ,p_assignment_type => p_rec.assignment_type
2305: ,p_person_id => p_rec.person_id
2306: ,p_effective_date => p_effective_date
2359: if g_debug then
2360: hr_utility.set_location(l_proc, 70);
2361: end if;
2362: --
2363: per_asg_bus1.chk_date_probation_end
2364: (p_assignment_id => p_rec.assignment_id
2365: ,p_date_probation_end => p_rec.date_probation_end
2366: ,p_assignment_type => p_rec.assignment_type
2367: ,p_probation_period => p_rec.probation_period
2386: if g_debug then
2387: hr_utility.set_location(l_proc, 90);
2388: end if;
2389: --
2390: per_asg_bus1.chk_change_reason
2391: (p_assignment_id => p_rec.assignment_id
2392: ,p_assignment_type => p_rec.assignment_type
2393: ,p_change_reason => p_rec.change_reason
2394: ,p_effective_date => p_effective_date
2400: hr_utility.set_location(l_proc, 100);
2401: end if;
2402: --
2403:
2404: per_asg_bus1.chk_default_code_comb_id
2405: (p_assignment_id => p_rec.assignment_id
2406: ,p_default_code_comb_id => p_rec.default_code_comb_id
2407: ,p_assignment_type => p_rec.assignment_type
2408: ,p_effective_date => p_effective_date
2412: if g_debug then
2413: hr_utility.set_location(l_proc, 110);
2414: end if;
2415: --
2416: per_asg_bus1.chk_employment_category
2417: (p_assignment_id => p_rec.assignment_id
2418: ,p_assignment_type => p_rec.assignment_type
2419:
2420: ,p_employment_category => p_rec.employment_category
2501: hr_utility.set_location(l_proc, 180);
2502: end if;
2503:
2504: --
2505: per_asg_bus1.chk_frequency
2506: (p_assignment_id => p_rec.assignment_id
2507: ,p_frequency => p_rec.frequency
2508: ,p_effective_date => p_effective_date
2509: ,p_validation_start_date => p_validation_start_date
2513: if g_debug then
2514: hr_utility.set_location(l_proc, 190);
2515: end if;
2516: --
2517: per_asg_bus1.chk_frequency_normal_hours
2518: (p_assignment_id => p_rec.assignment_id
2519:
2520: ,p_frequency => p_rec.frequency
2521: ,p_normal_hours => p_rec.normal_hours
2610: if g_debug then
2611: hr_utility.set_location(l_proc, 260);
2612: end if;
2613: --
2614: per_asg_bus1.chk_location_id
2615: (p_assignment_id => p_rec.assignment_id
2616: ,p_location_id => p_rec.location_id
2617: ,p_assignment_type => p_rec.assignment_type
2618:
2664: if g_debug then
2665: hr_utility.set_location(l_proc, 290);
2666: end if;
2667: --
2668: per_asg_bus1.chk_job_id
2669: (p_assignment_id => p_rec.assignment_id
2670: ,p_business_group_id => p_rec.business_group_id
2671: ,p_assignment_type => p_rec.assignment_type
2672: ,p_job_id => p_rec.job_id
2694: if g_debug then
2695: hr_utility.set_location(l_proc, 310);
2696: end if;
2697: --
2698: per_asg_bus1.chk_grade_id
2699: (p_assignment_id => p_rec.assignment_id
2700: ,p_business_group_id => p_rec.business_group_id
2701: ,p_assignment_type => p_rec.assignment_type
2702: ,p_grade_id => p_rec.grade_id
2742: if g_debug then
2743: hr_utility.set_location(l_proc, 340);
2744: end if;
2745: --
2746: per_asg_bus1.chk_job_id_grade_id
2747: (p_assignment_id => p_rec.assignment_id
2748: ,p_job_id => p_rec.job_id
2749: ,p_grade_id => p_rec.grade_id
2750: ,p_validation_start_date => p_validation_start_date
2851: end if;
2852: if ( l_assignment_sequence =1 ) then
2853: hr_utility.set_location(l_proc, 386);
2854: p_rec.assignment_sequence:=1;
2855: per_asg_bus1.gen_chk_assignment_number
2856: (p_assignment_id => p_rec.assignment_id
2857: ,p_business_group_id => p_rec.business_group_id
2858: ,p_assignment_type => p_rec.assignment_type
2859: ,p_assignment_sequence => p_rec.assignment_sequence
2864: );
2865: hr_utility.set_location(l_proc, 387);
2866: else
2867: hr_utility.set_location(l_proc, 388);
2868: per_asg_bus1.gen_chk_assignment_number
2869: (p_assignment_id => p_rec.assignment_id
2870: ,p_business_group_id => p_rec.business_group_id
2871: ,p_assignment_type => p_rec.assignment_type
2872: ,p_assignment_sequence => p_rec.assignment_sequence
2899: if g_debug then
2900: hr_utility.set_location(l_proc, 430);
2901: end if;
2902: --
2903: per_asg_bus1.chk_manager_flag
2904: (p_assignment_id => p_rec.assignment_id
2905: ,p_assignment_type => p_rec.assignment_type
2906: ,p_organization_id => p_rec.organization_id
2907: ,p_manager_flag => p_rec.manager_flag
2914: if g_debug then
2915: hr_utility.set_location(l_proc, 400);
2916: end if;
2917: --
2918: per_asg_bus1.chk_organization_id
2919: (p_assignment_id => p_rec.assignment_id
2920: ,p_primary_flag => p_rec.primary_flag
2921: ,p_organization_id => p_rec.organization_id
2922: ,p_business_group_id => p_rec.business_group_id
2948: if g_debug then
2949: hr_utility.set_location(l_proc, 420);
2950: end if;
2951: --
2952: per_asg_bus1.chk_application_id
2953: (p_assignment_id => p_rec.assignment_id
2954: ,p_assignment_type => p_rec.assignment_type
2955: ,p_business_group_id => p_rec.business_group_id
2956: ,p_assignment_sequence => p_rec.assignment_sequence
2981: if g_debug then
2982: hr_utility.set_location(l_proc, 440);
2983: end if;
2984: --
2985: per_asg_bus1.chk_assignment_status_type_id
2986: (p_rec => p_rec
2987: ,p_effective_date => p_effective_date
2988: ,p_validation_start_date => p_validation_start_date
2989: );
2990: if g_debug then
2991: hr_utility.set_location(l_proc, 450);
2992: end if;
2993: --
2994: per_asg_bus1.chk_bargaining_unit_code
2995: (p_assignment_id => p_rec.assignment_id
2996: ,p_bargaining_unit_code => p_rec.bargaining_unit_code
2997: ,p_effective_date => p_effective_date
2998: ,p_object_version_number => p_rec.object_version_number
3002: if g_debug then
3003: hr_utility.set_location(l_proc, 451);
3004: end if;
3005: --
3006: per_asg_bus1.chk_hourly_salaried_code
3007: (p_assignment_id => p_rec.assignment_id
3008: ,p_hourly_salaried_code => p_rec.hourly_salaried_code
3009: ,p_effective_date => p_effective_date
3010: ,p_object_version_number => p_rec.object_version_number
3017: if g_debug then
3018: hr_utility.set_location(l_proc, 452);
3019: end if;
3020: --
3021: per_asg_bus1.chk_single_position
3022: (p_assignment_id => p_rec.assignment_id
3023: ,p_position_id => p_rec.position_id
3024: ,p_effective_date => p_effective_date
3025: ,p_effective_end_date => p_validation_end_date -- added for bug 10220040
3121: if g_debug then
3122: hr_utility.set_location(l_proc, 600);
3123: end if;
3124: --
3125: per_asg_bus1.chk_assignment_category
3126: (p_assignment_id => p_rec.assignment_id
3127: ,p_assignment_type => p_rec.assignment_type
3128: ,p_effective_date => p_effective_date
3129: ,p_assignment_category => p_rec.assignment_category
3303: --
3304: --
3305: -- Call descriptive flexfield validation routines
3306: --
3307: per_asg_bus1.chk_df(p_rec => p_rec);
3308:
3309: if g_debug then
3310: hr_utility.set_location(l_proc, 750);
3311: end if;
3311: end if;
3312: --
3313: -- Call the datetrack update integrity operation
3314: --
3315: per_asg_bus1.dt_update_validate
3316: (p_payroll_id => p_rec.payroll_id,
3317: p_person_id => p_rec.person_id,
3318: p_datetrack_mode => p_datetrack_mode,
3319: p_validation_start_date => p_validation_start_date,
5648: if g_debug then
5649: hr_utility.set_location(l_proc, 65);
5650: end if;
5651:
5652: per_asg_bus1.chk_assignment_category
5653: (p_assignment_id => p_assignment_id
5654: ,p_assignment_type => p_assignment_type
5655: ,p_effective_date => p_effective_date
5656: ,p_assignment_category => p_employment_category
6392: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
6393: ) is
6394: begin
6395:
6396: per_asg_bus1.chk_location_id
6397: (p_assignment_id => p_assignment_id
6398: ,p_location_id => p_location_id
6399: ,p_assignment_type => p_assignment_type
6400: ,p_vacancy_id => p_vacancy_id
7583: ) is
7584: begin
7585:
7586: --
7587: per_asg_bus1.chk_frozen_single_pos
7588: (p_assignment_id => p_assignment_id
7589: ,p_position_id => p_position_id
7590: ,p_effective_date => p_effective_date
7591: ,p_effective_end_date => to_date('31/12/4712','dd/mm/rrrr')
7683: if not l_asg_in_overlap_dates then
7684: -- Check whether there are any assignments attached to a Single Position
7685: if (p_assignment_type = 'E' or p_assignment_type = 'C') then -- 6397484(forward port of 6356978)
7686: /*---- Start change for the bug 5854568 ----(modified for the bug 6331872)*/
7687: if (per_asg_bus1.pos_assignments_exists(p_position_id, p_effective_date, p_assignment_id) and p_assignment_type in ('E','C'))
7688: /*---- End change for the bug 5854568 ----(modified for the bug 6331872)*/
7689: then
7690: hr_utility.set_message(800, 'PER_ASG_EXISTS_FOR_SINGLE_POS');
7691: hr_multi_message.add
7715: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default 'E'
7716: ) is
7717: begin
7718:
7719: per_asg_bus1.chk_single_position
7720: (p_assignment_id => p_assignment_id
7721: ,p_position_id => p_position_id
7722: ,p_effective_date => p_effective_date
7723: ,p_effective_end_date => to_date('31/12/4712','dd/mm/rrrr')
7784: )
7785: or
7786: (NOT l_api_updating)
7787: then
7788: per_asg_bus1.chk_frozen_single_pos
7789: (p_assignment_id => p_assignment_id
7790: ,p_position_id => p_position_id
7791: ,p_effective_date => p_effective_date
7792: ,p_effective_end_date => p_effective_end_date -- Added for bug 10220040
7857: return(false);
7858: end if;
7859: end;
7860: --
7861: end per_asg_bus1;