DBA Data[Home] [Help]

APPS.PAY_YEPP_MISS_ASSIGN_PKG dependencies on PAY_US_PAYROLL_UTILS

Line 94: pay_us_payroll_utils.formated_data_string (p_input_string => 'Year '

90: lv_ni_name := NVL(lv_ni_name, 'Employee SS #');
91:
92:
93: lv_format1 :=
94: pay_us_payroll_utils.formated_data_string (p_input_string => 'Year '
95: ,p_bold => 'Y'
96: ,p_output_file_type => p_output_file_type) ;
97: if (p_pre_or_gre is not null) then
98: if p_pre_or_gre= 'PRE' then

Line 99: lv_format1 := lv_format1 ||pay_us_payroll_utils.formated_data_string

95: ,p_bold => 'Y'
96: ,p_output_file_type => p_output_file_type) ;
97: if (p_pre_or_gre is not null) then
98: if p_pre_or_gre= 'PRE' then
99: lv_format1 := lv_format1 ||pay_us_payroll_utils.formated_data_string
100: (p_input_string => 'PRE '
101: ,p_bold => 'Y'
102: ,p_output_file_type => p_output_file_type);
103: elsif p_pre_or_gre = 'GRE' then

Line 104: lv_format1 := lv_format1 ||pay_us_payroll_utils.formated_data_string

100: (p_input_string => 'PRE '
101: ,p_bold => 'Y'
102: ,p_output_file_type => p_output_file_type);
103: elsif p_pre_or_gre = 'GRE' then
104: lv_format1 := lv_format1 ||pay_us_payroll_utils.formated_data_string
105: (p_input_string => 'GRE '
106: ,p_bold => 'Y'
107: ,p_output_file_type => p_output_file_type);
108: end if;

Line 110: lv_format1 := lv_format1 ||pay_us_payroll_utils.formated_data_string

106: ,p_bold => 'Y'
107: ,p_output_file_type => p_output_file_type);
108: end if;
109: else
110: lv_format1 := lv_format1 ||pay_us_payroll_utils.formated_data_string
111: (p_input_string => 'GRE '
112: ,p_bold => 'Y'
113: ,p_output_file_type => p_output_file_type);
114: end if;

Line 116: lv_format1 := lv_format1 || pay_us_payroll_utils.formated_data_string

112: ,p_bold => 'Y'
113: ,p_output_file_type => p_output_file_type);
114: end if;
115:
116: lv_format1 := lv_format1 || pay_us_payroll_utils.formated_data_string
117: (p_input_string => 'Employee Name '
118: ,p_bold => 'Y'
119: ,p_output_file_type => p_output_file_type) ||
120: pay_us_payroll_utils.formated_data_string (p_input_string => lv_ni_name||' '

Line 120: pay_us_payroll_utils.formated_data_string (p_input_string => lv_ni_name||' '

116: lv_format1 := lv_format1 || pay_us_payroll_utils.formated_data_string
117: (p_input_string => 'Employee Name '
118: ,p_bold => 'Y'
119: ,p_output_file_type => p_output_file_type) ||
120: pay_us_payroll_utils.formated_data_string (p_input_string => lv_ni_name||' '
121: ,p_bold => 'Y'
122: ,p_output_file_type => p_output_file_type) ||
123: pay_us_payroll_utils.formated_data_string (p_input_string => 'Employee #'
124: ,p_bold => 'Y'

Line 123: pay_us_payroll_utils.formated_data_string (p_input_string => 'Employee #'

119: ,p_output_file_type => p_output_file_type) ||
120: pay_us_payroll_utils.formated_data_string (p_input_string => lv_ni_name||' '
121: ,p_bold => 'Y'
122: ,p_output_file_type => p_output_file_type) ||
123: pay_us_payroll_utils.formated_data_string (p_input_string => 'Employee #'
124: ,p_bold => 'Y'
125: ,p_output_file_type => p_output_file_type) ;
126:
127: hr_utility.trace('Static Label1 = ' || lv_format1);

Line 159: pay_us_payroll_utils.formated_data_string (p_input_string => p_year

155: BEGIN
156:
157: hr_utility.set_location(gv_package_name || '.formated_detail_string', 10);
158: lv_format1 :=
159: pay_us_payroll_utils.formated_data_string (p_input_string => p_year
160: ,p_bold => 'N'
161: ,p_output_file_type => p_output_file_type) ||
162: pay_us_payroll_utils.formated_data_string (p_input_string => p_gre
163: ,p_bold => 'N'

Line 162: pay_us_payroll_utils.formated_data_string (p_input_string => p_gre

158: lv_format1 :=
159: pay_us_payroll_utils.formated_data_string (p_input_string => p_year
160: ,p_bold => 'N'
161: ,p_output_file_type => p_output_file_type) ||
162: pay_us_payroll_utils.formated_data_string (p_input_string => p_gre
163: ,p_bold => 'N'
164: ,p_output_file_type => p_output_file_type) ||
165: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name
166: ,p_bold => 'N'

Line 165: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name

161: ,p_output_file_type => p_output_file_type) ||
162: pay_us_payroll_utils.formated_data_string (p_input_string => p_gre
163: ,p_bold => 'N'
164: ,p_output_file_type => p_output_file_type) ||
165: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name
166: ,p_bold => 'N'
167: ,p_output_file_type => p_output_file_type) ||
168: pay_us_payroll_utils.formated_data_string (p_input_string => P_employee_ssn
169: ,p_bold => 'N'

Line 168: pay_us_payroll_utils.formated_data_string (p_input_string => P_employee_ssn

164: ,p_output_file_type => p_output_file_type) ||
165: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name
166: ,p_bold => 'N'
167: ,p_output_file_type => p_output_file_type) ||
168: pay_us_payroll_utils.formated_data_string (p_input_string => P_employee_ssn
169: ,p_bold => 'N'
170: ,p_output_file_type => p_output_file_type) ||
171: pay_us_payroll_utils.formated_data_string (p_input_string => p_emplyee_number
172: ,p_bold => 'N'

Line 171: pay_us_payroll_utils.formated_data_string (p_input_string => p_emplyee_number

167: ,p_output_file_type => p_output_file_type) ||
168: pay_us_payroll_utils.formated_data_string (p_input_string => P_employee_ssn
169: ,p_bold => 'N'
170: ,p_output_file_type => p_output_file_type) ||
171: pay_us_payroll_utils.formated_data_string (p_input_string => p_emplyee_number
172: ,p_bold => 'N'
173: ,p_output_file_type => p_output_file_type);
174:
175:

Line 200: pay_us_payroll_utils.formated_data_string (p_input_string => lvc_message

196: lvc_message := 'No person was picked up based on selection parameters.' ||
197: ' The YEPP Archive for the GRE has no missing assignments.';
198: hr_utility.set_location(gv_package_name || '.formated_zero_count', 10);
199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
200: pay_us_payroll_utils.formated_data_string (p_input_string => lvc_message
201: ,p_bold => 'N'
202: ,p_output_file_type => output_file_type));
203: hr_utility.set_location(gv_package_name || '.formated_zero_count', 20);
204: END;

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

234: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
235:
236:
237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
238: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
239: p_bold => 'N',
240: p_output_file_type => output_file_type)||'');
241:
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||

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

239: p_bold => 'N',
240: p_output_file_type => output_file_type)||'

');
241:
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
243: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
244: p_bold => 'N',
245: p_output_file_type => output_file_type)||'');
246:
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||

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

244: p_bold => 'N',
245: p_output_file_type => output_file_type)||'

');
246:
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
248: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,
249: p_bold => 'N',
250: p_output_file_type => output_file_type)||'');
251: ELSE
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

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

249: p_bold => 'N',
250: p_output_file_type => output_file_type)||'');
251: ELSE
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
253: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
254: p_bold => 'N',
255: p_output_file_type => output_file_type));
256:
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

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

254: p_bold => 'N',
255: p_output_file_type => output_file_type));
256:
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
258: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
259: p_bold => 'N',
260: p_output_file_type => output_file_type));
261:
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

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

259: p_bold => 'N',
260: p_output_file_type => output_file_type));
261:
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
263: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,
264: p_bold => 'N',
265: p_output_file_type => output_file_type));
266: END IF;
267:

Line 286: lv_format:= pay_us_payroll_utils.formated_data_string(p_input_string=>'Element Name'

282: lv_format VARCHAR2(32000);
283:
284: BEGIN
285: hr_utility.set_location(gv_package_name || '.formated_element_header.',10);
286: lv_format:= pay_us_payroll_utils.formated_data_string(p_input_string=>'Element Name'
287: ,p_output_file_type=>p_output_file_type
288: ,p_bold=>'Y')||
289: pay_us_payroll_utils.formated_data_string(p_input_string=>'Classification'
290: ,p_output_file_type=>p_output_file_type

Line 289: pay_us_payroll_utils.formated_data_string(p_input_string=>'Classification'

285: hr_utility.set_location(gv_package_name || '.formated_element_header.',10);
286: lv_format:= pay_us_payroll_utils.formated_data_string(p_input_string=>'Element Name'
287: ,p_output_file_type=>p_output_file_type
288: ,p_bold=>'Y')||
289: pay_us_payroll_utils.formated_data_string(p_input_string=>'Classification'
290: ,p_output_file_type=>p_output_file_type
291: ,p_bold=>'Y');
292: /*||
293: pay_us_payroll_utils.formated_data_string(p_input_string=>'Input Value Name'

Line 293: pay_us_payroll_utils.formated_data_string(p_input_string=>'Input Value Name'

289: pay_us_payroll_utils.formated_data_string(p_input_string=>'Classification'
290: ,p_output_file_type=>p_output_file_type
291: ,p_bold=>'Y');
292: /*||
293: pay_us_payroll_utils.formated_data_string(p_input_string=>'Input Value Name'
294: ,p_output_file_type=>p_output_file_type
295: ,p_bold=>'Y')*/
296:
297: p_static_label := lv_format;

Line 324: pay_us_payroll_utils.formated_data_string (p_input_string=>p_element_name

320:
321: hr_utility.set_location(gv_package_name || '.formated_element_row', 10);
322:
323: lv_format :=
324: pay_us_payroll_utils.formated_data_string (p_input_string=>p_element_name
325: ,p_output_file_type=>p_output_file_type
326: ,p_bold=>'N'
327: )||
328: pay_us_payroll_utils.formated_data_string (p_input_string=>p_classification

Line 328: pay_us_payroll_utils.formated_data_string (p_input_string=>p_classification

324: pay_us_payroll_utils.formated_data_string (p_input_string=>p_element_name
325: ,p_output_file_type=>p_output_file_type
326: ,p_bold=>'N'
327: )||
328: pay_us_payroll_utils.formated_data_string (p_input_string=>p_classification
329: ,p_output_file_type=>p_output_file_type
330: ,p_bold=>'N'
331: );
332: /*||

Line 333: pay_us_payroll_utils.formated_data_string (p_input_string=>p_input_value_name

329: ,p_output_file_type=>p_output_file_type
330: ,p_bold=>'N'
331: );
332: /*||
333: pay_us_payroll_utils.formated_data_string (p_input_string=>p_input_value_name
334: ,p_output_file_type=>p_output_file_type
335: ,p_bold=>'N'
336: );*/
337:

Line 519: select pay_us_payroll_utils.get_parameter(

515: into lv_legislative_param
516: from pay_payroll_actions
517: where payroll_action_id = p_payroll_action_id;
518:
519: select pay_us_payroll_utils.get_parameter(
520: 'ASSIGNMENT_SET',
521: lv_legislative_param),
522: pay_us_payroll_utils.get_parameter(
523: 'OUTPUT_TYPE',

Line 522: pay_us_payroll_utils.get_parameter(

518:
519: select pay_us_payroll_utils.get_parameter(
520: 'ASSIGNMENT_SET',
521: lv_legislative_param),
522: pay_us_payroll_utils.get_parameter(
523: 'OUTPUT_TYPE',
524: lv_legislative_param)
525: into lv_assignment_set, lv_output_file_type
526: from dual;

Line 541: pay_us_payroll_utils.formated_header_string(gv_title || ':- Tax Year: ' ||

537: hr_utility.trace('lv_assignment_set = ' || lv_assignment_set);
538: hr_utility.trace('lv_output_file_type = ' || lv_output_file_type);
539:
540: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
541: pay_us_payroll_utils.formated_header_string(gv_title || ':- Tax Year: ' ||
542: to_char(lv_effective_date,'YYYY'),lv_output_file_type ));
543:
544: open c_get_business_group_id(nvl(p_tax_unit_id,l_pre_organization_id));
545: fetch c_get_business_group_id into lv_business_group_id;

Line 700: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(

696:
697: lv_element_count := 0;
698:
699: lv_title := 'Element Information';
700: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(
701: lv_title
702: ,lv_output_file_type
703: ));
704:

Line 711: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,

707:
708: IF lv_output_file_type ='HTML' THEN
709: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
710: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
711: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,
712: p_bold => 'N',
713: p_output_file_type => lv_output_file_type)||'

');
714: ELSE
715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

Line 716: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,

712: p_bold => 'N',
713: p_output_file_type => lv_output_file_type)||'

');
714: ELSE
715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
716: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,
717: p_bold => 'N',
718: p_output_file_type => lv_output_file_type));
719: END IF;
720:

Line 774: lv_element_count_info := pay_us_payroll_utils.formated_data_string

770:
771: -- hr_utility.set_location(gv_package_name || '.select_employee', 170);
772: END IF;
773:
774: lv_element_count_info := pay_us_payroll_utils.formated_data_string
775: (p_input_string =>'Number of Elements Found = '|| lv_element_count
776: ,p_bold => 'N'
777: ,p_output_file_type => lv_output_file_type);
778: