DBA Data[Home] [Help]

APPS.PAY_SE_PAYSLIP_ARCHIVE dependencies on PAY_BALANCE_PKG

Line 2302: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);

2298: OPEN csr_tax_unit(p_assignment_action_id);
2299: FETCH csr_tax_unit INTO l_tu_id;
2300: CLOSE csr_tax_unit;
2301:
2302: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
2303: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
2304: IF g_user_balance_table.count > 0 THEN
2305:
2306: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP

Line 2303: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));

2299: FETCH csr_tax_unit INTO l_tu_id;
2300: CLOSE csr_tax_unit;
2301:
2302: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
2303: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
2304: IF g_user_balance_table.count > 0 THEN
2305:
2306: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP
2307: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);

Line 2307: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);

2303: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
2304: IF g_user_balance_table.count > 0 THEN
2305:
2306: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP
2307: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);
2308: IF l_balance_value > 0 THEN
2309:
2310: pay_action_information_api.create_action_information (
2311: p_action_information_id => l_action_info_id

Line 2662: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);

2658: CLOSE csr_tax_unit;
2659:
2660: --fnd_file.put_line(fnd_file.log,'p_assignment_action_id ' || p_assignment_action_id );
2661:
2662: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
2663: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_effective_date));
2664:
2665: --fnd_file.put_line(fnd_file.log,'ARCHIVE_EMPLOYEE_DETAILS');
2666: -------------------------------------------------------------

Line 2663: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_effective_date));

2659:
2660: --fnd_file.put_line(fnd_file.log,'p_assignment_action_id ' || p_assignment_action_id );
2661:
2662: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
2663: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_effective_date));
2664:
2665: --fnd_file.put_line(fnd_file.log,'ARCHIVE_EMPLOYEE_DETAILS');
2666: -------------------------------------------------------------
2667: --Archive EMPLOYEE_DETAILS, PAYMENT_INFO and BALANCES