DBA Data[Home] [Help]

APPS.PAY_CA_YEPP_MISS_ASSIGN_PKG dependencies on PAY_US_PAYROLL_UTILS

Line 97: pay_us_payroll_utils.formated_data_string (p_input_string => lv_year_heading

93: lv_emp_name_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NAME');
94: lv_gre_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','GRE');
95:
96: lv_format1 :=
97: pay_us_payroll_utils.formated_data_string (p_input_string => lv_year_heading
98: ,p_bold => 'Y'
99: ,p_output_file_type => p_output_file_type) ||
100: pay_us_payroll_utils.formated_data_string (p_input_string => lv_gre_heading
101: ,p_bold => 'Y'

Line 100: pay_us_payroll_utils.formated_data_string (p_input_string => lv_gre_heading

96: lv_format1 :=
97: pay_us_payroll_utils.formated_data_string (p_input_string => lv_year_heading
98: ,p_bold => 'Y'
99: ,p_output_file_type => p_output_file_type) ||
100: pay_us_payroll_utils.formated_data_string (p_input_string => lv_gre_heading
101: ,p_bold => 'Y'
102: ,p_output_file_type => p_output_file_type) ||
103: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_name_heading
104: ,p_bold => 'Y'

Line 103: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_name_heading

99: ,p_output_file_type => p_output_file_type) ||
100: pay_us_payroll_utils.formated_data_string (p_input_string => lv_gre_heading
101: ,p_bold => 'Y'
102: ,p_output_file_type => p_output_file_type) ||
103: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_name_heading
104: ,p_bold => 'Y'
105: ,p_output_file_type => p_output_file_type) ||
106: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_sin_heading
107: ,p_bold => 'Y'

Line 106: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_sin_heading

102: ,p_output_file_type => p_output_file_type) ||
103: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_name_heading
104: ,p_bold => 'Y'
105: ,p_output_file_type => p_output_file_type) ||
106: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_sin_heading
107: ,p_bold => 'Y'
108: ,p_output_file_type => p_output_file_type) ||
109: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_num_heading
110: ,p_bold => 'Y'

Line 109: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_num_heading

105: ,p_output_file_type => p_output_file_type) ||
106: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_sin_heading
107: ,p_bold => 'Y'
108: ,p_output_file_type => p_output_file_type) ||
109: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_num_heading
110: ,p_bold => 'Y'
111: ,p_output_file_type => p_output_file_type) ;
112:
113: return lv_format1 ;

Line 139: pay_us_payroll_utils.formated_data_string (p_input_string => lv_year_heading

135: lv_emp_name_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','EMP_NAME');
136: lv_pre_heading := hr_general.decode_lookup('PAY_CA_MISSING_ASG','PRE');
137:
138: lv_format1 :=
139: pay_us_payroll_utils.formated_data_string (p_input_string => lv_year_heading
140: ,p_bold => 'Y'
141: ,p_output_file_type => p_output_file_type) ||
142: pay_us_payroll_utils.formated_data_string (p_input_string => lv_pre_heading
143: ,p_bold => 'Y'

Line 142: pay_us_payroll_utils.formated_data_string (p_input_string => lv_pre_heading

138: lv_format1 :=
139: pay_us_payroll_utils.formated_data_string (p_input_string => lv_year_heading
140: ,p_bold => 'Y'
141: ,p_output_file_type => p_output_file_type) ||
142: pay_us_payroll_utils.formated_data_string (p_input_string => lv_pre_heading
143: ,p_bold => 'Y'
144: ,p_output_file_type => p_output_file_type) ||
145: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_name_heading
146: ,p_bold => 'Y'

Line 145: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_name_heading

141: ,p_output_file_type => p_output_file_type) ||
142: pay_us_payroll_utils.formated_data_string (p_input_string => lv_pre_heading
143: ,p_bold => 'Y'
144: ,p_output_file_type => p_output_file_type) ||
145: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_name_heading
146: ,p_bold => 'Y'
147: ,p_output_file_type => p_output_file_type) ||
148: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_sin_heading
149: ,p_bold => 'Y'

Line 148: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_sin_heading

144: ,p_output_file_type => p_output_file_type) ||
145: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_name_heading
146: ,p_bold => 'Y'
147: ,p_output_file_type => p_output_file_type) ||
148: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_sin_heading
149: ,p_bold => 'Y'
150: ,p_output_file_type => p_output_file_type) ||
151: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_num_heading
152: ,p_bold => 'Y'

Line 151: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_num_heading

147: ,p_output_file_type => p_output_file_type) ||
148: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_sin_heading
149: ,p_bold => 'Y'
150: ,p_output_file_type => p_output_file_type) ||
151: pay_us_payroll_utils.formated_data_string (p_input_string => lv_emp_num_heading
152: ,p_bold => 'Y'
153: ,p_output_file_type => p_output_file_type) ;
154:
155: return lv_format1 ;

Line 175: pay_us_payroll_utils.formated_data_string (p_input_string => p_year

171: lv_format1 VARCHAR2(22000);
172: BEGIN
173:
174: lv_format1 :=
175: pay_us_payroll_utils.formated_data_string (p_input_string => p_year
176: ,p_bold => 'N'
177: ,p_output_file_type => p_output_file_type) ||
178: pay_us_payroll_utils.formated_data_string (p_input_string => p_gre
179: ,p_bold => 'N'

Line 178: pay_us_payroll_utils.formated_data_string (p_input_string => p_gre

174: lv_format1 :=
175: pay_us_payroll_utils.formated_data_string (p_input_string => p_year
176: ,p_bold => 'N'
177: ,p_output_file_type => p_output_file_type) ||
178: pay_us_payroll_utils.formated_data_string (p_input_string => p_gre
179: ,p_bold => 'N'
180: ,p_output_file_type => p_output_file_type) ||
181: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name
182: ,p_bold => 'N'

Line 181: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name

177: ,p_output_file_type => p_output_file_type) ||
178: pay_us_payroll_utils.formated_data_string (p_input_string => p_gre
179: ,p_bold => 'N'
180: ,p_output_file_type => p_output_file_type) ||
181: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name
182: ,p_bold => 'N'
183: ,p_output_file_type => p_output_file_type) ||
184: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_sin
185: ,p_bold => 'N'

Line 184: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_sin

180: ,p_output_file_type => p_output_file_type) ||
181: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name
182: ,p_bold => 'N'
183: ,p_output_file_type => p_output_file_type) ||
184: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_sin
185: ,p_bold => 'N'
186: ,p_output_file_type => p_output_file_type) ||
187: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_number
188: ,p_bold => 'N'

Line 187: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_number

183: ,p_output_file_type => p_output_file_type) ||
184: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_sin
185: ,p_bold => 'N'
186: ,p_output_file_type => p_output_file_type) ||
187: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_number
188: ,p_bold => 'N'
189: ,p_output_file_type => p_output_file_type);
190:
191: return lv_format1;

Line 211: pay_us_payroll_utils.formated_data_string (p_input_string => p_year

207: lv_format1 VARCHAR2(22000);
208: BEGIN
209:
210: lv_format1 :=
211: pay_us_payroll_utils.formated_data_string (p_input_string => p_year
212: ,p_bold => 'N'
213: ,p_output_file_type => p_output_file_type) ||
214: pay_us_payroll_utils.formated_data_string (p_input_string => p_pre
215: ,p_bold => 'N'

Line 214: pay_us_payroll_utils.formated_data_string (p_input_string => p_pre

210: lv_format1 :=
211: pay_us_payroll_utils.formated_data_string (p_input_string => p_year
212: ,p_bold => 'N'
213: ,p_output_file_type => p_output_file_type) ||
214: pay_us_payroll_utils.formated_data_string (p_input_string => p_pre
215: ,p_bold => 'N'
216: ,p_output_file_type => p_output_file_type) ||
217: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name
218: ,p_bold => 'N'

Line 217: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name

213: ,p_output_file_type => p_output_file_type) ||
214: pay_us_payroll_utils.formated_data_string (p_input_string => p_pre
215: ,p_bold => 'N'
216: ,p_output_file_type => p_output_file_type) ||
217: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name
218: ,p_bold => 'N'
219: ,p_output_file_type => p_output_file_type) ||
220: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_sin
221: ,p_bold => 'N'

Line 220: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_sin

216: ,p_output_file_type => p_output_file_type) ||
217: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name
218: ,p_bold => 'N'
219: ,p_output_file_type => p_output_file_type) ||
220: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_sin
221: ,p_bold => 'N'
222: ,p_output_file_type => p_output_file_type) ||
223: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_number
224: ,p_bold => 'N'

Line 223: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_number

219: ,p_output_file_type => p_output_file_type) ||
220: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_sin
221: ,p_bold => 'N'
222: ,p_output_file_type => p_output_file_type) ||
223: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_number
224: ,p_bold => 'N'
225: ,p_output_file_type => p_output_file_type);
226:
227: return lv_format1;

Line 244: pay_us_payroll_utils.formated_data_string (p_input_string => lvc_message

240:
241: hr_utility.set_location(gv_package_name || '.formated_zero_count', 10);
242:
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
244: pay_us_payroll_utils.formated_data_string (p_input_string => lvc_message
245: ,p_bold => 'N'
246: ,p_output_file_type => output_file_type));
247: END;
248:

Line 279: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,

275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
279: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
280: p_bold => 'N',
281: p_output_file_type => output_file_type)||'');
282: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
283: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,

Line 283: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,

279: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
280: p_bold => 'N',
281: p_output_file_type => output_file_type)||'

');
282: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
283: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
284: p_bold => 'N',
285: p_output_file_type => output_file_type)||'');
286: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
287: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,

Line 287: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,

283: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
284: p_bold => 'N',
285: p_output_file_type => output_file_type)||'

');
286: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
287: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,
288: p_bold => 'N',
289: p_output_file_type => output_file_type)||'');
290: else
291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

Line 292: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,

288: p_bold => 'N',
289: p_output_file_type => output_file_type)||'');
290: else
291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
292: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
293: p_bold => 'N',
294: p_output_file_type => output_file_type));
295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
296: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,

Line 296: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,

292: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
293: p_bold => 'N',
294: p_output_file_type => output_file_type));
295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
296: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
297: p_bold => 'N',
298: p_output_file_type => output_file_type));
299: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
300: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,

Line 300: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,

296: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
297: p_bold => 'N',
298: p_output_file_type => output_file_type));
299: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
300: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,
301: p_bold => 'N',
302: p_output_file_type => output_file_type));
303: end if;
304:

Line 579: pay_us_payroll_utils.formated_header_string(gv_title || ' - '|| p_report_type ||' '||

575: -- 'Year End Archive Missing Assignments Report'
576: gv_title := hr_general.decode_lookup('PAY_CA_MISSING_ASG','MISSING_REPORT_HEADING');
577:
578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
579: pay_us_payroll_utils.formated_header_string(gv_title || ' - '|| p_report_type ||' '||
580: to_char(lv_effective_date,'YYYY'), p_output_file_type ));
581:
582: IF p_report_type IN ('T4','T4A') THEN
583: hr_utility.trace('The value of gre is '||p_gre_id);