DBA Data[Home] [Help]

APPS.HR_ACCRUAL_PLAN_API dependencies on PAY_ACCRUAL_PLANS

Line 1740: -- Now call the insert row handler for pay accrual plans

1736: end if;
1737:
1738: hr_utility.set_location(l_proc, 270);
1739: --
1740: -- Now call the insert row handler for pay accrual plans
1741: --
1742: pay_pap_ins.ins
1743: (p_effective_date => p_effective_date
1744: ,p_business_group_id => p_business_group_id

Line 1849: pay_accrual_plans pap

1845: SET mandatory_flag = 'X'
1846: WHERE input_value_id =
1847: ( SELECT piv.input_value_id
1848: FROM pay_input_values_f piv,
1849: pay_accrual_plans pap
1850: WHERE pap.accrual_plan_id = p_accrual_plan_id
1851: AND pap.accrual_plan_element_type_id = piv.element_type_id
1852: AND piv.name = 'Pay Value'
1853: );

Line 2136: from pay_accrual_plans pap

2132: -- Fetches the current accrual plan.
2133: --
2134: cursor csr_get_accrual_plan IS
2135: select *
2136: from pay_accrual_plans pap
2137: where pap.accrual_plan_id = p_accrual_plan_id;
2138:
2139: --
2140: -- Declare cursors and local variables

Line 3174: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 41);

3170:
3171: --
3172: -- delete the net calculation rules
3173: --
3174: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 41);
3175: for l_ncr in c_get_ncr(p_accrual_plan_id) loop
3176: --
3177: pay_ncr_api.delete_pay_net_calc_rule (
3178: p_net_calculation_rule_id => l_ncr.net_calculation_rule_id,

Line 3189: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 42);

3185: -- delete the element types created for the plan
3186: --
3187: -- first the accrual plan element type...
3188: --
3189: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 42);
3190: hr_elements.chk_del_element_type (
3191: 'ZAP',
3192: p_accrual_plan_element_type_id,
3193: '',

Line 3199: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 43);

3195: l_effective_start_date,
3196: l_effective_end_date);
3197:
3198: --
3199: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 43);
3200: hr_elements.del_3p_element_type (
3201: p_accrual_plan_element_type_id,
3202: 'ZAP',
3203: p_effective_date,

Line 3208: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions',44);

3204: l_effective_start_date,
3205: l_effective_end_date,
3206: '');
3207:
3208: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions',44);
3209: delete from pay_element_types_f
3210: where element_type_id = p_accrual_plan_element_type_id;
3211:
3212: --

Line 3216: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 45);

3212: --
3213: -- ...then the carried over element type...
3214: --
3215:
3216: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 45);
3217: hr_elements.chk_del_element_type (
3218: 'ZAP',
3219: p_co_element_type_id,
3220: '',

Line 3226: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 46);

3222: l_effective_start_date,
3223: l_effective_end_date);
3224:
3225: --
3226: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 46);
3227: hr_elements.del_3p_element_type (
3228: p_co_element_type_id,
3229: 'ZAP',
3230: p_effective_date,

Line 3236: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions',47);

3232: l_effective_end_date,
3233: '');
3234:
3235: --
3236: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions',47);
3237: hr_utility.trace('DELETE ELEMENT: '||to_char(p_co_element_type_id));
3238: delete from pay_element_types_f
3239: where element_type_id = p_co_element_type_id;
3240:

Line 3244: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 48);

3240:
3241: --
3242: -- ...then the residual element type.
3243: --
3244: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 48);
3245:
3246: hr_elements.chk_del_element_type (
3247: 'ZAP',
3248: p_residual_element_type_id,

Line 3255: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 49);

3251: l_effective_start_date,
3252: l_effective_end_date);
3253:
3254: --
3255: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 49);
3256: hr_elements.del_3p_element_type (
3257: p_residual_element_type_id,
3258: 'ZAP',
3259: p_effective_date,

Line 3272: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 50);

3268:
3269: --
3270: -- ...then the payroll balance element type.
3271: --
3272: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 50);
3273:
3274: hr_elements.chk_del_element_type (
3275: 'ZAP',
3276: p_balance_element_type_id,

Line 3283: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 51);

3279: l_effective_start_date,
3280: l_effective_end_date);
3281:
3282: --
3283: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 51);
3284: hr_elements.del_3p_element_type (
3285: p_balance_element_type_id,
3286: 'ZAP',
3287: p_effective_date,

Line 3299: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 50);

3295:
3296: --
3297: -- ...then the tagging element type.
3298: --
3299: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 50);
3300:
3301: hr_elements.chk_del_element_type (
3302: 'ZAP',
3303: p_tagging_element_type_id,

Line 3310: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 51);

3306: l_effective_start_date,
3307: l_effective_end_date);
3308:
3309: --
3310: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 51);
3311: hr_elements.del_3p_element_type (
3312: p_tagging_element_type_id,
3313: 'ZAP',
3314: p_effective_date,