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.54.12020000.2 2013/01/02 12:19:31 anchhetr 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.54.12020000.2 2013/01/02 12:19:31 anchhetr 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 1144: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS1')

1140: IS
1141: SELECT pai.action_information4
1142: , pai.action_information2
1143: , pai.action_information8
1144: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS1')
1145: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS2')
1146: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS3')
1147: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS4')
1148: , pay_in_reports_pkg.get_location_details(pai.action_information7,'CITY')

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

1141: SELECT pai.action_information4
1142: , pai.action_information2
1143: , pai.action_information8
1144: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS1')
1145: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS2')
1146: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS3')
1147: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS4')
1148: , pay_in_reports_pkg.get_location_details(pai.action_information7,'CITY')
1149: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_STATE')

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

1142: , pai.action_information2
1143: , pai.action_information8
1144: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS1')
1145: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS2')
1146: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS3')
1147: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS4')
1148: , pay_in_reports_pkg.get_location_details(pai.action_information7,'CITY')
1149: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_STATE')
1150: , pay_in_reports_pkg.get_location_details(pai.action_information7,'POSTAL_CODE')

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

1143: , pai.action_information8
1144: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS1')
1145: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS2')
1146: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS3')
1147: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS4')
1148: , pay_in_reports_pkg.get_location_details(pai.action_information7,'CITY')
1149: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_STATE')
1150: , pay_in_reports_pkg.get_location_details(pai.action_information7,'POSTAL_CODE')
1151: , pay_in_reports_pkg.get_location_details(pai.action_information7,'TELEPHONE')

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

1144: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS1')
1145: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS2')
1146: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS3')
1147: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS4')
1148: , pay_in_reports_pkg.get_location_details(pai.action_information7,'CITY')
1149: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_STATE')
1150: , pay_in_reports_pkg.get_location_details(pai.action_information7,'POSTAL_CODE')
1151: , pay_in_reports_pkg.get_location_details(pai.action_information7,'TELEPHONE')
1152: , pay_in_reports_pkg.get_location_details(pai.action_information7,'FAX')

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

1145: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS2')
1146: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS3')
1147: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS4')
1148: , pay_in_reports_pkg.get_location_details(pai.action_information7,'CITY')
1149: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_STATE')
1150: , pay_in_reports_pkg.get_location_details(pai.action_information7,'POSTAL_CODE')
1151: , pay_in_reports_pkg.get_location_details(pai.action_information7,'TELEPHONE')
1152: , pay_in_reports_pkg.get_location_details(pai.action_information7,'FAX')
1153: , pai.action_information11

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

1146: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS3')
1147: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS4')
1148: , pay_in_reports_pkg.get_location_details(pai.action_information7,'CITY')
1149: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_STATE')
1150: , pay_in_reports_pkg.get_location_details(pai.action_information7,'POSTAL_CODE')
1151: , pay_in_reports_pkg.get_location_details(pai.action_information7,'TELEPHONE')
1152: , pay_in_reports_pkg.get_location_details(pai.action_information7,'FAX')
1153: , pai.action_information11
1154: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS1')

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

1147: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_ADDRESS4')
1148: , pay_in_reports_pkg.get_location_details(pai.action_information7,'CITY')
1149: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_STATE')
1150: , pay_in_reports_pkg.get_location_details(pai.action_information7,'POSTAL_CODE')
1151: , pay_in_reports_pkg.get_location_details(pai.action_information7,'TELEPHONE')
1152: , pay_in_reports_pkg.get_location_details(pai.action_information7,'FAX')
1153: , pai.action_information11
1154: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS1')
1155: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS2')

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

1148: , pay_in_reports_pkg.get_location_details(pai.action_information7,'CITY')
1149: , pay_in_reports_pkg.get_location_details(pai.action_information7,'EMPLOYER_STATE')
1150: , pay_in_reports_pkg.get_location_details(pai.action_information7,'POSTAL_CODE')
1151: , pay_in_reports_pkg.get_location_details(pai.action_information7,'TELEPHONE')
1152: , pay_in_reports_pkg.get_location_details(pai.action_information7,'FAX')
1153: , pai.action_information11
1154: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS1')
1155: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS2')
1156: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS3')

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

1150: , pay_in_reports_pkg.get_location_details(pai.action_information7,'POSTAL_CODE')
1151: , pay_in_reports_pkg.get_location_details(pai.action_information7,'TELEPHONE')
1152: , pay_in_reports_pkg.get_location_details(pai.action_information7,'FAX')
1153: , pai.action_information11
1154: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS1')
1155: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS2')
1156: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS3')
1157: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS4')
1158: , pay_in_reports_pkg.get_location_details(pai.action_information16,'CITY')

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

1151: , pay_in_reports_pkg.get_location_details(pai.action_information7,'TELEPHONE')
1152: , pay_in_reports_pkg.get_location_details(pai.action_information7,'FAX')
1153: , pai.action_information11
1154: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS1')
1155: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS2')
1156: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS3')
1157: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS4')
1158: , pay_in_reports_pkg.get_location_details(pai.action_information16,'CITY')
1159: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_STATE')

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

1152: , pay_in_reports_pkg.get_location_details(pai.action_information7,'FAX')
1153: , pai.action_information11
1154: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS1')
1155: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS2')
1156: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS3')
1157: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS4')
1158: , pay_in_reports_pkg.get_location_details(pai.action_information16,'CITY')
1159: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_STATE')
1160: , pay_in_reports_pkg.get_location_details(pai.action_information16,'POSTAL_CODE')

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

1153: , pai.action_information11
1154: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS1')
1155: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS2')
1156: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS3')
1157: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS4')
1158: , pay_in_reports_pkg.get_location_details(pai.action_information16,'CITY')
1159: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_STATE')
1160: , pay_in_reports_pkg.get_location_details(pai.action_information16,'POSTAL_CODE')
1161: , pai.action_information17

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

1154: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS1')
1155: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS2')
1156: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS3')
1157: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS4')
1158: , pay_in_reports_pkg.get_location_details(pai.action_information16,'CITY')
1159: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_STATE')
1160: , pay_in_reports_pkg.get_location_details(pai.action_information16,'POSTAL_CODE')
1161: , pai.action_information17
1162: , pai.action_information18

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

1155: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS2')
1156: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS3')
1157: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS4')
1158: , pay_in_reports_pkg.get_location_details(pai.action_information16,'CITY')
1159: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_STATE')
1160: , pay_in_reports_pkg.get_location_details(pai.action_information16,'POSTAL_CODE')
1161: , pai.action_information17
1162: , pai.action_information18
1163: , pai.action_information13

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

1156: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS3')
1157: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_ADDRESS4')
1158: , pay_in_reports_pkg.get_location_details(pai.action_information16,'CITY')
1159: , pay_in_reports_pkg.get_location_details(pai.action_information16,'EMPLOYER_STATE')
1160: , pay_in_reports_pkg.get_location_details(pai.action_information16,'POSTAL_CODE')
1161: , pai.action_information17
1162: , pai.action_information18
1163: , pai.action_information13
1164: FROM pay_action_information pai

Line 5909: END pay_in_reports_pkg;

5905:
5906: fnd_file.put_line(fnd_file.log,'XML Created.');
5907: END create_esi_xml;
5908:
5909: END pay_in_reports_pkg;