DBA Data[Home] [Help]

APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on HR_GBBAL

Line 2162: DEBUG ('Before calling function hr_gbbal.calc_asg_proc_ptd_date');

2158:
2159: LOOP
2160: FETCH csr_get_end_date INTO l_effective_date;
2161: EXIT WHEN csr_get_end_date%NOTFOUND;
2162: DEBUG ('Before calling function hr_gbbal.calc_asg_proc_ptd_date');
2163: l_bal_value :=
2164: l_bal_value
2165: + hr_gbbal.calc_asg_proc_ptd_date (
2166: p_assignment_id=> p_assignment_id,

Line 2165: + hr_gbbal.calc_asg_proc_ptd_date (

2161: EXIT WHEN csr_get_end_date%NOTFOUND;
2162: DEBUG ('Before calling function hr_gbbal.calc_asg_proc_ptd_date');
2163: l_bal_value :=
2164: l_bal_value
2165: + hr_gbbal.calc_asg_proc_ptd_date (
2166: p_assignment_id=> p_assignment_id,
2167: p_balance_type_id=> p_balance_type_id,
2168: p_effective_date=> l_effective_date
2169: );

Line 2299: DEBUG ('Before calling function hr_gbbal.calc_balance');

2295: DEBUG('g_pen_ele_details(i).effective_end_date: '
2296: || TO_CHAR(g_pen_ele_details(i).effective_end_date, 'DD/MON/YYYY'));
2297:
2298: DEBUG ('Primary Assignment');
2299: DEBUG ('Before calling function hr_gbbal.calc_balance');
2300: l_value := l_value +
2301: hr_gbbal.calc_balance (
2302: p_assignment_id=> p_assignment_id,
2303: p_balance_type_id=> p_balance_type_id,

Line 2301: hr_gbbal.calc_balance (

2297:
2298: DEBUG ('Primary Assignment');
2299: DEBUG ('Before calling function hr_gbbal.calc_balance');
2300: l_value := l_value +
2301: hr_gbbal.calc_balance (
2302: p_assignment_id=> p_assignment_id,
2303: p_balance_type_id=> p_balance_type_id,
2304: p_period_from_date=> GREATEST(p_effective_start_date,
2305: g_pen_ele_details(i).effective_start_date),

Line 2338: DEBUG ('Before calling function hr_gbbal.calc_balance');

2334: || TO_CHAR(g_pen_ele_details(j).effective_start_date, 'DD/MON/YYYY'));
2335: DEBUG('g_pen_ele_details(j).effective_end_date: '
2336: || TO_CHAR(g_pen_ele_details(j).effective_end_date, 'DD/MON/YYYY'));
2337:
2338: DEBUG ('Before calling function hr_gbbal.calc_balance');
2339: l_value :=
2340: l_value
2341: + hr_gbbal.calc_balance (
2342: p_assignment_id=> l_secondary_asg_ids (i),

Line 2341: + hr_gbbal.calc_balance (

2337:
2338: DEBUG ('Before calling function hr_gbbal.calc_balance');
2339: l_value :=
2340: l_value
2341: + hr_gbbal.calc_balance (
2342: p_assignment_id=> l_secondary_asg_ids (i),
2343: p_balance_type_id=> p_balance_type_id,
2344: p_period_from_date=> GREATEST(p_effective_start_date,
2345: g_pen_ele_details(j).effective_start_date),

Line 4926: l_value := hr_gbbal.calc_balance (

4922: l_rec_ele_ent_details.effective_end_date));
4923: FETCH csr_get_end_date INTO l_end_date;
4924: CLOSE csr_get_end_date;
4925: DEBUG('l_end_date: '|| TO_CHAR(l_end_date, 'DD/MON/YYYY'));
4926: l_value := hr_gbbal.calc_balance (
4927: p_assignment_id=> g_pen_ele_details(i).assignment_id,
4928: p_balance_type_id=> l_bal_type_id,
4929: p_period_from_date=> GREATEST(g_effective_start_date,
4930: g_pen_ele_details(i).effective_start_date,

Line 4944: l_value := hr_gbbal.calc_balance (

4940:
4941: l_balance_name := 'NI '|| g_ni_cont_out_ele_ids(j).category || ' Able ET';
4942: DEBUG('l_balance_name: '||l_balance_name);
4943: l_bal_type_id := get_pay_bal_id (p_balance_name => l_balance_name);
4944: l_value := hr_gbbal.calc_balance (
4945: p_assignment_id=> g_pen_ele_details(i).assignment_id,
4946: p_balance_type_id=> l_bal_type_id,
4947: p_period_from_date=> GREATEST(g_effective_start_date,
4948: g_pen_ele_details(i).effective_start_date,