DBA Data[Home] [Help]

APPS.PAY_COSTING_DETAIL_REP_PKG dependencies on HR_GENERAL

Line 125: -- FND_COMMON_LOOKUPS table using the hr_general.decode_fnd_comm_lookup

121:
122: BEGIN
123:
124: -- bug 3039073 replace hardcoded strings with translatable variables from
125: -- FND_COMMON_LOOKUPS table using the hr_general.decode_fnd_comm_lookup
126: -- function from the hrgenral.pkb package
127: -- Bug 2007614
128: open c_legislation_code ;
129: fetch c_legislation_code into lv_legislation_code;

Line 150: hr_general.decode_fnd_comm_lookup

146:
147: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
148: lv_format1 :=
149: formated_data_string (p_input_string =>
150: hr_general.decode_fnd_comm_lookup
151: ('PAYROLL_REPORTS', --lookup_type
152: 'CONS_SET_NAME')--lookup_code
153: ,p_bold => 'Y'
154: ,p_output_file_type => p_output_file_type) ||

Line 156: hr_general.decode_fnd_comm_lookup

152: 'CONS_SET_NAME')--lookup_code
153: ,p_bold => 'Y'
154: ,p_output_file_type => p_output_file_type) ||
155: formated_data_string (p_input_string =>
156: hr_general.decode_fnd_comm_lookup
157: ('PAYROLL_REPORTS', --lookup_type
158: 'PR_NAME')--lookup_code
159: ,p_bold => 'Y'
160: ,p_output_file_type => p_output_file_type) ||

Line 162: hr_general.decode_fnd_comm_lookup

158: 'PR_NAME')--lookup_code
159: ,p_bold => 'Y'
160: ,p_output_file_type => p_output_file_type) ||
161: formated_data_string (p_input_string =>
162: hr_general.decode_fnd_comm_lookup
163: ('PAYROLL_REPORTS', --lookup_type
164: 'GRE')--lookup_code
165: ,p_bold => 'Y'
166: ,p_output_file_type => p_output_file_type) ||

Line 168: hr_general.decode_fnd_comm_lookup

164: 'GRE')--lookup_code
165: ,p_bold => 'Y'
166: ,p_output_file_type => p_output_file_type) ||
167: formated_data_string (p_input_string =>
168: hr_general.decode_fnd_comm_lookup
169: ('PAYROLL_REPORTS', --lookup_type
170: 'L_NAME')--lookup_code
171: ,p_bold => 'Y'
172: ,p_output_file_type => p_output_file_type) ||

Line 174: hr_general.decode_fnd_comm_lookup

170: 'L_NAME')--lookup_code
171: ,p_bold => 'Y'
172: ,p_output_file_type => p_output_file_type) ||
173: formated_data_string (p_input_string =>
174: hr_general.decode_fnd_comm_lookup
175: ('PAYROLL_REPORTS', --lookup_type
176: 'F_NAME')--lookup_code
177: ,p_bold => 'Y'
178: ,p_output_file_type => p_output_file_type) ||

Line 180: hr_general.decode_fnd_comm_lookup

176: 'F_NAME')--lookup_code
177: ,p_bold => 'Y'
178: ,p_output_file_type => p_output_file_type) ||
179: formated_data_string (p_input_string =>
180: hr_general.decode_fnd_comm_lookup
181: ('PAYROLL_REPORTS', --lookup_type
182: 'MI_NAME')--lookup_code
183: ,p_bold => 'Y'
184: ,p_output_file_type => p_output_file_type) ||

Line 186: hr_general.decode_fnd_comm_lookup

182: 'MI_NAME')--lookup_code
183: ,p_bold => 'Y'
184: ,p_output_file_type => p_output_file_type) ||
185: formated_data_string (p_input_string =>
186: hr_general.decode_fnd_comm_lookup
187: ('PAYROLL_REPORTS', --lookup_type
188: 'EFF_DT')--lookup_code
189: ,p_bold => 'Y'
190: ,p_output_file_type => p_output_file_type) ||

Line 192: hr_general.decode_fnd_comm_lookup

188: 'EFF_DT')--lookup_code
189: ,p_bold => 'Y'
190: ,p_output_file_type => p_output_file_type) ||
191: formated_data_string (p_input_string =>
192: hr_general.decode_fnd_comm_lookup
193: ('PAYROLL_REPORTS', --lookup_type
194: 'ELE_NAME')--lookup_code
195: ,p_bold => 'Y'
196: ,p_output_file_type => p_output_file_type) ||

Line 198: hr_general.decode_fnd_comm_lookup

194: 'ELE_NAME')--lookup_code
195: ,p_bold => 'Y'
196: ,p_output_file_type => p_output_file_type) ||
197: formated_data_string (p_input_string =>
198: hr_general.decode_fnd_comm_lookup
199: ('PAYROLL_REPORTS', --lookup_type
200: 'INP_VAL')--lookup_code
201: ,p_bold => 'Y'
202: ,p_output_file_type => p_output_file_type) ||

Line 204: hr_general.decode_fnd_comm_lookup

200: 'INP_VAL')--lookup_code
201: ,p_bold => 'Y'
202: ,p_output_file_type => p_output_file_type) ||
203: formated_data_string (p_input_string =>
204: hr_general.decode_fnd_comm_lookup
205: ('PAYROLL_REPORTS', --lookup_type
206: 'UOM')--lookup_code
207: ,p_bold => 'Y'
208: ,p_output_file_type => p_output_file_type) ||

Line 210: hr_general.decode_fnd_comm_lookup

206: 'UOM')--lookup_code
207: ,p_bold => 'Y'
208: ,p_output_file_type => p_output_file_type) ||
209: formated_data_string (p_input_string =>
210: hr_general.decode_fnd_comm_lookup
211: ('PAYROLL_REPORTS', --lookup_type
212: 'COST_ALLOC_SEGM')--lookup_code
213: ,p_bold => 'Y'
214: ,p_output_file_type => p_output_file_type) ||

Line 216: hr_general.decode_fnd_comm_lookup

212: 'COST_ALLOC_SEGM')--lookup_code
213: ,p_bold => 'Y'
214: ,p_output_file_type => p_output_file_type) ||
215: formated_data_string (p_input_string =>
216: hr_general.decode_fnd_comm_lookup
217: ('PAYROLL_REPORTS', --lookup_type
218: 'CR_AMT')--lookup_code
219: ,p_bold => 'Y'
220: ,p_output_file_type => p_output_file_type) ||

Line 222: hr_general.decode_fnd_comm_lookup

218: 'CR_AMT')--lookup_code
219: ,p_bold => 'Y'
220: ,p_output_file_type => p_output_file_type) ||
221: formated_data_string (p_input_string =>
222: hr_general.decode_fnd_comm_lookup
223: ('PAYROLL_REPORTS', --lookup_type
224: 'DR_AMT')--lookup_code
225: ,p_bold => 'Y'
226: ,p_output_file_type => p_output_file_type) ;

Line 232: hr_general.decode_fnd_comm_lookup

228:
229: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);
230: lv_format2 :=
231: formated_data_string (p_input_string =>
232: hr_general.decode_fnd_comm_lookup
233: ('PAYROLL_REPORTS', --lookup_type
234: 'ORG_NAME')--lookup_code
235: ,p_bold => 'Y'
236: ,p_output_file_type => p_output_file_type) ||

Line 238: hr_general.decode_fnd_comm_lookup

234: 'ORG_NAME')--lookup_code
235: ,p_bold => 'Y'
236: ,p_output_file_type => p_output_file_type) ||
237: formated_data_string (p_input_string =>
238: hr_general.decode_fnd_comm_lookup
239: ('PAYROLL_REPORTS', --lookup_type
240: 'LOC_NAME')--lookup_code
241: ,p_bold => 'Y'
242: ,p_output_file_type => p_output_file_type) ;

Line 247: NVL(hr_general.decode_fnd_comm_lookup

243: /* Added by ssmukher for Bug 4142845 */
244: if p_chk_ni_prt = 'Y' then
245: lv_format2 := lv_format2 ||
246: formated_data_string (p_input_string =>
247: NVL(hr_general.decode_fnd_comm_lookup
248: ('PAYROLL_REPORTS', --lookup_type
249: lv_ssl_number),
250: lv_ssl_number)--lookup_code Bug 2007614
251: ,p_bold => 'Y'

Line 257: hr_general.decode_fnd_comm_lookup

253: end if;
254:
255: lv_format2 := lv_format2 ||
256: formated_data_string (p_input_string =>
257: hr_general.decode_fnd_comm_lookup
258: ('PAYROLL_REPORTS', --lookup_type
259: 'EMP_NO')--lookup_code
260: ,p_bold => 'Y'
261: ,p_output_file_type => p_output_file_type) ||

Line 263: hr_general.decode_fnd_comm_lookup

259: 'EMP_NO')--lookup_code
260: ,p_bold => 'Y'
261: ,p_output_file_type => p_output_file_type) ||
262: formated_data_string (p_input_string =>
263: hr_general.decode_fnd_comm_lookup
264: ('PAYROLL_REPORTS', --lookup_type
265: 'ASSIGN_NO')--lookup_code
266: ,p_bold => 'Y'
267: ,p_output_file_type => p_output_file_type)

Line 680: gv_title := hr_general.decode_fnd_comm_lookup

676:
677: hr_utility.set_location(gv_package_name || '.costing_extract', 60);
678: hr_utility.trace('Static and Element Label = ' || lv_header_label);
679:
680: gv_title := hr_general.decode_fnd_comm_lookup
681: ('PAYROLL_REPORTS',
682: 'COSTING_REPORT_TITLE');
683:
684: fnd_file.put_line(fnd_file.output, formated_header_string(

Line 1161: lv_accrual_type:=nvl(hr_general.decode_lookup('PAY_PAYRPCBR',lv_cost_mode),' ');

1157: hr_utility.set_location(gv_package_name || '.costing_extract', 90);
1158: exit;
1159: end if;
1160:
1161: lv_accrual_type:=nvl(hr_general.decode_lookup('PAY_PAYRPCBR',lv_cost_mode),' ');
1162: if p_output_file_type='HTML' and lv_accrual_type = ' ' then
1163: lv_accrual_type:=' ';
1164: end if;
1165: