16: hr_utility.set_location('p_effective_start_date '||p_effective_start_date,10);
17: hr_utility.set_location('p_effective_end_date '||p_effective_end_date,10);
18: hr_utility.set_location('p_effective_date '||p_effective_date,10);
19: --
20: if p_effective_end_date <> hr_api.g_eot then
21: --
22: if p_dml_operation = 'INSERT' then
23: --
24: l_datetrack_mode := hr_api.g_update;
20: if p_effective_end_date <> hr_api.g_eot then
21: --
22: if p_dml_operation = 'INSERT' then
23: --
24: l_datetrack_mode := hr_api.g_update;
25: l_update := true;
26: --
27: elsif l_datetrack_mode in ('CORRECTION') then
28: --
25: l_update := true;
26: --
27: elsif l_datetrack_mode in ('CORRECTION') then
28: --
29: l_datetrack_mode := hr_api.g_correction ;
30: l_update := true;
31: --
32: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
33: --
31: --
32: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
33: --
34: if p_effective_date = p_effective_start_date then
35: l_datetrack_mode := hr_api.g_correction ;
36: l_update := true;
37: else
38: --
39: if l_datetrack_mode in ('UPDATE_OVERRIDE') then
37: else
38: --
39: if l_datetrack_mode in ('UPDATE_OVERRIDE') then
40: --
41: l_datetrack_mode := hr_api.g_update_override ;
42: l_update := false ;
43: --
44: elsif l_datetrack_mode in ('UPDATE') then
45: --
42: l_update := false ;
43: --
44: elsif l_datetrack_mode in ('UPDATE') then
45: --
46: l_datetrack_mode := hr_api.g_update;
47: --
48: end if;
49: --
50: end if;
51: --
52: elsif l_datetrack_mode in ('UPDATE_CHANGE_INSERT') then
53: --
54: if p_effective_date = p_effective_start_date then
55: l_datetrack_mode := hr_api.g_correction ;
56: l_update := true;
57: else
58: l_datetrack_mode := hr_api.g_update_change_insert ;
59: l_update := true;
54: if p_effective_date = p_effective_start_date then
55: l_datetrack_mode := hr_api.g_correction ;
56: l_update := true;
57: else
58: l_datetrack_mode := hr_api.g_update_change_insert ;
59: l_update := true;
60: end if;
61: --
62: else
60: end if;
61: --
62: else
63: --
64: l_datetrack_mode := hr_api.g_update;
65: l_update := false;
66: --
67: end if;
68: --
68: --
69: else
70: if p_dml_operation = 'INSERT' then
71: --
72: l_datetrack_mode := hr_api.g_update;
73: l_update := false;
74: --
75: elsif l_datetrack_mode in ('CORRECTION') then
76: --
73: l_update := false;
74: --
75: elsif l_datetrack_mode in ('CORRECTION') then
76: --
77: l_datetrack_mode := hr_api.g_correction ;
78: l_update := false;
79: --
80: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
81: --
79: --
80: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
81: --
82: if p_effective_date = p_effective_start_date then
83: l_datetrack_mode := hr_api.g_correction ;
84: l_update := true;
85: else
86: l_datetrack_mode := hr_api.g_update ;
87: l_update := false ;
82: if p_effective_date = p_effective_start_date then
83: l_datetrack_mode := hr_api.g_correction ;
84: l_update := true;
85: else
86: l_datetrack_mode := hr_api.g_update ;
87: l_update := false ;
88: end if;
89: --
90: elsif l_datetrack_mode in ('UPDATE_CHANGE_INSERT') then
89: --
90: elsif l_datetrack_mode in ('UPDATE_CHANGE_INSERT') then
91: --
92: if p_effective_date = p_effective_start_date then
93: l_datetrack_mode := hr_api.g_correction ;
94: l_update := false;
95: else
96: l_datetrack_mode := hr_api.g_update ;
97: l_update := false;
92: if p_effective_date = p_effective_start_date then
93: l_datetrack_mode := hr_api.g_correction ;
94: l_update := false;
95: else
96: l_datetrack_mode := hr_api.g_update ;
97: l_update := false;
98: end if;
99: --
100: else
98: end if;
99: --
100: else
101: --
102: l_datetrack_mode := hr_api.g_update;
103: l_update := false;
104: --
105: end if;
106: --
114: end get_dt_modes ;
115:
116: procedure UPLOAD_RATE(
117: P_RATE_ID in Number,
118: P_PL_TYP_ID in Number default hr_api.g_number,
119: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,
120: P_PL_ID in Number default hr_api.g_number,
121: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
122: P_OPT_ID in Number default hr_api.g_number,
115:
116: procedure UPLOAD_RATE(
117: P_RATE_ID in Number,
118: P_PL_TYP_ID in Number default hr_api.g_number,
119: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,
120: P_PL_ID in Number default hr_api.g_number,
121: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
122: P_OPT_ID in Number default hr_api.g_number,
123: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
116: procedure UPLOAD_RATE(
117: P_RATE_ID in Number,
118: P_PL_TYP_ID in Number default hr_api.g_number,
119: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,
120: P_PL_ID in Number default hr_api.g_number,
121: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
122: P_OPT_ID in Number default hr_api.g_number,
123: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
124: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
117: P_RATE_ID in Number,
118: P_PL_TYP_ID in Number default hr_api.g_number,
119: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,
120: P_PL_ID in Number default hr_api.g_number,
121: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
122: P_OPT_ID in Number default hr_api.g_number,
123: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
124: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
125: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
118: P_PL_TYP_ID in Number default hr_api.g_number,
119: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,
120: P_PL_ID in Number default hr_api.g_number,
121: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
122: P_OPT_ID in Number default hr_api.g_number,
123: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
124: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
125: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
126: P_RATE_TYPE in varchar2,
119: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,
120: P_PL_ID in Number default hr_api.g_number,
121: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
122: P_OPT_ID in Number default hr_api.g_number,
123: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
124: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
125: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
126: P_RATE_TYPE in varchar2,
127: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
120: P_PL_ID in Number default hr_api.g_number,
121: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
122: P_OPT_ID in Number default hr_api.g_number,
123: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
124: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
125: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
126: P_RATE_TYPE in varchar2,
127: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
128: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
121: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
122: P_OPT_ID in Number default hr_api.g_number,
123: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
124: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
125: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
126: P_RATE_TYPE in varchar2,
127: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
128: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
129: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
123: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
124: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
125: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
126: P_RATE_TYPE in varchar2,
127: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
128: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
129: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
130: P_OLD_VAL in number default hr_api.g_number,
131: P_NEW_VAL in number default hr_api.g_number,
124: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
125: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
126: P_RATE_TYPE in varchar2,
127: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
128: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
129: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
130: P_OLD_VAL in number default hr_api.g_number,
131: P_NEW_VAL in number default hr_api.g_number,
132: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
125: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
126: P_RATE_TYPE in varchar2,
127: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
128: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
129: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
130: P_OLD_VAL in number default hr_api.g_number,
131: P_NEW_VAL in number default hr_api.g_number,
132: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
133: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
126: P_RATE_TYPE in varchar2,
127: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
128: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
129: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
130: P_OLD_VAL in number default hr_api.g_number,
131: P_NEW_VAL in number default hr_api.g_number,
132: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
133: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
134: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
127: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
128: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
129: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
130: P_OLD_VAL in number default hr_api.g_number,
131: P_NEW_VAL in number default hr_api.g_number,
132: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
133: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
134: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
135: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2, --NOTE: this P_COMP_LVL_FCTR_ID is VARCHAR2 and NOT NUMBER as it suggests.
128: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
129: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
130: P_OLD_VAL in number default hr_api.g_number,
131: P_NEW_VAL in number default hr_api.g_number,
132: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
133: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
134: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
135: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2, --NOTE: this P_COMP_LVL_FCTR_ID is VARCHAR2 and NOT NUMBER as it suggests.
136: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2, --NOTE: this P_ELEMENT_TYPE_ID is VARCHAR2 and NOT NUMBER as it suggests.
129: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
130: P_OLD_VAL in number default hr_api.g_number,
131: P_NEW_VAL in number default hr_api.g_number,
132: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
133: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
134: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
135: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2, --NOTE: this P_COMP_LVL_FCTR_ID is VARCHAR2 and NOT NUMBER as it suggests.
136: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2, --NOTE: this P_ELEMENT_TYPE_ID is VARCHAR2 and NOT NUMBER as it suggests.
137: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2, --NOTE: this P_INPUT_VALUE_ID is VARCHAR2 and NOT NUMBER as it suggests.
130: P_OLD_VAL in number default hr_api.g_number,
131: P_NEW_VAL in number default hr_api.g_number,
132: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
133: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
134: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
135: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2, --NOTE: this P_COMP_LVL_FCTR_ID is VARCHAR2 and NOT NUMBER as it suggests.
136: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2, --NOTE: this P_ELEMENT_TYPE_ID is VARCHAR2 and NOT NUMBER as it suggests.
137: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2, --NOTE: this P_INPUT_VALUE_ID is VARCHAR2 and NOT NUMBER as it suggests.
138: P_ELE_ENTRY_VAL_CD in varchar2 default hr_api.g_varchar2,
131: P_NEW_VAL in number default hr_api.g_number,
132: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
133: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
134: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
135: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2, --NOTE: this P_COMP_LVL_FCTR_ID is VARCHAR2 and NOT NUMBER as it suggests.
136: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2, --NOTE: this P_ELEMENT_TYPE_ID is VARCHAR2 and NOT NUMBER as it suggests.
137: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2, --NOTE: this P_INPUT_VALUE_ID is VARCHAR2 and NOT NUMBER as it suggests.
138: P_ELE_ENTRY_VAL_CD in varchar2 default hr_api.g_varchar2,
139: P_OBJECT_VERSION_NUMBER in number,
132: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
133: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
134: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
135: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2, --NOTE: this P_COMP_LVL_FCTR_ID is VARCHAR2 and NOT NUMBER as it suggests.
136: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2, --NOTE: this P_ELEMENT_TYPE_ID is VARCHAR2 and NOT NUMBER as it suggests.
137: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2, --NOTE: this P_INPUT_VALUE_ID is VARCHAR2 and NOT NUMBER as it suggests.
138: P_ELE_ENTRY_VAL_CD in varchar2 default hr_api.g_varchar2,
139: P_OBJECT_VERSION_NUMBER in number,
140: P_EFFECTIVE_START_DATE in date,
133: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
134: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
135: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2, --NOTE: this P_COMP_LVL_FCTR_ID is VARCHAR2 and NOT NUMBER as it suggests.
136: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2, --NOTE: this P_ELEMENT_TYPE_ID is VARCHAR2 and NOT NUMBER as it suggests.
137: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2, --NOTE: this P_INPUT_VALUE_ID is VARCHAR2 and NOT NUMBER as it suggests.
138: P_ELE_ENTRY_VAL_CD in varchar2 default hr_api.g_varchar2,
139: P_OBJECT_VERSION_NUMBER in number,
140: P_EFFECTIVE_START_DATE in date,
141: P_EFFECTIVE_END_DATE in date,
134: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
135: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2, --NOTE: this P_COMP_LVL_FCTR_ID is VARCHAR2 and NOT NUMBER as it suggests.
136: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2, --NOTE: this P_ELEMENT_TYPE_ID is VARCHAR2 and NOT NUMBER as it suggests.
137: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2, --NOTE: this P_INPUT_VALUE_ID is VARCHAR2 and NOT NUMBER as it suggests.
138: P_ELE_ENTRY_VAL_CD in varchar2 default hr_api.g_varchar2,
139: P_OBJECT_VERSION_NUMBER in number,
140: P_EFFECTIVE_START_DATE in date,
141: P_EFFECTIVE_END_DATE in date,
142: P_DATETRACK_MODE in varchar2,