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_GB_RTI_FPS_ARCHIVE dependencies on PAY_BALANCE_PKG

Line 99: g_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of normal balances

95: g_ni_pt_eid NUMBER:=0;
96: g_ni_pt_ivid NUMBER:=0;
97: g_fps_bal_det_tab t_fps_bal_det_tab;
98: g_fps_aggr_bal_det_tab t_fps_bal_det_tab;
99: g_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of normal balances
100: g_aggr_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of aggregation balances
101: g_aggr_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni aggregation balances
102: --
103: g_tax_ref VARCHAR2(20);

Line 100: g_aggr_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of aggregation balances

96: g_ni_pt_ivid NUMBER:=0;
97: g_fps_bal_det_tab t_fps_bal_det_tab;
98: g_fps_aggr_bal_det_tab t_fps_bal_det_tab;
99: g_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of normal balances
100: g_aggr_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of aggregation balances
101: g_aggr_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni aggregation balances
102: --
103: g_tax_ref VARCHAR2(20);
104: --

Line 101: g_aggr_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni aggregation balances

97: g_fps_bal_det_tab t_fps_bal_det_tab;
98: g_fps_aggr_bal_det_tab t_fps_bal_det_tab;
99: g_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of normal balances
100: g_aggr_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of aggregation balances
101: g_aggr_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni aggregation balances
102: --
103: g_tax_ref VARCHAR2(20);
104: --
105: g_paye_eid NUMBER :=0 ;

Line 1597: l_trivial_a := 100 * NVL(pay_balance_pkg.get_value(l_trivial_a_id,l_last_asg_action_id),0);

1593: OPEN get_defined_balance_id('Trivial Commutation Type C','_ASG_RUN');
1594: FETCH get_defined_balance_id INTO l_trivial_c_id;
1595: CLOSE get_defined_balance_id;
1596:
1597: l_trivial_a := 100 * NVL(pay_balance_pkg.get_value(l_trivial_a_id,l_last_asg_action_id),0);
1598:
1599: l_trivial_b := 100 * NVL(pay_balance_pkg.get_value(l_trivial_b_id,l_last_asg_action_id),0);
1600:
1601: l_trivial_c := 100 * NVL(pay_balance_pkg.get_value(l_trivial_c_id,l_last_asg_action_id),0);

Line 1599: l_trivial_b := 100 * NVL(pay_balance_pkg.get_value(l_trivial_b_id,l_last_asg_action_id),0);

1595: CLOSE get_defined_balance_id;
1596:
1597: l_trivial_a := 100 * NVL(pay_balance_pkg.get_value(l_trivial_a_id,l_last_asg_action_id),0);
1598:
1599: l_trivial_b := 100 * NVL(pay_balance_pkg.get_value(l_trivial_b_id,l_last_asg_action_id),0);
1600:
1601: l_trivial_c := 100 * NVL(pay_balance_pkg.get_value(l_trivial_c_id,l_last_asg_action_id),0);
1602:
1603: p_fps_rec3.assignment_id := p_asg_id;

Line 1601: l_trivial_c := 100 * NVL(pay_balance_pkg.get_value(l_trivial_c_id,l_last_asg_action_id),0);

1597: l_trivial_a := 100 * NVL(pay_balance_pkg.get_value(l_trivial_a_id,l_last_asg_action_id),0);
1598:
1599: l_trivial_b := 100 * NVL(pay_balance_pkg.get_value(l_trivial_b_id,l_last_asg_action_id),0);
1600:
1601: l_trivial_c := 100 * NVL(pay_balance_pkg.get_value(l_trivial_c_id,l_last_asg_action_id),0);
1602:
1603: p_fps_rec3.assignment_id := p_asg_id;
1604: p_fps_rec3.action_info_category := 'GB_RTI_FPS_ASG_DET3';
1605:

Line 4331: l_ni_contrib := NVL(pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id, p_assignment_action_id => f_asg_act_id ),0);

4327: FETCH get_def_bal_id_ni_total_emplyr INTO l_def_bal_id1;
4328: CLOSE get_def_bal_id_ni_total_emplyr;
4329: hr_utility.trace('l_def_bal_id : '|| TO_CHAR(l_def_bal_id));
4330: hr_utility.trace('l_def_bal_id1 : '|| TO_CHAR(l_def_bal_id1));
4331: l_ni_contrib := NVL(pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id, p_assignment_action_id => f_asg_act_id ),0);
4332: l_ni_contrib := l_ni_contrib - NVL(pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id1, p_assignment_action_id => f_asg_act_id ),0);
4333: END IF;
4334: hr_utility.trace('Leaving get_ni_contrib');
4335: END IF;

Line 4332: l_ni_contrib := l_ni_contrib - NVL(pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id1, p_assignment_action_id => f_asg_act_id ),0);

4328: CLOSE get_def_bal_id_ni_total_emplyr;
4329: hr_utility.trace('l_def_bal_id : '|| TO_CHAR(l_def_bal_id));
4330: hr_utility.trace('l_def_bal_id1 : '|| TO_CHAR(l_def_bal_id1));
4331: l_ni_contrib := NVL(pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id, p_assignment_action_id => f_asg_act_id ),0);
4332: l_ni_contrib := l_ni_contrib - NVL(pay_balance_pkg.get_value(p_defined_balance_id => l_def_bal_id1, p_assignment_action_id => f_asg_act_id ),0);
4333: END IF;
4334: hr_utility.trace('Leaving get_ni_contrib');
4335: END IF;
4336:

Line 4538: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval

4534: p_fps_bal_context_2 OUT nocopy act_info_rec )
4535: RETURN BOOLEAN
4536: IS
4537:
4538: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
4539: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
4540: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_first_fps_asg_det2';
4541: l_asg_primary_flag VARCHAR2(1);
4542: l_per_agg_flag VARCHAR2(1);

Line 4539: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval

4535: RETURN BOOLEAN
4536: IS
4537:
4538: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
4539: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
4540: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_first_fps_asg_det2';
4541: l_asg_primary_flag VARCHAR2(1);
4542: l_per_agg_flag VARCHAR2(1);
4543: l_aggr_archive_flag VARCHAR2(1);

Line 4682: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_id ,

4678: --p_fps_bal_context_2.act_info27 := l_tax_basis;
4679:
4680: -- added by kvinayku end
4681:
4682: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_id ,
4683: p_defined_balance_lst => g_defined_balance_lst ,
4684: p_context_lst => l_context_lst ,
4685: p_output_table => l_output_table );
4686: hr_utility.trace('After invoking get_value');

Line 4811: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval

4807: p_fps_bal_context_2 OUT nocopy act_info_rec )
4808: RETURN BOOLEAN
4809: IS
4810:
4811: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
4812: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
4813: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_first_fps_agg_asg_det2';
4814: l_asg_primary_flag VARCHAR2(1);
4815: l_per_agg_flag VARCHAR2(1);

Line 4812: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval

4808: RETURN BOOLEAN
4809: IS
4810:
4811: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
4812: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
4813: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_first_fps_agg_asg_det2';
4814: l_asg_primary_flag VARCHAR2(1);
4815: l_per_agg_flag VARCHAR2(1);
4816: l_aggr_archive_flag VARCHAR2(1);

Line 4933: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_id ,

4929:
4930: --Tax code fix end
4931: hr_utility.trace('Tax Code '||p_fps_bal_context_2.act_info25||' Tax Basis '||p_fps_bal_context_2.act_info27);
4932:
4933: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_id ,
4934: p_defined_balance_lst => g_defined_balance_lst ,
4935: p_context_lst => l_context_lst ,
4936: p_output_table => l_output_table );
4937: hr_utility.trace('After invoking get_value');

Line 5057: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval

5053: p_asg_id IN NUMBER,
5054: p_fps_bal_context_2 IN OUT nocopy act_info_rec )
5055: RETURN BOOLEAN
5056: IS
5057: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
5058: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
5059: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_fps_asg_det2';
5060: l_asg_primary_flag VARCHAR2(1);
5061: l_per_agg_flag VARCHAR2(1);

Line 5058: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval

5054: p_fps_bal_context_2 IN OUT nocopy act_info_rec )
5055: RETURN BOOLEAN
5056: IS
5057: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
5058: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
5059: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_fps_asg_det2';
5060: l_asg_primary_flag VARCHAR2(1);
5061: l_per_agg_flag VARCHAR2(1);
5062: l_aggr_archive_flag VARCHAR2(1);

Line 5228: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_id ,

5224: if l_child_exists = 'N' then
5225: --We need to get balances with master asg action id
5226: hr_utility.trace('Processing with Master Action ID:'||p_last_asg_action_id);
5227:
5228: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_id ,
5229: p_defined_balance_lst => g_defined_balance_lst ,
5230: p_context_lst => l_context_lst ,
5231: p_output_table => l_output_table );
5232:

Line 5419: pay_balance_pkg.get_value(p_assignment_action_id => l_chld_act_id ,

5415: LOOP
5416: --Loop for getting the balances for all child asg action id's
5417: l_chld_act_id := rec.assignment_action_id;
5418: hr_utility.trace('l_chld_act_id:'||l_chld_act_id);
5419: pay_balance_pkg.get_value(p_assignment_action_id => l_chld_act_id ,
5420: p_defined_balance_lst => g_defined_balance_lst ,
5421: p_context_lst => l_context_lst ,
5422: p_output_table => l_output_table );
5423:

Line 5739: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval

5735: p_asg_id IN NUMBER,
5736: p_fps_bal_context_2 IN OUT nocopy act_info_rec )
5737: RETURN BOOLEAN
5738: IS
5739: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
5740: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
5741: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_fps_agg_asg_det2';
5742: l_asg_primary_flag VARCHAR2(1);
5743: l_per_agg_flag VARCHAR2(1);

Line 5740: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval

5736: p_fps_bal_context_2 IN OUT nocopy act_info_rec )
5737: RETURN BOOLEAN
5738: IS
5739: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
5740: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
5741: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_fps_agg_asg_det2';
5742: l_asg_primary_flag VARCHAR2(1);
5743: l_per_agg_flag VARCHAR2(1);
5744: l_aggr_archive_flag VARCHAR2(1);

Line 5901: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_id ,

5897: if l_child_exists = 'N' then
5898: --We need to get balances with master asg action id
5899: hr_utility.trace('Processing with Master Action ID:'||p_last_asg_action_id);
5900: --
5901: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_id ,
5902: p_defined_balance_lst => g_aggr_defined_balance_lst ,
5903: p_context_lst => l_context_lst ,
5904: p_output_table => l_output_table );
5905:

Line 6098: pay_balance_pkg.get_value(p_assignment_action_id => l_chld_act_id,

6094: --Loop for getting the balances for all child asg action id's
6095: l_chld_act_id := rec.assignment_action_id;
6096: hr_utility.trace('l_chld_act_id:'||l_chld_act_id);
6097:
6098: pay_balance_pkg.get_value(p_assignment_action_id => l_chld_act_id,
6099: p_defined_balance_lst => g_aggr_defined_balance_lst ,
6100: p_context_lst => l_context_lst ,
6101: p_output_table => l_output_table );
6102:

Line 7534: l_gross := pay_balance_pkg.get_value(l_gross_id,l_last_asg_action_id);

7530: CLOSE csr_last_action;
7531:
7532: -- Fetching balances
7533: IF l_last_asg_action_id IS NOT NULL THEN
7534: l_gross := pay_balance_pkg.get_value(l_gross_id,l_last_asg_action_id);
7535: IF l_gross <= 0 THEN
7536: l_taxable := pay_balance_pkg.get_value(l_taxable_id,l_last_asg_action_id);
7537: END IF;
7538:

Line 7536: l_taxable := pay_balance_pkg.get_value(l_taxable_id,l_last_asg_action_id);

7532: -- Fetching balances
7533: IF l_last_asg_action_id IS NOT NULL THEN
7534: l_gross := pay_balance_pkg.get_value(l_gross_id,l_last_asg_action_id);
7535: IF l_gross <= 0 THEN
7536: l_taxable := pay_balance_pkg.get_value(l_taxable_id,l_last_asg_action_id);
7537: END IF;
7538:
7539: IF l_taxable <= 0 THEN
7540: l_niable := pay_balance_pkg.get_value(l_niable_id,l_last_asg_action_id);

Line 7540: l_niable := pay_balance_pkg.get_value(l_niable_id,l_last_asg_action_id);

7536: l_taxable := pay_balance_pkg.get_value(l_taxable_id,l_last_asg_action_id);
7537: END IF;
7538:
7539: IF l_taxable <= 0 THEN
7540: l_niable := pay_balance_pkg.get_value(l_niable_id,l_last_asg_action_id);
7541: end if;
7542: END IF;
7543:
7544: IF l_gross > 0 or l_taxable > 0 or l_niable > 0 THEN

Line 10013: l_gross := pay_balance_pkg.get_value(l_gross_id,l_last_asg_action_id);

10009: hr_utility.trace('l_last_effective_date: '|| l_last_effective_date);
10010:
10011: -- Fetching balances
10012: IF l_last_asg_action_id IS NOT NULL THEN
10013: l_gross := pay_balance_pkg.get_value(l_gross_id,l_last_asg_action_id);
10014: IF l_gross <= 0 THEN
10015: l_taxable := pay_balance_pkg.get_value(l_taxable_id,l_last_asg_action_id);
10016: END IF;
10017:

Line 10015: l_taxable := pay_balance_pkg.get_value(l_taxable_id,l_last_asg_action_id);

10011: -- Fetching balances
10012: IF l_last_asg_action_id IS NOT NULL THEN
10013: l_gross := pay_balance_pkg.get_value(l_gross_id,l_last_asg_action_id);
10014: IF l_gross <= 0 THEN
10015: l_taxable := pay_balance_pkg.get_value(l_taxable_id,l_last_asg_action_id);
10016: END IF;
10017:
10018: IF l_taxable <= 0 THEN
10019: l_niable := pay_balance_pkg.get_value(l_niable_id,l_last_asg_action_id);

Line 10019: l_niable := pay_balance_pkg.get_value(l_niable_id,l_last_asg_action_id);

10015: l_taxable := pay_balance_pkg.get_value(l_taxable_id,l_last_asg_action_id);
10016: END IF;
10017:
10018: IF l_taxable <= 0 THEN
10019: l_niable := pay_balance_pkg.get_value(l_niable_id,l_last_asg_action_id);
10020: end if;
10021: END IF;
10022:
10023: IF l_gross > 0 or l_taxable > 0 or l_niable > 0 THEN

Line 13661: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);

13657:
13658: --Footer Validations
13659: pay_gb_rti_fps_validate_13.footer_validations(l_payroll_rec.econ_number,l_final_submission,l_flag);
13660:
13661: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);
13662: hr_utility.set_location('l_payroll_rec.bus_grp_id = ' || l_payroll_rec.bus_grp_id,10);
13663: hr_utility.set_location('l_payroll_rec.act_param_grp_id = ' || l_payroll_rec.act_param_grp_id,20);
13664: hr_utility.set_location('l_sender_id = '||l_payroll_rec.sender_id,30);
13665: hr_utility.set_location('l_test_indicator = '||l_payroll_rec.test_indicator,40);