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_KR_SEP_PKG dependencies on PAY_KR_REPORT_PKG

Line 47: g_legislation_code := pay_kr_report_pkg.legislation_code(p_business_group_id);

43: begin
44: --
45: if g_business_group_id is null or p_business_group_id <> g_business_group_id then
46: g_business_group_id := p_business_group_id;
47: g_legislation_code := pay_kr_report_pkg.legislation_code(p_business_group_id);
48: end if;
49: --
50: if p_balance_type_id is null then
51: open csr_balance;

Line 75: g_legislation_code := pay_kr_report_pkg.legislation_code(p_business_group_id);

71: begin
72: --
73: if g_business_group_id is null or p_business_group_id <> g_business_group_id then
74: g_business_group_id := p_business_group_id;
75: g_legislation_code := pay_kr_report_pkg.legislation_code(p_business_group_id);
76: end if;
77: --
78: if p_user_entity_id is null then
79: open csr_user_entity;

Line 112: -- l_itax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_bal_id);

108: -- get_balance_type_id('RTAX_WO_ADJ',p_business_group_id,g_rtax_wo_adj_bal_id);
109: -- get_balance_type_id('STAX',p_business_group_id,g_stax_bal_id);
110: -- get_balance_type_id('STAX_WO_ADJ',p_business_group_id,g_stax_wo_adj_bal_id);
111: ----
112: -- l_itax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_bal_id);
113: -- l_itax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_wo_adj_bal_id);
114: -- l_rtax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_bal_id);
115: -- l_rtax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_wo_adj_bal_id);
116: -- l_stax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_bal_id);

Line 113: -- l_itax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_wo_adj_bal_id);

109: -- get_balance_type_id('STAX',p_business_group_id,g_stax_bal_id);
110: -- get_balance_type_id('STAX_WO_ADJ',p_business_group_id,g_stax_wo_adj_bal_id);
111: ----
112: -- l_itax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_bal_id);
113: -- l_itax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_wo_adj_bal_id);
114: -- l_rtax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_bal_id);
115: -- l_rtax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_wo_adj_bal_id);
116: -- l_stax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_bal_id);
117: -- l_stax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_wo_adj_bal_id);

Line 114: -- l_rtax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_bal_id);

110: -- get_balance_type_id('STAX_WO_ADJ',p_business_group_id,g_stax_wo_adj_bal_id);
111: ----
112: -- l_itax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_bal_id);
113: -- l_itax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_wo_adj_bal_id);
114: -- l_rtax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_bal_id);
115: -- l_rtax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_wo_adj_bal_id);
116: -- l_stax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_bal_id);
117: -- l_stax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_wo_adj_bal_id);
118: ----

Line 115: -- l_rtax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_wo_adj_bal_id);

111: ----
112: -- l_itax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_bal_id);
113: -- l_itax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_wo_adj_bal_id);
114: -- l_rtax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_bal_id);
115: -- l_rtax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_wo_adj_bal_id);
116: -- l_stax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_bal_id);
117: -- l_stax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_wo_adj_bal_id);
118: ----
119: -- p_itax_adj := l_itax - l_itax_wo_adj;

Line 116: -- l_stax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_bal_id);

112: -- l_itax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_bal_id);
113: -- l_itax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_wo_adj_bal_id);
114: -- l_rtax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_bal_id);
115: -- l_rtax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_wo_adj_bal_id);
116: -- l_stax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_bal_id);
117: -- l_stax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_wo_adj_bal_id);
118: ----
119: -- p_itax_adj := l_itax - l_itax_wo_adj;
120: -- p_rtax_adj := l_rtax - l_rtax_wo_adj;

Line 117: -- l_stax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_wo_adj_bal_id);

113: -- l_itax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_wo_adj_bal_id);
114: -- l_rtax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_bal_id);
115: -- l_rtax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_wo_adj_bal_id);
116: -- l_stax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_bal_id);
117: -- l_stax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_wo_adj_bal_id);
118: ----
119: -- p_itax_adj := l_itax - l_itax_wo_adj;
120: -- p_rtax_adj := l_rtax - l_rtax_wo_adj;
121: -- p_stax_adj := l_stax - l_stax_wo_adj;

Line 128: p_itax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_itax_ue_id));

124: get_user_entity_id('X_YEA_ITAX_ADJ',p_business_group_id,g_itax_ue_id);
125: get_user_entity_id('X_YEA_RTAX_ADJ',p_business_group_id,g_rtax_ue_id);
126: get_user_entity_id('X_YEA_STAX_ADJ',p_business_group_id,g_stax_ue_id);
127: --
128: p_itax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_itax_ue_id));
129: p_rtax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_rtax_ue_id));
130: p_stax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_stax_ue_id));
131: --
132: return l_dummy;

Line 129: p_rtax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_rtax_ue_id));

125: get_user_entity_id('X_YEA_RTAX_ADJ',p_business_group_id,g_rtax_ue_id);
126: get_user_entity_id('X_YEA_STAX_ADJ',p_business_group_id,g_stax_ue_id);
127: --
128: p_itax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_itax_ue_id));
129: p_rtax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_rtax_ue_id));
130: p_stax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_stax_ue_id));
131: --
132: return l_dummy;
133: --

Line 130: p_stax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_stax_ue_id));

126: get_user_entity_id('X_YEA_STAX_ADJ',p_business_group_id,g_stax_ue_id);
127: --
128: p_itax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_itax_ue_id));
129: p_rtax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_rtax_ue_id));
130: p_stax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_stax_ue_id));
131: --
132: return l_dummy;
133: --
134: end get_iyea_tax_adj;

Line 158: -- l_hi_prem_ee := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_ee_bal_id);

154: -- get_balance_type_id('HI_PREM_EE_WO_ADJ',p_business_group_id,g_hi_prem_ee_wo_adj_bal_id);
155: -- get_balance_type_id('HI_PREM_ER',p_business_group_id,g_hi_prem_er_bal_id);
156: -- get_balance_type_id('HI_PREM_ER_WO_ADJ',p_business_group_id,g_hi_prem_er_wo_adj_bal_id);
157: ----
158: -- l_hi_prem_ee := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_ee_bal_id);
159: -- l_hi_prem_ee_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_ee_wo_adj_bal_id);
160: -- l_hi_prem_er := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_er_bal_id);
161: -- l_hi_prem_er_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_er_wo_adj_bal_id);
162: ----

Line 159: -- l_hi_prem_ee_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_ee_wo_adj_bal_id);

155: -- get_balance_type_id('HI_PREM_ER',p_business_group_id,g_hi_prem_er_bal_id);
156: -- get_balance_type_id('HI_PREM_ER_WO_ADJ',p_business_group_id,g_hi_prem_er_wo_adj_bal_id);
157: ----
158: -- l_hi_prem_ee := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_ee_bal_id);
159: -- l_hi_prem_ee_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_ee_wo_adj_bal_id);
160: -- l_hi_prem_er := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_er_bal_id);
161: -- l_hi_prem_er_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_er_wo_adj_bal_id);
162: ----
163: -- p_hi_prem_ee_adj := l_hi_prem_ee - l_hi_prem_ee_wo_adj;

Line 160: -- l_hi_prem_er := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_er_bal_id);

156: -- get_balance_type_id('HI_PREM_ER_WO_ADJ',p_business_group_id,g_hi_prem_er_wo_adj_bal_id);
157: ----
158: -- l_hi_prem_ee := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_ee_bal_id);
159: -- l_hi_prem_ee_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_ee_wo_adj_bal_id);
160: -- l_hi_prem_er := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_er_bal_id);
161: -- l_hi_prem_er_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_er_wo_adj_bal_id);
162: ----
163: -- p_hi_prem_ee_adj := l_hi_prem_ee - l_hi_prem_ee_wo_adj;
164: -- p_hi_prem_er_adj := l_hi_prem_er - l_hi_prem_er_wo_adj;

Line 161: -- l_hi_prem_er_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_er_wo_adj_bal_id);

157: ----
158: -- l_hi_prem_ee := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_ee_bal_id);
159: -- l_hi_prem_ee_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_ee_wo_adj_bal_id);
160: -- l_hi_prem_er := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_er_bal_id);
161: -- l_hi_prem_er_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_er_wo_adj_bal_id);
162: ----
163: -- p_hi_prem_ee_adj := l_hi_prem_ee - l_hi_prem_ee_wo_adj;
164: -- p_hi_prem_er_adj := l_hi_prem_er - l_hi_prem_er_wo_adj;
165: */

Line 170: p_hi_prem_ee_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_hi_prem_ee_ue_id));

166: --
167: get_user_entity_id('A_HEALTH_INS_SEP_ADJ_EMPLOYEE_CHARGE_ASG_YTD',p_business_group_id,g_hi_prem_ee_ue_id);
168: get_user_entity_id('A_HEALTH_INS_SEP_ADJ_EMPLOYER_CHARGE_ASG_YTD',p_business_group_id,g_hi_prem_er_ue_id);
169: --
170: p_hi_prem_ee_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_hi_prem_ee_ue_id));
171: p_hi_prem_er_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_hi_prem_er_ue_id));
172: --
173: return l_dummy;
174: --

Line 171: p_hi_prem_er_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_hi_prem_er_ue_id));

167: get_user_entity_id('A_HEALTH_INS_SEP_ADJ_EMPLOYEE_CHARGE_ASG_YTD',p_business_group_id,g_hi_prem_ee_ue_id);
168: get_user_entity_id('A_HEALTH_INS_SEP_ADJ_EMPLOYER_CHARGE_ASG_YTD',p_business_group_id,g_hi_prem_er_ue_id);
169: --
170: p_hi_prem_ee_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_hi_prem_ee_ue_id));
171: p_hi_prem_er_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_hi_prem_er_ue_id));
172: --
173: return l_dummy;
174: --
175: end get_ihia_prem_adj;