APPS.PAY_GB_ONLINE_SOE dependencies on PAY_GB_PAYROLL_ACTIONS_PKG

Line 83: l_ni_a_total_value := pay_gb_payroll_actions_pkg.report_balance_items

79: l_tax_district_ytd := '_ASG_TD_YTD';
80:
81:
82: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'A') = 1 THEN
83: l_ni_a_total_value := pay_gb_payroll_actions_pkg.report_balance_items
84: (p_balance_name => 'NI A Total',
85: p_dimension => l_tax_district_ytd,
86: p_assignment_action_id => p_assignment_action_id);
87: end if;

Line 89: l_ni_b_total_value := pay_gb_payroll_actions_pkg.report_balance_items

85: p_dimension => l_tax_district_ytd,
86: p_assignment_action_id => p_assignment_action_id);
87: end if;
88: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'B') = 1 THEN
89: l_ni_b_total_value := pay_gb_payroll_actions_pkg.report_balance_items
90: (p_balance_name => 'NI B Total',
91: p_dimension => l_tax_district_ytd,
92: p_assignment_action_id => p_assignment_action_id);
93: end if;

Line 95: l_ni_d_total_value := pay_gb_payroll_actions_pkg.report_balance_items

91: p_dimension => l_tax_district_ytd,
92: p_assignment_action_id => p_assignment_action_id);
93: end if;
94: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'D') = 1 THEN
95: l_ni_d_total_value := pay_gb_payroll_actions_pkg.report_balance_items
96: (p_balance_name => 'NI D Total',
97: p_dimension => l_tax_district_ytd,
98: p_assignment_action_id => p_assignment_action_id);
99: end if;

Line 101: l_ni_e_total_value := pay_gb_payroll_actions_pkg.report_balance_items

97: p_dimension => l_tax_district_ytd,
98: p_assignment_action_id => p_assignment_action_id);
99: end if;
100: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'E') = 1 THEN
101: l_ni_e_total_value := pay_gb_payroll_actions_pkg.report_balance_items
102: (p_balance_name => 'NI E Total',
103: p_dimension => l_tax_district_ytd,
104: p_assignment_action_id => p_assignment_action_id);
105: end if;

Line 107: l_ni_f_total_value := pay_gb_payroll_actions_pkg.report_balance_items

103: p_dimension => l_tax_district_ytd,
104: p_assignment_action_id => p_assignment_action_id);
105: end if;
106: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'F') = 1 THEN
107: l_ni_f_total_value := pay_gb_payroll_actions_pkg.report_balance_items
108: (p_balance_name => 'NI F Total',
109: p_dimension => l_tax_district_ytd,
110: p_assignment_action_id => p_assignment_action_id);
111: end if;

Line 113: l_ni_g_total_value := pay_gb_payroll_actions_pkg.report_balance_items

109: p_dimension => l_tax_district_ytd,
110: p_assignment_action_id => p_assignment_action_id);
111: end if;
112: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'G') = 1 THEN
113: l_ni_g_total_value := pay_gb_payroll_actions_pkg.report_balance_items
114: (p_balance_name => 'NI G Total',
115: p_dimension => l_tax_district_ytd,
116: p_assignment_action_id => p_assignment_action_id);
117: end if;

Line 119: l_ni_l_total_value := pay_gb_payroll_actions_pkg.report_balance_items

115: p_dimension => l_tax_district_ytd,
116: p_assignment_action_id => p_assignment_action_id);
117: end if;
118: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'L') = 1 THEN
119: l_ni_l_total_value := pay_gb_payroll_actions_pkg.report_balance_items
120: (p_balance_name => 'NI L Total',
121: p_dimension => l_tax_district_ytd,
122: p_assignment_action_id => p_assignment_action_id);
123: end if;

Line 125: l_ni_j_total_value := pay_gb_payroll_actions_pkg.report_balance_items

121: p_dimension => l_tax_district_ytd,
122: p_assignment_action_id => p_assignment_action_id);
123: end if;
124: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'J') = 1 THEN
125: l_ni_j_total_value := pay_gb_payroll_actions_pkg.report_balance_items
126: (p_balance_name => 'NI J Total',
127: p_dimension => l_tax_district_ytd,
128: p_assignment_action_id => p_assignment_action_id);
129: end if;

Line 131: l_ni_s_total_value := pay_gb_payroll_actions_pkg.report_balance_items

127: p_dimension => l_tax_district_ytd,
128: p_assignment_action_id => p_assignment_action_id);
129: end if;
130: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'S') = 1 THEN
131: l_ni_s_total_value := pay_gb_payroll_actions_pkg.report_balance_items
132: (p_balance_name => 'NI S Total',
133: p_dimension => l_tax_district_ytd,
134: p_assignment_action_id => p_assignment_action_id);
135: end if;

Line 141: l_temp_balance := pay_gb_payroll_actions_pkg.report_all_ni_balance

137: l_employer_balance := l_ni_a_total_value + l_ni_b_total_value + l_ni_d_total_value
138: + l_ni_e_total_value + l_ni_f_total_value + l_ni_g_total_value
139: + l_ni_j_total_value + l_ni_l_total_value + l_ni_s_total_value;
140:
141: l_temp_balance := pay_gb_payroll_actions_pkg.report_all_ni_balance
142: (p_balance_name => 'NI Employee',
143: p_dimension => l_tax_district_ytd,
144: p_assignment_action_id => p_assignment_action_id);
145:

Line 148: l_temp_balance := pay_gb_payroll_actions_pkg.report_balance_items

144: p_assignment_action_id => p_assignment_action_id);
145:
146: l_employer_balance := l_employer_balance - l_temp_balance;
147:
148: l_temp_balance := pay_gb_payroll_actions_pkg.report_balance_items
149: (p_balance_name => 'NI C Employer',
150: p_dimension => l_tax_district_ytd,
151: p_assignment_action_id => p_assignment_action_id);
152:

Line 158: l_temp_balance := pay_gb_payroll_actions_pkg.report_balance_items

154:
155: /* 9539764 Begin
156: NI S Employer value is already included in NI S Total.
157: So the below code is not needed.
158: l_temp_balance := pay_gb_payroll_actions_pkg.report_balance_items
159: (p_balance_name => 'NI S Employer',
160: p_dimension => l_tax_district_ytd,
161: p_assignment_action_id => p_assignment_action_id);
162:

Line 427: l_calculated_balance := pay_gb_payroll_actions_pkg.report_all_ni_balance('NI Able',p_assignment_action_id,'_ASG_TD_YTD');

423: end loop;
424: end if;
425:
426: l_display := FALSE;
427: l_calculated_balance := pay_gb_payroll_actions_pkg.report_all_ni_balance('NI Able',p_assignment_action_id,'_ASG_TD_YTD');
428: hr_utility.trace('NI Able : ' || l_calculated_balance);
429: if l_calculated_balance <> 0 then
430: l_display := TRUE;
431: pay_soe_util.setValue('01',null,TRUE,FALSE);

Line 440: l_calculated_balance := pay_gb_payroll_actions_pkg.report_all_ni_balance('NI Able',p_assignment_action_id,'_ASG_TRANSFER_PTD');

436: fnd_currency.get_format_mask(substr(PAY_SOE_GLB.g_currency_code,2,3),40)),FALSE,FALSE);
437: pay_soe_util.setValue('06',null,FALSE,TRUE);
438: end if;
439:
440: l_calculated_balance := pay_gb_payroll_actions_pkg.report_all_ni_balance('NI Able',p_assignment_action_id,'_ASG_TRANSFER_PTD');
441: hr_utility.trace('NI Able PTD : ' || l_calculated_balance);
442: if l_calculated_balance <> 0 then
443: l_display := TRUE;
444: pay_soe_util.setValue('01',null,TRUE,FALSE);

Line 453: l_calculated_balance := pay_gb_payroll_actions_pkg.report_all_ni_balance('NI Employee',p_assignment_action_id,'_ASG_TD_YTD');

449: fnd_currency.get_format_mask(substr(PAY_SOE_GLB.g_currency_code,2,3),40)),FALSE,FALSE);
450: pay_soe_util.setValue('06',null,FALSE,TRUE);
451: end if;
452:
453: l_calculated_balance := pay_gb_payroll_actions_pkg.report_all_ni_balance('NI Employee',p_assignment_action_id,'_ASG_TD_YTD');
454: hr_utility.trace('NI Employee : ' || l_calculated_balance);
455: if l_calculated_balance <> 0 then
456: l_display := TRUE;
457: pay_soe_util.setValue('01',null,TRUE,FALSE);

Line 568: pay_gb_payroll_actions_pkg.get_database_items

564: close getTaxPhone;
565:
566: l_asg_act_id := checkPrepayment(p_assignment_action_id);
567:
568: pay_gb_payroll_actions_pkg.get_database_items
569: (p_assignment_id => res.assignment_id,
570: p_run_assignment_action_id => l_asg_act_id,
571: p_date_earned => to_char(res.date_earned,'YYYY/MM/DD'),
572: p_payroll_action_id => res.payroll_action_id,