DBA Data[Home] [Help]

APPS.PER_CAGR_EVALUATION_PKG dependencies on PER_CAGR_EVALUATION_PKG

Line 1: PACKAGE BODY per_cagr_evaluation_pkg AS

1: PACKAGE BODY per_cagr_evaluation_pkg AS
2: /* $Header: pecgrevl.pkb 120.0.12000000.2 2007/05/28 11:24:53 ande ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Package Record Type Specification |

Line 64: g_pkg constant varchar2(25) := 'PER_CAGR_EVALUATION_PKG';

60: g_entitlement_items entitlement_items;
61:
62: g_params control_structure;
63: g_output_structure cagr_SE_record;
64: g_pkg constant varchar2(25) := 'PER_CAGR_EVALUATION_PKG';
65: g_record_error exception;
66:
67:
68: --

Line 85: ,p_output_structure out nocopy per_cagr_evaluation_pkg.cagr_SE_record) IS

81: ,p_entitlement_item_id in number
82: ,p_collective_agreement_id in number default null
83: ,p_collective_agreement_set_id in number default null
84: ,p_commit_flag in varchar2 default 'N'
85: ,p_output_structure out nocopy per_cagr_evaluation_pkg.cagr_SE_record) IS
86:
87: l_proc constant varchar2(80) := g_pkg || '.get_entitlement_value';
88: l_cagr_request_id number(15);
89:

Line 132: ,p_output_structure out nocopy per_cagr_evaluation_pkg.cagr_BE_table

128: ,p_step_id in number default null
129: ,p_collective_agreement_id in number default null
130: ,p_collective_agreement_set_id in number default null
131: ,p_commit_flag in varchar2 default 'N'
132: ,p_output_structure out nocopy per_cagr_evaluation_pkg.cagr_BE_table
133: ,p_cagr_request_id out nocopy number) IS
134:
135: -- return set of results for an item
136: CURSOR csr_get_results IS

Line 2059: AND 'N' = per_cagr_evaluation_pkg.new_entitlement(pcrr.cagr_entitlement_item_id)

2055: and pcel.STATUS = 'A'
2056: and p_params.effective_date between pcel.effective_start_date
2057: and pcel.effective_end_date))
2058: OR pcrr.cagr_entitlement_line_id is null)
2059: AND 'N' = per_cagr_evaluation_pkg.new_entitlement(pcrr.cagr_entitlement_item_id)
2060: ORDER BY pcrr.cagr_entitlement_item_id;
2061: --
2062: -- Cursor to return entitlement values (driving cursor checks date and status)
2063: --

Line 3817: p_params PER_CAGR_EVALUATION_PKG.control_structure;

3813: ,p_apply_results_flag in varchar2 default 'N'
3814: ,p_cagr_request_id out nocopy number) IS
3815: --
3816: l_proc constant varchar2(61) := g_pkg || '.initialise';
3817: p_params PER_CAGR_EVALUATION_PKG.control_structure;
3818: l_se_rec PER_CAGR_EVALUATION_PKG.cagr_SE_record;
3819: --
3820: BEGIN
3821: hr_utility.set_location('Entering:'||l_proc, 5);

Line 3818: l_se_rec PER_CAGR_EVALUATION_PKG.cagr_SE_record;

3814: ,p_cagr_request_id out nocopy number) IS
3815: --
3816: l_proc constant varchar2(61) := g_pkg || '.initialise';
3817: p_params PER_CAGR_EVALUATION_PKG.control_structure;
3818: l_se_rec PER_CAGR_EVALUATION_PKG.cagr_SE_record;
3819: --
3820: BEGIN
3821: hr_utility.set_location('Entering:'||l_proc, 5);
3822:

Line 3976: per_cagr_evaluation_pkg.evaluation_process(p_params => p_params

3972:
3973: --
3974: -- invoke evaluation processing;
3975: --
3976: per_cagr_evaluation_pkg.evaluation_process(p_params => p_params
3977: ,p_SE_rec => g_output_structure);
3978:
3979: --
3980: -- populate eligible results to HRMS dependent upon mode and param

Line 4040: END per_cagr_evaluation_pkg;

4036: END new_entitlement;
4037:
4038:
4039:
4040: END per_cagr_evaluation_pkg;