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_PCL_BUS dependencies on PER_PCL_BUS

Line 1: Package Body per_pcl_bus as

1: Package Body per_pcl_bus as
2: /* $Header: pepclrhi.pkb 115.9 2002/12/09 15:33:43 pkakar noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_pcl_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 346: if ( nvl(per_pcl_bus.g_cagr_entitlement_line_id, hr_api.g_number)

342: ,p_argument => 'cagr_entitlement_line_id'
343: ,p_argument_value => p_cagr_entitlement_line_id
344: );
345: --
346: if ( nvl(per_pcl_bus.g_cagr_entitlement_line_id, hr_api.g_number)
347: = p_cagr_entitlement_line_id) then
348: --
349: -- The legislation code has already been found with a previous
350: -- call to this function. Just return the value in the global

Line 353: l_legislation_code := per_pcl_bus.g_legislation_code;

349: -- The legislation code has already been found with a previous
350: -- call to this function. Just return the value in the global
351: -- variable.
352: --
353: l_legislation_code := per_pcl_bus.g_legislation_code;
354: hr_utility.set_location(l_proc, 20);
355: else
356: --
357: -- The ID is different to the last call to this function

Line 377: per_pcl_bus.g_cagr_entitlement_line_id := p_cagr_entitlement_line_id;

373: -- Set the global variables so the values are
374: -- available for the next call to this function.
375: --
376: close csr_leg_code;
377: per_pcl_bus.g_cagr_entitlement_line_id := p_cagr_entitlement_line_id;
378: per_pcl_bus.g_legislation_code := l_legislation_code;
379: end if;
380: hr_utility.set_location(' Leaving:'|| l_proc, 40);
381: return l_legislation_code;

Line 378: per_pcl_bus.g_legislation_code := l_legislation_code;

374: -- available for the next call to this function.
375: --
376: close csr_leg_code;
377: per_pcl_bus.g_cagr_entitlement_line_id := p_cagr_entitlement_line_id;
378: per_pcl_bus.g_legislation_code := l_legislation_code;
379: end if;
380: hr_utility.set_location(' Leaving:'|| l_proc, 40);
381: return l_legislation_code;
382: end return_legislation_code;

Line 678: per_pcl_bus.check_for_correct_type

674: --
675: -- Check that the value is of the correct
676: -- type for the entitlement item
677: --
678: per_pcl_bus.check_for_correct_type
679: (p_cagr_entitlement_item_id => p_cagr_entitlement_item_id
680: ,p_value => l_value
681: ,p_business_group_id => 0
682: ,p_effective_date => p_effective_date);

Line 842: per_pcl_bus.check_for_correct_type

838: --
839: -- Check that the value is of the correct
840: -- type for the entitlement item
841: --
842: per_pcl_bus.check_for_correct_type
843: (p_cagr_entitlement_item_id => p_cagr_entitlement_item_id
844: ,p_value => l_range_from
845: ,p_business_group_id => 0
846: ,p_effective_date => p_effective_date);

Line 1008: per_pcl_bus.check_for_correct_type

1004: --
1005: -- Check that the value is of the correct
1006: -- type for the entitlement item
1007: --
1008: per_pcl_bus.check_for_correct_type
1009: (p_cagr_entitlement_item_id => p_cagr_entitlement_item_id
1010: ,p_value => l_range_to
1011: ,p_business_group_id => 0
1012: ,p_effective_date => p_effective_date);

Line 2212: per_pcl_bus.chk_mandatory

2208: hr_utility.set_location(l_proc, 30);
2209: --
2210: -- Validate mandatory
2211: --
2212: per_pcl_bus.chk_mandatory
2213: ( p_mandatory => p_rec.mandatory
2214: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2215: ,p_effective_date => p_effective_date
2216: ,p_validation_start_date => p_validation_start_date

Line 2223: per_pcl_bus.chk_value

2219: hr_utility.set_location(l_proc, 40);
2220: --
2221: -- Validate value
2222: --
2223: per_pcl_bus.chk_value
2224: (p_value => p_rec.value
2225: ,p_cagr_entitlement_item_id => l_cagr_entitlement_item_id
2226: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2227: ,p_cagr_entitlement_id => p_rec.cagr_entitlement_id

Line 2235: per_pcl_bus.chk_range_from

2231: hr_utility.set_location(l_proc, 50);
2232: --
2233: -- Validate Range_From
2234: --
2235: per_pcl_bus.chk_range_from
2236: (p_range_from => p_rec.range_from
2237: ,p_cagr_entitlement_item_id => l_cagr_entitlement_item_id
2238: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2239: ,p_category_name => l_category_name

Line 2246: per_pcl_bus.chk_range_to

2242: hr_utility.set_location(l_proc, 60);
2243: --
2244: -- Validate Range_To
2245: --
2246: per_pcl_bus.chk_range_to
2247: (p_range_to => p_rec.range_to
2248: ,p_cagr_entitlement_item_id => l_cagr_entitlement_item_id
2249: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2250: ,p_category_name => l_category_name

Line 2258: per_pcl_bus.chk_dates_are_valid

2254: --
2255: -- If the entitlement item has been defined as a DATE
2256: -- type then check that all the dates are valid.
2257: --
2258: per_pcl_bus.chk_dates_are_valid
2259: (p_cagr_entitlement_item_id => l_cagr_entitlement_item_id
2260: ,p_value => p_rec.value
2261: ,p_range_from => p_rec.range_from
2262: ,p_range_to => p_rec.range_to

Line 2269: per_pcl_bus.chk_grade_spine_id

2265: hr_utility.set_location(l_proc, 70);
2266: --
2267: -- Validate grade_spine_id
2268: --
2269: per_pcl_bus.chk_grade_spine_id
2270: ( p_grade_spine_id => p_rec.grade_spine_id
2271: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2272: ,p_cagr_entitlement_id => p_rec.cagr_entitlement_id
2273: ,p_effective_date => p_effective_date

Line 2281: per_pcl_bus.chk_parent_spine_id

2277: hr_utility.set_location(l_proc, 80);
2278: --
2279: -- Validate parent_spine_id
2280: --
2281: per_pcl_bus.chk_parent_spine_id
2282: (p_parent_spine_id => p_rec.parent_spine_id
2283: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2284: ,p_cagr_entitlement_id => p_rec.cagr_entitlement_id);
2285: --

Line 2290: per_pcl_bus.chk_status

2286: hr_utility.set_location(l_proc, 90);
2287: --
2288: -- Validate status
2289: --
2290: per_pcl_bus.chk_status
2291: (p_status => p_rec.status
2292: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2293: ,p_effective_date => p_effective_date
2294: ,p_validation_start_date => p_validation_start_date

Line 2301: per_pcl_bus.chk_oipl_id

2297: hr_utility.set_location(l_proc, 100);
2298: --
2299: -- Validate oipl_id
2300: --
2301: per_pcl_bus.chk_oipl_id
2302: (p_oipl_id => p_rec.oipl_id
2303: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2304: ,p_effective_date => p_effective_date
2305: ,p_validation_start_date => p_validation_start_date

Line 2312: per_pcl_bus.chk_step_id

2308: hr_utility.set_location(l_proc, 110);
2309: --
2310: -- Validate step_id
2311: --
2312: per_pcl_bus.chk_step_id
2313: (p_step_id => p_rec.step_id
2314: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2315: ,p_cagr_entitlement_id => p_rec.cagr_entitlement_id
2316: ,p_effective_date => p_effective_date

Line 2324: per_pcl_bus.chk_eligy_prfl_id

2320: hr_utility.set_location(l_proc, 120);
2321: --
2322: -- Validate eligy_prfl_id
2323: --
2324: per_pcl_bus.chk_eligy_prfl_id
2325: ( p_eligy_prfl_id => p_rec.eligy_prfl_id
2326: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2327: ,p_grade_spine_id => p_rec.grade_spine_id
2328: ,p_category_name => l_category_name

Line 2390: per_pcl_bus.chk_mandatory

2386: ,p_formula_criteria => l_formula_criteria);
2387: --
2388: -- Validate mandatory
2389: --
2390: per_pcl_bus.chk_mandatory
2391: (p_mandatory => p_rec.mandatory
2392: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2393: ,p_effective_date => p_effective_date
2394: ,p_validation_start_date => p_validation_start_date

Line 2404: per_pcl_bus.chk_value

2400: hr_utility.set_location(l_proc, 30);
2401: --
2402: -- Validate value
2403: --
2404: per_pcl_bus.chk_value
2405: (p_value => p_rec.value
2406: ,p_cagr_entitlement_item_id => l_cagr_entitlement_item_id
2407: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2408: ,p_cagr_entitlement_id => p_rec.cagr_entitlement_id

Line 2416: per_pcl_bus.chk_range_from

2412: hr_utility.set_location(l_proc, 40);
2413: --
2414: -- Validate Range_From
2415: --
2416: per_pcl_bus.chk_range_from
2417: (p_range_from => p_rec.range_from
2418: ,p_cagr_entitlement_item_id => l_cagr_entitlement_item_id
2419: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2420: ,p_category_name => l_category_name

Line 2427: per_pcl_bus.chk_range_to

2423: hr_utility.set_location(l_proc, 50);
2424: --
2425: -- Validate Range_To
2426: --
2427: per_pcl_bus.chk_range_to
2428: (p_range_to => p_rec.range_to
2429: ,p_cagr_entitlement_item_id => l_cagr_entitlement_item_id
2430: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2431: ,p_category_name => l_category_name

Line 2439: per_pcl_bus.chk_dates_are_valid

2435: --
2436: -- If the entitlement item has been defined as a DATE
2437: -- type then check that all the dates are valid.
2438: --
2439: per_pcl_bus.chk_dates_are_valid
2440: (p_cagr_entitlement_item_id => l_cagr_entitlement_item_id
2441: ,p_value => p_rec.value
2442: ,p_range_from => p_rec.range_from
2443: ,p_range_to => p_rec.range_to

Line 2450: per_pcl_bus.chk_grade_spine_id

2446: hr_utility.set_location(l_proc, 65);
2447: --
2448: -- Validate grade_spine_id
2449: --
2450: per_pcl_bus.chk_grade_spine_id
2451: (p_grade_spine_id => p_rec.grade_spine_id
2452: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2453: ,p_cagr_entitlement_id => p_rec.cagr_entitlement_id
2454: ,p_effective_date => p_effective_date

Line 2462: per_pcl_bus.chk_parent_spine_id

2458: hr_utility.set_location(l_proc, 70);
2459: --
2460: -- Validate parent_spine_id
2461: --
2462: per_pcl_bus.chk_parent_spine_id
2463: (p_parent_spine_id => p_rec.parent_spine_id
2464: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2465: ,p_cagr_entitlement_id => p_rec.cagr_entitlement_id);
2466: --

Line 2471: per_pcl_bus.chk_status

2467: hr_utility.set_location(l_proc, 80);
2468: --
2469: -- Validate status
2470: --
2471: per_pcl_bus.chk_status
2472: (p_status => p_rec.status
2473: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2474: ,p_effective_date => p_effective_date
2475: ,p_validation_start_date => p_validation_start_date

Line 2482: per_pcl_bus.chk_oipl_id

2478: hr_utility.set_location(l_proc, 90);
2479: --
2480: -- Validate oipl_id
2481: --
2482: per_pcl_bus.chk_oipl_id
2483: (p_oipl_id => p_rec.oipl_id
2484: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2485: ,p_effective_date => p_effective_date
2486: ,p_validation_start_date => p_validation_start_date

Line 2493: per_pcl_bus.chk_step_id

2489: hr_utility.set_location(l_proc, 100);
2490: --
2491: -- Validate step_id
2492: --
2493: per_pcl_bus.chk_step_id
2494: (p_step_id => p_rec.step_id
2495: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2496: ,p_cagr_entitlement_id => p_rec.cagr_entitlement_id
2497: ,p_effective_date => p_effective_date

Line 2505: per_pcl_bus.chk_eligy_prfl_id

2501: hr_utility.set_location(l_proc, 110);
2502: --
2503: -- Validate eligy_prfl_id
2504: --
2505: per_pcl_bus.chk_eligy_prfl_id
2506: ( p_eligy_prfl_id => p_rec.eligy_prfl_id
2507: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
2508: ,p_grade_spine_id => p_rec.grade_spine_id
2509: ,p_category_name => l_category_name

Line 2517: per_pcl_bus.chk_object_version_number

2513: ,p_formula_criteria => l_formula_criteria);
2514: --
2515: -- Validate object_version_number
2516: --
2517: per_pcl_bus.chk_object_version_number
2518: (p_object_version_number => p_rec.object_version_number );
2519: --
2520: hr_utility.set_location(l_proc, 120);
2521: --

Line 2559: per_pcl_bus.chk_object_version_number

2555: --
2556: -- Call all supporting business operations
2557: --
2558:
2559: per_pcl_bus.chk_object_version_number
2560: (
2561: p_object_version_number => p_rec.object_version_number );
2562:
2563: dt_delete_validate

Line 2573: end per_pcl_bus;

2569: --
2570: hr_utility.set_location(' Leaving:'||l_proc, 10);
2571: End delete_validate;
2572: --
2573: end per_pcl_bus;