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_NL_IZA_REPORT dependencies on PAY_NL_XDO_REPORT

Line 6: /Counter for accessing the values in PAY_NL_XDO_REPORT.vXMLTable/

2: /* $Header: paynliza.pkb 120.0 2005/05/29 02:40:37 appldev noship $ */
3:
4: level_cnt NUMBER;
5:
6: /*Counter for accessing the values in PAY_NL_XDO_REPORT.vXMLTable*/
7: vCtr NUMBER;
8:
9: /*-------------------------------------------------------------------------------
10: |Name : populate_iza_report_data |

Line 116: PAY_NL_XDO_REPORT.vXMLTable.DELETE;

112: open csr_employer_data;
113: fetch csr_employer_data into v_employer_data;
114: close csr_employer_data;
115:
116: PAY_NL_XDO_REPORT.vXMLTable.DELETE;
117: vCtr := 0;
118:
119: /*Get all the XML tags and values*/
120: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';

Line 120: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';

116: PAY_NL_XDO_REPORT.vXMLTable.DELETE;
117: vCtr := 0;
118:
119: /*Get all the XML tags and values*/
120: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
121: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_bg_name;
122: vCtr := vCtr + 1;
123: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
124: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(fnd_date.canonical_to_date(p_eff_date),'DD-Mon-YYYY');

Line 121: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_bg_name;

117: vCtr := 0;
118:
119: /*Get all the XML tags and values*/
120: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
121: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_bg_name;
122: vCtr := vCtr + 1;
123: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
124: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(fnd_date.canonical_to_date(p_eff_date),'DD-Mon-YYYY');
125: vCtr := vCtr + 1;

Line 123: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';

119: /*Get all the XML tags and values*/
120: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
121: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_bg_name;
122: vCtr := vCtr + 1;
123: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
124: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(fnd_date.canonical_to_date(p_eff_date),'DD-Mon-YYYY');
125: vCtr := vCtr + 1;
126: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
127: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;

Line 124: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(fnd_date.canonical_to_date(p_eff_date),'DD-Mon-YYYY');

120: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
121: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_bg_name;
122: vCtr := vCtr + 1;
123: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
124: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(fnd_date.canonical_to_date(p_eff_date),'DD-Mon-YYYY');
125: vCtr := vCtr + 1;
126: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
127: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
128: vCtr := vCtr + 1;

Line 126: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';

122: vCtr := vCtr + 1;
123: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
124: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(fnd_date.canonical_to_date(p_eff_date),'DD-Mon-YYYY');
125: vCtr := vCtr + 1;
126: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
127: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
128: vCtr := vCtr + 1;
129: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
130: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employer;

Line 127: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;

123: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EFF_DATE';
124: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(fnd_date.canonical_to_date(p_eff_date),'DD-Mon-YYYY');
125: vCtr := vCtr + 1;
126: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
127: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
128: vCtr := vCtr + 1;
129: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
130: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employer;
131: vCtr := vCtr + 1;

Line 129: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';

125: vCtr := vCtr + 1;
126: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
127: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
128: vCtr := vCtr + 1;
129: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
130: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employer;
131: vCtr := vCtr + 1;
132: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PROCESS_MONTH';
133: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_process_month,'MMYYYY'),'YYYY / MM');

Line 130: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employer;

126: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ORG_HIERARCHY';
127: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_org_struct;
128: vCtr := vCtr + 1;
129: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
130: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employer;
131: vCtr := vCtr + 1;
132: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PROCESS_MONTH';
133: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_process_month,'MMYYYY'),'YYYY / MM');
134: vCtr := vCtr + 1;

Line 132: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PROCESS_MONTH';

128: vCtr := vCtr + 1;
129: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
130: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employer;
131: vCtr := vCtr + 1;
132: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PROCESS_MONTH';
133: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_process_month,'MMYYYY'),'YYYY / MM');
134: vCtr := vCtr + 1;
135: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CURRENCY';
136: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.currency;

Line 133: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_process_month,'MMYYYY'),'YYYY / MM');

129: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EMPLOYER';
130: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := p_employer;
131: vCtr := vCtr + 1;
132: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PROCESS_MONTH';
133: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_process_month,'MMYYYY'),'YYYY / MM');
134: vCtr := vCtr + 1;
135: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CURRENCY';
136: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.currency;
137: vCtr := vCtr + 1;

Line 135: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CURRENCY';

131: vCtr := vCtr + 1;
132: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PROCESS_MONTH';
133: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_process_month,'MMYYYY'),'YYYY / MM');
134: vCtr := vCtr + 1;
135: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CURRENCY';
136: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.currency;
137: vCtr := vCtr + 1;
138: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL_CENTER';
139: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.payroll_center;

Line 136: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.currency;

132: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PROCESS_MONTH';
133: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(to_date(p_process_month,'MMYYYY'),'YYYY / MM');
134: vCtr := vCtr + 1;
135: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CURRENCY';
136: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.currency;
137: vCtr := vCtr + 1;
138: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL_CENTER';
139: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.payroll_center;
140: vCtr := vCtr + 1;

Line 138: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL_CENTER';

134: vCtr := vCtr + 1;
135: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CURRENCY';
136: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.currency;
137: vCtr := vCtr + 1;
138: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL_CENTER';
139: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.payroll_center;
140: vCtr := vCtr + 1;
141: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PROVINCE';
142: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.province;

Line 139: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.payroll_center;

135: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CURRENCY';
136: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.currency;
137: vCtr := vCtr + 1;
138: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL_CENTER';
139: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.payroll_center;
140: vCtr := vCtr + 1;
141: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PROVINCE';
142: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.province;
143: vCtr := vCtr + 1;

Line 141: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PROVINCE';

137: vCtr := vCtr + 1;
138: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL_CENTER';
139: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.payroll_center;
140: vCtr := vCtr + 1;
141: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PROVINCE';
142: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.province;
143: vCtr := vCtr + 1;
144: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_CLIENT_NUMBER';
145: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.employer_number;

Line 142: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.province;

138: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PAYROLL_CENTER';
139: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.payroll_center;
140: vCtr := vCtr + 1;
141: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PROVINCE';
142: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.province;
143: vCtr := vCtr + 1;
144: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_CLIENT_NUMBER';
145: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.employer_number;
146: vCtr := vCtr + 1;

Line 144: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_CLIENT_NUMBER';

140: vCtr := vCtr + 1;
141: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PROVINCE';
142: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.province;
143: vCtr := vCtr + 1;
144: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_CLIENT_NUMBER';
145: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.employer_number;
146: vCtr := vCtr + 1;
147: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYER_NUMBER';
148: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.sub_employer_number;

Line 145: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.employer_number;

141: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PROVINCE';
142: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.province;
143: vCtr := vCtr + 1;
144: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_CLIENT_NUMBER';
145: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.employer_number;
146: vCtr := vCtr + 1;
147: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYER_NUMBER';
148: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.sub_employer_number;
149:

Line 147: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYER_NUMBER';

143: vCtr := vCtr + 1;
144: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_CLIENT_NUMBER';
145: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.employer_number;
146: vCtr := vCtr + 1;
147: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYER_NUMBER';
148: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.sub_employer_number;
149:
150: for v_employee_data in csr_employee_data
151: loop

Line 148: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.sub_employer_number;

144: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_CLIENT_NUMBER';
145: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.employer_number;
146: vCtr := vCtr + 1;
147: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'SUB_EMPLOYER_NUMBER';
148: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employer_data.sub_employer_number;
149:
150: for v_employee_data in csr_employee_data
151: loop
152: if (v_employee_data.process_status = 'REJECTED' or v_employee_data.process_status = 'MISSING') then

Line 154: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';

150: for v_employee_data in csr_employee_data
151: loop
152: if (v_employee_data.process_status = 'REJECTED' or v_employee_data.process_status = 'MISSING') then
153: vCtr := vCtr + 1;
154: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
155: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
156: vCtr := vCtr + 1;
157: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EXCHANGE_NUMBER';
158: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.exchange_number;

Line 155: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;

151: loop
152: if (v_employee_data.process_status = 'REJECTED' or v_employee_data.process_status = 'MISSING') then
153: vCtr := vCtr + 1;
154: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
155: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
156: vCtr := vCtr + 1;
157: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EXCHANGE_NUMBER';
158: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.exchange_number;
159: vCtr := vCtr + 1;

Line 157: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EXCHANGE_NUMBER';

153: vCtr := vCtr + 1;
154: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
155: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
156: vCtr := vCtr + 1;
157: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EXCHANGE_NUMBER';
158: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.exchange_number;
159: vCtr := vCtr + 1;
160: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'NAME';
161: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.name;

Line 158: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.exchange_number;

154: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
155: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := null;
156: vCtr := vCtr + 1;
157: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EXCHANGE_NUMBER';
158: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.exchange_number;
159: vCtr := vCtr + 1;
160: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'NAME';
161: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.name;
162: vCtr := vCtr + 1;

Line 160: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'NAME';

156: vCtr := vCtr + 1;
157: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EXCHANGE_NUMBER';
158: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.exchange_number;
159: vCtr := vCtr + 1;
160: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'NAME';
161: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.name;
162: vCtr := vCtr + 1;
163: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'DOB';
164: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.dob,'DD-MM-YY');

Line 161: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.name;

157: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EXCHANGE_NUMBER';
158: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.exchange_number;
159: vCtr := vCtr + 1;
160: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'NAME';
161: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.name;
162: vCtr := vCtr + 1;
163: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'DOB';
164: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.dob,'DD-MM-YY');
165: vCtr := vCtr + 1;

Line 163: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'DOB';

159: vCtr := vCtr + 1;
160: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'NAME';
161: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.name;
162: vCtr := vCtr + 1;
163: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'DOB';
164: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.dob,'DD-MM-YY');
165: vCtr := vCtr + 1;
166: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PARTICIPANT_NUMBER';
167: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.participant_number;

Line 164: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.dob,'DD-MM-YY');

160: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'NAME';
161: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.name;
162: vCtr := vCtr + 1;
163: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'DOB';
164: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.dob,'DD-MM-YY');
165: vCtr := vCtr + 1;
166: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PARTICIPANT_NUMBER';
167: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.participant_number;
168: vCtr := vCtr + 1;

Line 166: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PARTICIPANT_NUMBER';

162: vCtr := vCtr + 1;
163: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'DOB';
164: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.dob,'DD-MM-YY');
165: vCtr := vCtr + 1;
166: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PARTICIPANT_NUMBER';
167: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.participant_number;
168: vCtr := vCtr + 1;
169: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_AMT_1';
170: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.iza_amt_1,'99G990D00MI');

Line 167: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.participant_number;

163: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'DOB';
164: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.dob,'DD-MM-YY');
165: vCtr := vCtr + 1;
166: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PARTICIPANT_NUMBER';
167: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.participant_number;
168: vCtr := vCtr + 1;
169: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_AMT_1';
170: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.iza_amt_1,'99G990D00MI');
171: vCtr := vCtr + 1;

Line 169: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_AMT_1';

165: vCtr := vCtr + 1;
166: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PARTICIPANT_NUMBER';
167: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.participant_number;
168: vCtr := vCtr + 1;
169: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_AMT_1';
170: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.iza_amt_1,'99G990D00MI');
171: vCtr := vCtr + 1;
172: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_AMT_2';
173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.iza_amt_2,'99G990D00MI');

Line 170: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.iza_amt_1,'99G990D00MI');

166: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'PARTICIPANT_NUMBER';
167: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.participant_number;
168: vCtr := vCtr + 1;
169: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_AMT_1';
170: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.iza_amt_1,'99G990D00MI');
171: vCtr := vCtr + 1;
172: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_AMT_2';
173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.iza_amt_2,'99G990D00MI');
174: vCtr := vCtr + 1;

Line 172: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_AMT_2';

168: vCtr := vCtr + 1;
169: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_AMT_1';
170: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.iza_amt_1,'99G990D00MI');
171: vCtr := vCtr + 1;
172: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_AMT_2';
173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.iza_amt_2,'99G990D00MI');
174: vCtr := vCtr + 1;
175: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CORR_AMT_1';
176: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.corr_amt_1,'99G990D00MI');

Line 173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.iza_amt_2,'99G990D00MI');

169: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_AMT_1';
170: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.iza_amt_1,'99G990D00MI');
171: vCtr := vCtr + 1;
172: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_AMT_2';
173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.iza_amt_2,'99G990D00MI');
174: vCtr := vCtr + 1;
175: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CORR_AMT_1';
176: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.corr_amt_1,'99G990D00MI');
177: vCtr := vCtr + 1;

Line 175: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CORR_AMT_1';

171: vCtr := vCtr + 1;
172: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_AMT_2';
173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.iza_amt_2,'99G990D00MI');
174: vCtr := vCtr + 1;
175: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CORR_AMT_1';
176: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.corr_amt_1,'99G990D00MI');
177: vCtr := vCtr + 1;
178: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CORR_AMT_2';
179: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.corr_amt_2,'99G990D00MI');

Line 176: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.corr_amt_1,'99G990D00MI');

172: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'IZA_AMT_2';
173: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.iza_amt_2,'99G990D00MI');
174: vCtr := vCtr + 1;
175: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CORR_AMT_1';
176: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.corr_amt_1,'99G990D00MI');
177: vCtr := vCtr + 1;
178: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CORR_AMT_2';
179: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.corr_amt_2,'99G990D00MI');
180: vCtr := vCtr + 1;

Line 178: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CORR_AMT_2';

174: vCtr := vCtr + 1;
175: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CORR_AMT_1';
176: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.corr_amt_1,'99G990D00MI');
177: vCtr := vCtr + 1;
178: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CORR_AMT_2';
179: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.corr_amt_2,'99G990D00MI');
180: vCtr := vCtr + 1;
181: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EXPLANATION';
182: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.explanation;

Line 179: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.corr_amt_2,'99G990D00MI');

175: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CORR_AMT_1';
176: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.corr_amt_1,'99G990D00MI');
177: vCtr := vCtr + 1;
178: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CORR_AMT_2';
179: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.corr_amt_2,'99G990D00MI');
180: vCtr := vCtr + 1;
181: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EXPLANATION';
182: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.explanation;
183: vCtr := vCtr + 1;

Line 181: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EXPLANATION';

177: vCtr := vCtr + 1;
178: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CORR_AMT_2';
179: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.corr_amt_2,'99G990D00MI');
180: vCtr := vCtr + 1;
181: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EXPLANATION';
182: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.explanation;
183: vCtr := vCtr + 1;
184: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
185: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

Line 182: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.explanation;

178: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'CORR_AMT_2';
179: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(v_employee_data.corr_amt_2,'99G990D00MI');
180: vCtr := vCtr + 1;
181: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EXPLANATION';
182: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.explanation;
183: vCtr := vCtr + 1;
184: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
185: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
186: if v_employee_data.process_status = 'REJECTED' then

Line 184: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';

180: vCtr := vCtr + 1;
181: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EXPLANATION';
182: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.explanation;
183: vCtr := vCtr + 1;
184: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
185: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
186: if v_employee_data.process_status = 'REJECTED' then
187: l_rejected_count := l_rejected_count + 1;
188: l_rejected_amt_1 := l_rejected_amt_1 + v_employee_data.iza_amt_1;

Line 185: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';

181: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EXPLANATION';
182: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_employee_data.explanation;
183: vCtr := vCtr + 1;
184: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
185: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
186: if v_employee_data.process_status = 'REJECTED' then
187: l_rejected_count := l_rejected_count + 1;
188: l_rejected_amt_1 := l_rejected_amt_1 + v_employee_data.iza_amt_1;
189: l_rejected_amt_2 := l_rejected_amt_2 + v_employee_data.iza_amt_2;

Line 221: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_COUNT';

217: end loop;
218:
219: /*Fetch XML file as a BLOB*/
220: vCtr := vCtr + 1;
221: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_COUNT';
222: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_accepted_count;
223: vCtr := vCtr + 1;
224: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_COUNT';
225: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_rejected_count;

Line 222: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_accepted_count;

218:
219: /*Fetch XML file as a BLOB*/
220: vCtr := vCtr + 1;
221: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_COUNT';
222: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_accepted_count;
223: vCtr := vCtr + 1;
224: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_COUNT';
225: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_rejected_count;
226: vCtr := vCtr + 1;

Line 224: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_COUNT';

220: vCtr := vCtr + 1;
221: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_COUNT';
222: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_accepted_count;
223: vCtr := vCtr + 1;
224: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_COUNT';
225: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_rejected_count;
226: vCtr := vCtr + 1;
227: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MISSING_COUNT';
228: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_missing_count;

Line 225: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_rejected_count;

221: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_COUNT';
222: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_accepted_count;
223: vCtr := vCtr + 1;
224: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_COUNT';
225: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_rejected_count;
226: vCtr := vCtr + 1;
227: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MISSING_COUNT';
228: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_missing_count;
229: l_Record_count := l_accepted_count + l_rejected_count;

Line 227: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MISSING_COUNT';

223: vCtr := vCtr + 1;
224: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_COUNT';
225: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_rejected_count;
226: vCtr := vCtr + 1;
227: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MISSING_COUNT';
228: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_missing_count;
229: l_Record_count := l_accepted_count + l_rejected_count;
230: l_tape_amt_1 := l_accepted_amt_1 + l_rejected_amt_1;
231: l_tape_amt_2 := l_accepted_amt_2 + l_rejected_amt_2;

Line 228: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_missing_count;

224: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_COUNT';
225: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_rejected_count;
226: vCtr := vCtr + 1;
227: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'MISSING_COUNT';
228: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_missing_count;
229: l_Record_count := l_accepted_count + l_rejected_count;
230: l_tape_amt_1 := l_accepted_amt_1 + l_rejected_amt_1;
231: l_tape_amt_2 := l_accepted_amt_2 + l_rejected_amt_2;
232: l_tape_corr_1 := l_accepted_corr_1 + l_rejected_corr_1;

Line 239: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RECORD_COUNT';

235: l_accepted_total := l_accepted_amt_1 + l_accepted_amt_2 + l_accepted_corr_1 + l_accepted_corr_2;
236: l_rejected_total := l_rejected_amt_1 + l_rejected_amt_2 + l_rejected_corr_1 + l_rejected_corr_2;
237: l_retro_total := l_retro_amt_1 + l_retro_amt_2 + l_retro_corr_1 + l_retro_corr_2;
238: vCtr := vCtr + 1;
239: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RECORD_COUNT';
240: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_record_count;
241: vCtr := vCtr + 1;
242: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_COUNT';
243: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_retro_count;

Line 240: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_record_count;

236: l_rejected_total := l_rejected_amt_1 + l_rejected_amt_2 + l_rejected_corr_1 + l_rejected_corr_2;
237: l_retro_total := l_retro_amt_1 + l_retro_amt_2 + l_retro_corr_1 + l_retro_corr_2;
238: vCtr := vCtr + 1;
239: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RECORD_COUNT';
240: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_record_count;
241: vCtr := vCtr + 1;
242: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_COUNT';
243: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_retro_count;
244: vCtr := vCtr + 1;

Line 242: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_COUNT';

238: vCtr := vCtr + 1;
239: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RECORD_COUNT';
240: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_record_count;
241: vCtr := vCtr + 1;
242: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_COUNT';
243: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_retro_count;
244: vCtr := vCtr + 1;
245: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_AMT_1';
246: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_amt_1,'9G999G990D00MI');

Line 243: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_retro_count;

239: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RECORD_COUNT';
240: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_record_count;
241: vCtr := vCtr + 1;
242: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_COUNT';
243: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_retro_count;
244: vCtr := vCtr + 1;
245: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_AMT_1';
246: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_amt_1,'9G999G990D00MI');
247: vCtr := vCtr + 1;

Line 245: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_AMT_1';

241: vCtr := vCtr + 1;
242: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_COUNT';
243: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_retro_count;
244: vCtr := vCtr + 1;
245: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_AMT_1';
246: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_amt_1,'9G999G990D00MI');
247: vCtr := vCtr + 1;
248: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_AMT_1';
249: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_amt_1,'9G999G990D00MI');

Line 246: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_amt_1,'9G999G990D00MI');

242: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_COUNT';
243: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_retro_count;
244: vCtr := vCtr + 1;
245: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_AMT_1';
246: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_amt_1,'9G999G990D00MI');
247: vCtr := vCtr + 1;
248: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_AMT_1';
249: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_amt_1,'9G999G990D00MI');
250: vCtr := vCtr + 1;

Line 248: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_AMT_1';

244: vCtr := vCtr + 1;
245: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_AMT_1';
246: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_amt_1,'9G999G990D00MI');
247: vCtr := vCtr + 1;
248: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_AMT_1';
249: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_amt_1,'9G999G990D00MI');
250: vCtr := vCtr + 1;
251: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_AMT_1';
252: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_amt_1,'9G999G990D00MI');

Line 249: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_amt_1,'9G999G990D00MI');

245: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_AMT_1';
246: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_amt_1,'9G999G990D00MI');
247: vCtr := vCtr + 1;
248: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_AMT_1';
249: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_amt_1,'9G999G990D00MI');
250: vCtr := vCtr + 1;
251: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_AMT_1';
252: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_amt_1,'9G999G990D00MI');
253: vCtr := vCtr + 1;

Line 251: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_AMT_1';

247: vCtr := vCtr + 1;
248: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_AMT_1';
249: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_amt_1,'9G999G990D00MI');
250: vCtr := vCtr + 1;
251: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_AMT_1';
252: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_amt_1,'9G999G990D00MI');
253: vCtr := vCtr + 1;
254: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_AMT_1';
255: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_amt_1,'9G999G990D00MI');

Line 252: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_amt_1,'9G999G990D00MI');

248: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_AMT_1';
249: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_amt_1,'9G999G990D00MI');
250: vCtr := vCtr + 1;
251: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_AMT_1';
252: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_amt_1,'9G999G990D00MI');
253: vCtr := vCtr + 1;
254: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_AMT_1';
255: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_amt_1,'9G999G990D00MI');
256: vCtr := vCtr + 1;

Line 254: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_AMT_1';

250: vCtr := vCtr + 1;
251: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_AMT_1';
252: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_amt_1,'9G999G990D00MI');
253: vCtr := vCtr + 1;
254: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_AMT_1';
255: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_amt_1,'9G999G990D00MI');
256: vCtr := vCtr + 1;
257: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_AMT_2';
258: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_amt_2,'9G999G990D00MI');

Line 255: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_amt_1,'9G999G990D00MI');

251: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_AMT_1';
252: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_amt_1,'9G999G990D00MI');
253: vCtr := vCtr + 1;
254: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_AMT_1';
255: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_amt_1,'9G999G990D00MI');
256: vCtr := vCtr + 1;
257: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_AMT_2';
258: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_amt_2,'9G999G990D00MI');
259: vCtr := vCtr + 1;

Line 257: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_AMT_2';

253: vCtr := vCtr + 1;
254: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_AMT_1';
255: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_amt_1,'9G999G990D00MI');
256: vCtr := vCtr + 1;
257: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_AMT_2';
258: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_amt_2,'9G999G990D00MI');
259: vCtr := vCtr + 1;
260: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_AMT_2';
261: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_amt_2,'9G999G990D00MI');

Line 258: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_amt_2,'9G999G990D00MI');

254: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_AMT_1';
255: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_amt_1,'9G999G990D00MI');
256: vCtr := vCtr + 1;
257: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_AMT_2';
258: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_amt_2,'9G999G990D00MI');
259: vCtr := vCtr + 1;
260: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_AMT_2';
261: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_amt_2,'9G999G990D00MI');
262: vCtr := vCtr + 1;

Line 260: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_AMT_2';

256: vCtr := vCtr + 1;
257: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_AMT_2';
258: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_amt_2,'9G999G990D00MI');
259: vCtr := vCtr + 1;
260: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_AMT_2';
261: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_amt_2,'9G999G990D00MI');
262: vCtr := vCtr + 1;
263: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_AMT_2';
264: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_amt_2,'9G999G990D00MI');

Line 261: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_amt_2,'9G999G990D00MI');

257: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_AMT_2';
258: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_amt_2,'9G999G990D00MI');
259: vCtr := vCtr + 1;
260: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_AMT_2';
261: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_amt_2,'9G999G990D00MI');
262: vCtr := vCtr + 1;
263: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_AMT_2';
264: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_amt_2,'9G999G990D00MI');
265: vCtr := vCtr + 1;

Line 263: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_AMT_2';

259: vCtr := vCtr + 1;
260: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_AMT_2';
261: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_amt_2,'9G999G990D00MI');
262: vCtr := vCtr + 1;
263: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_AMT_2';
264: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_amt_2,'9G999G990D00MI');
265: vCtr := vCtr + 1;
266: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_AMT_2';
267: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_amt_2,'9G999G990D00MI');

Line 264: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_amt_2,'9G999G990D00MI');

260: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_AMT_2';
261: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_amt_2,'9G999G990D00MI');
262: vCtr := vCtr + 1;
263: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_AMT_2';
264: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_amt_2,'9G999G990D00MI');
265: vCtr := vCtr + 1;
266: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_AMT_2';
267: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_amt_2,'9G999G990D00MI');
268: vCtr := vCtr + 1;

Line 266: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_AMT_2';

262: vCtr := vCtr + 1;
263: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_AMT_2';
264: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_amt_2,'9G999G990D00MI');
265: vCtr := vCtr + 1;
266: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_AMT_2';
267: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_amt_2,'9G999G990D00MI');
268: vCtr := vCtr + 1;
269: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_CORR_1';
270: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_corr_1,'9G999G990D00MI');

Line 267: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_amt_2,'9G999G990D00MI');

263: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_AMT_2';
264: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_amt_2,'9G999G990D00MI');
265: vCtr := vCtr + 1;
266: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_AMT_2';
267: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_amt_2,'9G999G990D00MI');
268: vCtr := vCtr + 1;
269: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_CORR_1';
270: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_corr_1,'9G999G990D00MI');
271: vCtr := vCtr + 1;

Line 269: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_CORR_1';

265: vCtr := vCtr + 1;
266: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_AMT_2';
267: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_amt_2,'9G999G990D00MI');
268: vCtr := vCtr + 1;
269: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_CORR_1';
270: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_corr_1,'9G999G990D00MI');
271: vCtr := vCtr + 1;
272: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_CORR_1';
273: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_corr_1,'9G999G990D00MI');

Line 270: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_corr_1,'9G999G990D00MI');

266: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_AMT_2';
267: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_amt_2,'9G999G990D00MI');
268: vCtr := vCtr + 1;
269: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_CORR_1';
270: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_corr_1,'9G999G990D00MI');
271: vCtr := vCtr + 1;
272: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_CORR_1';
273: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_corr_1,'9G999G990D00MI');
274: vCtr := vCtr + 1;

Line 272: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_CORR_1';

268: vCtr := vCtr + 1;
269: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_CORR_1';
270: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_corr_1,'9G999G990D00MI');
271: vCtr := vCtr + 1;
272: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_CORR_1';
273: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_corr_1,'9G999G990D00MI');
274: vCtr := vCtr + 1;
275: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_CORR_1';
276: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_corr_1,'9G999G990D00MI');

Line 273: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_corr_1,'9G999G990D00MI');

269: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_CORR_1';
270: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_corr_1,'9G999G990D00MI');
271: vCtr := vCtr + 1;
272: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_CORR_1';
273: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_corr_1,'9G999G990D00MI');
274: vCtr := vCtr + 1;
275: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_CORR_1';
276: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_corr_1,'9G999G990D00MI');
277: vCtr := vCtr + 1;

Line 275: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_CORR_1';

271: vCtr := vCtr + 1;
272: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_CORR_1';
273: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_corr_1,'9G999G990D00MI');
274: vCtr := vCtr + 1;
275: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_CORR_1';
276: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_corr_1,'9G999G990D00MI');
277: vCtr := vCtr + 1;
278: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_CORR_1';
279: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_corr_1,'9G999G990D00MI');

Line 276: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_corr_1,'9G999G990D00MI');

272: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_CORR_1';
273: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_corr_1,'9G999G990D00MI');
274: vCtr := vCtr + 1;
275: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_CORR_1';
276: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_corr_1,'9G999G990D00MI');
277: vCtr := vCtr + 1;
278: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_CORR_1';
279: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_corr_1,'9G999G990D00MI');
280: vCtr := vCtr + 1;

Line 278: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_CORR_1';

274: vCtr := vCtr + 1;
275: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_CORR_1';
276: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_corr_1,'9G999G990D00MI');
277: vCtr := vCtr + 1;
278: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_CORR_1';
279: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_corr_1,'9G999G990D00MI');
280: vCtr := vCtr + 1;
281: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_CORR_2';
282: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_corr_2,'9G999G990D00MI');

Line 279: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_corr_1,'9G999G990D00MI');

275: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_CORR_1';
276: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_corr_1,'9G999G990D00MI');
277: vCtr := vCtr + 1;
278: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_CORR_1';
279: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_corr_1,'9G999G990D00MI');
280: vCtr := vCtr + 1;
281: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_CORR_2';
282: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_corr_2,'9G999G990D00MI');
283: vCtr := vCtr + 1;

Line 281: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_CORR_2';

277: vCtr := vCtr + 1;
278: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_CORR_1';
279: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_corr_1,'9G999G990D00MI');
280: vCtr := vCtr + 1;
281: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_CORR_2';
282: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_corr_2,'9G999G990D00MI');
283: vCtr := vCtr + 1;
284: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_CORR_2';
285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_corr_2,'9G999G990D00MI');

Line 282: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_corr_2,'9G999G990D00MI');

278: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_CORR_1';
279: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_corr_1,'9G999G990D00MI');
280: vCtr := vCtr + 1;
281: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_CORR_2';
282: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_corr_2,'9G999G990D00MI');
283: vCtr := vCtr + 1;
284: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_CORR_2';
285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_corr_2,'9G999G990D00MI');
286: vCtr := vCtr + 1;

Line 284: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_CORR_2';

280: vCtr := vCtr + 1;
281: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_CORR_2';
282: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_corr_2,'9G999G990D00MI');
283: vCtr := vCtr + 1;
284: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_CORR_2';
285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_corr_2,'9G999G990D00MI');
286: vCtr := vCtr + 1;
287: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_CORR_2';
288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_corr_2,'9G999G990D00MI');

Line 285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_corr_2,'9G999G990D00MI');

281: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_CORR_2';
282: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_corr_2,'9G999G990D00MI');
283: vCtr := vCtr + 1;
284: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_CORR_2';
285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_corr_2,'9G999G990D00MI');
286: vCtr := vCtr + 1;
287: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_CORR_2';
288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_corr_2,'9G999G990D00MI');
289: vCtr := vCtr + 1;

Line 287: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_CORR_2';

283: vCtr := vCtr + 1;
284: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_CORR_2';
285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_corr_2,'9G999G990D00MI');
286: vCtr := vCtr + 1;
287: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_CORR_2';
288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_corr_2,'9G999G990D00MI');
289: vCtr := vCtr + 1;
290: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_CORR_2';
291: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_corr_2,'9G999G990D00MI');

Line 288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_corr_2,'9G999G990D00MI');

284: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_CORR_2';
285: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_corr_2,'9G999G990D00MI');
286: vCtr := vCtr + 1;
287: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_CORR_2';
288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_corr_2,'9G999G990D00MI');
289: vCtr := vCtr + 1;
290: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_CORR_2';
291: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_corr_2,'9G999G990D00MI');
292: vCtr := vCtr + 1;

Line 290: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_CORR_2';

286: vCtr := vCtr + 1;
287: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_CORR_2';
288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_corr_2,'9G999G990D00MI');
289: vCtr := vCtr + 1;
290: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_CORR_2';
291: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_corr_2,'9G999G990D00MI');
292: vCtr := vCtr + 1;
293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_TOTAL';
294: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_total,'99G999G999G990D00MI');

Line 291: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_corr_2,'9G999G990D00MI');

287: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_CORR_2';
288: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_corr_2,'9G999G990D00MI');
289: vCtr := vCtr + 1;
290: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_CORR_2';
291: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_corr_2,'9G999G990D00MI');
292: vCtr := vCtr + 1;
293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_TOTAL';
294: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_total,'99G999G999G990D00MI');
295: vCtr := vCtr + 1;

Line 293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_TOTAL';

289: vCtr := vCtr + 1;
290: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_CORR_2';
291: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_corr_2,'9G999G990D00MI');
292: vCtr := vCtr + 1;
293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_TOTAL';
294: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_total,'99G999G999G990D00MI');
295: vCtr := vCtr + 1;
296: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_TOTAL';
297: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_total,'99G999G999G990D00MI');

Line 294: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_total,'99G999G999G990D00MI');

290: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_CORR_2';
291: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_corr_2,'9G999G990D00MI');
292: vCtr := vCtr + 1;
293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_TOTAL';
294: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_total,'99G999G999G990D00MI');
295: vCtr := vCtr + 1;
296: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_TOTAL';
297: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_total,'99G999G999G990D00MI');
298: vCtr := vCtr + 1;

Line 296: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_TOTAL';

292: vCtr := vCtr + 1;
293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_TOTAL';
294: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_total,'99G999G999G990D00MI');
295: vCtr := vCtr + 1;
296: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_TOTAL';
297: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_total,'99G999G999G990D00MI');
298: vCtr := vCtr + 1;
299: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_TOTAL';
300: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_total,'99G999G999G990D00MI');

Line 297: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_total,'99G999G999G990D00MI');

293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'TAPE_TOTAL';
294: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_tape_total,'99G999G999G990D00MI');
295: vCtr := vCtr + 1;
296: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_TOTAL';
297: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_total,'99G999G999G990D00MI');
298: vCtr := vCtr + 1;
299: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_TOTAL';
300: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_total,'99G999G999G990D00MI');
301: vCtr := vCtr + 1;

Line 299: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_TOTAL';

295: vCtr := vCtr + 1;
296: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_TOTAL';
297: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_total,'99G999G999G990D00MI');
298: vCtr := vCtr + 1;
299: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_TOTAL';
300: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_total,'99G999G999G990D00MI');
301: vCtr := vCtr + 1;
302: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_TOTAL';
303: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_total,'99G999G999G990D00MI');

Line 300: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_total,'99G999G999G990D00MI');

296: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ACCEPTED_TOTAL';
297: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_accepted_total,'99G999G999G990D00MI');
298: vCtr := vCtr + 1;
299: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_TOTAL';
300: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_total,'99G999G999G990D00MI');
301: vCtr := vCtr + 1;
302: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_TOTAL';
303: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_total,'99G999G999G990D00MI');
304: vCtr := vCtr + 1;

Line 302: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_TOTAL';

298: vCtr := vCtr + 1;
299: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_TOTAL';
300: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_total,'99G999G999G990D00MI');
301: vCtr := vCtr + 1;
302: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_TOTAL';
303: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_total,'99G999G999G990D00MI');
304: vCtr := vCtr + 1;
305: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EARLIEST_CORRECTION_DATE';
306: l_earliest_correction_date1 := to_char(l_earliest_correction_date,'DD-MM-YY');

Line 303: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_total,'99G999G999G990D00MI');

299: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REJECTED_TOTAL';
300: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_rejected_total,'99G999G999G990D00MI');
301: vCtr := vCtr + 1;
302: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_TOTAL';
303: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_total,'99G999G999G990D00MI');
304: vCtr := vCtr + 1;
305: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EARLIEST_CORRECTION_DATE';
306: l_earliest_correction_date1 := to_char(l_earliest_correction_date,'DD-MM-YY');
307: if l_earliest_correction_date = hr_general.end_of_time then

Line 305: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EARLIEST_CORRECTION_DATE';

301: vCtr := vCtr + 1;
302: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'RETRO_TOTAL';
303: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := to_char(l_retro_total,'99G999G999G990D00MI');
304: vCtr := vCtr + 1;
305: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'EARLIEST_CORRECTION_DATE';
306: l_earliest_correction_date1 := to_char(l_earliest_correction_date,'DD-MM-YY');
307: if l_earliest_correction_date = hr_general.end_of_time then
308: l_earliest_correction_date1 := NULL;
309: end if;

Line 310: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_earliest_correction_date1;

306: l_earliest_correction_date1 := to_char(l_earliest_correction_date,'DD-MM-YY');
307: if l_earliest_correction_date = hr_general.end_of_time then
308: l_earliest_correction_date1 := NULL;
309: end if;
310: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_earliest_correction_date1;
311:
312: pay_nl_xdo_Report.WritetoCLOB_rtf(p_xfdf_blob );
313:
314: end populate_iza_report_data;

Line 312: pay_nl_xdo_Report.WritetoCLOB_rtf(p_xfdf_blob );

308: l_earliest_correction_date1 := NULL;
309: end if;
310: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_earliest_correction_date1;
311:
312: pay_nl_xdo_Report.WritetoCLOB_rtf(p_xfdf_blob );
313:
314: end populate_iza_report_data;
315:
316: