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 1841: pay_accrual_plans pap

1837: SET mandatory_flag = 'X'
1838: WHERE input_value_id =
1839: ( SELECT piv.input_value_id
1840: FROM pay_input_values_f piv,
1841: pay_accrual_plans pap
1842: WHERE pap.accrual_plan_id = p_accrual_plan_id
1843: AND pap.accrual_plan_element_type_id = piv.element_type_id
1844: AND piv.name = 'Pay Value'
1845: );

Line 2128: from pay_accrual_plans pap

2124: -- Fetches the current accrual plan.
2125: --
2126: cursor csr_get_accrual_plan IS
2127: select *
2128: from pay_accrual_plans pap
2129: where pap.accrual_plan_id = p_accrual_plan_id;
2130:
2131: --
2132: -- Declare cursors and local variables

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

3154:
3155: --
3156: -- delete the net calculation rules
3157: --
3158: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 41);
3159: for l_ncr in c_get_ncr(p_accrual_plan_id) loop
3160: --
3161: pay_ncr_api.delete_pay_net_calc_rule (
3162: p_net_calculation_rule_id => l_ncr.net_calculation_rule_id,

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

3169: -- delete the element types created for the plan
3170: --
3171: -- first the accrual plan element type...
3172: --
3173: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 42);
3174: hr_elements.chk_del_element_type (
3175: 'ZAP',
3176: p_accrual_plan_element_type_id,
3177: '',

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

3179: l_effective_start_date,
3180: l_effective_end_date);
3181:
3182: --
3183: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 43);
3184: hr_elements.del_3p_element_type (
3185: p_accrual_plan_element_type_id,
3186: 'ZAP',
3187: p_effective_date,

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

3188: l_effective_start_date,
3189: l_effective_end_date,
3190: '');
3191:
3192: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions',44);
3193: delete from pay_element_types_f
3194: where element_type_id = p_accrual_plan_element_type_id;
3195:
3196: --

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

3196: --
3197: -- ...then the carried over element type...
3198: --
3199:
3200: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 45);
3201: hr_elements.chk_del_element_type (
3202: 'ZAP',
3203: p_co_element_type_id,
3204: '',

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

3206: l_effective_start_date,
3207: l_effective_end_date);
3208:
3209: --
3210: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 46);
3211: hr_elements.del_3p_element_type (
3212: p_co_element_type_id,
3213: 'ZAP',
3214: p_effective_date,

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

3216: l_effective_end_date,
3217: '');
3218:
3219: --
3220: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions',47);
3221: hr_utility.trace('DELETE ELEMENT: '||to_char(p_co_element_type_id));
3222: delete from pay_element_types_f
3223: where element_type_id = p_co_element_type_id;
3224:

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

3224:
3225: --
3226: -- ...then the residual element type.
3227: --
3228: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 48);
3229:
3230: hr_elements.chk_del_element_type (
3231: 'ZAP',
3232: p_residual_element_type_id,

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

3235: l_effective_start_date,
3236: l_effective_end_date);
3237:
3238: --
3239: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 49);
3240: hr_elements.del_3p_element_type (
3241: p_residual_element_type_id,
3242: 'ZAP',
3243: p_effective_date,

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

3252:
3253: --
3254: -- ...then the payroll balance element type.
3255: --
3256: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 50);
3257:
3258: hr_elements.chk_del_element_type (
3259: 'ZAP',
3260: p_balance_element_type_id,

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

3263: l_effective_start_date,
3264: l_effective_end_date);
3265:
3266: --
3267: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 51);
3268: hr_elements.del_3p_element_type (
3269: p_balance_element_type_id,
3270: 'ZAP',
3271: p_effective_date,

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

3279:
3280: --
3281: -- ...then the tagging element type.
3282: --
3283: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 50);
3284:
3285: hr_elements.chk_del_element_type (
3286: 'ZAP',
3287: p_tagging_element_type_id,

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

3290: l_effective_start_date,
3291: l_effective_end_date);
3292:
3293: --
3294: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 51);
3295: hr_elements.del_3p_element_type (
3296: p_tagging_element_type_id,
3297: 'ZAP',
3298: p_effective_date,