eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_BALANCE_PKG

Line 3159: l_balance_value := pay_balance_pkg.get_value(g_element_table(l_index).prim_bal_def_bal_id , p_assignment_action_id );

3155:
3156: IF (g_element_table(l_index).prim_bal_def_bal_id IS NOT NULL) THEN
3157:
3158: -- get the primary balance ytd value for the element
3159: l_balance_value := pay_balance_pkg.get_value(g_element_table(l_index).prim_bal_def_bal_id , p_assignment_action_id );
3160:
3161: END IF;
3162:
3163: /* get the element run result value */

Line 3203: -- l_balance_value := pay_balance_pkg.get_value(g_element_table(l_index).prim_bal_def_bal_id , p_assignment_action_id );

3199: -- fnd_file.put_line(fnd_file.log,'after : l_result_value = ' || l_result_value);
3200:
3201: -- l_balance_value := NULL ;
3202:
3203: -- l_balance_value := pay_balance_pkg.get_value(g_element_table(l_index).prim_bal_def_bal_id , p_assignment_action_id );
3204:
3205: -- fnd_file.put_line(fnd_file.log,'l_result_value = ' || l_result_value);
3206: -- fnd_file.put_line(fnd_file.log,'l_ele_entry_id = ' || l_ele_entry_id);
3207:

Line 3218: l_balance_value := pay_balance_pkg.get_value(g_element_table(l_index).prim_bal_def_bal_id , p_assignment_action_id );

3214: /*
3215: IF (g_element_table(l_index).prim_bal_def_bal_id IS NOT NULL) and (csr_result_value%ROWCOUNT = 1) THEN
3216:
3217: -- get the primary balance ytd value for the element
3218: l_balance_value := pay_balance_pkg.get_value(g_element_table(l_index).prim_bal_def_bal_id , p_assignment_action_id );
3219:
3220: END IF;
3221: */
3222:

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

3485: OPEN csr_tax_unit(p_assignment_action_id);
3486: FETCH csr_tax_unit INTO l_tu_id;
3487: CLOSE csr_tax_unit;
3488:
3489: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
3490: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
3491:
3492: IF g_user_balance_table.count > 0 THEN
3493: -- fnd_file.put_line(fnd_file.log,'In ARCHIVE_OTH_BALANCE 1');

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

3486: FETCH csr_tax_unit INTO l_tu_id;
3487: CLOSE csr_tax_unit;
3488:
3489: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
3490: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
3491:
3492: IF g_user_balance_table.count > 0 THEN
3493: -- fnd_file.put_line(fnd_file.log,'In ARCHIVE_OTH_BALANCE 1');
3494:

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

3493: -- fnd_file.put_line(fnd_file.log,'In ARCHIVE_OTH_BALANCE 1');
3494:
3495: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP
3496:
3497: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);
3498:
3499: IF l_balance_value > 0 THEN
3500: -- fnd_file.put_line(fnd_file.log,'In ARCHIVE_OTH_BALANCE 2 :' || l_balance_value);
3501: pay_action_information_api.create_action_information (

Line 4063: l_threshold_used_per_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

4059:
4060: -- calculating the Threshold Remaining
4061:
4062: l_defined_balance_id := GET_DEFINED_BALANCE_ID('THRESHOLD_USED_PER_YTD');
4063: l_threshold_used_per_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
4064: l_threshold_remaining := g_tax_card_tab(7).screen_entry_val - l_threshold_used_per_ytd ;
4065:
4066:
4067: -- fnd_file.put_line(fnd_file.log,'archiving ADDL EMPLOYEE DETAILS');

Line 4110: g_bal_val(l_index).bal_val := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

4106:
4107: -- fnd_file.put_line(fnd_file.log,'l_defined_balance_id = '||to_char(l_defined_balance_id));
4108: -- fnd_file.put_line(fnd_file.log,'p_assignment_action_id = '||to_char(p_assignment_action_id));
4109:
4110: g_bal_val(l_index).bal_val := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
4111:
4112: -- fnd_file.put_line(fnd_file.log,'g_bal_val(l_index).bal_val = '||to_char(g_bal_val(l_index).bal_val));
4113:
4114: END LOOP;

Line 4719: l_balance_value := pay_balance_pkg.get_value(csr_rec.prim_def_bal_id , p_assignment_action_id );

4715: -- fnd_file.put_line(fnd_file.log,'l_element_name = ' || l_element_name);
4716: -- fnd_file.put_line(fnd_file.log,'csr_rec.prim_def_bal_id = ' || csr_rec.prim_def_bal_id );
4717:
4718:
4719: l_balance_value := pay_balance_pkg.get_value(csr_rec.prim_def_bal_id , p_assignment_action_id );
4720:
4721: /* Change for element classification name from 'Holiday Pay Earnings Adjustment' to 'Holiday Pay Earnings Adjust' */
4722:
4723: -- IF csr_rec.ele_class in ('Earnings Adjustment' , 'Holiday Pay Earnings Adjustment') THEN

Line 4733: -- Bug Fix : 5909576, pay_balance_pkg.get_value already returns a value in NUMBER format.

4729: -- IF csr_rec.ele_class in ('Earnings Adjustment' , 'Holiday Pay Earnings Adjust') THEN
4730: IF csr_rec.ele_class in ('Earnings Adjustment') THEN
4731:
4732: -- l_balance_value := fnd_number.number_to_canonical (0 - fnd_number.canonical_to_number (l_balance_value) ) ;
4733: -- Bug Fix : 5909576, pay_balance_pkg.get_value already returns a value in NUMBER format.
4734: -- So we need not do a fnd_number.canonical_to_number on l_balance_value.
4735:
4736: l_balance_value := (0 - l_balance_value ) ;
4737:

Line 4795: l_balance_value := pay_balance_pkg.get_value(csr_rec.prim_def_bal_id , p_assignment_action_id );

4791: fnd_file.put_line(fnd_file.log,'l_element_name = ' || l_element_name);
4792: fnd_file.put_line(fnd_file.log,'csr_rec.prim_def_bal_id = ' || csr_rec.prim_def_bal_id );
4793:
4794:
4795: l_balance_value := pay_balance_pkg.get_value(csr_rec.prim_def_bal_id , p_assignment_action_id );
4796:
4797: fnd_file.put_line(fnd_file.log,'l_balance_value = ' || l_balance_value);
4798: fnd_file.put_line(fnd_file.log,'---------------------');
4799: