APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on HR_GBBAL

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

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

Line 2166: + hr_gbbal.calc_asg_proc_ptd_date (

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

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

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

Line 2302: hr_gbbal.calc_balance (

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

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

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

Line 2342: + hr_gbbal.calc_balance (

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

Line 4927: l_value := hr_gbbal.calc_balance (

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

Line 4945: l_value := hr_gbbal.calc_balance (

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

Line 4967: l_value := hr_gbbal.calc_balance (

4963: l_bal_type_id := null;
4964: l_bal_type_id := get_pay_bal_id (p_balance_name => l_balance_name);
4965: if l_bal_type_id is not null
4966: then
4967: l_value := hr_gbbal.calc_balance (
4968: p_assignment_id=> g_pen_ele_details(i).assignment_id,
4969: p_balance_type_id=> l_bal_type_id,
4970: p_period_from_date=> GREATEST(g_effective_start_date,
4971: g_pen_ele_details(i).effective_start_date,