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.PAY_IN_REPORTS_PKG dependencies on PAY_IN_REPORTS_PKG

Line 1: PACKAGE BODY PAY_IN_REPORTS_PKG AS

1: PACKAGE BODY PAY_IN_REPORTS_PKG AS
2: /* $Header: pyinprpt.pkb 120.35.12010000.12 2008/09/12 10:16:43 rsaharay ship $ */
3:
4: g_xml_data CLOB;
5: g_package CONSTANT VARCHAR2(100) := 'pay_in_reports_pkg.';

Line 5: g_package CONSTANT VARCHAR2(100) := 'pay_in_reports_pkg.';

1: PACKAGE BODY PAY_IN_REPORTS_PKG AS
2: /* $Header: pyinprpt.pkb 120.35.12010000.12 2008/09/12 10:16:43 rsaharay ship $ */
3:
4: g_xml_data CLOB;
5: g_package CONSTANT VARCHAR2(100) := 'pay_in_reports_pkg.';
6: g_debug BOOLEAN ;
7: --------------------------------------------------------------------------
8: -- --
9: -- Name : get_eit_remarks --

Line 1064: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS1')

1060: IS
1061: SELECT pai.action_information4
1062: , pai.action_information2
1063: , pai.action_information8
1064: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS1')
1065: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS2')
1066: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS3')
1067: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS4')
1068: , pay_in_reports_pkg.get_location_details(pai.action_information7,'CITY')

Line 1065: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS2')

1061: SELECT pai.action_information4
1062: , pai.action_information2
1063: , pai.action_information8
1064: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS1')
1065: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS2')
1066: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS3')
1067: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS4')
1068: , pay_in_reports_pkg.get_location_details(pai.action_information7,'CITY')
1069: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_STATE')

Line 1066: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS3')

1062: , pai.action_information2
1063: , pai.action_information8
1064: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS1')
1065: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS2')
1066: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS3')
1067: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS4')
1068: , pay_in_reports_pkg.get_location_details(pai.action_information7,'CITY')
1069: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_STATE')
1070: , pay_in_reports_pkg.get_location_details(pai.action_information7,'POSTAL_CODE')

Line 1067: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS4')

1063: , pai.action_information8
1064: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS1')
1065: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS2')
1066: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS3')
1067: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS4')
1068: , pay_in_reports_pkg.get_location_details(pai.action_information7,'CITY')
1069: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_STATE')
1070: , pay_in_reports_pkg.get_location_details(pai.action_information7,'POSTAL_CODE')
1071: , pay_in_reports_pkg.get_location_details(pai.action_information7,'TELEPHONE')

Line 1068: , pay_in_reports_pkg.get_location_details(pai.action_information7,'CITY')

1064: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS1')
1065: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS2')
1066: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS3')
1067: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS4')
1068: , pay_in_reports_pkg.get_location_details(pai.action_information7,'CITY')
1069: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_STATE')
1070: , pay_in_reports_pkg.get_location_details(pai.action_information7,'POSTAL_CODE')
1071: , pay_in_reports_pkg.get_location_details(pai.action_information7,'TELEPHONE')
1072: , pay_in_reports_pkg.get_location_details(pai.action_information7,'FAX')

Line 1069: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_STATE')

1065: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS2')
1066: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS3')
1067: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS4')
1068: , pay_in_reports_pkg.get_location_details(pai.action_information7,'CITY')
1069: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_STATE')
1070: , pay_in_reports_pkg.get_location_details(pai.action_information7,'POSTAL_CODE')
1071: , pay_in_reports_pkg.get_location_details(pai.action_information7,'TELEPHONE')
1072: , pay_in_reports_pkg.get_location_details(pai.action_information7,'FAX')
1073: , pai.action_information11

Line 1070: , pay_in_reports_pkg.get_location_details(pai.action_information7,'POSTAL_CODE')

1066: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS3')
1067: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS4')
1068: , pay_in_reports_pkg.get_location_details(pai.action_information7,'CITY')
1069: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_STATE')
1070: , pay_in_reports_pkg.get_location_details(pai.action_information7,'POSTAL_CODE')
1071: , pay_in_reports_pkg.get_location_details(pai.action_information7,'TELEPHONE')
1072: , pay_in_reports_pkg.get_location_details(pai.action_information7,'FAX')
1073: , pai.action_information11
1074: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS1')

Line 1071: , pay_in_reports_pkg.get_location_details(pai.action_information7,'TELEPHONE')

1067: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS4')
1068: , pay_in_reports_pkg.get_location_details(pai.action_information7,'CITY')
1069: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_STATE')
1070: , pay_in_reports_pkg.get_location_details(pai.action_information7,'POSTAL_CODE')
1071: , pay_in_reports_pkg.get_location_details(pai.action_information7,'TELEPHONE')
1072: , pay_in_reports_pkg.get_location_details(pai.action_information7,'FAX')
1073: , pai.action_information11
1074: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS1')
1075: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS2')

Line 1072: , pay_in_reports_pkg.get_location_details(pai.action_information7,'FAX')

1068: , pay_in_reports_pkg.get_location_details(pai.action_information7,'CITY')
1069: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_STATE')
1070: , pay_in_reports_pkg.get_location_details(pai.action_information7,'POSTAL_CODE')
1071: , pay_in_reports_pkg.get_location_details(pai.action_information7,'TELEPHONE')
1072: , pay_in_reports_pkg.get_location_details(pai.action_information7,'FAX')
1073: , pai.action_information11
1074: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS1')
1075: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS2')
1076: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS3')

Line 1074: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS1')

1070: , pay_in_reports_pkg.get_location_details(pai.action_information7,'POSTAL_CODE')
1071: , pay_in_reports_pkg.get_location_details(pai.action_information7,'TELEPHONE')
1072: , pay_in_reports_pkg.get_location_details(pai.action_information7,'FAX')
1073: , pai.action_information11
1074: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS1')
1075: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS2')
1076: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS3')
1077: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS4')
1078: , pay_in_reports_pkg.get_location_details(pai.action_information16,'CITY')

Line 1075: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS2')

1071: , pay_in_reports_pkg.get_location_details(pai.action_information7,'TELEPHONE')
1072: , pay_in_reports_pkg.get_location_details(pai.action_information7,'FAX')
1073: , pai.action_information11
1074: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS1')
1075: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS2')
1076: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS3')
1077: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS4')
1078: , pay_in_reports_pkg.get_location_details(pai.action_information16,'CITY')
1079: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_STATE')

Line 1076: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS3')

1072: , pay_in_reports_pkg.get_location_details(pai.action_information7,'FAX')
1073: , pai.action_information11
1074: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS1')
1075: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS2')
1076: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS3')
1077: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS4')
1078: , pay_in_reports_pkg.get_location_details(pai.action_information16,'CITY')
1079: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_STATE')
1080: , pay_in_reports_pkg.get_location_details(pai.action_information16,'POSTAL_CODE')

Line 1077: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS4')

1073: , pai.action_information11
1074: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS1')
1075: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS2')
1076: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS3')
1077: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS4')
1078: , pay_in_reports_pkg.get_location_details(pai.action_information16,'CITY')
1079: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_STATE')
1080: , pay_in_reports_pkg.get_location_details(pai.action_information16,'POSTAL_CODE')
1081: , pai.action_information17

Line 1078: , pay_in_reports_pkg.get_location_details(pai.action_information16,'CITY')

1074: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS1')
1075: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS2')
1076: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS3')
1077: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS4')
1078: , pay_in_reports_pkg.get_location_details(pai.action_information16,'CITY')
1079: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_STATE')
1080: , pay_in_reports_pkg.get_location_details(pai.action_information16,'POSTAL_CODE')
1081: , pai.action_information17
1082: , pai.action_information18

Line 1079: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_STATE')

1075: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS2')
1076: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS3')
1077: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS4')
1078: , pay_in_reports_pkg.get_location_details(pai.action_information16,'CITY')
1079: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_STATE')
1080: , pay_in_reports_pkg.get_location_details(pai.action_information16,'POSTAL_CODE')
1081: , pai.action_information17
1082: , pai.action_information18
1083: , pai.action_information13

Line 1080: , pay_in_reports_pkg.get_location_details(pai.action_information16,'POSTAL_CODE')

1076: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS3')
1077: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS4')
1078: , pay_in_reports_pkg.get_location_details(pai.action_information16,'CITY')
1079: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_STATE')
1080: , pay_in_reports_pkg.get_location_details(pai.action_information16,'POSTAL_CODE')
1081: , pai.action_information17
1082: , pai.action_information18
1083: , pai.action_information13
1084: FROM pay_action_information pai

Line 5190: END pay_in_reports_pkg;

5186:
5187: fnd_file.put_line(fnd_file.log,'XML Created.');
5188: END create_esi_xml;
5189:
5190: END pay_in_reports_pkg;