DBA Data[Home] [Help]

APPS.PAY_SE_PAYSLIP_ARCHIVE dependencies on PAY_BALANCE_PKG

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

2310: OPEN csr_tax_unit(p_assignment_action_id);
2311: FETCH csr_tax_unit INTO l_tu_id;
2312: CLOSE csr_tax_unit;
2313:
2314: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
2315: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
2316: IF g_user_balance_table.count > 0 THEN
2317:
2318: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP

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

2311: FETCH csr_tax_unit INTO l_tu_id;
2312: CLOSE csr_tax_unit;
2313:
2314: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
2315: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
2316: IF g_user_balance_table.count > 0 THEN
2317:
2318: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP
2319: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);

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

2315: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
2316: IF g_user_balance_table.count > 0 THEN
2317:
2318: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP
2319: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);
2320: IF l_balance_value > 0 THEN
2321:
2322: pay_action_information_api.create_action_information (
2323: p_action_information_id => l_action_info_id

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

2670: CLOSE csr_tax_unit;
2671:
2672: --fnd_file.put_line(fnd_file.log,'p_assignment_action_id ' || p_assignment_action_id );
2673:
2674: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
2675: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_effective_date));
2676:
2677: --fnd_file.put_line(fnd_file.log,'ARCHIVE_EMPLOYEE_DETAILS');
2678: -------------------------------------------------------------

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

2671:
2672: --fnd_file.put_line(fnd_file.log,'p_assignment_action_id ' || p_assignment_action_id );
2673:
2674: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
2675: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_effective_date));
2676:
2677: --fnd_file.put_line(fnd_file.log,'ARCHIVE_EMPLOYEE_DETAILS');
2678: -------------------------------------------------------------
2679: --Archive EMPLOYEE_DETAILS, PAYMENT_INFO and BALANCES