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.PER_PERUSHRM_XMLP_PKG dependencies on PER_NEW_HIRE_PKG

Line 212: per_new_hire_pkg.char_set_init( p_character_set => p_character_set);

208: p_character_set in varchar2
209: ) IS
210: BEGIN
211:
212: per_new_hire_pkg.char_set_init( p_character_set => p_character_set);
213:
214:
215: END;
216: procedure new_hire_record(person_id in number,NATIONAL_IDENTIFIER in varchar2,FIRST_NAME in varchar2,

Line 260: per_new_hire_pkg.get_employee_address

256:
257: if p_state_code = 'CA' then
258: hr_utility.set_location(l_name,20);
259:
260: per_new_hire_pkg.get_employee_address
261: (l_person_id,l_address,l_city,l_state,l_zip,l_zip_extension);
262: l_buffer := per_new_hire_pkg.ca_w4_record(
263: p_record_identifier => 'W4'
264: ,p_national_identifier => NATIONAL_IDENTIFIER

Line 262: l_buffer := per_new_hire_pkg.ca_w4_record(

258: hr_utility.set_location(l_name,20);
259:
260: per_new_hire_pkg.get_employee_address
261: (l_person_id,l_address,l_city,l_state,l_zip,l_zip_extension);
262: l_buffer := per_new_hire_pkg.ca_w4_record(
263: p_record_identifier => 'W4'
264: ,p_national_identifier => NATIONAL_IDENTIFIER
265: ,p_first_name => FIRST_NAME
266: ,p_middle_name => MIDDLE_NAME

Line 281: l_buffer := per_new_hire_pkg.a03_ca_new_hire_record(

277: -- file_io.put(l_buffer);
278: if p_audit_report = 'Y' then
279:
280:
281: l_buffer := per_new_hire_pkg.a03_ca_new_hire_record(
282: p_national_identifier => NATIONAL_IDENTIFIER
283: ,p_first_name => FIRST_NAME
284: ,p_middle_name => FULL_MIDDLE_NAME
285: ,p_last_name => LAST_NAME

Line 300: per_new_hire_pkg.get_employee_address

296: end if;
297: elsif p_state_code = 'NY' then
298: hr_utility.set_location(l_name,40);
299:
300: per_new_hire_pkg.get_employee_address
301: (l_person_id,l_address,l_city,l_state,l_zip,l_zip_extension);
302: hr_utility.trace('date_start = ' ||to_char(DATE_START));
303:
304: l_buffer := per_new_hire_pkg.ny_1h_record(

Line 304: l_buffer := per_new_hire_pkg.ny_1h_record(

300: per_new_hire_pkg.get_employee_address
301: (l_person_id,l_address,l_city,l_state,l_zip,l_zip_extension);
302: hr_utility.trace('date_start = ' ||to_char(DATE_START));
303:
304: l_buffer := per_new_hire_pkg.ny_1h_record(
305: p_record_identifier => '1H'
306: ,p_last_name => LAST_NAME
307: ,p_middle_name => MIDDLE_NAME
308: ,p_first_name => FIRST_NAME

Line 320: l_buffer := per_new_hire_pkg.a03_ny_new_hire_record(

316: c_no_of_newhire := c_no_of_newhire + 1;
317: -- file_io.put(l_buffer);
318: if p_audit_report = 'Y' then
319:
320: l_buffer := per_new_hire_pkg.a03_ny_new_hire_record(
321: p_national_identifier => NATIONAL_IDENTIFIER
322: ,p_first_name => FIRST_NAME
323: ,p_middle_name => FULL_MIDDLE_NAME
324: ,p_last_name => LAST_NAME

Line 338: per_new_hire_pkg.get_location_address_3lines

334: hr_utility.set_location(l_name,50);
335: elsif p_state_code = 'FL' then
336: hr_utility.trace('p_state_code = FL');
337: l_location_id := gre_location_id;
338: per_new_hire_pkg.get_location_address_3lines
339: (l_location_id,l_loc_address_line1,l_loc_address_line2,l_loc_address_line3
340: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
341: per_new_hire_pkg.get_employee_address_3lines
342: (l_person_id,l_emp_address_line1,l_emp_address_line2,l_emp_address_line3

Line 341: per_new_hire_pkg.get_employee_address_3lines

337: l_location_id := gre_location_id;
338: per_new_hire_pkg.get_location_address_3lines
339: (l_location_id,l_loc_address_line1,l_loc_address_line2,l_loc_address_line3
340: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
341: per_new_hire_pkg.get_employee_address_3lines
342: (l_person_id,l_emp_address_line1,l_emp_address_line2,l_emp_address_line3
343: ,l_emp_city,l_emp_state,l_emp_zip,l_emp_zip_extension,l_emp_country);
344: hr_utility.set_location(l_name,51);
345: hr_utility.trace('p_mult_state = ' || p_multi_state_1);

Line 347: l_buffer := per_new_hire_pkg.fl_new_hire_record(

343: ,l_emp_city,l_emp_state,l_emp_zip,l_emp_zip_extension,l_emp_country);
344: hr_utility.set_location(l_name,51);
345: hr_utility.trace('p_mult_state = ' || p_multi_state_1);
346: hr_utility.trace('l_loc_state = ' || l_loc_state);
347: l_buffer := per_new_hire_pkg.fl_new_hire_record(
348: p_record_identifier => 'FL Newhire Record'
349: ,p_national_identifier => NATIONAL_IDENTIFIER
350: ,p_first_name => FIRST_NAME
351: ,p_middle_name => FULL_MIDDLE_NAME

Line 394: l_buffer := per_new_hire_pkg.a03_fl_new_hire_record(

390:
391: -- file_io.put(l_buffer);
392: if p_audit_report = 'Y' then
393:
394: l_buffer := per_new_hire_pkg.a03_fl_new_hire_record(
395: p_national_identifier => NATIONAL_IDENTIFIER
396: ,p_first_name => FIRST_NAME
397: ,p_middle_name => FULL_MIDDLE_NAME
398: ,p_last_name => LAST_NAME

Line 429: per_new_hire_pkg.get_location_address_3lines

425: -- file_io.put_a03(l_buffer);
426: end if;
427: elsif p_state_code = 'IL' then
428: l_location_id := gre_location_id;
429: per_new_hire_pkg.get_location_address_3lines
430: (l_location_id,l_loc_address_line1,l_loc_address_line2,l_loc_address_line3
431: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
432: per_new_hire_pkg.get_employee_address_3lines
433: (l_person_id,l_emp_address_line1,l_emp_address_line2,l_emp_address_line3

Line 432: per_new_hire_pkg.get_employee_address_3lines

428: l_location_id := gre_location_id;
429: per_new_hire_pkg.get_location_address_3lines
430: (l_location_id,l_loc_address_line1,l_loc_address_line2,l_loc_address_line3
431: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
432: per_new_hire_pkg.get_employee_address_3lines
433: (l_person_id,l_emp_address_line1,l_emp_address_line2,l_emp_address_line3
434: ,l_emp_city,l_emp_state,l_emp_zip,l_emp_zip_extension,l_emp_country);
435: l_buffer := per_new_hire_pkg.il_new_hire_record(
436: p_record_identifier => 'W4'

Line 435: l_buffer := per_new_hire_pkg.il_new_hire_record(

431: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
432: per_new_hire_pkg.get_employee_address_3lines
433: (l_person_id,l_emp_address_line1,l_emp_address_line2,l_emp_address_line3
434: ,l_emp_city,l_emp_state,l_emp_zip,l_emp_zip_extension,l_emp_country);
435: l_buffer := per_new_hire_pkg.il_new_hire_record(
436: p_record_identifier => 'W4'
437: ,p_national_identifier => NATIONAL_IDENTIFIER
438: ,p_first_name => FIRST_NAME
439: ,p_middle_name => FULL_MIDDLE_NAME

Line 466: l_buffer := per_new_hire_pkg.a03_il_new_hire_record(

462: );
463: -- file_io.put(l_buffer);
464: if p_audit_report = 'Y' then
465:
466: l_buffer := per_new_hire_pkg.a03_il_new_hire_record(
467: p_national_identifier => NATIONAL_IDENTIFIER
468: ,p_first_name => FIRST_NAME
469: ,p_middle_name => FULL_MIDDLE_NAME
470: ,p_last_name => LAST_NAME

Line 492: per_new_hire_pkg.get_location_address_3lines

488: end if;
489: elsif p_state_code = 'TX' then
490: l_location_id := gre_location_id;
491: hr_utility.trace('gre_location_id = ' || l_location_id);
492: per_new_hire_pkg.get_location_address_3lines
493: (l_location_id,l_loc_address_line1,l_loc_address_line2,l_loc_address_line3
494: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
495: per_new_hire_pkg.get_employee_address_3lines
496: (l_person_id,l_emp_address_line1,l_emp_address_line2,l_emp_address_line3

Line 495: per_new_hire_pkg.get_employee_address_3lines

491: hr_utility.trace('gre_location_id = ' || l_location_id);
492: per_new_hire_pkg.get_location_address_3lines
493: (l_location_id,l_loc_address_line1,l_loc_address_line2,l_loc_address_line3
494: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
495: per_new_hire_pkg.get_employee_address_3lines
496: (l_person_id,l_emp_address_line1,l_emp_address_line2,l_emp_address_line3
497: ,l_emp_city,l_emp_state,l_emp_zip,l_emp_zip_extension,l_emp_country);
498: l_buffer := per_new_hire_pkg.tx_new_hire_record(
499: p_record_identifier => 'W4'

Line 498: l_buffer := per_new_hire_pkg.tx_new_hire_record(

494: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
495: per_new_hire_pkg.get_employee_address_3lines
496: (l_person_id,l_emp_address_line1,l_emp_address_line2,l_emp_address_line3
497: ,l_emp_city,l_emp_state,l_emp_zip,l_emp_zip_extension,l_emp_country);
498: l_buffer := per_new_hire_pkg.tx_new_hire_record(
499: p_record_identifier => 'W4'
500: ,p_national_identifier => NATIONAL_IDENTIFIER
501: ,p_first_name => FIRST_NAME
502: ,p_middle_name => FULL_MIDDLE_NAME

Line 543: l_buffer := per_new_hire_pkg.a03_tx_new_hire_record(

539: ,p_salary => ' ' ,p_frequency => ' ' );
540: -- file_io.put(l_buffer);
541: if p_audit_report = 'Y' then
542:
543: l_buffer := per_new_hire_pkg.a03_tx_new_hire_record(
544: p_national_identifier => NATIONAL_IDENTIFIER
545: ,p_first_name => FIRST_NAME
546: ,p_middle_name => FULL_MIDDLE_NAME
547: ,p_last_name => LAST_NAME

Line 594: l_buffer := per_new_hire_pkg.ca_t4_record(

590: BEGIN
591:
592: hr_utility.set_location('Entering.....:' || l_name,10);
593: if p_state_code = 'CA' then
594: l_buffer := per_new_hire_pkg.ca_t4_record(
595: p_record_identifier => 'T4'
596: ,p_number_of_employee => C_NO_OF_NEWHIRE
597: );
598:

Line 602: l_buffer := per_new_hire_pkg.ny_1t_record(

598:
599: hr_utility.trace('l_buffer = ' || l_buffer);
600: --file_io.put(l_buffer);
601: elsif p_state_code = 'NY' then
602: l_buffer := per_new_hire_pkg.ny_1t_record(
603: p_record_identifier => '1T'
604: ,p_number_of_employee => C_NO_OF_NEWHIRE
605: );
606:

Line 609: l_buffer := per_new_hire_pkg.ny_1f_record(

605: );
606:
607: hr_utility.trace('l_buffer = ' || l_buffer);
608: --file_io.put(l_buffer);
609: l_buffer := per_new_hire_pkg.ny_1f_record(
610: p_record_identifier => '1F'
611: ,p_number_of_employer => c_no_of_gre
612: );
613:

Line 662: per_new_hire_pkg.get_location_address_3lines

658: fetch c_tax_unit_name into l_tax_unit_name,l_location_id;
659: close c_tax_unit_name;
660:
661: hr_utility.trace('location_id = ' || to_char(l_location_id));
662: per_new_hire_pkg.get_location_address_3lines
663: (l_location_id,l_loc_address_line1,l_loc_address_line2,l_loc_address_line3
664: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
665:
666: l_tax_unit_name := upper(l_tax_unit_name);

Line 718: l_buffer := per_new_hire_pkg.a03_ca_new_hire_header;

714: BEGIN
715:
716: hr_utility.set_location('Entering....' || l_name,10);
717: if p_state_code = 'CA' then
718: l_buffer := per_new_hire_pkg.a03_ca_new_hire_header;
719: elsif p_state_code = 'NY' then
720: l_buffer := per_new_hire_pkg.a03_ny_new_hire_header;
721: elsif p_state_code = 'IL' then
722: l_buffer := per_new_hire_pkg.a03_il_new_hire_header;

Line 720: l_buffer := per_new_hire_pkg.a03_ny_new_hire_header;

716: hr_utility.set_location('Entering....' || l_name,10);
717: if p_state_code = 'CA' then
718: l_buffer := per_new_hire_pkg.a03_ca_new_hire_header;
719: elsif p_state_code = 'NY' then
720: l_buffer := per_new_hire_pkg.a03_ny_new_hire_header;
721: elsif p_state_code = 'IL' then
722: l_buffer := per_new_hire_pkg.a03_il_new_hire_header;
723: elsif p_state_code = 'FL' then
724: l_buffer := per_new_hire_pkg.a03_fl_new_hire_header;

Line 722: l_buffer := per_new_hire_pkg.a03_il_new_hire_header;

718: l_buffer := per_new_hire_pkg.a03_ca_new_hire_header;
719: elsif p_state_code = 'NY' then
720: l_buffer := per_new_hire_pkg.a03_ny_new_hire_header;
721: elsif p_state_code = 'IL' then
722: l_buffer := per_new_hire_pkg.a03_il_new_hire_header;
723: elsif p_state_code = 'FL' then
724: l_buffer := per_new_hire_pkg.a03_fl_new_hire_header;
725: elsif p_state_code = 'TX' then
726: l_buffer := per_new_hire_pkg.a03_tx_new_hire_header;

Line 724: l_buffer := per_new_hire_pkg.a03_fl_new_hire_header;

720: l_buffer := per_new_hire_pkg.a03_ny_new_hire_header;
721: elsif p_state_code = 'IL' then
722: l_buffer := per_new_hire_pkg.a03_il_new_hire_header;
723: elsif p_state_code = 'FL' then
724: l_buffer := per_new_hire_pkg.a03_fl_new_hire_header;
725: elsif p_state_code = 'TX' then
726: l_buffer := per_new_hire_pkg.a03_tx_new_hire_header;
727: end if;
728: hr_utility.set_location('Entering....' || l_name,20);

Line 726: l_buffer := per_new_hire_pkg.a03_tx_new_hire_header;

722: l_buffer := per_new_hire_pkg.a03_il_new_hire_header;
723: elsif p_state_code = 'FL' then
724: l_buffer := per_new_hire_pkg.a03_fl_new_hire_header;
725: elsif p_state_code = 'TX' then
726: l_buffer := per_new_hire_pkg.a03_tx_new_hire_header;
727: end if;
728: hr_utility.set_location('Entering....' || l_name,20);
729:
730: -- file_io.put_a03(l_buffer);

Line 977: per_new_hire_pkg.get_new_hire_contact

973: l_person_id := new_hire_contact_id;
974: l_report_date := fnd_date.canonical_to_date(P_REPORT_DATE);
975: l_business_group_id := P_BUSINESS_GROUP_ID;
976:
977: per_new_hire_pkg.get_new_hire_contact
978: (l_person_id,
979: l_business_group_id,
980: l_report_date,
981: l_contact_name,

Line 1021: per_new_hire_pkg.get_new_hire_contact

1017: l_person_id := new_hire_contact_id;
1018: l_report_date := fnd_date.canonical_to_date(P_REPORT_DATE);
1019: l_business_group_id := P_BUSINESS_GROUP_ID;
1020:
1021: per_new_hire_pkg.get_new_hire_contact
1022: (l_person_id,
1023: l_business_group_id,
1024: l_report_date,
1025: l_contact_name,

Line 1064: per_new_hire_pkg.get_new_hire_contact

1060: l_person_id := new_hire_contact_id;
1061: l_report_date := fnd_date.canonical_to_date(P_REPORT_DATE);
1062: l_business_group_id := P_BUSINESS_GROUP_ID;
1063:
1064: per_new_hire_pkg.get_new_hire_contact
1065: (l_person_id,
1066: l_business_group_id,
1067: l_report_date,
1068: l_contact_name,

Line 1301: per_new_hire_pkg.get_location_address

1297: hr_utility.set_location(l_name,30);
1298: hr_utility.trace('cp_pre_tax_unit_id = ' || cp_pre_tax_unit_id);
1299: hr_utility.trace('tax_unit_id = ' || tax_unit_id);
1300:
1301: per_new_hire_pkg.get_location_address
1302: (l_location_id,l_address,l_city,l_state,l_zip,l_zip_extension);
1303:
1304:
1305: if cp_pre_tax_unit_id is NULL then

Line 1307: l_buffer := per_new_hire_pkg.ca_e4_record(

1303:
1304:
1305: if cp_pre_tax_unit_id is NULL then
1306: a01_header_record(TAX_UNIT_ID,federal_id) ;
1307: l_buffer := per_new_hire_pkg.ca_e4_record(
1308: p_record_identifier => 'E4'
1309: ,p_federal_id => FEDERAL_ID
1310: ,p_sit_company_state_id => SIT_COMPANY_STATE_ID
1311: ,p_branch_code => l_branch_code

Line 1325: l_buffer := per_new_hire_pkg.ca_t4_record(

1321: cp_pre_tax_unit_id := tax_unit_id;
1322: c_no_of_newhire := 0;
1323: c_no_of_gre := c_no_of_gre + 1;
1324: elsif cp_pre_tax_unit_id <> tax_unit_id then
1325: l_buffer := per_new_hire_pkg.ca_t4_record(
1326: p_record_identifier => 'T4'
1327: ,p_number_of_employee => C_NO_OF_NEWHIRE
1328: );
1329:

Line 1335: l_buffer := per_new_hire_pkg.ca_e4_record(

1331: --file_io.put(l_buffer);
1332:
1333: a01_header_record(TAX_UNIT_ID,federal_id) ;
1334:
1335: l_buffer := per_new_hire_pkg.ca_e4_record(
1336: p_record_identifier => 'E4'
1337: ,p_federal_id => FEDERAL_ID
1338: ,p_sit_company_state_id => SIT_COMPANY_STATE_ID
1339: ,p_branch_code => l_branch_code

Line 1357: per_new_hire_pkg.get_location_address

1353:
1354: elsif p_state_code = 'NY' then
1355: hr_utility.set_location(l_name,40);
1356: hr_utility.trace('p_report_date = ' || p_report_date);
1357: per_new_hire_pkg.get_location_address
1358: (l_location_id,l_address,l_city,l_state,l_zip,l_zip_extension);
1359:
1360: if cp_pre_tax_unit_id is NULL then
1361: hr_utility.set_location(l_name,41);

Line 1396: per_new_hire_pkg.get_location_address

1392: hr_utility.trace('transmitter_tax_unit_name = ' || l_trans_tax_unit_name);
1393: hr_utility.trace('transmitter_federal_id = ' || l_trans_federal_id);
1394: hr_utility.trace('transmitter_location_id = ' || to_char(l_trans_location_id));
1395:
1396: per_new_hire_pkg.get_location_address
1397: (l_trans_location_id,l_trans_address
1398: ,l_trans_city,l_trans_state,l_trans_zip,l_trans_zip_extension);
1399:
1400:

Line 1401: l_buffer := per_new_hire_pkg.ny_1a_record(

1397: (l_trans_location_id,l_trans_address
1398: ,l_trans_city,l_trans_state,l_trans_zip,l_trans_zip_extension);
1399:
1400:
1401: l_buffer := per_new_hire_pkg.ny_1a_record(
1402: p_record_identifier => '1A'
1403: ,p_creation_date => to_char(SYSDATE,'MMDDRR')
1404: ,p_federal_id => l_trans_federal_id
1405: ,p_tax_unit_name => l_trans_tax_unit_name

Line 1431: l_buffer := per_new_hire_pkg.ny_1e_record(

1427: file_io.put_a01(g_delimiter); */
1428: a01_header_record(TAX_UNIT_ID,federal_id) ;
1429:
1430:
1431: l_buffer := per_new_hire_pkg.ny_1e_record(
1432: p_record_identifier => '1E'
1433: ,p_federal_id => FEDERAL_ID
1434: ,p_tax_unit_name => TAX_UNIT_NAME
1435: ,p_street_address => l_address

Line 1452: l_buffer := per_new_hire_pkg.ny_1t_record(

1448: hr_utility.set_location(l_name,50);
1449:
1450: a01_header_record(TAX_UNIT_ID,federal_id) ;
1451:
1452: l_buffer := per_new_hire_pkg.ny_1t_record(
1453: p_record_identifier => '1T'
1454: ,p_number_of_employee => C_NO_OF_NEWHIRE
1455: );
1456:

Line 1459: l_buffer := per_new_hire_pkg.ny_1e_record(

1455: );
1456:
1457: hr_utility.trace('l_buffer = ' || l_buffer);
1458: -- file_io.put(l_buffer);
1459: l_buffer := per_new_hire_pkg.ny_1e_record(
1460: p_record_identifier => '1E'
1461: ,p_federal_id => FEDERAL_ID
1462: ,p_tax_unit_name => TAX_UNIT_NAME
1463: ,p_street_address => l_address

Line 1497: l_buffer := per_new_hire_pkg.tx_t4_record(

1493: end if;
1494: close c_tx_term_number;
1495: hr_utility.trace('l_tx_term_num = ' || l_tx_term_num);
1496:
1497: l_buffer := per_new_hire_pkg.tx_t4_record(
1498: p_record_identifier => 'T4'
1499: ,p_number_of_employee => l_tx_emp_num + l_tx_term_num
1500: );
1501: