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

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

220: g_ni_pt_eid NUMBER:=0;
221: g_ni_pt_ivid NUMBER:=0;
222: g_fps_bal_det_tab t_fps_bal_det_tab;
223: g_fps_aggr_bal_det_tab t_fps_bal_det_tab;
224: g_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of normal balances
225: g_aggr_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of aggregation balances
226: g_aggr_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni aggregation balances
227: --
228: g_tax_ref VARCHAR2(20);

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

221: g_ni_pt_ivid NUMBER:=0;
222: g_fps_bal_det_tab t_fps_bal_det_tab;
223: g_fps_aggr_bal_det_tab t_fps_bal_det_tab;
224: g_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of normal balances
225: g_aggr_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of aggregation balances
226: g_aggr_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni aggregation balances
227: --
228: g_tax_ref VARCHAR2(20);
229: --

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

222: g_fps_bal_det_tab t_fps_bal_det_tab;
223: g_fps_aggr_bal_det_tab t_fps_bal_det_tab;
224: g_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of normal balances
225: g_aggr_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of aggregation balances
226: g_aggr_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni aggregation balances
227: --
228: g_tax_ref VARCHAR2(20);
229: --
230: g_paye_eid NUMBER :=0 ;

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

3958: p_fps_bal_context_2 OUT nocopy act_info_rec )
3959: RETURN BOOLEAN
3960: IS
3961:
3962: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
3963: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
3964: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_first_fps_asg_det2';
3965: l_asg_primary_flag VARCHAR2(1);
3966: l_per_agg_flag VARCHAR2(1);

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

3959: RETURN BOOLEAN
3960: IS
3961:
3962: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
3963: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
3964: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_first_fps_asg_det2';
3965: l_asg_primary_flag VARCHAR2(1);
3966: l_per_agg_flag VARCHAR2(1);
3967: l_aggr_archive_flag VARCHAR2(1);

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

4102: --p_fps_bal_context_2.act_info27 := l_tax_basis;
4103:
4104: -- added by kvinayku end
4105:
4106: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_id ,
4107: p_defined_balance_lst => g_defined_balance_lst ,
4108: p_context_lst => l_context_lst ,
4109: p_output_table => l_output_table );
4110: hr_utility.trace('After invoking get_value');

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

4220: p_fps_bal_context_2 OUT nocopy act_info_rec )
4221: RETURN BOOLEAN
4222: IS
4223:
4224: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
4225: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
4226: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_first_fps_agg_asg_det2';
4227: l_asg_primary_flag VARCHAR2(1);
4228: l_per_agg_flag VARCHAR2(1);

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

4221: RETURN BOOLEAN
4222: IS
4223:
4224: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
4225: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
4226: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_first_fps_agg_asg_det2';
4227: l_asg_primary_flag VARCHAR2(1);
4228: l_per_agg_flag VARCHAR2(1);
4229: l_aggr_archive_flag VARCHAR2(1);

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

4342: --Tax code fix end
4343:
4344: hr_utility.trace('Tax Code '||p_fps_bal_context_2.act_info25||' Tax Basis '||p_fps_bal_context_2.act_info27);
4345:
4346: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_id ,
4347: p_defined_balance_lst => g_defined_balance_lst ,
4348: p_context_lst => l_context_lst ,
4349: p_output_table => l_output_table );
4350: hr_utility.trace('After invoking get_value');

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

4455: p_asg_id IN NUMBER,
4456: p_fps_bal_context_2 IN OUT nocopy act_info_rec )
4457: RETURN BOOLEAN
4458: IS
4459: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
4460: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
4461: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_fps_asg_det2';
4462: l_asg_primary_flag VARCHAR2(1);
4463: l_per_agg_flag VARCHAR2(1);

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

4456: p_fps_bal_context_2 IN OUT nocopy act_info_rec )
4457: RETURN BOOLEAN
4458: IS
4459: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
4460: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
4461: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_fps_asg_det2';
4462: l_asg_primary_flag VARCHAR2(1);
4463: l_per_agg_flag VARCHAR2(1);
4464: l_aggr_archive_flag VARCHAR2(1);

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

4626: if l_child_exists = 'N' then
4627: --We need to get balances with master asg action id
4628: hr_utility.trace('Processing with Master Action ID:'||p_last_asg_action_id);
4629:
4630: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_id ,
4631: p_defined_balance_lst => g_defined_balance_lst ,
4632: p_context_lst => l_context_lst ,
4633: p_output_table => l_output_table );
4634:

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

4809: LOOP
4810: --Loop for getting the balances for all child asg action id's
4811: l_chld_act_id := rec.assignment_action_id;
4812: hr_utility.trace('l_chld_act_id:'||l_chld_act_id);
4813: pay_balance_pkg.get_value(p_assignment_action_id => l_chld_act_id ,
4814: p_defined_balance_lst => g_defined_balance_lst ,
4815: p_context_lst => l_context_lst ,
4816: p_output_table => l_output_table );
4817:

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

5121: p_asg_id IN NUMBER,
5122: p_fps_bal_context_2 IN OUT nocopy act_info_rec )
5123: RETURN BOOLEAN
5124: IS
5125: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
5126: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
5127: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_fps_agg_asg_det2';
5128: l_asg_primary_flag VARCHAR2(1);
5129: l_per_agg_flag VARCHAR2(1);

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

5122: p_fps_bal_context_2 IN OUT nocopy act_info_rec )
5123: RETURN BOOLEAN
5124: IS
5125: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
5126: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
5127: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_fps_agg_asg_det2';
5128: l_asg_primary_flag VARCHAR2(1);
5129: l_per_agg_flag VARCHAR2(1);
5130: l_aggr_archive_flag VARCHAR2(1);

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

5283: if l_child_exists = 'N' then
5284: --We need to get balances with master asg action id
5285: hr_utility.trace('Processing with Master Action ID:'||p_last_asg_action_id);
5286: --
5287: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_id ,
5288: p_defined_balance_lst => g_aggr_defined_balance_lst ,
5289: p_context_lst => l_context_lst ,
5290: p_output_table => l_output_table );
5291:

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

5472: --Loop for getting the balances for all child asg action id's
5473: l_chld_act_id := rec.assignment_action_id;
5474: hr_utility.trace('l_chld_act_id:'||l_chld_act_id);
5475:
5476: pay_balance_pkg.get_value(p_assignment_action_id => l_chld_act_id,
5477: p_defined_balance_lst => g_aggr_defined_balance_lst ,
5478: p_context_lst => l_context_lst ,
5479: p_output_table => l_output_table );
5480:

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

6863: CLOSE csr_last_action;
6864:
6865: -- Fetching balances
6866: IF l_last_asg_action_id IS NOT NULL THEN
6867: l_gross := pay_balance_pkg.get_value(l_gross_id,l_last_asg_action_id);
6868: IF l_gross <= 0 THEN
6869: l_taxable := pay_balance_pkg.get_value(l_taxable_id,l_last_asg_action_id);
6870: END IF;
6871:

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

6865: -- Fetching balances
6866: IF l_last_asg_action_id IS NOT NULL THEN
6867: l_gross := pay_balance_pkg.get_value(l_gross_id,l_last_asg_action_id);
6868: IF l_gross <= 0 THEN
6869: l_taxable := pay_balance_pkg.get_value(l_taxable_id,l_last_asg_action_id);
6870: END IF;
6871:
6872: IF l_taxable <= 0 THEN
6873: l_niable := pay_balance_pkg.get_value(l_niable_id,l_last_asg_action_id);

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

6869: l_taxable := pay_balance_pkg.get_value(l_taxable_id,l_last_asg_action_id);
6870: END IF;
6871:
6872: IF l_taxable <= 0 THEN
6873: l_niable := pay_balance_pkg.get_value(l_niable_id,l_last_asg_action_id);
6874: end if;
6875: END IF;
6876:
6877: IF l_gross > 0 or l_taxable > 0 or l_niable > 0 THEN

Line 6918: l_gross := pay_balance_pkg.get_value(l_gross_id,asg_rec.asg_act_id);

6914: OPEN get_defined_balance_id('NIable Pay','_ASG_TD_YTD');
6915: FETCH get_defined_balance_id INTO l_niable_id;
6916: CLOSE get_defined_balance_id;
6917:
6918: l_gross := pay_balance_pkg.get_value(l_gross_id,asg_rec.asg_act_id);
6919: IF l_gross <= 0 THEN
6920: l_taxable := pay_balance_pkg.get_value(l_taxable_id,asg_rec.asg_act_id);
6921: END IF;
6922: IF l_taxable <= 0 THEN

Line 6920: l_taxable := pay_balance_pkg.get_value(l_taxable_id,asg_rec.asg_act_id);

6916: CLOSE get_defined_balance_id;
6917:
6918: l_gross := pay_balance_pkg.get_value(l_gross_id,asg_rec.asg_act_id);
6919: IF l_gross <= 0 THEN
6920: l_taxable := pay_balance_pkg.get_value(l_taxable_id,asg_rec.asg_act_id);
6921: END IF;
6922: IF l_taxable <= 0 THEN
6923: l_niable := pay_balance_pkg.get_value(l_niable_id,asg_rec.asg_act_id);
6924: END IF;

Line 6923: l_niable := pay_balance_pkg.get_value(l_niable_id,asg_rec.asg_act_id);

6919: IF l_gross <= 0 THEN
6920: l_taxable := pay_balance_pkg.get_value(l_taxable_id,asg_rec.asg_act_id);
6921: END IF;
6922: IF l_taxable <= 0 THEN
6923: l_niable := pay_balance_pkg.get_value(l_niable_id,asg_rec.asg_act_id);
6924: END IF;
6925: END IF;
6926:
6927: IF l_gross > 0 or l_taxable > 0 or l_niable > 0 THEN

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

9362: hr_utility.trace('l_last_effective_date: '|| l_last_effective_date);
9363:
9364: -- Fetching balances
9365: IF l_last_asg_action_id IS NOT NULL THEN
9366: l_gross := pay_balance_pkg.get_value(l_gross_id,l_last_asg_action_id);
9367: IF l_gross <= 0 THEN
9368: l_taxable := pay_balance_pkg.get_value(l_taxable_id,l_last_asg_action_id);
9369: END IF;
9370:

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

9364: -- Fetching balances
9365: IF l_last_asg_action_id IS NOT NULL THEN
9366: l_gross := pay_balance_pkg.get_value(l_gross_id,l_last_asg_action_id);
9367: IF l_gross <= 0 THEN
9368: l_taxable := pay_balance_pkg.get_value(l_taxable_id,l_last_asg_action_id);
9369: END IF;
9370:
9371: IF l_taxable <= 0 THEN
9372: l_niable := pay_balance_pkg.get_value(l_niable_id,l_last_asg_action_id);

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

9368: l_taxable := pay_balance_pkg.get_value(l_taxable_id,l_last_asg_action_id);
9369: END IF;
9370:
9371: IF l_taxable <= 0 THEN
9372: l_niable := pay_balance_pkg.get_value(l_niable_id,l_last_asg_action_id);
9373: end if;
9374: END IF;
9375:
9376: IF l_gross > 0 or l_taxable > 0 or l_niable > 0 THEN

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

12898:
12899: --Footer Validations
12900: pay_gb_rti_fps_validate.footer_validations(l_payroll_rec.econ_number,l_final_submission,l_flag);
12901:
12902: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);
12903: hr_utility.set_location('l_payroll_rec.bus_grp_id = ' || l_payroll_rec.bus_grp_id,10);
12904: hr_utility.set_location('l_payroll_rec.act_param_grp_id = ' || l_payroll_rec.act_param_grp_id,20);
12905: hr_utility.set_location('l_sender_id = '||l_payroll_rec.sender_id,30);
12906: hr_utility.set_location('l_test_indicator = '||l_payroll_rec.test_indicator,40);