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

APPS.PER_CPN_BUS dependencies on PER_CPN_BUS

Line 1: Package Body per_cpn_bus as

1: Package Body per_cpn_bus as
2: /* $Header: pecpnrhi.pkb 120.2 2011/09/09 10:51:47 schowdhu ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' per_cpn_bus.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_cpn_bus.'; -- Global package name
9: --
10: -- The following two global variables are only to be
11: -- used by the return_legislation_code function.
12: --

Line 2292: per_cpn_bus.chk_definition_id

2288: hr_utility.set_location(l_proc, 10);
2289: --
2290: -- Rule Check unique competence name
2291: --
2292: per_cpn_bus.chk_definition_id
2293: (p_competence_id => p_rec.competence_id
2294: ,p_business_group_id => p_rec.business_group_id
2295: ,p_competence_definition_id => p_rec.competence_definition_id
2296: ,p_object_version_number => p_rec.object_version_number

Line 2303: per_cpn_bus.chk_rat_scale_bus_grp_exist

2299: --
2300: -- Rule Check if rating scale exists and is in same business group as
2301: -- as that of competence
2302: --
2303: per_cpn_bus.chk_rat_scale_bus_grp_exist
2304: (p_competence_id => p_rec.competence_id
2305: ,p_object_version_number => p_rec.object_version_number
2306: ,p_rating_scale_id => p_rec.rating_scale_id
2307: ,p_business_group_id => p_rec.business_group_id);

Line 2312: per_cpn_bus.chk_rating_scale_type

2308: hr_utility.set_location(l_proc, 16);
2309: --
2310: -- Rule Check if rating scale is valid
2311: --
2312: per_cpn_bus.chk_rating_scale_type
2313: (p_competence_id => p_rec.competence_id
2314: ,p_object_version_number => p_rec.object_version_number
2315: ,p_rating_scale_id => p_rec.rating_scale_id
2316: );

Line 2321: per_cpn_bus.chk_competence_dates

2317: --
2318: --
2319: -- Rule Check Dates
2320: --
2321: per_cpn_bus.chk_competence_dates
2322: (p_date_from => p_rec.date_from
2323: ,p_date_to => p_rec.date_to );
2324: --
2325: -- Rule check Certification required Flag

Line 2327: per_cpn_bus.chk_certification_required

2323: ,p_date_to => p_rec.date_to );
2324: --
2325: -- Rule check Certification required Flag
2326: --
2327: per_cpn_bus.chk_certification_required
2328: (p_competence_id => p_rec.competence_id
2329: ,p_object_version_number => p_rec.object_version_number
2330: ,p_certification_required => p_rec.certification_required
2331: ,p_effective_date => p_effective_date

Line 2337: per_cpn_bus.chk_evaluation_method

2333: hr_utility.set_location(l_proc, 25);
2334: --
2335: -- Rule check Evaluation Method
2336: --
2337: per_cpn_bus.chk_evaluation_method
2338: (p_competence_id => p_rec.competence_id
2339: ,p_object_version_number => p_rec.object_version_number
2340: ,p_evaluation_method => p_rec.evaluation_method
2341: ,p_effective_date => p_effective_date

Line 2347: per_cpn_bus.chk_renewal_period_units

2343: hr_utility.set_location(l_proc, 30);
2344: --
2345: -- Rule check Renewal period units
2346: --
2347: per_cpn_bus.chk_renewal_period_units
2348: (p_competence_id => p_rec.competence_id
2349: ,p_object_version_number => p_rec.object_version_number
2350: ,P_renewal_period_units => p_rec.renewal_period_units
2351: ,p_effective_date => p_effective_date

Line 2357: per_cpn_bus.chk_renewable_unit_frequency

2353: hr_utility.set_location(l_proc, 35);
2354: --
2355: -- Rule check dependency of period units and period frquency
2356: --
2357: per_cpn_bus.chk_renewable_unit_frequency
2358: (p_competence_id => p_rec.competence_id
2359: ,p_object_version_number => p_rec.object_version_number
2360: ,p_renewal_period_units => p_rec.renewal_period_units
2361: ,p_renewal_period_frequency => p_rec.renewal_period_frequency

Line 2372: per_cpn_bus.chk_competence_cluster

2368: hr_utility.set_location(l_proc, 40);
2369: --
2370: -- Rule check competence cluster
2371: --
2372: per_cpn_bus.chk_competence_cluster
2373: (p_competence_id => p_rec.competence_id
2374: ,p_competence_cluster => p_rec.competence_cluster
2375: ,p_object_version_number => p_rec.object_version_number
2376: ,p_effective_date => p_effective_date

Line 2383: per_cpn_bus.chk_unit_standard_id

2379:
2380: --
2381: -- Rule check unit_standard_id
2382: --
2383: per_cpn_bus.chk_unit_standard_id
2384: (p_competence_id => p_rec.competence_id
2385: ,p_unit_standard_id => p_rec.unit_standard_id
2386: ,p_business_group_id => p_rec.business_group_id
2387: ,p_object_version_number => p_rec.object_version_number

Line 2395: per_cpn_bus.chk_credit_type

2391:
2392: --
2393: -- Rule check credit type
2394: --
2395: per_cpn_bus.chk_credit_type
2396: (p_competence_id => p_rec.competence_id
2397: ,p_credit_type => p_rec.credit_type
2398: ,p_object_version_number => p_rec.object_version_number
2399: ,p_effective_date => p_effective_date

Line 2405: per_cpn_bus.chk_level_type

2401: hr_utility.set_location(l_proc, 70);
2402: --
2403: -- Rule check level type
2404: --
2405: per_cpn_bus.chk_level_type
2406: (p_competence_id => p_rec.competence_id
2407: ,p_level_type => p_rec.level_type
2408: ,p_object_version_number => p_rec.object_version_number
2409: ,p_effective_date => p_effective_date

Line 2415: per_cpn_bus.chk_level_number

2411: hr_utility.set_location(l_proc, 80);
2412: --
2413: -- Rule check level
2414: --
2415: per_cpn_bus.chk_level_number
2416: (p_competence_id => p_rec.competence_id
2417: ,p_level_number => p_rec.level_number
2418: ,p_object_version_number => p_rec.object_version_number
2419: ,p_effective_date => p_effective_date

Line 2426: per_cpn_bus.chk_field

2422:
2423: --
2424: -- Rule check field
2425: --
2426: per_cpn_bus.chk_field
2427: (p_competence_id => p_rec.competence_id
2428: ,p_field => p_rec.field
2429: ,p_object_version_number => p_rec.object_version_number
2430: ,p_effective_date => p_effective_date

Line 2437: per_cpn_bus.chk_sub_field

2433:
2434: --
2435: -- Rule check sub field
2436: --
2437: per_cpn_bus.chk_sub_field
2438: (p_competence_id => p_rec.competence_id
2439: ,p_sub_field => p_rec.sub_field
2440: ,p_object_version_number => p_rec.object_version_number
2441: ,p_effective_date => p_effective_date

Line 2448: per_cpn_bus.chk_provider

2444:
2445: --
2446: -- Rule check provider
2447: --
2448: per_cpn_bus.chk_provider
2449: (p_competence_id => p_rec.competence_id
2450: ,p_provider => p_rec.provider
2451: ,p_object_version_number => p_rec.object_version_number
2452: ,p_effective_date => p_effective_date

Line 2459: per_cpn_bus.chk_qa_organization

2455:
2456: --
2457: -- Rule check qa organization
2458: --
2459: per_cpn_bus.chk_qa_organization
2460: (p_competence_id => p_rec.competence_id
2461: ,p_qa_organization => p_rec.qa_organization
2462: ,p_object_version_number => p_rec.object_version_number
2463: ,p_effective_date => p_effective_date

Line 2471: per_cpn_bus.chk_ddf(p_rec => p_rec); -- BUG3356369

2467: --
2468: --
2469: -- Call descriptive flexfield validation routines
2470: --
2471: per_cpn_bus.chk_ddf(p_rec => p_rec); -- BUG3356369
2472: --
2473: hr_utility.set_location(l_proc, 140);
2474: --
2475: per_cpn_bus.chk_df(p_rec => p_rec);

Line 2475: per_cpn_bus.chk_df(p_rec => p_rec);

2471: per_cpn_bus.chk_ddf(p_rec => p_rec); -- BUG3356369
2472: --
2473: hr_utility.set_location(l_proc, 140);
2474: --
2475: per_cpn_bus.chk_df(p_rec => p_rec);
2476: --
2477: --
2478: hr_utility.set_location(' Leaving:'||l_proc, 150);
2479: End insert_validate;

Line 2501: per_cpn_bus.chk_definition_id

2497: chk_non_updateable_args(p_rec => p_rec);
2498: --
2499: -- Rule Check unique competence name
2500: --
2501: per_cpn_bus.chk_definition_id
2502: (p_competence_id => p_rec.competence_id
2503: ,p_business_group_id => p_rec.business_group_id
2504: ,p_competence_definition_id => p_rec.competence_definition_id
2505: ,p_object_version_number => p_rec.object_version_number

Line 2511: per_cpn_bus.chk_competence_dates

2507: hr_utility.set_location(l_proc, 15);
2508: --
2509: -- Rule Check Dates
2510: --
2511: per_cpn_bus.chk_competence_dates
2512: (p_date_from => p_rec.date_from
2513: ,p_date_to => p_rec.date_to
2514: ,p_competence_id => p_rec.competence_id
2515: ,p_called_from => 'UPDATE'

Line 2519: per_cpn_bus.chk_certification_required

2515: ,p_called_from => 'UPDATE'
2516: );
2517: -- Rule check Certification required Flag
2518: --
2519: per_cpn_bus.chk_certification_required
2520: (p_competence_id => p_rec.competence_id
2521: ,p_object_version_number => p_rec.object_version_number
2522: ,p_certification_required => p_rec.certification_required
2523: ,p_effective_date => p_effective_date

Line 2529: per_cpn_bus.chk_evaluation_method

2525: hr_utility.set_location(l_proc, 25);
2526: --
2527: -- Rule check Evaluation Method
2528: --
2529: per_cpn_bus.chk_evaluation_method
2530: (p_competence_id => p_rec.competence_id
2531: ,p_object_version_number => p_rec.object_version_number
2532: ,p_evaluation_method => p_rec.evaluation_method
2533: ,p_effective_date => p_effective_date

Line 2539: per_cpn_bus.chk_renewal_period_units

2535: hr_utility.set_location(l_proc, 30);
2536: --
2537: -- Rule check Renewal period units
2538: --
2539: per_cpn_bus.chk_renewal_period_units
2540: (p_competence_id => p_rec.competence_id
2541: ,p_object_version_number => p_rec.object_version_number
2542: ,p_renewal_period_units => p_rec.renewal_period_units
2543: ,p_effective_date => p_effective_date

Line 2549: per_cpn_bus.chk_renewable_unit_frequency

2545: hr_utility.set_location(l_proc, 35);
2546: --
2547: -- Rule check dependency of period units and period frquency
2548: --
2549: per_cpn_bus.chk_renewable_unit_frequency
2550: (p_competence_id => p_rec.competence_id
2551: ,p_object_version_number => p_rec.object_version_number
2552: ,p_renewal_period_units => p_rec.renewal_period_units
2553: ,p_renewal_period_frequency => p_rec.renewal_period_frequency

Line 2561: per_cpn_bus.chk_rat_scale_bus_grp_exist

2557: --
2558: -- Rule Check if rating scale exists and is in same business group as
2559: -- as that of competence
2560: --
2561: per_cpn_bus.chk_rat_scale_bus_grp_exist
2562: (p_competence_id => p_rec.competence_id
2563: ,p_object_version_number => p_rec.object_version_number
2564: ,p_rating_scale_id => p_rec.rating_scale_id
2565: ,p_business_group_id => p_rec.business_group_id);

Line 2571: per_cpn_bus.chk_rating_scale_type

2567: --
2568: --
2569: -- Rule Check if rating scale is valid
2570: --
2571: per_cpn_bus.chk_rating_scale_type
2572: (p_competence_id => p_rec.competence_id
2573: ,p_object_version_number => p_rec.object_version_number
2574: ,p_rating_scale_id => p_rec.rating_scale_id
2575: );

Line 2581: per_cpn_bus.chk_competence_has_prof

2577: hr_utility.set_location(l_proc, 40);
2578: --
2579: -- Rule check if competence has any Proficiency levels. If it has
2580: -- then do not allow any rating scales to be assinged to this competence.
2581: per_cpn_bus.chk_competence_has_prof
2582: (p_competence_id => p_rec.competence_id
2583: ,p_object_version_number => p_rec.object_version_number
2584: ,p_rating_scale_id => p_rec.rating_scale_id
2585: );

Line 2591: per_cpn_bus.chk_competence_rating_update

2587: hr_utility.set_location(l_proc, 45);
2588: --
2589: -- Rule check competence rating scale cannot be updated if the rating
2590: -- level for that rating scale is used in competence element
2591: per_cpn_bus.chk_competence_rating_update
2592: (p_competence_id => p_rec.competence_id
2593: ,p_object_version_number => p_rec.object_version_number
2594: ,p_rating_scale_id => p_rec.rating_scale_id
2595: );

Line 2606: per_cpn_bus.chk_competence_cluster

2602: hr_utility.set_location(l_proc, 60);
2603: --
2604: -- Rule check competence cluster
2605: --
2606: per_cpn_bus.chk_competence_cluster
2607: (p_competence_id => p_rec.competence_id
2608: ,p_competence_cluster => p_rec.competence_cluster
2609: ,p_object_version_number => p_rec.object_version_number
2610: ,p_effective_date => p_effective_date

Line 2617: per_cpn_bus.chk_unit_standard_id

2613:
2614: --
2615: -- Rule check unit_standard_id
2616: --
2617: per_cpn_bus.chk_unit_standard_id
2618: (p_competence_id => p_rec.competence_id
2619: ,p_unit_standard_id => p_rec.unit_standard_id
2620: ,p_business_group_id => p_rec.business_group_id
2621: ,p_object_version_number => p_rec.object_version_number

Line 2629: per_cpn_bus.chk_credit_type

2625:
2626: --
2627: -- Rule check credit type
2628: --
2629: per_cpn_bus.chk_credit_type
2630: (p_competence_id => p_rec.competence_id
2631: ,p_credit_type => p_rec.credit_type
2632: ,p_object_version_number => p_rec.object_version_number
2633: ,p_effective_date => p_effective_date

Line 2640: per_cpn_bus.chk_level_type

2636:
2637: --
2638: -- Rule check level type
2639: --
2640: per_cpn_bus.chk_level_type
2641: (p_competence_id => p_rec.competence_id
2642: ,p_level_type => p_rec.level_type
2643: ,p_object_version_number => p_rec.object_version_number
2644: ,p_effective_date => p_effective_date

Line 2651: per_cpn_bus.chk_level_number

2647:
2648: --
2649: -- Rule check level
2650: --
2651: per_cpn_bus.chk_level_number
2652: (p_competence_id => p_rec.competence_id
2653: ,p_level_number => p_rec.level_number
2654: ,p_object_version_number => p_rec.object_version_number
2655: ,p_effective_date => p_effective_date

Line 2662: per_cpn_bus.chk_field

2658:
2659: --
2660: -- Rule check field
2661: --
2662: per_cpn_bus.chk_field
2663: (p_competence_id => p_rec.competence_id
2664: ,p_field => p_rec.field
2665: ,p_object_version_number => p_rec.object_version_number
2666: ,p_effective_date => p_effective_date

Line 2673: per_cpn_bus.chk_sub_field

2669:
2670: --
2671: -- Rule check sub field
2672: --
2673: per_cpn_bus.chk_sub_field
2674: (p_competence_id => p_rec.competence_id
2675: ,p_sub_field => p_rec.sub_field
2676: ,p_object_version_number => p_rec.object_version_number
2677: ,p_effective_date => p_effective_date

Line 2684: per_cpn_bus.chk_provider

2680:
2681: --
2682: -- Rule check provider
2683: --
2684: per_cpn_bus.chk_provider
2685: (p_competence_id => p_rec.competence_id
2686: ,p_provider => p_rec.provider
2687: ,p_object_version_number => p_rec.object_version_number
2688: ,p_effective_date => p_effective_date

Line 2695: per_cpn_bus.chk_qa_organization

2691: hr_utility.set_location(l_proc, 140);
2692: --
2693: -- Rule check qa organization
2694: --
2695: per_cpn_bus.chk_qa_organization
2696: (p_competence_id => p_rec.competence_id
2697: ,p_qa_organization => p_rec.qa_organization
2698: ,p_object_version_number => p_rec.object_version_number
2699: ,p_effective_date => p_effective_date

Line 2706: per_cpn_bus.chk_ddf(p_rec => p_rec); -- BUG3356369

2702: --
2703: --
2704: -- Call descriptive flexfield validation routines
2705: --
2706: per_cpn_bus.chk_ddf(p_rec => p_rec); -- BUG3356369
2707: --
2708: hr_utility.set_location(l_proc, 160);
2709: --
2710: per_cpn_bus.chk_df(p_rec => p_rec);

Line 2710: per_cpn_bus.chk_df(p_rec => p_rec);

2706: per_cpn_bus.chk_ddf(p_rec => p_rec); -- BUG3356369
2707: --
2708: hr_utility.set_location(l_proc, 160);
2709: --
2710: per_cpn_bus.chk_df(p_rec => p_rec);
2711: --
2712: --
2713: hr_utility.set_location(' Leaving:'||l_proc, 180);
2714: End update_validate;

Line 2732: per_cpn_bus.chk_competence_delete

2728: -- Validate Delete of Competence
2729: --
2730: -- Business Rule mapping
2731: --
2732: per_cpn_bus.chk_competence_delete
2733: (p_competence_id => p_rec.competence_id
2734: ,p_object_version_number => p_rec.object_version_number
2735: );
2736: --

Line 2812: end per_cpn_bus;

2808: --
2809: End return_legislation_code;
2810: --
2811: --
2812: end per_cpn_bus;