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_CEI_BUS dependencies on PER_CEI_BUS

Line 1: Package Body per_cei_bus as

1: Package Body per_cei_bus as
2: /* $Header: peceirhi.pkb 120.1 2006/10/18 08:58:46 grreddy noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_cei_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 110: if ( nvl(per_cei_bus.g_cagr_entitlement_item_id, hr_api.g_number)

106: ,p_argument => 'cagr_entitlement_item_id'
107: ,p_argument_value => p_cagr_entitlement_item_id
108: );
109: --
110: if ( nvl(per_cei_bus.g_cagr_entitlement_item_id, hr_api.g_number)
111: = p_cagr_entitlement_item_id) then
112: --
113: -- The legislation code has already been found with a previous
114: -- call to this function. Just return the value in the global

Line 117: l_legislation_code := per_cei_bus.g_legislation_code;

113: -- The legislation code has already been found with a previous
114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := per_cei_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function

Line 141: per_cei_bus.g_cagr_entitlement_item_id := p_cagr_entitlement_item_id;

137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --
140: close csr_leg_code;
141: per_cei_bus.g_cagr_entitlement_item_id := p_cagr_entitlement_item_id;
142: per_cei_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;

Line 142: per_cei_bus.g_legislation_code := l_legislation_code;

138: -- available for the next call to this function.
139: --
140: close csr_leg_code;
141: per_cei_bus.g_cagr_entitlement_item_id := p_cagr_entitlement_item_id;
142: per_cei_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;

Line 2410: per_cei_bus.chk_item_name

2406: -- END IF;
2407: --
2408: hr_utility.set_location(l_proc,20);
2409: --
2410: per_cei_bus.chk_item_name
2411: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2412: ,p_item_name => p_rec.item_name
2413: ,p_category_name => p_rec.category_name
2414: ,p_legislation_code => p_rec.legislation_code

Line 2419: per_cei_bus.chk_legislation_code

2415: ,p_business_group_id => p_rec.business_group_id);
2416: --
2417: hr_utility.set_location(l_proc,30);
2418: --
2419: per_cei_bus.chk_legislation_code
2420: (p_legislation_code => p_rec.legislation_code);
2421: --
2422: hr_utility.set_location(l_proc,40);
2423: --

Line 2424: per_cei_bus.chk_beneficial_rule

2420: (p_legislation_code => p_rec.legislation_code);
2421: --
2422: hr_utility.set_location(l_proc,40);
2423: --
2424: per_cei_bus.chk_beneficial_rule
2425: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2426: ,p_beneficial_rule => p_rec.beneficial_rule
2427: ,p_ben_rule_value_set_id => p_rec.ben_rule_value_set_id
2428: ,p_effective_date => p_effective_date);

Line 2432: per_cei_bus.chk_cagr_api_id

2428: ,p_effective_date => p_effective_date);
2429: --
2430: hr_utility.set_location(l_proc,50);
2431: --
2432: per_cei_bus.chk_cagr_api_id
2433: (p_cagr_api_id => p_rec.cagr_api_id
2434: ,p_cagr_api_param_id => p_rec.cagr_api_param_id
2435: ,p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2436: ,p_element_type_id => p_rec.element_type_id);

Line 2440: per_cei_bus.chk_cagr_api_param_id

2436: ,p_element_type_id => p_rec.element_type_id);
2437: --
2438: hr_utility.set_location(l_proc,60);
2439: --
2440: per_cei_bus.chk_cagr_api_param_id
2441: (p_cagr_api_param_id => p_rec.cagr_api_param_id
2442: ,p_input_value_id => p_rec.element_type_id
2443: ,p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2444: ,p_cagr_api_id => p_rec.cagr_api_id

Line 2449: per_cei_bus.chk_multiple_entries_flag

2445: );
2446: --
2447: hr_utility.set_location(l_proc,70);
2448: --
2449: per_cei_bus.chk_multiple_entries_flag
2450: (p_mult_entries_allowed_flag => p_rec.mult_entries_allowed_flag
2451: ,p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2452: ,p_category_name => p_rec.category_name
2453: ,p_element_type_id => p_rec.element_type_id

Line 2461: per_cei_bus.chk_category_name

2457: );
2458: --
2459: hr_utility.set_location(l_proc,80);
2460: --
2461: per_cei_bus.chk_category_name
2462: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2463: ,p_category_name => p_rec.category_name
2464: ,p_effective_date => p_effective_date);
2465: -- -- CEI Enh

Line 2468: per_cei_bus.chk_auto_create_entries_flag -- CEI Enh

2464: ,p_effective_date => p_effective_date);
2465: -- -- CEI Enh
2466: hr_utility.set_location(l_proc,85); -- CEI Enh
2467: -- -- CEI Enh
2468: per_cei_bus.chk_auto_create_entries_flag -- CEI Enh
2469: (p_auto_create_entries_flag => p_rec.auto_create_entries_flag -- CEI Enh
2470: ,p_category_name => p_rec.category_name -- CEI Enh
2471: ,p_effective_date => p_effective_date -- CEI Enh
2472: ); -- CEI Enh

Line 2476: per_cei_bus.chk_uom

2472: ); -- CEI Enh
2473: --
2474: hr_utility.set_location(l_proc,90);
2475: --
2476: per_cei_bus.chk_uom
2477: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2478: ,p_uom => p_rec.uom
2479: ,p_input_value_id => p_rec.input_value_id
2480: ,p_cagr_api_param_id => p_rec.cagr_api_param_id

Line 2485: per_cei_bus.chk_item_is_unique

2481: ,p_effective_date => p_effective_date);
2482: --
2483: hr_utility.set_location(l_proc,100);
2484: --
2485: per_cei_bus.chk_item_is_unique
2486: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2487: ,p_category_name => p_rec.category_name
2488: ,p_cagr_api_id => p_rec.cagr_api_id
2489: ,p_cagr_api_param_id => p_rec.cagr_api_param_id

Line 2498: per_cei_bus.chk_element_type_id

2494: );
2495: --
2496: hr_utility.set_location(l_proc,110);
2497: --
2498: per_cei_bus.chk_element_type_id
2499: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2500: ,p_element_type_id => p_rec.element_type_id
2501: ,p_input_value_id => p_rec.input_value_id
2502: ,p_cagr_api_id => p_rec.cagr_api_id

Line 2510: per_cei_bus.chk_input_value_id

2506: );
2507: --
2508: hr_utility.set_location(l_proc,120);
2509: --
2510: per_cei_bus.chk_input_value_id
2511: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2512: ,p_element_type_id => p_rec.element_type_id
2513: ,p_input_value_id => p_rec.input_value_id
2514: ,p_cagr_api_param_id => p_rec.cagr_api_param_id

Line 2520: per_Cei_bus.chk_flex_value_set_id

2516: );
2517: --
2518: hr_utility.set_location(l_proc,130);
2519: --
2520: per_Cei_bus.chk_flex_value_set_id
2521: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2522: ,p_flex_value_set_id => p_rec.flex_value_set_id);
2523: --
2524: hr_utility.set_location(l_proc,140);

Line 2526: per_cei_bus.chk_ben_rule_value_set_id

2522: ,p_flex_value_set_id => p_rec.flex_value_set_id);
2523: --
2524: hr_utility.set_location(l_proc,140);
2525: --
2526: per_cei_bus.chk_ben_rule_value_set_id
2527: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2528: ,p_ben_rule_value_set_id => p_rec.ben_rule_value_set_id);
2529: --
2530: hr_utility.set_location(l_proc,150);

Line 2532: per_cei_bus.chk_column_type

2528: ,p_ben_rule_value_set_id => p_rec.ben_rule_value_set_id);
2529: --
2530: hr_utility.set_location(l_proc,150);
2531: --
2532: per_cei_bus.chk_column_type
2533: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2534: ,p_column_type => p_rec.column_type
2535: ,p_uom => p_rec.uom
2536: ,p_input_value_id => p_rec.input_value_id

Line 2543: per_cei_bus.chk_column_size

2539: ,p_cagr_api_param_id => p_rec.cagr_api_param_id);
2540: --
2541: hr_utility.set_location(l_proc,160);
2542: --
2543: per_cei_bus.chk_column_size
2544: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2545: ,p_column_size => p_rec.column_size
2546: ,p_cagr_api_param_id => p_rec.cagr_api_param_id);
2547: --

Line 2583: per_cei_bus.chk_item_name

2579: ,p_rec => p_rec);
2580: --
2581: hr_utility.set_location(l_proc,30);
2582: --
2583: per_cei_bus.chk_item_name
2584: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2585: ,p_item_name => p_rec.item_name
2586: ,p_category_name => p_rec.category_name
2587: ,p_legislation_code => p_rec.legislation_code

Line 2592: per_cei_bus.chk_legislation_code

2588: ,p_business_group_id => p_rec.business_group_id);
2589: --
2590: hr_utility.set_location(l_proc,40);
2591: --
2592: per_cei_bus.chk_legislation_code
2593: (p_legislation_code => p_rec.legislation_code);
2594: --
2595: hr_utility.set_location(l_proc,50);
2596: --

Line 2597: per_cei_bus.chk_beneficial_rule

2593: (p_legislation_code => p_rec.legislation_code);
2594: --
2595: hr_utility.set_location(l_proc,50);
2596: --
2597: per_cei_bus.chk_beneficial_rule
2598: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2599: ,p_beneficial_rule => p_rec.beneficial_rule
2600: ,p_ben_rule_value_set_id => p_rec.ben_rule_value_set_id
2601: ,p_effective_date => p_effective_date);

Line 2605: per_cei_bus.chk_cagr_api_id

2601: ,p_effective_date => p_effective_date);
2602: --
2603: hr_utility.set_location(l_proc,60);
2604: --
2605: per_cei_bus.chk_cagr_api_id
2606: (p_cagr_api_id => p_rec.cagr_api_id
2607: ,p_cagr_api_param_id => p_rec.cagr_api_param_id
2608: ,p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2609: ,p_element_type_id => p_rec.element_type_id);

Line 2613: per_cei_bus.chk_cagr_api_param_id

2609: ,p_element_type_id => p_rec.element_type_id);
2610: --
2611: hr_utility.set_location(l_proc,70);
2612: --
2613: per_cei_bus.chk_cagr_api_param_id
2614: (p_cagr_api_param_id => p_rec.cagr_api_param_id
2615: ,p_input_value_id => p_rec.element_type_id
2616: ,p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2617: ,p_cagr_api_id => p_rec.cagr_api_id

Line 2622: per_cei_bus.chk_category_name

2618: );
2619: --
2620: hr_utility.set_location(l_proc,80);
2621: --
2622: per_cei_bus.chk_category_name
2623: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2624: ,p_category_name => p_rec.category_name
2625: ,p_effective_date => p_effective_date);
2626: -- -- CEI Enh

Line 2629: per_cei_bus.chk_auto_create_entries_flag -- CEI Enh

2625: ,p_effective_date => p_effective_date);
2626: -- -- CEI Enh
2627: hr_utility.set_location(l_proc,85); -- CEI Enh
2628: -- -- CEI Enh
2629: per_cei_bus.chk_auto_create_entries_flag -- CEI Enh
2630: (p_auto_create_entries_flag => p_rec.auto_create_entries_flag -- CEI Enh
2631: ,p_category_name => p_rec.category_name -- CEI Enh
2632: ,p_effective_date => p_effective_date -- CEI Enh
2633: ); -- CEI Enh

Line 2637: per_cei_bus.chk_uom

2633: ); -- CEI Enh
2634: --
2635: hr_utility.set_location(l_proc,90);
2636: --
2637: per_cei_bus.chk_uom
2638: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2639: ,p_uom => p_rec.uom
2640: ,p_input_value_id => p_rec.input_value_id
2641: ,p_cagr_api_param_id => p_rec.cagr_api_param_id

Line 2646: per_cei_bus.chk_item_is_unique

2642: ,p_effective_date => p_effective_date);
2643: --
2644: hr_utility.set_location(l_proc,100);
2645: --
2646: per_cei_bus.chk_item_is_unique
2647: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2648: ,p_category_name => p_rec.category_name
2649: ,p_cagr_api_id => p_rec.cagr_api_id
2650: ,p_cagr_api_param_id => p_rec.cagr_api_param_id

Line 2659: per_cei_bus.chk_element_type_id

2655: );
2656: --
2657: hr_utility.set_location(l_proc,110);
2658: --
2659: per_cei_bus.chk_element_type_id
2660: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2661: ,p_element_type_id => p_rec.element_type_id
2662: ,p_input_value_id => p_rec.input_value_id
2663: ,p_cagr_api_id => p_rec.cagr_api_id

Line 2671: per_cei_bus.chk_input_value_id

2667: );
2668: --
2669: hr_utility.set_location(l_proc,120);
2670: --
2671: per_cei_bus.chk_input_value_id
2672: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2673: ,p_element_type_id => p_rec.element_type_id
2674: ,p_input_value_id => p_rec.input_value_id
2675: ,p_cagr_api_param_id => p_rec.cagr_api_param_id

Line 2681: per_cei_bus.chk_flex_value_set_id

2677: );
2678: --
2679: hr_utility.set_location(l_proc,130);
2680: --
2681: per_cei_bus.chk_flex_value_set_id
2682: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2683: ,p_flex_value_set_id => p_rec.flex_value_set_id);
2684: --
2685: hr_utility.set_location(l_proc,140);

Line 2687: per_cei_bus.chk_ben_rule_value_set_id

2683: ,p_flex_value_set_id => p_rec.flex_value_set_id);
2684: --
2685: hr_utility.set_location(l_proc,140);
2686: --
2687: per_cei_bus.chk_ben_rule_value_set_id
2688: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2689: ,p_ben_rule_value_set_id => p_rec.ben_rule_value_set_id);
2690: --
2691: hr_utility.set_location(l_proc,150);

Line 2693: per_cei_bus.chk_column_type

2689: ,p_ben_rule_value_set_id => p_rec.ben_rule_value_set_id);
2690: --
2691: hr_utility.set_location(l_proc,150);
2692: --
2693: per_cei_bus.chk_column_type
2694: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2695: ,p_column_type => p_rec.column_type
2696: ,p_uom => p_rec.uom
2697: ,p_input_value_id => p_rec.input_value_id

Line 2704: per_cei_bus.chk_column_size

2700: ,p_cagr_api_param_id => p_rec.cagr_api_param_id);
2701: --
2702: hr_utility.set_location(l_proc,160);
2703: --
2704: per_cei_bus.chk_column_size
2705: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2706: ,p_column_size => p_rec.column_size
2707: ,p_cagr_api_param_id => p_rec.cagr_api_param_id);
2708: --

Line 2711: per_cei_bus.chk_multiple_entries_flag

2707: ,p_cagr_api_param_id => p_rec.cagr_api_param_id);
2708: --
2709: hr_utility.set_location(l_proc,160);
2710: --
2711: per_cei_bus.chk_multiple_entries_flag
2712: (p_mult_entries_allowed_flag => p_rec.mult_entries_allowed_flag
2713: ,p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id
2714: ,p_category_name => p_rec.category_name
2715: ,p_element_type_id => p_rec.element_type_id

Line 2739: per_cei_bus.chk_item_use

2735: hr_utility.set_location('Entering:'||l_proc, 5);
2736: --
2737: -- Call all supporting business operations
2738: --
2739: per_cei_bus.chk_item_use
2740: (p_cagr_entitlement_item_id => p_rec.cagr_entitlement_item_id);
2741: --
2742: hr_utility.set_location(' Leaving:'||l_proc, 10);
2743: End delete_validate;

Line 2745: end per_cei_bus;

2741: --
2742: hr_utility.set_location(' Leaving:'||l_proc, 10);
2743: End delete_validate;
2744: --
2745: end per_cei_bus;