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 323: l_buffer := per_new_hire_pkg.a03_ny_new_hire_record(

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

Line 344: per_new_hire_pkg.get_location_address_3lines

340: hr_utility.set_location(l_name,50);
341: elsif p_state_code = 'FL' then
342: hr_utility.trace('p_state_code = FL');
343: l_location_id := gre_location_id;
344: per_new_hire_pkg.get_location_address_3lines
345: (l_location_id,l_loc_address_line1,l_loc_address_line2,l_loc_address_line3
346: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
347: per_new_hire_pkg.get_employee_address_3lines
348: (l_person_id,l_emp_address_line1,l_emp_address_line2,l_emp_address_line3

Line 347: per_new_hire_pkg.get_employee_address_3lines

343: l_location_id := gre_location_id;
344: per_new_hire_pkg.get_location_address_3lines
345: (l_location_id,l_loc_address_line1,l_loc_address_line2,l_loc_address_line3
346: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
347: per_new_hire_pkg.get_employee_address_3lines
348: (l_person_id,l_emp_address_line1,l_emp_address_line2,l_emp_address_line3
349: ,l_emp_city,l_emp_state,l_emp_zip,l_emp_zip_extension,l_emp_country);
350: hr_utility.set_location(l_name,51);
351: hr_utility.trace('p_mult_state = ' || p_multi_state_1);

Line 353: l_buffer := per_new_hire_pkg.fl_new_hire_record(

349: ,l_emp_city,l_emp_state,l_emp_zip,l_emp_zip_extension,l_emp_country);
350: hr_utility.set_location(l_name,51);
351: hr_utility.trace('p_mult_state = ' || p_multi_state_1);
352: hr_utility.trace('l_loc_state = ' || l_loc_state);
353: l_buffer := per_new_hire_pkg.fl_new_hire_record(
354: p_record_identifier => 'FL Newhire Record'
355: ,p_national_identifier => NATIONAL_IDENTIFIER
356: ,p_first_name => FIRST_NAME
357: ,p_middle_name => FULL_MIDDLE_NAME

Line 401: l_buffer := per_new_hire_pkg.a03_fl_new_hire_record(

397:
398: -- file_io.put(l_buffer);
399: if p_audit_report = 'Y' then
400:
401: l_buffer := per_new_hire_pkg.a03_fl_new_hire_record(
402: p_national_identifier => NATIONAL_IDENTIFIER
403: ,p_first_name => FIRST_NAME
404: ,p_middle_name => FULL_MIDDLE_NAME
405: ,p_last_name => LAST_NAME

Line 437: per_new_hire_pkg.get_location_address_3lines

433: -- file_io.put_a03(l_buffer);
434: end if;
435: elsif p_state_code = 'IL' then
436: l_location_id := gre_location_id;
437: per_new_hire_pkg.get_location_address_3lines
438: (l_location_id,l_loc_address_line1,l_loc_address_line2,l_loc_address_line3
439: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
440: per_new_hire_pkg.get_employee_address_3lines
441: (l_person_id,l_emp_address_line1,l_emp_address_line2,l_emp_address_line3

Line 440: per_new_hire_pkg.get_employee_address_3lines

436: l_location_id := gre_location_id;
437: per_new_hire_pkg.get_location_address_3lines
438: (l_location_id,l_loc_address_line1,l_loc_address_line2,l_loc_address_line3
439: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
440: per_new_hire_pkg.get_employee_address_3lines
441: (l_person_id,l_emp_address_line1,l_emp_address_line2,l_emp_address_line3
442: ,l_emp_city,l_emp_state,l_emp_zip,l_emp_zip_extension,l_emp_country);
443: l_buffer := per_new_hire_pkg.il_new_hire_record(
444: p_record_identifier => 'W4'

Line 443: l_buffer := per_new_hire_pkg.il_new_hire_record(

439: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
440: per_new_hire_pkg.get_employee_address_3lines
441: (l_person_id,l_emp_address_line1,l_emp_address_line2,l_emp_address_line3
442: ,l_emp_city,l_emp_state,l_emp_zip,l_emp_zip_extension,l_emp_country);
443: l_buffer := per_new_hire_pkg.il_new_hire_record(
444: p_record_identifier => 'W4'
445: ,p_national_identifier => NATIONAL_IDENTIFIER
446: ,p_first_name => FIRST_NAME
447: ,p_middle_name => FULL_MIDDLE_NAME

Line 474: l_buffer := per_new_hire_pkg.a03_il_new_hire_record(

470: );
471: -- file_io.put(l_buffer);
472: if p_audit_report = 'Y' then
473:
474: l_buffer := per_new_hire_pkg.a03_il_new_hire_record(
475: p_national_identifier => NATIONAL_IDENTIFIER
476: ,p_first_name => FIRST_NAME
477: ,p_middle_name => FULL_MIDDLE_NAME
478: ,p_last_name => LAST_NAME

Line 500: per_new_hire_pkg.get_location_address_3lines

496: end if;
497: elsif p_state_code = 'TX' then
498: l_location_id := gre_location_id;
499: hr_utility.trace('gre_location_id = ' || l_location_id);
500: per_new_hire_pkg.get_location_address_3lines
501: (l_location_id,l_loc_address_line1,l_loc_address_line2,l_loc_address_line3
502: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
503: per_new_hire_pkg.get_employee_address_3lines
504: (l_person_id,l_emp_address_line1,l_emp_address_line2,l_emp_address_line3

Line 503: per_new_hire_pkg.get_employee_address_3lines

499: hr_utility.trace('gre_location_id = ' || l_location_id);
500: per_new_hire_pkg.get_location_address_3lines
501: (l_location_id,l_loc_address_line1,l_loc_address_line2,l_loc_address_line3
502: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
503: per_new_hire_pkg.get_employee_address_3lines
504: (l_person_id,l_emp_address_line1,l_emp_address_line2,l_emp_address_line3
505: ,l_emp_city,l_emp_state,l_emp_zip,l_emp_zip_extension,l_emp_country);
506: l_buffer := per_new_hire_pkg.tx_new_hire_record(
507: p_record_identifier => 'W4'

Line 506: l_buffer := per_new_hire_pkg.tx_new_hire_record(

502: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
503: per_new_hire_pkg.get_employee_address_3lines
504: (l_person_id,l_emp_address_line1,l_emp_address_line2,l_emp_address_line3
505: ,l_emp_city,l_emp_state,l_emp_zip,l_emp_zip_extension,l_emp_country);
506: l_buffer := per_new_hire_pkg.tx_new_hire_record(
507: p_record_identifier => 'W4'
508: ,p_national_identifier => NATIONAL_IDENTIFIER
509: ,p_first_name => FIRST_NAME
510: ,p_middle_name => FULL_MIDDLE_NAME

Line 551: l_buffer := per_new_hire_pkg.a03_tx_new_hire_record(

547: ,p_salary => ' ' ,p_frequency => ' ' );
548: -- file_io.put(l_buffer);
549: if p_audit_report = 'Y' then
550:
551: l_buffer := per_new_hire_pkg.a03_tx_new_hire_record(
552: p_national_identifier => NATIONAL_IDENTIFIER
553: ,p_first_name => FIRST_NAME
554: ,p_middle_name => FULL_MIDDLE_NAME
555: ,p_last_name => LAST_NAME

Line 602: l_buffer := per_new_hire_pkg.ca_t4_record(

598: BEGIN
599:
600: hr_utility.set_location('Entering.....:' || l_name,10);
601: if p_state_code = 'CA' then
602: l_buffer := per_new_hire_pkg.ca_t4_record(
603: p_record_identifier => 'T4'
604: ,p_number_of_employee => C_NO_OF_NEWHIRE
605: );
606:

Line 610: l_buffer := per_new_hire_pkg.ny_1t_record(

606:
607: hr_utility.trace('l_buffer = ' || l_buffer);
608: --file_io.put(l_buffer);
609: elsif p_state_code = 'NY' then
610: l_buffer := per_new_hire_pkg.ny_1t_record(
611: p_record_identifier => '1T'
612: ,p_number_of_employee => C_NO_OF_NEWHIRE
613: );
614:

Line 617: l_buffer := per_new_hire_pkg.ny_1f_record(

613: );
614:
615: hr_utility.trace('l_buffer = ' || l_buffer);
616: --file_io.put(l_buffer);
617: l_buffer := per_new_hire_pkg.ny_1f_record(
618: p_record_identifier => '1F'
619: ,p_number_of_employer => c_no_of_gre
620: );
621:

Line 670: per_new_hire_pkg.get_location_address_3lines

666: fetch c_tax_unit_name into l_tax_unit_name,l_location_id;
667: close c_tax_unit_name;
668:
669: hr_utility.trace('location_id = ' || to_char(l_location_id));
670: per_new_hire_pkg.get_location_address_3lines
671: (l_location_id,l_loc_address_line1,l_loc_address_line2,l_loc_address_line3
672: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
673:
674: l_tax_unit_name := upper(l_tax_unit_name);

Line 726: l_buffer := per_new_hire_pkg.a03_ca_new_hire_header;

722: BEGIN
723:
724: hr_utility.set_location('Entering....' || l_name,10);
725: if p_state_code = 'CA' then
726: l_buffer := per_new_hire_pkg.a03_ca_new_hire_header;
727: elsif p_state_code = 'NY' then
728: l_buffer := per_new_hire_pkg.a03_ny_new_hire_header;
729: elsif p_state_code = 'IL' then
730: l_buffer := per_new_hire_pkg.a03_il_new_hire_header;

Line 728: l_buffer := per_new_hire_pkg.a03_ny_new_hire_header;

724: hr_utility.set_location('Entering....' || l_name,10);
725: if p_state_code = 'CA' then
726: l_buffer := per_new_hire_pkg.a03_ca_new_hire_header;
727: elsif p_state_code = 'NY' then
728: l_buffer := per_new_hire_pkg.a03_ny_new_hire_header;
729: elsif p_state_code = 'IL' then
730: l_buffer := per_new_hire_pkg.a03_il_new_hire_header;
731: elsif p_state_code = 'FL' then
732: l_buffer := per_new_hire_pkg.a03_fl_new_hire_header;

Line 730: l_buffer := per_new_hire_pkg.a03_il_new_hire_header;

726: l_buffer := per_new_hire_pkg.a03_ca_new_hire_header;
727: elsif p_state_code = 'NY' then
728: l_buffer := per_new_hire_pkg.a03_ny_new_hire_header;
729: elsif p_state_code = 'IL' then
730: l_buffer := per_new_hire_pkg.a03_il_new_hire_header;
731: elsif p_state_code = 'FL' then
732: l_buffer := per_new_hire_pkg.a03_fl_new_hire_header;
733: elsif p_state_code = 'TX' then
734: l_buffer := per_new_hire_pkg.a03_tx_new_hire_header;

Line 732: l_buffer := per_new_hire_pkg.a03_fl_new_hire_header;

728: l_buffer := per_new_hire_pkg.a03_ny_new_hire_header;
729: elsif p_state_code = 'IL' then
730: l_buffer := per_new_hire_pkg.a03_il_new_hire_header;
731: elsif p_state_code = 'FL' then
732: l_buffer := per_new_hire_pkg.a03_fl_new_hire_header;
733: elsif p_state_code = 'TX' then
734: l_buffer := per_new_hire_pkg.a03_tx_new_hire_header;
735: end if;
736: hr_utility.set_location('Entering....' || l_name,20);

Line 734: l_buffer := per_new_hire_pkg.a03_tx_new_hire_header;

730: l_buffer := per_new_hire_pkg.a03_il_new_hire_header;
731: elsif p_state_code = 'FL' then
732: l_buffer := per_new_hire_pkg.a03_fl_new_hire_header;
733: elsif p_state_code = 'TX' then
734: l_buffer := per_new_hire_pkg.a03_tx_new_hire_header;
735: end if;
736: hr_utility.set_location('Entering....' || l_name,20);
737:
738: -- file_io.put_a03(l_buffer);

Line 985: per_new_hire_pkg.get_new_hire_contact

981: l_person_id := new_hire_contact_id;
982: l_report_date := fnd_date.canonical_to_date(P_REPORT_DATE);
983: l_business_group_id := P_BUSINESS_GROUP_ID;
984:
985: per_new_hire_pkg.get_new_hire_contact
986: (l_person_id,
987: l_business_group_id,
988: l_report_date,
989: l_contact_name,

Line 1029: per_new_hire_pkg.get_new_hire_contact

1025: l_person_id := new_hire_contact_id;
1026: l_report_date := fnd_date.canonical_to_date(P_REPORT_DATE);
1027: l_business_group_id := P_BUSINESS_GROUP_ID;
1028:
1029: per_new_hire_pkg.get_new_hire_contact
1030: (l_person_id,
1031: l_business_group_id,
1032: l_report_date,
1033: l_contact_name,

Line 1072: per_new_hire_pkg.get_new_hire_contact

1068: l_person_id := new_hire_contact_id;
1069: l_report_date := fnd_date.canonical_to_date(P_REPORT_DATE);
1070: l_business_group_id := P_BUSINESS_GROUP_ID;
1071:
1072: per_new_hire_pkg.get_new_hire_contact
1073: (l_person_id,
1074: l_business_group_id,
1075: l_report_date,
1076: l_contact_name,

Line 1309: per_new_hire_pkg.get_location_address

1305: hr_utility.set_location(l_name,30);
1306: hr_utility.trace('cp_pre_tax_unit_id = ' || cp_pre_tax_unit_id);
1307: hr_utility.trace('tax_unit_id = ' || tax_unit_id);
1308:
1309: per_new_hire_pkg.get_location_address
1310: (l_location_id,l_address,l_city,l_state,l_zip,l_zip_extension);
1311:
1312:
1313: if cp_pre_tax_unit_id is NULL then

Line 1315: l_buffer := per_new_hire_pkg.ca_e4_record(

1311:
1312:
1313: if cp_pre_tax_unit_id is NULL then
1314: a01_header_record(TAX_UNIT_ID,federal_id) ;
1315: l_buffer := per_new_hire_pkg.ca_e4_record(
1316: p_record_identifier => 'E4'
1317: ,p_federal_id => FEDERAL_ID
1318: ,p_sit_company_state_id => SIT_COMPANY_STATE_ID
1319: ,p_branch_code => l_branch_code

Line 1333: l_buffer := per_new_hire_pkg.ca_t4_record(

1329: cp_pre_tax_unit_id := tax_unit_id;
1330: c_no_of_newhire := 0;
1331: c_no_of_gre := c_no_of_gre + 1;
1332: elsif cp_pre_tax_unit_id <> tax_unit_id then
1333: l_buffer := per_new_hire_pkg.ca_t4_record(
1334: p_record_identifier => 'T4'
1335: ,p_number_of_employee => C_NO_OF_NEWHIRE
1336: );
1337:

Line 1343: l_buffer := per_new_hire_pkg.ca_e4_record(

1339: --file_io.put(l_buffer);
1340:
1341: a01_header_record(TAX_UNIT_ID,federal_id) ;
1342:
1343: l_buffer := per_new_hire_pkg.ca_e4_record(
1344: p_record_identifier => 'E4'
1345: ,p_federal_id => FEDERAL_ID
1346: ,p_sit_company_state_id => SIT_COMPANY_STATE_ID
1347: ,p_branch_code => l_branch_code

Line 1365: per_new_hire_pkg.get_location_address

1361:
1362: elsif p_state_code = 'NY' then
1363: hr_utility.set_location(l_name,40);
1364: hr_utility.trace('p_report_date = ' || p_report_date);
1365: per_new_hire_pkg.get_location_address
1366: (l_location_id,l_address,l_city,l_state,l_zip,l_zip_extension);
1367:
1368: if cp_pre_tax_unit_id is NULL then
1369: hr_utility.set_location(l_name,41);

Line 1404: per_new_hire_pkg.get_location_address

1400: hr_utility.trace('transmitter_tax_unit_name = ' || l_trans_tax_unit_name);
1401: hr_utility.trace('transmitter_federal_id = ' || l_trans_federal_id);
1402: hr_utility.trace('transmitter_location_id = ' || to_char(l_trans_location_id));
1403:
1404: per_new_hire_pkg.get_location_address
1405: (l_trans_location_id,l_trans_address
1406: ,l_trans_city,l_trans_state,l_trans_zip,l_trans_zip_extension);
1407:
1408:

Line 1409: l_buffer := per_new_hire_pkg.ny_1a_record(

1405: (l_trans_location_id,l_trans_address
1406: ,l_trans_city,l_trans_state,l_trans_zip,l_trans_zip_extension);
1407:
1408:
1409: l_buffer := per_new_hire_pkg.ny_1a_record(
1410: p_record_identifier => '1A'
1411: ,p_creation_date => to_char(SYSDATE,'MMDDRR')
1412: ,p_federal_id => l_trans_federal_id
1413: ,p_tax_unit_name => l_trans_tax_unit_name

Line 1439: l_buffer := per_new_hire_pkg.ny_1e_record(

1435: file_io.put_a01(g_delimiter); */
1436: a01_header_record(TAX_UNIT_ID,federal_id) ;
1437:
1438:
1439: l_buffer := per_new_hire_pkg.ny_1e_record(
1440: p_record_identifier => '1E'
1441: ,p_federal_id => FEDERAL_ID
1442: ,p_tax_unit_name => TAX_UNIT_NAME
1443: ,p_street_address => l_address

Line 1460: l_buffer := per_new_hire_pkg.ny_1t_record(

1456: hr_utility.set_location(l_name,50);
1457:
1458: a01_header_record(TAX_UNIT_ID,federal_id) ;
1459:
1460: l_buffer := per_new_hire_pkg.ny_1t_record(
1461: p_record_identifier => '1T'
1462: ,p_number_of_employee => C_NO_OF_NEWHIRE
1463: );
1464:

Line 1467: l_buffer := per_new_hire_pkg.ny_1e_record(

1463: );
1464:
1465: hr_utility.trace('l_buffer = ' || l_buffer);
1466: -- file_io.put(l_buffer);
1467: l_buffer := per_new_hire_pkg.ny_1e_record(
1468: p_record_identifier => '1E'
1469: ,p_federal_id => FEDERAL_ID
1470: ,p_tax_unit_name => TAX_UNIT_NAME
1471: ,p_street_address => l_address

Line 1505: l_buffer := per_new_hire_pkg.tx_t4_record(

1501: end if;
1502: close c_tx_term_number;
1503: hr_utility.trace('l_tx_term_num = ' || l_tx_term_num);
1504:
1505: l_buffer := per_new_hire_pkg.tx_t4_record(
1506: p_record_identifier => 'T4'
1507: ,p_number_of_employee => l_tx_emp_num + l_tx_term_num
1508: );
1509: