[Home] [Help]
67: business_group_id,
68: accrual_plan_element_type_id,
69: pto_input_value_id,
70: co_input_value_id,
71: residual_input_value_id,
72: accrual_category,
73: accrual_plan_name,
74: accrual_start,
75: accrual_units_of_measure,
78: accrual_formula_id,
79: co_formula_id,
80: co_date_input_value_id,
81: co_exp_date_input_value_id,
82: residual_date_input_value_id,
83: description,
84: ineligibility_formula_id,
85: payroll_formula_id,
86: defined_balance_id,
125: p_rec.business_group_id,
126: p_rec.accrual_plan_element_type_id,
127: p_rec.pto_input_value_id,
128: p_rec.co_input_value_id,
129: p_rec.residual_input_value_id,
130: p_rec.accrual_category,
131: p_rec.accrual_plan_name,
132: p_rec.accrual_start,
133: p_rec.accrual_units_of_measure,
136: p_rec.accrual_formula_id,
137: p_rec.co_formula_id,
138: p_rec.co_date_input_value_id,
139: p_rec.co_exp_date_input_value_id,
140: p_rec.residual_date_input_value_id,
141: p_rec.description,
142: p_rec.ineligibility_formula_id,
143: p_rec.payroll_formula_id,
144: p_rec.defined_balance_id,
243: Procedure pre_insert(p_rec in out nocopy pay_pap_shd.g_rec_type) is
244: --
245: l_proc varchar2(72) := g_package||'pre_insert';
246:
247: Cursor C_Sel1 is select pay_accrual_plans_s.nextval from sys.dual;
248: --
249: Begin
250: hr_utility.set_location('Entering:'||l_proc, 5);
251:
310: ,p_business_group_id =>p_rec.business_group_id
311: ,p_accrual_plan_element_type_id =>p_rec.accrual_plan_element_type_id
312: ,p_pto_input_value_id =>p_rec.pto_input_value_id
313: ,p_co_input_value_id =>p_rec.co_input_value_id
314: ,p_residual_input_value_id =>p_rec.residual_input_value_id
315: ,p_accrual_category =>p_rec.accrual_category
316: ,p_accrual_plan_name =>p_rec.accrual_plan_name
317: ,p_accrual_start =>p_rec.accrual_start
318: ,p_accrual_units_of_measure =>p_rec.accrual_units_of_measure
321: ,p_accrual_formula_id =>p_rec.accrual_formula_id
322: ,p_co_formula_id =>p_rec.co_formula_id
323: ,p_co_date_input_value_id =>p_rec.co_date_input_value_id
324: ,p_co_exp_date_input_value_id =>p_rec.co_exp_date_input_value_id
325: ,p_residual_date_input_value_id =>p_rec.residual_date_input_value_id
326: ,p_description =>p_rec.description
327: ,p_ineligibility_formula_id =>p_rec.ineligibility_formula_id
328: ,p_payroll_formula_id =>p_rec.payroll_formula_id
329: ,p_defined_balance_id =>p_rec.defined_balance_id
435: ,p_business_group_id IN NUMBER
436: ,p_accrual_plan_element_type_id IN NUMBER
437: ,p_pto_input_value_id IN NUMBER
438: ,p_co_input_value_id IN NUMBER
439: ,p_residual_input_value_id IN NUMBER
440: ,p_accrual_category IN VARCHAR2
441: ,p_accrual_plan_name IN VARCHAR2
442: ,p_accrual_units_of_measure IN VARCHAR2
443: ,p_accrual_start IN VARCHAR2 DEFAULT NULL
446: ,p_accrual_formula_id IN NUMBER DEFAULT NULL
447: ,p_co_formula_id IN NUMBER DEFAULT NULL
448: ,p_co_date_input_value_id IN NUMBER DEFAULT NULL
449: ,p_co_exp_date_input_value_id IN NUMBER DEFAULT NULL
450: ,p_residual_date_input_value_id IN NUMBER DEFAULT NULL
451: ,p_description IN VARCHAR2 DEFAULT NULL
452: ,p_ineligibility_formula_id IN NUMBER DEFAULT NULL
453: ,p_payroll_formula_id IN NUMBER DEFAULT NULL
454: ,p_defined_balance_id IN NUMBER DEFAULT NULL
508: p_business_group_id,
509: p_accrual_plan_element_type_id,
510: p_pto_input_value_id,
511: p_co_input_value_id,
512: p_residual_input_value_id,
513: p_accrual_category,
514: p_accrual_plan_name,
515: p_accrual_start,
516: p_accrual_units_of_measure,
519: p_accrual_formula_id,
520: p_co_formula_id,
521: p_co_date_input_value_id,
522: p_co_exp_date_input_value_id,
523: p_residual_date_input_value_id,
524: p_description,
525: p_ineligibility_formula_id,
526: p_payroll_formula_id,
527: p_defined_balance_id,