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_JP_YEA_BAL_ADJ_PKG dependencies on FND_NUMBER

Line 25: select fnd_number.canonical_to_number(org_information5)

21: --
22: l_formula_name ff_formulas_f_tl.formula_name%type;
23: --
24: cursor c_org_formula is
25: select fnd_number.canonical_to_number(org_information5)
26: from hr_organization_information
27: where organization_id = fnd_number.canonical_to_number(p_business_group_id)
28: and org_information_context = 'JP_BUSINESS_GROUP_INFO';
29: --

Line 27: where organization_id = fnd_number.canonical_to_number(p_business_group_id)

23: --
24: cursor c_org_formula is
25: select fnd_number.canonical_to_number(org_information5)
26: from hr_organization_information
27: where organization_id = fnd_number.canonical_to_number(p_business_group_id)
28: and org_information_context = 'JP_BUSINESS_GROUP_INFO';
29: --
30: cursor c_pay_formula is
31: select fnd_number.canonical_to_number(prl_information4)

Line 31: select fnd_number.canonical_to_number(prl_information4)

27: where organization_id = fnd_number.canonical_to_number(p_business_group_id)
28: and org_information_context = 'JP_BUSINESS_GROUP_INFO';
29: --
30: cursor c_pay_formula is
31: select fnd_number.canonical_to_number(prl_information4)
32: from pay_all_payrolls_f
33: where payroll_id = fnd_number.canonical_to_number(p_payroll_id)
34: and fnd_date.canonical_to_date(p_effective_date)
35: between effective_start_date and effective_end_date;

Line 33: where payroll_id = fnd_number.canonical_to_number(p_payroll_id)

29: --
30: cursor c_pay_formula is
31: select fnd_number.canonical_to_number(prl_information4)
32: from pay_all_payrolls_f
33: where payroll_id = fnd_number.canonical_to_number(p_payroll_id)
34: and fnd_date.canonical_to_date(p_effective_date)
35: between effective_start_date and effective_end_date;
36: --
37: cursor c_formula is

Line 113: l_inputs(i).value := fnd_number.canonical_to_number(p_business_group_id);

109: --
110: if l_inputs(i).datatype = 'NUMBER' then
111: --
112: if l_inputs(i).name = 'BUSINESS_GROUP_ID' then
113: l_inputs(i).value := fnd_number.canonical_to_number(p_business_group_id);
114: elsif l_inputs(i).name = 'PAYROLL_ID' then
115: l_inputs(i).value := fnd_number.canonical_to_number(p_payroll_id);
116: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
117: l_inputs(i).value := fnd_number.canonical_to_number(p_payroll_action_id);

Line 115: l_inputs(i).value := fnd_number.canonical_to_number(p_payroll_id);

111: --
112: if l_inputs(i).name = 'BUSINESS_GROUP_ID' then
113: l_inputs(i).value := fnd_number.canonical_to_number(p_business_group_id);
114: elsif l_inputs(i).name = 'PAYROLL_ID' then
115: l_inputs(i).value := fnd_number.canonical_to_number(p_payroll_id);
116: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
117: l_inputs(i).value := fnd_number.canonical_to_number(p_payroll_action_id);
118: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
119: l_inputs(i).value := fnd_number.canonical_to_number(p_assignment_id);

Line 117: l_inputs(i).value := fnd_number.canonical_to_number(p_payroll_action_id);

113: l_inputs(i).value := fnd_number.canonical_to_number(p_business_group_id);
114: elsif l_inputs(i).name = 'PAYROLL_ID' then
115: l_inputs(i).value := fnd_number.canonical_to_number(p_payroll_id);
116: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
117: l_inputs(i).value := fnd_number.canonical_to_number(p_payroll_action_id);
118: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
119: l_inputs(i).value := fnd_number.canonical_to_number(p_assignment_id);
120: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
121: l_inputs(i).value := fnd_number.canonical_to_number(p_assignment_action_id);

Line 119: l_inputs(i).value := fnd_number.canonical_to_number(p_assignment_id);

115: l_inputs(i).value := fnd_number.canonical_to_number(p_payroll_id);
116: elsif l_inputs(i).name = 'PAYROLL_ACTION_ID' then
117: l_inputs(i).value := fnd_number.canonical_to_number(p_payroll_action_id);
118: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
119: l_inputs(i).value := fnd_number.canonical_to_number(p_assignment_id);
120: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
121: l_inputs(i).value := fnd_number.canonical_to_number(p_assignment_action_id);
122: elsif l_inputs(i).name = 'ELEMENT_ENTRY_ID' then
123: l_inputs(i).value := fnd_number.canonical_to_number(p_element_entry_id);

Line 121: l_inputs(i).value := fnd_number.canonical_to_number(p_assignment_action_id);

117: l_inputs(i).value := fnd_number.canonical_to_number(p_payroll_action_id);
118: elsif l_inputs(i).name = 'ASSIGNMENT_ID' then
119: l_inputs(i).value := fnd_number.canonical_to_number(p_assignment_id);
120: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
121: l_inputs(i).value := fnd_number.canonical_to_number(p_assignment_action_id);
122: elsif l_inputs(i).name = 'ELEMENT_ENTRY_ID' then
123: l_inputs(i).value := fnd_number.canonical_to_number(p_element_entry_id);
124: elsif l_inputs(i).name = 'ELEMENT_TYPE_ID' then
125: l_inputs(i).value := fnd_number.canonical_to_number(p_element_type_id);

Line 123: l_inputs(i).value := fnd_number.canonical_to_number(p_element_entry_id);

119: l_inputs(i).value := fnd_number.canonical_to_number(p_assignment_id);
120: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
121: l_inputs(i).value := fnd_number.canonical_to_number(p_assignment_action_id);
122: elsif l_inputs(i).name = 'ELEMENT_ENTRY_ID' then
123: l_inputs(i).value := fnd_number.canonical_to_number(p_element_entry_id);
124: elsif l_inputs(i).name = 'ELEMENT_TYPE_ID' then
125: l_inputs(i).value := fnd_number.canonical_to_number(p_element_type_id);
126: end if;
127: --

Line 125: l_inputs(i).value := fnd_number.canonical_to_number(p_element_type_id);

121: l_inputs(i).value := fnd_number.canonical_to_number(p_assignment_action_id);
122: elsif l_inputs(i).name = 'ELEMENT_ENTRY_ID' then
123: l_inputs(i).value := fnd_number.canonical_to_number(p_element_entry_id);
124: elsif l_inputs(i).name = 'ELEMENT_TYPE_ID' then
125: l_inputs(i).value := fnd_number.canonical_to_number(p_element_type_id);
126: end if;
127: --
128: elsif l_inputs(i).datatype = 'DATE' and l_inputs(i).name = 'DATE_EARNED' then
129: --

Line 149: g_number_value(1) := fnd_number.canonical_to_number(l_outputs(i).value);

145: --
146: if l_outputs(i).datatype = 'NUMBER' then
147: --
148: if l_outputs(i).name = 'L_NUM1' then
149: g_number_value(1) := fnd_number.canonical_to_number(l_outputs(i).value);
150: elsif l_outputs(i).name = 'L_NUM2' then
151: g_number_value(2) := fnd_number.canonical_to_number(l_outputs(i).value);
152: elsif l_outputs(i).name = 'L_NUM3' then
153: g_number_value(3) := fnd_number.canonical_to_number(l_outputs(i).value);

Line 151: g_number_value(2) := fnd_number.canonical_to_number(l_outputs(i).value);

147: --
148: if l_outputs(i).name = 'L_NUM1' then
149: g_number_value(1) := fnd_number.canonical_to_number(l_outputs(i).value);
150: elsif l_outputs(i).name = 'L_NUM2' then
151: g_number_value(2) := fnd_number.canonical_to_number(l_outputs(i).value);
152: elsif l_outputs(i).name = 'L_NUM3' then
153: g_number_value(3) := fnd_number.canonical_to_number(l_outputs(i).value);
154: elsif l_outputs(i).name = 'L_NUM4' then
155: g_number_value(4) := fnd_number.canonical_to_number(l_outputs(i).value);

Line 153: g_number_value(3) := fnd_number.canonical_to_number(l_outputs(i).value);

149: g_number_value(1) := fnd_number.canonical_to_number(l_outputs(i).value);
150: elsif l_outputs(i).name = 'L_NUM2' then
151: g_number_value(2) := fnd_number.canonical_to_number(l_outputs(i).value);
152: elsif l_outputs(i).name = 'L_NUM3' then
153: g_number_value(3) := fnd_number.canonical_to_number(l_outputs(i).value);
154: elsif l_outputs(i).name = 'L_NUM4' then
155: g_number_value(4) := fnd_number.canonical_to_number(l_outputs(i).value);
156: elsif l_outputs(i).name = 'L_NUM5' then
157: g_number_value(5) := fnd_number.canonical_to_number(l_outputs(i).value);

Line 155: g_number_value(4) := fnd_number.canonical_to_number(l_outputs(i).value);

151: g_number_value(2) := fnd_number.canonical_to_number(l_outputs(i).value);
152: elsif l_outputs(i).name = 'L_NUM3' then
153: g_number_value(3) := fnd_number.canonical_to_number(l_outputs(i).value);
154: elsif l_outputs(i).name = 'L_NUM4' then
155: g_number_value(4) := fnd_number.canonical_to_number(l_outputs(i).value);
156: elsif l_outputs(i).name = 'L_NUM5' then
157: g_number_value(5) := fnd_number.canonical_to_number(l_outputs(i).value);
158: elsif l_outputs(i).name = 'L_NUM6' then
159: g_number_value(6) := fnd_number.canonical_to_number(l_outputs(i).value);

Line 157: g_number_value(5) := fnd_number.canonical_to_number(l_outputs(i).value);

153: g_number_value(3) := fnd_number.canonical_to_number(l_outputs(i).value);
154: elsif l_outputs(i).name = 'L_NUM4' then
155: g_number_value(4) := fnd_number.canonical_to_number(l_outputs(i).value);
156: elsif l_outputs(i).name = 'L_NUM5' then
157: g_number_value(5) := fnd_number.canonical_to_number(l_outputs(i).value);
158: elsif l_outputs(i).name = 'L_NUM6' then
159: g_number_value(6) := fnd_number.canonical_to_number(l_outputs(i).value);
160: elsif l_outputs(i).name = 'L_NUM7' then
161: g_number_value(7) := fnd_number.canonical_to_number(l_outputs(i).value);

Line 159: g_number_value(6) := fnd_number.canonical_to_number(l_outputs(i).value);

155: g_number_value(4) := fnd_number.canonical_to_number(l_outputs(i).value);
156: elsif l_outputs(i).name = 'L_NUM5' then
157: g_number_value(5) := fnd_number.canonical_to_number(l_outputs(i).value);
158: elsif l_outputs(i).name = 'L_NUM6' then
159: g_number_value(6) := fnd_number.canonical_to_number(l_outputs(i).value);
160: elsif l_outputs(i).name = 'L_NUM7' then
161: g_number_value(7) := fnd_number.canonical_to_number(l_outputs(i).value);
162: elsif l_outputs(i).name = 'L_NUM8' then
163: g_number_value(8) := fnd_number.canonical_to_number(l_outputs(i).value);

Line 161: g_number_value(7) := fnd_number.canonical_to_number(l_outputs(i).value);

157: g_number_value(5) := fnd_number.canonical_to_number(l_outputs(i).value);
158: elsif l_outputs(i).name = 'L_NUM6' then
159: g_number_value(6) := fnd_number.canonical_to_number(l_outputs(i).value);
160: elsif l_outputs(i).name = 'L_NUM7' then
161: g_number_value(7) := fnd_number.canonical_to_number(l_outputs(i).value);
162: elsif l_outputs(i).name = 'L_NUM8' then
163: g_number_value(8) := fnd_number.canonical_to_number(l_outputs(i).value);
164: elsif l_outputs(i).name = 'L_NUM9' then
165: g_number_value(9) := fnd_number.canonical_to_number(l_outputs(i).value);

Line 163: g_number_value(8) := fnd_number.canonical_to_number(l_outputs(i).value);

159: g_number_value(6) := fnd_number.canonical_to_number(l_outputs(i).value);
160: elsif l_outputs(i).name = 'L_NUM7' then
161: g_number_value(7) := fnd_number.canonical_to_number(l_outputs(i).value);
162: elsif l_outputs(i).name = 'L_NUM8' then
163: g_number_value(8) := fnd_number.canonical_to_number(l_outputs(i).value);
164: elsif l_outputs(i).name = 'L_NUM9' then
165: g_number_value(9) := fnd_number.canonical_to_number(l_outputs(i).value);
166: elsif l_outputs(i).name = 'L_NUM10' then
167: g_number_value(10) := fnd_number.canonical_to_number(l_outputs(i).value);

Line 165: g_number_value(9) := fnd_number.canonical_to_number(l_outputs(i).value);

161: g_number_value(7) := fnd_number.canonical_to_number(l_outputs(i).value);
162: elsif l_outputs(i).name = 'L_NUM8' then
163: g_number_value(8) := fnd_number.canonical_to_number(l_outputs(i).value);
164: elsif l_outputs(i).name = 'L_NUM9' then
165: g_number_value(9) := fnd_number.canonical_to_number(l_outputs(i).value);
166: elsif l_outputs(i).name = 'L_NUM10' then
167: g_number_value(10) := fnd_number.canonical_to_number(l_outputs(i).value);
168: end if;
169: --

Line 167: g_number_value(10) := fnd_number.canonical_to_number(l_outputs(i).value);

163: g_number_value(8) := fnd_number.canonical_to_number(l_outputs(i).value);
164: elsif l_outputs(i).name = 'L_NUM9' then
165: g_number_value(9) := fnd_number.canonical_to_number(l_outputs(i).value);
166: elsif l_outputs(i).name = 'L_NUM10' then
167: g_number_value(10) := fnd_number.canonical_to_number(l_outputs(i).value);
168: end if;
169: --
170: elsif l_outputs(i).datatype = 'TEXT' then
171: --