1: Package Body irc_isc_bus as
2: /* $Header: iriscrhi.pkb 120.0 2005/07/26 15:11:17 mbocutt noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' irc_isc_bus.'; -- Global package name
9: --
10: -- The following two global variables are only to be
11: -- used by the return_legislation_code function.
12: --
2416: ,p_argument_value => p_effective_date
2417: );
2418: --
2419: hr_utility.set_location(l_proc, 40);
2420: irc_isc_bus.chk_person_id(
2421: p_person_id => p_rec.object_id
2422: ,p_effective_date => p_effective_date
2423: );
2424: --
2422: ,p_effective_date => p_effective_date
2423: );
2424: --
2425: hr_utility.set_location(l_proc, 50);
2426: irc_isc_bus.chk_search_name(
2427: p_search_name => p_rec.search_name
2428: ,p_person_id => p_rec.object_id
2429: ,p_search_criteria_id => p_rec.search_criteria_id
2430: ,p_object_version_number => p_rec.object_version_number
2430: ,p_object_version_number => p_rec.object_version_number
2431: );
2432: --
2433: hr_utility.set_location(l_proc, 60);
2434: irc_isc_bus.chk_distance_to_location(
2435: p_distance_to_location => p_rec.distance_to_location
2436: ,p_geocode_location => p_rec.geocode_location
2437: ,p_search_criteria_id => p_rec.search_criteria_id
2438: ,p_object_version_number => p_rec.object_version_number
2438: ,p_object_version_number => p_rec.object_version_number
2439: );
2440: --
2441: hr_utility.set_location(l_proc, 63);
2442: irc_isc_bus.chk_location_id(
2443: p_location_id => p_rec.location_id
2444: ,p_search_criteria_id => p_rec.search_criteria_id
2445: ,p_object_version_number => p_rec.object_version_number
2446: );
2445: ,p_object_version_number => p_rec.object_version_number
2446: );
2447: --
2448: hr_utility.set_location(l_proc, 66);
2449: irc_isc_bus.chk_longitude_latitude(
2450: p_longitude => p_rec.longitude
2451: ,p_latitude => p_rec.latitude
2452: ,p_search_criteria_id => p_rec.search_criteria_id
2453: ,p_object_version_number => p_rec.object_version_number
2453: ,p_object_version_number => p_rec.object_version_number
2454: );
2455: --
2456: hr_utility.set_location(l_proc, 70);
2457: irc_isc_bus.chk_use_for_matching(
2458: p_use_for_matching => p_rec.use_for_matching
2459: ,p_search_criteria_id => p_rec.search_criteria_id
2460: ,p_object_version_number => p_rec.object_version_number
2461: );
2460: ,p_object_version_number => p_rec.object_version_number
2461: );
2462: --
2463: hr_utility.set_location(l_proc, 80);
2464: irc_isc_bus.chk_match_competence(
2465: p_match_competence => p_rec.match_competence
2466: ,p_search_criteria_id => p_rec.search_criteria_id
2467: ,p_object_version_number => p_rec.object_version_number
2468: );
2467: ,p_object_version_number => p_rec.object_version_number
2468: );
2469: --
2470: hr_utility.set_location(l_proc, 90);
2471: irc_isc_bus.chk_match_qualification(
2472: p_match_qualification => p_rec.match_qualification
2473: ,p_search_criteria_id => p_rec.search_criteria_id
2474: ,p_object_version_number => p_rec.object_version_number
2475: );
2474: ,p_object_version_number => p_rec.object_version_number
2475: );
2476: --
2477: hr_utility.set_location(l_proc, 100);
2478: irc_isc_bus.chk_min_salary(
2479: p_min_salary => p_rec.min_salary
2480: ,p_search_criteria_id => p_rec.search_criteria_id
2481: ,p_object_version_number => p_rec.object_version_number
2482: );
2484: end if;
2485:
2486: if p_rec.object_type= 'WPREF' then
2487: hr_utility.set_location(l_proc, 114);
2488: irc_isc_bus.chk_unique_work (
2489: p_object_id => p_rec.object_id
2490: );
2491: hr_utility.set_location(l_proc, 117);
2492: irc_isc_bus.chk_work_at_home(
2488: irc_isc_bus.chk_unique_work (
2489: p_object_id => p_rec.object_id
2490: );
2491: hr_utility.set_location(l_proc, 117);
2492: irc_isc_bus.chk_work_at_home(
2493: p_work_at_home => p_rec.work_at_home
2494: ,p_effective_date => p_effective_date
2495: ,p_search_criteria_id => p_rec.search_criteria_id
2496: ,p_object_version_number => p_rec.object_version_number
2495: ,p_search_criteria_id => p_rec.search_criteria_id
2496: ,p_object_version_number => p_rec.object_version_number
2497: );
2498: hr_utility.set_location(l_proc, 119);
2499: irc_isc_bus.chk_keywords(
2500: p_keywords => p_rec.keywords
2501: ,p_search_criteria_id => p_rec.search_criteria_id
2502: ,p_object_version_number => p_rec.object_version_number
2503: );
2506: hr_utility.set_location(l_proc, 110);
2507: if p_rec.object_type= 'VACANCY' then
2508: --
2509: hr_utility.set_location(l_proc, 70);
2510: irc_isc_bus.chk_vacancy_id(
2511: p_vacancy_id => p_rec.object_id
2512: ,p_effective_date => p_effective_date
2513: );
2514: --
2512: ,p_effective_date => p_effective_date
2513: );
2514: --
2515: hr_utility.set_location(l_proc, 120);
2516: irc_isc_bus.chk_min_qual_level(
2517: p_min_qual_level => p_rec.min_qual_level
2518: ,p_search_criteria_id => p_rec.search_criteria_id
2519: ,p_object_version_number => p_rec.object_version_number
2520: );
2519: ,p_object_version_number => p_rec.object_version_number
2520: );
2521: --
2522: hr_utility.set_location(l_proc, 130);
2523: irc_isc_bus.chk_min_salary(
2524: p_min_salary => p_rec.min_salary
2525: ,p_search_criteria_id => p_rec.search_criteria_id
2526: ,p_object_version_number => p_rec.object_version_number
2527: );
2526: ,p_object_version_number => p_rec.object_version_number
2527: );
2528: --
2529: hr_utility.set_location(l_proc, 140);
2530: irc_isc_bus.chk_max_salary(
2531: p_max_salary => p_rec.max_salary
2532: ,p_min_salary => p_rec.min_salary
2533: ,p_search_criteria_id => p_rec.search_criteria_id
2534: ,p_object_version_number => p_rec.object_version_number
2534: ,p_object_version_number => p_rec.object_version_number
2535: );
2536: --
2537: hr_utility.set_location(l_proc, 145);
2538: irc_isc_bus.chk_qual_rank(
2539: p_min_qual_level => p_rec.min_qual_level
2540: ,p_max_qual_level => p_rec.max_qual_level
2541: );
2542: --
2540: ,p_max_qual_level => p_rec.max_qual_level
2541: );
2542: --
2543: hr_utility.set_location(l_proc, 147);
2544: irc_isc_bus.chk_employee_contractor(
2545: p_employee => p_rec.employee
2546: ,p_contractor => p_rec.contractor
2547: );
2548: --
2548: --
2549: end if;
2550: --
2551: hr_utility.set_location(l_proc, 150);
2552: irc_isc_bus.chk_salary_currency
2553: (p_salary_currency => p_rec.salary_currency
2554: ,p_min_salary => p_rec.min_salary
2555: ,p_max_salary => p_rec.max_salary
2556: ,p_effective_date => p_effective_date
2559: );
2560: --
2561: --
2562: hr_utility.set_location(l_proc, 155);
2563: irc_isc_bus.chk_salary_period(
2564: p_salary_period => p_rec.salary_period
2565: ,p_min_salary => p_rec.min_salary
2566: ,p_max_salary => p_rec.max_salary
2567: ,p_effective_date => p_effective_date
2569: ,p_object_version_number => p_rec.object_version_number
2570: );
2571: --
2572: hr_utility.set_location(l_proc, 160);
2573: irc_isc_bus.chk_employee(
2574: p_employee => p_rec.employee
2575: ,p_search_criteria_id => p_rec.search_criteria_id
2576: ,p_object_version_number => p_rec.object_version_number
2577: );
2576: ,p_object_version_number => p_rec.object_version_number
2577: );
2578: --
2579: hr_utility.set_location(l_proc, 170);
2580: irc_isc_bus.chk_contractor(
2581: p_contractor => p_rec.contractor
2582: ,p_search_criteria_id => p_rec.search_criteria_id
2583: ,p_object_version_number => p_rec.object_version_number
2584: );
2583: ,p_object_version_number => p_rec.object_version_number
2584: );
2585: --
2586: hr_utility.set_location(l_proc, 180);
2587: irc_isc_bus.chk_professional_area(
2588: p_professional_area => p_rec.professional_area
2589: ,p_effective_date => p_effective_date
2590: ,p_search_criteria_id => p_rec.search_criteria_id
2591: ,p_object_version_number => p_rec.object_version_number
2591: ,p_object_version_number => p_rec.object_version_number
2592: );
2593: --
2594: hr_utility.set_location(l_proc, 190);
2595: irc_isc_bus.chk_employment_category(
2596: p_employment_category => p_rec.employment_category
2597: ,p_effective_date => p_effective_date
2598: ,p_search_criteria_id => p_rec.search_criteria_id
2599: ,p_object_version_number => p_rec.object_version_number
2599: ,p_object_version_number => p_rec.object_version_number
2600: );
2601: --
2602: hr_utility.set_location(l_proc, 200);
2603: irc_isc_bus.chk_work_at_home(
2604: p_work_at_home => p_rec.work_at_home
2605: ,p_effective_date => p_effective_date
2606: ,p_search_criteria_id => p_rec.search_criteria_id
2607: ,p_object_version_number => p_rec.object_version_number
2607: ,p_object_version_number => p_rec.object_version_number
2608: );
2609: --
2610: hr_utility.set_location(l_proc, 210);
2611: irc_isc_bus.chk_travel_percentage(
2612: p_travel_percentage => p_rec.travel_percentage
2613: ,p_effective_date => p_effective_date
2614: ,p_search_criteria_id => p_rec.search_criteria_id
2615: ,p_object_version_number => p_rec.object_version_number
2615: ,p_object_version_number => p_rec.object_version_number
2616: );
2617: --
2618: hr_utility.set_location(l_proc, 215);
2619: irc_isc_bus.chk_date_posted(
2620: p_date_posted => p_rec.date_posted
2621: ,p_effective_date => p_effective_date
2622: ,p_search_criteria_id => p_rec.search_criteria_id
2623: ,p_object_version_number => p_rec.object_version_number
2623: ,p_object_version_number => p_rec.object_version_number
2624: );
2625: --
2626: hr_utility.set_location(l_proc, 220);
2627: irc_isc_bus.chk_ddf(p_rec);
2628: --
2629: hr_utility.set_location(l_proc, 230);
2630: irc_isc_bus.chk_df(p_rec);
2631: --
2626: hr_utility.set_location(l_proc, 220);
2627: irc_isc_bus.chk_ddf(p_rec);
2628: --
2629: hr_utility.set_location(l_proc, 230);
2630: irc_isc_bus.chk_df(p_rec);
2631: --
2632: hr_utility.set_location(' Leaving:'||l_proc, 240);
2633: End insert_validate;
2634: --
2667:
2668: if p_rec.object_type in( 'PERSON','WPREF') then
2669: --
2670: hr_utility.set_location(l_proc, 30);
2671: irc_isc_bus.chk_search_name(
2672: p_search_name => p_rec.search_name
2673: ,p_person_id => p_rec.object_id
2674: ,p_search_criteria_id => p_rec.search_criteria_id
2675: ,p_object_version_number => p_rec.object_version_number
2675: ,p_object_version_number => p_rec.object_version_number
2676: );
2677: --
2678: hr_utility.set_location(l_proc, 40);
2679: irc_isc_bus.chk_distance_to_location(
2680: p_distance_to_location => p_rec.distance_to_location
2681: ,p_geocode_location => p_rec.geocode_location
2682: ,p_search_criteria_id => p_rec.search_criteria_id
2683: ,p_object_version_number => p_rec.object_version_number
2683: ,p_object_version_number => p_rec.object_version_number
2684: );
2685: --
2686: hr_utility.set_location(l_proc, 43);
2687: irc_isc_bus.chk_location_id(
2688: p_location_id => p_rec.location_id
2689: ,p_search_criteria_id => p_rec.search_criteria_id
2690: ,p_object_version_number => p_rec.object_version_number
2691: );
2690: ,p_object_version_number => p_rec.object_version_number
2691: );
2692: --
2693: hr_utility.set_location(l_proc, 46);
2694: irc_isc_bus.chk_longitude_latitude(
2695: p_longitude => p_rec.longitude
2696: ,p_latitude => p_rec.latitude
2697: ,p_search_criteria_id => p_rec.search_criteria_id
2698: ,p_object_version_number => p_rec.object_version_number
2698: ,p_object_version_number => p_rec.object_version_number
2699: );
2700: --
2701: hr_utility.set_location(l_proc, 50);
2702: irc_isc_bus.chk_use_for_matching(
2703: p_use_for_matching => p_rec.use_for_matching
2704: ,p_search_criteria_id => p_rec.search_criteria_id
2705: ,p_object_version_number => p_rec.object_version_number
2706: );
2705: ,p_object_version_number => p_rec.object_version_number
2706: );
2707: --
2708: hr_utility.set_location(l_proc, 60);
2709: irc_isc_bus.chk_match_competence(
2710: p_match_competence => p_rec.match_competence
2711: ,p_search_criteria_id => p_rec.search_criteria_id
2712: ,p_object_version_number => p_rec.object_version_number
2713: );
2712: ,p_object_version_number => p_rec.object_version_number
2713: );
2714: --
2715: hr_utility.set_location(l_proc, 70);
2716: irc_isc_bus.chk_match_qualification(
2717: p_match_qualification => p_rec.match_qualification
2718: ,p_search_criteria_id => p_rec.search_criteria_id
2719: ,p_object_version_number => p_rec.object_version_number
2720: );
2719: ,p_object_version_number => p_rec.object_version_number
2720: );
2721: --
2722: hr_utility.set_location(l_proc, 80);
2723: irc_isc_bus.chk_min_salary(
2724: p_min_salary => p_rec.min_salary
2725: ,p_search_criteria_id => p_rec.search_criteria_id
2726: ,p_object_version_number => p_rec.object_version_number
2727: );
2726: ,p_object_version_number => p_rec.object_version_number
2727: );
2728: --
2729: hr_utility.set_location(l_proc, 85);
2730: irc_isc_bus.chk_date_posted(
2731: p_date_posted => p_rec.date_posted
2732: ,p_effective_date => p_effective_date
2733: ,p_search_criteria_id => p_rec.search_criteria_id
2734: ,p_object_version_number => p_rec.object_version_number
2737: end if;
2738: --
2739: if p_rec.object_type= 'WPREF' then
2740: hr_utility.set_location(l_proc, 87);
2741: irc_isc_bus.chk_work_at_home(
2742: p_work_at_home => p_rec.work_at_home
2743: ,p_effective_date => p_effective_date
2744: ,p_search_criteria_id => p_rec.search_criteria_id
2745: ,p_object_version_number => p_rec.object_version_number
2744: ,p_search_criteria_id => p_rec.search_criteria_id
2745: ,p_object_version_number => p_rec.object_version_number
2746: );
2747: --
2748: irc_isc_bus.chk_keywords(
2749: p_keywords => p_rec.keywords
2750: ,p_search_criteria_id => p_rec.search_criteria_id
2751: ,p_object_version_number => p_rec.object_version_number
2752: );
2755: hr_utility.set_location(l_proc, 90);
2756: if p_rec.object_type= 'VACANCY' then
2757: --
2758: hr_utility.set_location(l_proc, 100);
2759: irc_isc_bus.chk_min_qual_level(
2760: p_min_qual_level => p_rec.min_qual_level
2761: ,p_search_criteria_id => p_rec.search_criteria_id
2762: ,p_object_version_number => p_rec.object_version_number
2763: );
2762: ,p_object_version_number => p_rec.object_version_number
2763: );
2764: --
2765: hr_utility.set_location(l_proc, 110);
2766: irc_isc_bus.chk_min_salary(
2767: p_min_salary => p_rec.min_salary
2768: ,p_search_criteria_id => p_rec.search_criteria_id
2769: ,p_object_version_number => p_rec.object_version_number
2770: );
2769: ,p_object_version_number => p_rec.object_version_number
2770: );
2771: --
2772: hr_utility.set_location(l_proc, 120);
2773: irc_isc_bus.chk_max_salary(
2774: p_max_salary => p_rec.max_salary
2775: ,p_min_salary => p_rec.min_salary
2776: ,p_search_criteria_id => p_rec.search_criteria_id
2777: ,p_object_version_number => p_rec.object_version_number
2777: ,p_object_version_number => p_rec.object_version_number
2778: );
2779: --
2780: hr_utility.set_location(l_proc, 125);
2781: irc_isc_bus.chk_qual_rank(
2782: p_min_qual_level => p_rec.min_qual_level
2783: ,p_max_qual_level => p_rec.max_qual_level
2784: );
2785: --
2783: ,p_max_qual_level => p_rec.max_qual_level
2784: );
2785: --
2786: hr_utility.set_location(l_proc, 127);
2787: irc_isc_bus.chk_employee_contractor(
2788: p_employee => p_rec.employee
2789: ,p_contractor => p_rec.contractor
2790: );
2791: --
2791: --
2792: end if;
2793: --
2794: hr_utility.set_location(l_proc, 130);
2795: irc_isc_bus.chk_salary_currency
2796: (p_salary_currency => p_rec.salary_currency
2797: ,p_min_salary => p_rec.min_salary
2798: ,p_max_salary => p_rec.max_salary
2799: ,p_effective_date => p_effective_date
2801: ,p_object_version_number => p_rec.object_version_number
2802: );
2803: --
2804: hr_utility.set_location(l_proc, 135);
2805: irc_isc_bus.chk_salary_period(
2806: p_salary_period => p_rec.salary_period
2807: ,p_min_salary => p_rec.min_salary
2808: ,p_max_salary => p_rec.max_salary
2809: ,p_effective_date => p_effective_date
2811: ,p_object_version_number => p_rec.object_version_number
2812: );
2813: --
2814: hr_utility.set_location(l_proc, 140);
2815: irc_isc_bus.chk_employee(
2816: p_employee => p_rec.employee
2817: ,p_search_criteria_id => p_rec.search_criteria_id
2818: ,p_object_version_number => p_rec.object_version_number
2819: );
2818: ,p_object_version_number => p_rec.object_version_number
2819: );
2820: --
2821: hr_utility.set_location(l_proc, 150);
2822: irc_isc_bus.chk_contractor(
2823: p_contractor => p_rec.contractor
2824: ,p_search_criteria_id => p_rec.search_criteria_id
2825: ,p_object_version_number => p_rec.object_version_number
2826: );
2825: ,p_object_version_number => p_rec.object_version_number
2826: );
2827: --
2828: hr_utility.set_location(l_proc, 160);
2829: irc_isc_bus.chk_professional_area(
2830: p_professional_area => p_rec.professional_area
2831: ,p_effective_date => p_effective_date
2832: ,p_search_criteria_id => p_rec.search_criteria_id
2833: ,p_object_version_number => p_rec.object_version_number
2833: ,p_object_version_number => p_rec.object_version_number
2834: );
2835: --
2836: hr_utility.set_location(l_proc, 170);
2837: irc_isc_bus.chk_employment_category(
2838: p_employment_category => p_rec.employment_category
2839: ,p_effective_date => p_effective_date
2840: ,p_search_criteria_id => p_rec.search_criteria_id
2841: ,p_object_version_number => p_rec.object_version_number
2841: ,p_object_version_number => p_rec.object_version_number
2842: );
2843: --
2844: hr_utility.set_location(l_proc, 180);
2845: irc_isc_bus.chk_work_at_home(
2846: p_work_at_home => p_rec.work_at_home
2847: ,p_effective_date => p_effective_date
2848: ,p_search_criteria_id => p_rec.search_criteria_id
2849: ,p_object_version_number => p_rec.object_version_number
2849: ,p_object_version_number => p_rec.object_version_number
2850: );
2851: --
2852: hr_utility.set_location(l_proc, 190);
2853: irc_isc_bus.chk_travel_percentage(
2854: p_travel_percentage => p_rec.travel_percentage
2855: ,p_effective_date => p_effective_date
2856: ,p_search_criteria_id => p_rec.search_criteria_id
2857: ,p_object_version_number => p_rec.object_version_number
2857: ,p_object_version_number => p_rec.object_version_number
2858: );
2859: --
2860: hr_utility.set_location(l_proc, 200);
2861: irc_isc_bus.chk_ddf(p_rec);
2862: --
2863: hr_utility.set_location(l_proc, 210);
2864: irc_isc_bus.chk_df(p_rec);
2865: --
2860: hr_utility.set_location(l_proc, 200);
2861: irc_isc_bus.chk_ddf(p_rec);
2862: --
2863: hr_utility.set_location(l_proc, 210);
2864: irc_isc_bus.chk_df(p_rec);
2865: --
2866: hr_utility.set_location(' Leaving:'||l_proc, 10);
2867: End update_validate;
2868: --
2882: --
2883: hr_utility.set_location(' Leaving:'||l_proc, 10);
2884: End delete_validate;
2885: --
2886: end irc_isc_bus;