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 3170: l_balance_value := pay_balance_pkg.get_value(g_element_table(l_index).prim_bal_def_bal_id , p_assignment_action_id );

3166:
3167: IF (g_element_table(l_index).prim_bal_def_bal_id IS NOT NULL) THEN
3168:
3169: -- get the primary balance ytd value for the element
3170: l_balance_value := pay_balance_pkg.get_value(g_element_table(l_index).prim_bal_def_bal_id , p_assignment_action_id );
3171:
3172: END IF;
3173:
3174: /* get the element run result value */

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

3210: -- fnd_file.put_line(fnd_file.log,'after : l_result_value = ' || l_result_value);
3211:
3212: -- l_balance_value := NULL ;
3213:
3214: -- l_balance_value := pay_balance_pkg.get_value(g_element_table(l_index).prim_bal_def_bal_id , p_assignment_action_id );
3215:
3216: -- fnd_file.put_line(fnd_file.log,'l_result_value = ' || l_result_value);
3217: -- fnd_file.put_line(fnd_file.log,'l_ele_entry_id = ' || l_ele_entry_id);
3218:

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

3225: /*
3226: IF (g_element_table(l_index).prim_bal_def_bal_id IS NOT NULL) and (csr_result_value%ROWCOUNT = 1) THEN
3227:
3228: -- get the primary balance ytd value for the element
3229: l_balance_value := pay_balance_pkg.get_value(g_element_table(l_index).prim_bal_def_bal_id , p_assignment_action_id );
3230:
3231: END IF;
3232: */
3233:

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

3496: OPEN csr_tax_unit(p_assignment_action_id);
3497: FETCH csr_tax_unit INTO l_tu_id;
3498: CLOSE csr_tax_unit;
3499:
3500: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
3501: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
3502:
3503: IF g_user_balance_table.count > 0 THEN
3504: -- fnd_file.put_line(fnd_file.log,'In ARCHIVE_OTH_BALANCE 1');

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

3497: FETCH csr_tax_unit INTO l_tu_id;
3498: CLOSE csr_tax_unit;
3499:
3500: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
3501: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
3502:
3503: IF g_user_balance_table.count > 0 THEN
3504: -- fnd_file.put_line(fnd_file.log,'In ARCHIVE_OTH_BALANCE 1');
3505:

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

3504: -- fnd_file.put_line(fnd_file.log,'In ARCHIVE_OTH_BALANCE 1');
3505:
3506: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP
3507:
3508: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);
3509:
3510: IF l_balance_value > 0 THEN
3511: -- fnd_file.put_line(fnd_file.log,'In ARCHIVE_OTH_BALANCE 2 :' || l_balance_value);
3512: pay_action_information_api.create_action_information (

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

4070:
4071: -- calculating the Threshold Remaining
4072:
4073: l_defined_balance_id := GET_DEFINED_BALANCE_ID('THRESHOLD_USED_PER_YTD');
4074: l_threshold_used_per_ytd := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
4075: l_threshold_remaining := g_tax_card_tab(7).screen_entry_val - l_threshold_used_per_ytd ;
4076:
4077:
4078: -- fnd_file.put_line(fnd_file.log,'archiving ADDL EMPLOYEE DETAILS');

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

4117:
4118: -- fnd_file.put_line(fnd_file.log,'l_defined_balance_id = '||to_char(l_defined_balance_id));
4119: -- fnd_file.put_line(fnd_file.log,'p_assignment_action_id = '||to_char(p_assignment_action_id));
4120:
4121: g_bal_val(l_index).bal_val := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
4122:
4123: -- fnd_file.put_line(fnd_file.log,'g_bal_val(l_index).bal_val = '||to_char(g_bal_val(l_index).bal_val));
4124:
4125: END LOOP;

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

4726: -- fnd_file.put_line(fnd_file.log,'l_element_name = ' || l_element_name);
4727: -- fnd_file.put_line(fnd_file.log,'csr_rec.prim_def_bal_id = ' || csr_rec.prim_def_bal_id );
4728:
4729:
4730: l_balance_value := pay_balance_pkg.get_value(csr_rec.prim_def_bal_id , p_assignment_action_id );
4731:
4732: /* Change for element classification name from 'Holiday Pay Earnings Adjustment' to 'Holiday Pay Earnings Adjust' */
4733:
4734: -- IF csr_rec.ele_class in ('Earnings Adjustment' , 'Holiday Pay Earnings Adjustment') THEN

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

4740: -- IF csr_rec.ele_class in ('Earnings Adjustment' , 'Holiday Pay Earnings Adjust') THEN
4741: IF csr_rec.ele_class in ('Earnings Adjustment') THEN
4742:
4743: -- l_balance_value := fnd_number.number_to_canonical (0 - fnd_number.canonical_to_number (l_balance_value) ) ;
4744: -- Bug Fix : 5909576, pay_balance_pkg.get_value already returns a value in NUMBER format.
4745: -- So we need not do a fnd_number.canonical_to_number on l_balance_value.
4746:
4747: l_balance_value := (0 - l_balance_value ) ;
4748:

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

4802: fnd_file.put_line(fnd_file.log,'l_element_name = ' || l_element_name);
4803: fnd_file.put_line(fnd_file.log,'csr_rec.prim_def_bal_id = ' || csr_rec.prim_def_bal_id );
4804:
4805:
4806: l_balance_value := pay_balance_pkg.get_value(csr_rec.prim_def_bal_id , p_assignment_action_id );
4807:
4808: fnd_file.put_line(fnd_file.log,'l_balance_value = ' || l_balance_value);
4809: fnd_file.put_line(fnd_file.log,'---------------------');
4810: