APPS.PQP_GB_OSP_TEMPLATE dependencies on STANDARD

Line 187: -- the above select will fail if there is more than one standard rate

183: FROM ben_acty_base_rt_f
184: WHERE pl_id = p_pl_id
185: AND p_effective_date BETWEEN effective_start_date
186: AND effective_end_date;
187: -- the above select will fail if there is more than one standard rate
188: -- thus if the user has manually setup additional rates then
189: -- they must first manually delink them
190: -- leaving only the base standard rate created by plan copy in place
191:

Line 190: -- leaving only the base standard rate created by plan copy in place

186: AND effective_end_date;
187: -- the above select will fail if there is more than one standard rate
188: -- thus if the user has manually setup additional rates then
189: -- they must first manually delink them
190: -- leaving only the base standard rate created by plan copy in place
191:
192:
193: l_proc_step := 25;
194: IF g_debug THEN

Line 199: -- delete all extra inputs for this standard rate

195: debug(l_proc_name,l_proc_step);
196: END IF;
197:
198:
199: -- delete all extra inputs for this standard rate
200: DELETE FROM ben_extra_input_values
201: WHERE acty_base_rt_id = l_acty_base_rt_id;
202:
203:

Line 204: -- 2a) remove the link of the base element from the standard rate

200: DELETE FROM ben_extra_input_values
201: WHERE acty_base_rt_id = l_acty_base_rt_id;
202:
203:
204: -- 2a) remove the link of the base element from the standard rate
205: l_proc_step := 30;
206: IF g_debug THEN
207: debug(l_proc_name,l_proc_step);
208: END IF;

Line 276: -- 2. setting up standard rates

272: debug_enter(l_proc_name);
273:
274: -- what to automate ?
275: -- 1. making plans active
276: -- 2. setting up standard rates
277: -- 3. setup a benefits group for quick eligibity setup
278: -- 4. linking life events to person changes -- once only
279: -- what is not automated
280: -- is the delete half of this

Line 298: -- 2. setting up standard rates a) update standard rate

294: WHERE pl_id = p_pl_id
295: AND p_effective_date BETWEEN effective_start_date
296: AND effective_end_date;
297:
298: -- 2. setting up standard rates a) update standard rate
299:
300: l_proc_step := 20;
301: IF g_debug THEN
302: debug(l_proc_name,l_proc_step);

Line 319: --Set Standard Input Value as Absence Days

315: IF g_debug THEN
316: debug(l_proc_name,l_proc_step);
317: END IF;
318:
319: --Set Standard Input Value as Absence Days
320: --as LOS dosent make any sense for UNP
321: IF p_plan_class='UNP' THEN
322: l_input_name := 'ABSENCE DAYS' ;
323: ELSE

Line 347: -- 2. setting up standard rates b) insert extra inputs

343: IF g_debug THEN
344: debug(l_proc_name,l_proc_step);
345: END IF;
346:
347: -- 2. setting up standard rates b) insert extra inputs
348:
349: IF p_plan_class='OSP' OR p_plan_class='UNP' THEN
350: INSERT INTO ben_extra_input_values
351: (extra_input_value_id -- NOT NULL NUMBER(15)

Line 3348: -- benefit standard rates

3344: AND business_group_id = p_business_group_id
3345: AND template_type = 'U';
3346:
3347: -- Cursor to check whether elements are attached to
3348: -- benefit standard rates
3349:
3350: CURSOR csr_chk_ele_in_ben (c_element_type_id number)
3351: IS
3352: SELECT 'X'

Line 3854: -- standard rate formula before deleting them

3850: FETCH csr_get_ele_type_id INTO l_element_type_id;
3851: EXIT WHEN csr_get_ele_type_id%NOTFOUND;
3852:
3853: -- Check whether elements are attached to benefits
3854: -- standard rate formula before deleting them
3855:
3856: l_proc_step := 25;
3857: IF g_debug THEN
3858: debug(l_proc_name, l_proc_step);

Line 3870: hr_utility.set_message_token('TYPE','Standard Rates, Table: BEN_ACTY_BASE_RT_F');

3866:
3867: -- Raise Error
3868: Close csr_chk_ele_in_ben;
3869: hr_utility.set_message (800,'PER_74880_CHILD_RECORD');
3870: hr_utility.set_message_token('TYPE','Standard Rates, Table: BEN_ACTY_BASE_RT_F');
3871: hr_utility.raise_error;
3872:
3873: END IF; -- End if of element in ben check ...
3874: CLOSE csr_chk_ele_in_ben;