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.0 2005/05/31 07:14:07 appldev noship $ */
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 2286: per_cpn_bus.chk_definition_id

2282: hr_utility.set_location(l_proc, 10);
2283: --
2284: -- Rule Check unique competence name
2285: --
2286: per_cpn_bus.chk_definition_id
2287: (p_competence_id => p_rec.competence_id
2288: ,p_business_group_id => p_rec.business_group_id
2289: ,p_competence_definition_id => p_rec.competence_definition_id
2290: ,p_object_version_number => p_rec.object_version_number

Line 2297: per_cpn_bus.chk_rat_scale_bus_grp_exist

2293: --
2294: -- Rule Check if rating scale exists and is in same business group as
2295: -- as that of competence
2296: --
2297: per_cpn_bus.chk_rat_scale_bus_grp_exist
2298: (p_competence_id => p_rec.competence_id
2299: ,p_object_version_number => p_rec.object_version_number
2300: ,p_rating_scale_id => p_rec.rating_scale_id
2301: ,p_business_group_id => p_rec.business_group_id);

Line 2306: per_cpn_bus.chk_rating_scale_type

2302: hr_utility.set_location(l_proc, 16);
2303: --
2304: -- Rule Check if rating scale is valid
2305: --
2306: per_cpn_bus.chk_rating_scale_type
2307: (p_competence_id => p_rec.competence_id
2308: ,p_object_version_number => p_rec.object_version_number
2309: ,p_rating_scale_id => p_rec.rating_scale_id
2310: );

Line 2315: per_cpn_bus.chk_competence_dates

2311: --
2312: --
2313: -- Rule Check Dates
2314: --
2315: per_cpn_bus.chk_competence_dates
2316: (p_date_from => p_rec.date_from
2317: ,p_date_to => p_rec.date_to );
2318: --
2319: -- Rule check Certification required Flag

Line 2321: per_cpn_bus.chk_certification_required

2317: ,p_date_to => p_rec.date_to );
2318: --
2319: -- Rule check Certification required Flag
2320: --
2321: per_cpn_bus.chk_certification_required
2322: (p_competence_id => p_rec.competence_id
2323: ,p_object_version_number => p_rec.object_version_number
2324: ,p_certification_required => p_rec.certification_required
2325: ,p_effective_date => p_effective_date

Line 2331: per_cpn_bus.chk_evaluation_method

2327: hr_utility.set_location(l_proc, 25);
2328: --
2329: -- Rule check Evaluation Method
2330: --
2331: per_cpn_bus.chk_evaluation_method
2332: (p_competence_id => p_rec.competence_id
2333: ,p_object_version_number => p_rec.object_version_number
2334: ,p_evaluation_method => p_rec.evaluation_method
2335: ,p_effective_date => p_effective_date

Line 2341: per_cpn_bus.chk_renewal_period_units

2337: hr_utility.set_location(l_proc, 30);
2338: --
2339: -- Rule check Renewal period units
2340: --
2341: per_cpn_bus.chk_renewal_period_units
2342: (p_competence_id => p_rec.competence_id
2343: ,p_object_version_number => p_rec.object_version_number
2344: ,P_renewal_period_units => p_rec.renewal_period_units
2345: ,p_effective_date => p_effective_date

Line 2351: per_cpn_bus.chk_renewable_unit_frequency

2347: hr_utility.set_location(l_proc, 35);
2348: --
2349: -- Rule check dependency of period units and period frquency
2350: --
2351: per_cpn_bus.chk_renewable_unit_frequency
2352: (p_competence_id => p_rec.competence_id
2353: ,p_object_version_number => p_rec.object_version_number
2354: ,p_renewal_period_units => p_rec.renewal_period_units
2355: ,p_renewal_period_frequency => p_rec.renewal_period_frequency

Line 2366: per_cpn_bus.chk_competence_cluster

2362: hr_utility.set_location(l_proc, 40);
2363: --
2364: -- Rule check competence cluster
2365: --
2366: per_cpn_bus.chk_competence_cluster
2367: (p_competence_id => p_rec.competence_id
2368: ,p_competence_cluster => p_rec.competence_cluster
2369: ,p_object_version_number => p_rec.object_version_number
2370: ,p_effective_date => p_effective_date

Line 2377: per_cpn_bus.chk_unit_standard_id

2373:
2374: --
2375: -- Rule check unit_standard_id
2376: --
2377: per_cpn_bus.chk_unit_standard_id
2378: (p_competence_id => p_rec.competence_id
2379: ,p_unit_standard_id => p_rec.unit_standard_id
2380: ,p_business_group_id => p_rec.business_group_id
2381: ,p_object_version_number => p_rec.object_version_number

Line 2389: per_cpn_bus.chk_credit_type

2385:
2386: --
2387: -- Rule check credit type
2388: --
2389: per_cpn_bus.chk_credit_type
2390: (p_competence_id => p_rec.competence_id
2391: ,p_credit_type => p_rec.credit_type
2392: ,p_object_version_number => p_rec.object_version_number
2393: ,p_effective_date => p_effective_date

Line 2399: per_cpn_bus.chk_level_type

2395: hr_utility.set_location(l_proc, 70);
2396: --
2397: -- Rule check level type
2398: --
2399: per_cpn_bus.chk_level_type
2400: (p_competence_id => p_rec.competence_id
2401: ,p_level_type => p_rec.level_type
2402: ,p_object_version_number => p_rec.object_version_number
2403: ,p_effective_date => p_effective_date

Line 2409: per_cpn_bus.chk_level_number

2405: hr_utility.set_location(l_proc, 80);
2406: --
2407: -- Rule check level
2408: --
2409: per_cpn_bus.chk_level_number
2410: (p_competence_id => p_rec.competence_id
2411: ,p_level_number => p_rec.level_number
2412: ,p_object_version_number => p_rec.object_version_number
2413: ,p_effective_date => p_effective_date

Line 2420: per_cpn_bus.chk_field

2416:
2417: --
2418: -- Rule check field
2419: --
2420: per_cpn_bus.chk_field
2421: (p_competence_id => p_rec.competence_id
2422: ,p_field => p_rec.field
2423: ,p_object_version_number => p_rec.object_version_number
2424: ,p_effective_date => p_effective_date

Line 2431: per_cpn_bus.chk_sub_field

2427:
2428: --
2429: -- Rule check sub field
2430: --
2431: per_cpn_bus.chk_sub_field
2432: (p_competence_id => p_rec.competence_id
2433: ,p_sub_field => p_rec.sub_field
2434: ,p_object_version_number => p_rec.object_version_number
2435: ,p_effective_date => p_effective_date

Line 2442: per_cpn_bus.chk_provider

2438:
2439: --
2440: -- Rule check provider
2441: --
2442: per_cpn_bus.chk_provider
2443: (p_competence_id => p_rec.competence_id
2444: ,p_provider => p_rec.provider
2445: ,p_object_version_number => p_rec.object_version_number
2446: ,p_effective_date => p_effective_date

Line 2453: per_cpn_bus.chk_qa_organization

2449:
2450: --
2451: -- Rule check qa organization
2452: --
2453: per_cpn_bus.chk_qa_organization
2454: (p_competence_id => p_rec.competence_id
2455: ,p_qa_organization => p_rec.qa_organization
2456: ,p_object_version_number => p_rec.object_version_number
2457: ,p_effective_date => p_effective_date

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

2461: --
2462: --
2463: -- Call descriptive flexfield validation routines
2464: --
2465: per_cpn_bus.chk_ddf(p_rec => p_rec); -- BUG3356369
2466: --
2467: hr_utility.set_location(l_proc, 140);
2468: --
2469: per_cpn_bus.chk_df(p_rec => p_rec);

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

2465: per_cpn_bus.chk_ddf(p_rec => p_rec); -- BUG3356369
2466: --
2467: hr_utility.set_location(l_proc, 140);
2468: --
2469: per_cpn_bus.chk_df(p_rec => p_rec);
2470: --
2471: --
2472: hr_utility.set_location(' Leaving:'||l_proc, 150);
2473: End insert_validate;

Line 2495: per_cpn_bus.chk_definition_id

2491: chk_non_updateable_args(p_rec => p_rec);
2492: --
2493: -- Rule Check unique competence name
2494: --
2495: per_cpn_bus.chk_definition_id
2496: (p_competence_id => p_rec.competence_id
2497: ,p_business_group_id => p_rec.business_group_id
2498: ,p_competence_definition_id => p_rec.competence_definition_id
2499: ,p_object_version_number => p_rec.object_version_number

Line 2505: per_cpn_bus.chk_competence_dates

2501: hr_utility.set_location(l_proc, 15);
2502: --
2503: -- Rule Check Dates
2504: --
2505: per_cpn_bus.chk_competence_dates
2506: (p_date_from => p_rec.date_from
2507: ,p_date_to => p_rec.date_to
2508: ,p_competence_id => p_rec.competence_id
2509: ,p_called_from => 'UPDATE'

Line 2513: per_cpn_bus.chk_certification_required

2509: ,p_called_from => 'UPDATE'
2510: );
2511: -- Rule check Certification required Flag
2512: --
2513: per_cpn_bus.chk_certification_required
2514: (p_competence_id => p_rec.competence_id
2515: ,p_object_version_number => p_rec.object_version_number
2516: ,p_certification_required => p_rec.certification_required
2517: ,p_effective_date => p_effective_date

Line 2523: per_cpn_bus.chk_evaluation_method

2519: hr_utility.set_location(l_proc, 25);
2520: --
2521: -- Rule check Evaluation Method
2522: --
2523: per_cpn_bus.chk_evaluation_method
2524: (p_competence_id => p_rec.competence_id
2525: ,p_object_version_number => p_rec.object_version_number
2526: ,p_evaluation_method => p_rec.evaluation_method
2527: ,p_effective_date => p_effective_date

Line 2533: per_cpn_bus.chk_renewal_period_units

2529: hr_utility.set_location(l_proc, 30);
2530: --
2531: -- Rule check Renewal period units
2532: --
2533: per_cpn_bus.chk_renewal_period_units
2534: (p_competence_id => p_rec.competence_id
2535: ,p_object_version_number => p_rec.object_version_number
2536: ,p_renewal_period_units => p_rec.renewal_period_units
2537: ,p_effective_date => p_effective_date

Line 2543: per_cpn_bus.chk_renewable_unit_frequency

2539: hr_utility.set_location(l_proc, 35);
2540: --
2541: -- Rule check dependency of period units and period frquency
2542: --
2543: per_cpn_bus.chk_renewable_unit_frequency
2544: (p_competence_id => p_rec.competence_id
2545: ,p_object_version_number => p_rec.object_version_number
2546: ,p_renewal_period_units => p_rec.renewal_period_units
2547: ,p_renewal_period_frequency => p_rec.renewal_period_frequency

Line 2555: per_cpn_bus.chk_rat_scale_bus_grp_exist

2551: --
2552: -- Rule Check if rating scale exists and is in same business group as
2553: -- as that of competence
2554: --
2555: per_cpn_bus.chk_rat_scale_bus_grp_exist
2556: (p_competence_id => p_rec.competence_id
2557: ,p_object_version_number => p_rec.object_version_number
2558: ,p_rating_scale_id => p_rec.rating_scale_id
2559: ,p_business_group_id => p_rec.business_group_id);

Line 2565: per_cpn_bus.chk_rating_scale_type

2561: --
2562: --
2563: -- Rule Check if rating scale is valid
2564: --
2565: per_cpn_bus.chk_rating_scale_type
2566: (p_competence_id => p_rec.competence_id
2567: ,p_object_version_number => p_rec.object_version_number
2568: ,p_rating_scale_id => p_rec.rating_scale_id
2569: );

Line 2575: per_cpn_bus.chk_competence_has_prof

2571: hr_utility.set_location(l_proc, 40);
2572: --
2573: -- Rule check if competence has any Proficiency levels. If it has
2574: -- then do not allow any rating scales to be assinged to this competence.
2575: per_cpn_bus.chk_competence_has_prof
2576: (p_competence_id => p_rec.competence_id
2577: ,p_object_version_number => p_rec.object_version_number
2578: ,p_rating_scale_id => p_rec.rating_scale_id
2579: );

Line 2585: per_cpn_bus.chk_competence_rating_update

2581: hr_utility.set_location(l_proc, 45);
2582: --
2583: -- Rule check competence rating scale cannot be updated if the rating
2584: -- level for that rating scale is used in competence element
2585: per_cpn_bus.chk_competence_rating_update
2586: (p_competence_id => p_rec.competence_id
2587: ,p_object_version_number => p_rec.object_version_number
2588: ,p_rating_scale_id => p_rec.rating_scale_id
2589: );

Line 2600: per_cpn_bus.chk_competence_cluster

2596: hr_utility.set_location(l_proc, 60);
2597: --
2598: -- Rule check competence cluster
2599: --
2600: per_cpn_bus.chk_competence_cluster
2601: (p_competence_id => p_rec.competence_id
2602: ,p_competence_cluster => p_rec.competence_cluster
2603: ,p_object_version_number => p_rec.object_version_number
2604: ,p_effective_date => p_effective_date

Line 2611: per_cpn_bus.chk_unit_standard_id

2607:
2608: --
2609: -- Rule check unit_standard_id
2610: --
2611: per_cpn_bus.chk_unit_standard_id
2612: (p_competence_id => p_rec.competence_id
2613: ,p_unit_standard_id => p_rec.unit_standard_id
2614: ,p_business_group_id => p_rec.business_group_id
2615: ,p_object_version_number => p_rec.object_version_number

Line 2623: per_cpn_bus.chk_credit_type

2619:
2620: --
2621: -- Rule check credit type
2622: --
2623: per_cpn_bus.chk_credit_type
2624: (p_competence_id => p_rec.competence_id
2625: ,p_credit_type => p_rec.credit_type
2626: ,p_object_version_number => p_rec.object_version_number
2627: ,p_effective_date => p_effective_date

Line 2634: per_cpn_bus.chk_level_type

2630:
2631: --
2632: -- Rule check level type
2633: --
2634: per_cpn_bus.chk_level_type
2635: (p_competence_id => p_rec.competence_id
2636: ,p_level_type => p_rec.level_type
2637: ,p_object_version_number => p_rec.object_version_number
2638: ,p_effective_date => p_effective_date

Line 2645: per_cpn_bus.chk_level_number

2641:
2642: --
2643: -- Rule check level
2644: --
2645: per_cpn_bus.chk_level_number
2646: (p_competence_id => p_rec.competence_id
2647: ,p_level_number => p_rec.level_number
2648: ,p_object_version_number => p_rec.object_version_number
2649: ,p_effective_date => p_effective_date

Line 2656: per_cpn_bus.chk_field

2652:
2653: --
2654: -- Rule check field
2655: --
2656: per_cpn_bus.chk_field
2657: (p_competence_id => p_rec.competence_id
2658: ,p_field => p_rec.field
2659: ,p_object_version_number => p_rec.object_version_number
2660: ,p_effective_date => p_effective_date

Line 2667: per_cpn_bus.chk_sub_field

2663:
2664: --
2665: -- Rule check sub field
2666: --
2667: per_cpn_bus.chk_sub_field
2668: (p_competence_id => p_rec.competence_id
2669: ,p_sub_field => p_rec.sub_field
2670: ,p_object_version_number => p_rec.object_version_number
2671: ,p_effective_date => p_effective_date

Line 2678: per_cpn_bus.chk_provider

2674:
2675: --
2676: -- Rule check provider
2677: --
2678: per_cpn_bus.chk_provider
2679: (p_competence_id => p_rec.competence_id
2680: ,p_provider => p_rec.provider
2681: ,p_object_version_number => p_rec.object_version_number
2682: ,p_effective_date => p_effective_date

Line 2689: per_cpn_bus.chk_qa_organization

2685: hr_utility.set_location(l_proc, 140);
2686: --
2687: -- Rule check qa organization
2688: --
2689: per_cpn_bus.chk_qa_organization
2690: (p_competence_id => p_rec.competence_id
2691: ,p_qa_organization => p_rec.qa_organization
2692: ,p_object_version_number => p_rec.object_version_number
2693: ,p_effective_date => p_effective_date

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

2696: --
2697: --
2698: -- Call descriptive flexfield validation routines
2699: --
2700: per_cpn_bus.chk_ddf(p_rec => p_rec); -- BUG3356369
2701: --
2702: hr_utility.set_location(l_proc, 160);
2703: --
2704: per_cpn_bus.chk_df(p_rec => p_rec);

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

2700: per_cpn_bus.chk_ddf(p_rec => p_rec); -- BUG3356369
2701: --
2702: hr_utility.set_location(l_proc, 160);
2703: --
2704: per_cpn_bus.chk_df(p_rec => p_rec);
2705: --
2706: --
2707: hr_utility.set_location(' Leaving:'||l_proc, 180);
2708: End update_validate;

Line 2726: per_cpn_bus.chk_competence_delete

2722: -- Validate Delete of Competence
2723: --
2724: -- Business Rule mapping
2725: --
2726: per_cpn_bus.chk_competence_delete
2727: (p_competence_id => p_rec.competence_id
2728: ,p_object_version_number => p_rec.object_version_number
2729: );
2730: --

Line 2806: end per_cpn_bus;

2802: --
2803: End return_legislation_code;
2804: --
2805: --
2806: end per_cpn_bus;