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_PAYRPENP_XML_PKG dependencies on PAY_PRL_XML_UTILS

Line 76: l_tag := pay_prl_xml_utils.getTag('CP_ORGANIZATION_NAME', p_organization_name );

72: l_start_date_char := fnd_date.date_to_displaydate(p_start_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
73: l_end_date_char := fnd_date.date_to_displaydate(p_end_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
74:
75:
76: l_tag := pay_prl_xml_utils.getTag('CP_ORGANIZATION_NAME', p_organization_name );
77: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
78:
79: l_tag := pay_prl_xml_utils.getTag('CP_PAYROLL_NAME',p_payroll_name);
80: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 79: l_tag := pay_prl_xml_utils.getTag('CP_PAYROLL_NAME',p_payroll_name);

75:
76: l_tag := pay_prl_xml_utils.getTag('CP_ORGANIZATION_NAME', p_organization_name );
77: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
78:
79: l_tag := pay_prl_xml_utils.getTag('CP_PAYROLL_NAME',p_payroll_name);
80: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
81:
82: l_tag := pay_prl_xml_utils.getTag('CP_LOCATION_CODE',p_location_code);
83: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 82: l_tag := pay_prl_xml_utils.getTag('CP_LOCATION_CODE',p_location_code);

78:
79: l_tag := pay_prl_xml_utils.getTag('CP_PAYROLL_NAME',p_payroll_name);
80: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
81:
82: l_tag := pay_prl_xml_utils.getTag('CP_LOCATION_CODE',p_location_code);
83: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
84:
85: l_tag := pay_prl_xml_utils.getTag('CP_CONSOLIDATION_SET_NAME',p_consolidation_set_name);
86: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 85: l_tag := pay_prl_xml_utils.getTag('CP_CONSOLIDATION_SET_NAME',p_consolidation_set_name);

81:
82: l_tag := pay_prl_xml_utils.getTag('CP_LOCATION_CODE',p_location_code);
83: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
84:
85: l_tag := pay_prl_xml_utils.getTag('CP_CONSOLIDATION_SET_NAME',p_consolidation_set_name);
86: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
87:
88: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);
89: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 88: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);

84:
85: l_tag := pay_prl_xml_utils.getTag('CP_CONSOLIDATION_SET_NAME',p_consolidation_set_name);
86: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
87:
88: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);
89: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
90:
91: l_tag := pay_prl_xml_utils.getTag('CP_BUSINESS_GROUP_NAME',p_business_group_name);
92: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 91: l_tag := pay_prl_xml_utils.getTag('CP_BUSINESS_GROUP_NAME',p_business_group_name);

87:
88: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);
89: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
90:
91: l_tag := pay_prl_xml_utils.getTag('CP_BUSINESS_GROUP_NAME',p_business_group_name);
92: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
93:
94: l_tag := pay_prl_xml_utils.getTag('CP_NO_DATA_FOUND', to_char(p_no_data_found) );
95: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 94: l_tag := pay_prl_xml_utils.getTag('CP_NO_DATA_FOUND', to_char(p_no_data_found) );

90:
91: l_tag := pay_prl_xml_utils.getTag('CP_BUSINESS_GROUP_NAME',p_business_group_name);
92: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
93:
94: l_tag := pay_prl_xml_utils.getTag('CP_NO_DATA_FOUND', to_char(p_no_data_found) );
95: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
96:
97: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_DATE',p_report_date);
98: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 97: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_DATE',p_report_date);

93:
94: l_tag := pay_prl_xml_utils.getTag('CP_NO_DATA_FOUND', to_char(p_no_data_found) );
95: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
96:
97: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_DATE',p_report_date);
98: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
99:
100: l_tag := pay_prl_xml_utils.getTag('CP_START_DATE',l_start_date_char);
101: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 100: l_tag := pay_prl_xml_utils.getTag('CP_START_DATE',l_start_date_char);

96:
97: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_DATE',p_report_date);
98: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
99:
100: l_tag := pay_prl_xml_utils.getTag('CP_START_DATE',l_start_date_char);
101: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
102:
103: l_tag := pay_prl_xml_utils.getTag('CP_END_DATE',l_end_date_char);
104: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 103: l_tag := pay_prl_xml_utils.getTag('CP_END_DATE',l_end_date_char);

99:
100: l_tag := pay_prl_xml_utils.getTag('CP_START_DATE',l_start_date_char);
101: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
102:
103: l_tag := pay_prl_xml_utils.getTag('CP_END_DATE',l_end_date_char);
104: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
105:
106: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN1',get_display_name(p_group_column1));
107: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 106: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN1',get_display_name(p_group_column1));

102:
103: l_tag := pay_prl_xml_utils.getTag('CP_END_DATE',l_end_date_char);
104: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
105:
106: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN1',get_display_name(p_group_column1));
107: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
108:
109: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN2',get_display_name(p_group_column2));
110: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 109: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN2',get_display_name(p_group_column2));

105:
106: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN1',get_display_name(p_group_column1));
107: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
108:
109: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN2',get_display_name(p_group_column2));
110: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
111:
112: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN3',get_display_name(p_group_column3));
113: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 112: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN3',get_display_name(p_group_column3));

108:
109: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN2',get_display_name(p_group_column2));
110: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
111:
112: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN3',get_display_name(p_group_column3));
113: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
114:
115: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION1',p_sort_option_one);
116: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 115: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION1',p_sort_option_one);

111:
112: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN3',get_display_name(p_group_column3));
113: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
114:
115: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION1',p_sort_option_one);
116: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
117:
118: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION2',p_sort_option_two);
119: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 118: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION2',p_sort_option_two);

114:
115: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION1',p_sort_option_one);
116: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
117:
118: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION2',p_sort_option_two);
119: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
120:
121: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION3',p_sort_option_three);
122: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 121: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION3',p_sort_option_three);

117:
118: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION2',p_sort_option_two);
119: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
120:
121: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION3',p_sort_option_three);
122: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
123:
124: l_tag := pay_prl_xml_utils.getTag('CP_TEMPLATE_NAME',p_template_name);
125: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 124: l_tag := pay_prl_xml_utils.getTag('CP_TEMPLATE_NAME',p_template_name);

120:
121: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION3',p_sort_option_three);
122: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
123:
124: l_tag := pay_prl_xml_utils.getTag('CP_TEMPLATE_NAME',p_template_name);
125: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
126:
127: end;
128:

Line 142: l_tag := pay_prl_xml_utils.getTag('REG_A',p_master_column1);

138:
139: l_tag varchar2(200);
140:
141: begin
142: l_tag := pay_prl_xml_utils.getTag('REG_A',p_master_column1);
143: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
144:
145: l_tag := pay_prl_xml_utils.getTag('REG_B',p_master_column2);
146: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 145: l_tag := pay_prl_xml_utils.getTag('REG_B',p_master_column2);

141: begin
142: l_tag := pay_prl_xml_utils.getTag('REG_A',p_master_column1);
143: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
144:
145: l_tag := pay_prl_xml_utils.getTag('REG_B',p_master_column2);
146: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
147:
148: l_tag := pay_prl_xml_utils.getTag('REG_C',p_master_column3);
149: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 148: l_tag := pay_prl_xml_utils.getTag('REG_C',p_master_column3);

144:
145: l_tag := pay_prl_xml_utils.getTag('REG_B',p_master_column2);
146: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
147:
148: l_tag := pay_prl_xml_utils.getTag('REG_C',p_master_column3);
149: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
150:
151: end;
152:

Line 178: l_tag := pay_prl_xml_utils.getTag('ICX_PERIOD_START_DATE', to_char(p_ICX_period_start_date) );

174:
175: l_tag varchar2(200);
176:
177: begin
178: l_tag := pay_prl_xml_utils.getTag('ICX_PERIOD_START_DATE', to_char(p_ICX_period_start_date) );
179: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
180:
181: l_tag := pay_prl_xml_utils.getTag('ICX_PERIOD_END_DATE',p_ICX_period_end_date);
182: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 181: l_tag := pay_prl_xml_utils.getTag('ICX_PERIOD_END_DATE',p_ICX_period_end_date);

177: begin
178: l_tag := pay_prl_xml_utils.getTag('ICX_PERIOD_START_DATE', to_char(p_ICX_period_start_date) );
179: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
180:
181: l_tag := pay_prl_xml_utils.getTag('ICX_PERIOD_END_DATE',p_ICX_period_end_date);
182: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
183:
184: l_tag := pay_prl_xml_utils.getTag('ORDER_NAME',p_order_name);
185: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 184: l_tag := pay_prl_xml_utils.getTag('ORDER_NAME',p_order_name);

180:
181: l_tag := pay_prl_xml_utils.getTag('ICX_PERIOD_END_DATE',p_ICX_period_end_date);
182: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
183:
184: l_tag := pay_prl_xml_utils.getTag('ORDER_NAME',p_order_name);
185: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
186:
187: l_tag := pay_prl_xml_utils.getTag('ORGANIZATION_NAME',p_organization_name);
188: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 187: l_tag := pay_prl_xml_utils.getTag('ORGANIZATION_NAME',p_organization_name);

183:
184: l_tag := pay_prl_xml_utils.getTag('ORDER_NAME',p_order_name);
185: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
186:
187: l_tag := pay_prl_xml_utils.getTag('ORGANIZATION_NAME',p_organization_name);
188: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
189:
190: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);
191: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 190: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);

186:
187: l_tag := pay_prl_xml_utils.getTag('ORGANIZATION_NAME',p_organization_name);
188: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
189:
190: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);
191: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
192:
193: l_tag := pay_prl_xml_utils.getTag('PAYROLL_NAME',p_payroll_name);
194: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 193: l_tag := pay_prl_xml_utils.getTag('PAYROLL_NAME',p_payroll_name);

189:
190: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);
191: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
192:
193: l_tag := pay_prl_xml_utils.getTag('PAYROLL_NAME',p_payroll_name);
194: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
195:
196: l_tag := pay_prl_xml_utils.getTag('LOCATION_CODE',p_location_code);
197: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 196: l_tag := pay_prl_xml_utils.getTag('LOCATION_CODE',p_location_code);

192:
193: l_tag := pay_prl_xml_utils.getTag('PAYROLL_NAME',p_payroll_name);
194: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
195:
196: l_tag := pay_prl_xml_utils.getTag('LOCATION_CODE',p_location_code);
197: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
198:
199: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_ID',p_assignment_id);
200: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 199: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_ID',p_assignment_id);

195:
196: l_tag := pay_prl_xml_utils.getTag('LOCATION_CODE',p_location_code);
197: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
198:
199: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_ID',p_assignment_id);
200: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
201:
202: l_tag := pay_prl_xml_utils.getTag('PAY_BASIS',p_pay_basis);
203: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 202: l_tag := pay_prl_xml_utils.getTag('PAY_BASIS',p_pay_basis);

198:
199: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_ID',p_assignment_id);
200: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
201:
202: l_tag := pay_prl_xml_utils.getTag('PAY_BASIS',p_pay_basis);
203: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
204:
205: l_tag := pay_prl_xml_utils.getTag('FULL_NAME',p_full_name);
206: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 205: l_tag := pay_prl_xml_utils.getTag('FULL_NAME',p_full_name);

201:
202: l_tag := pay_prl_xml_utils.getTag('PAY_BASIS',p_pay_basis);
203: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
204:
205: l_tag := pay_prl_xml_utils.getTag('FULL_NAME',p_full_name);
206: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
207:
208: l_tag := pay_prl_xml_utils.getTag('USER_STATUS',p_user_status);
209: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 208: l_tag := pay_prl_xml_utils.getTag('USER_STATUS',p_user_status);

204:
205: l_tag := pay_prl_xml_utils.getTag('FULL_NAME',p_full_name);
206: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
207:
208: l_tag := pay_prl_xml_utils.getTag('USER_STATUS',p_user_status);
209: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
210:
211: l_tag := pay_prl_xml_utils.getTag('PERSON_ID',p_person_id);
212: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 211: l_tag := pay_prl_xml_utils.getTag('PERSON_ID',p_person_id);

207:
208: l_tag := pay_prl_xml_utils.getTag('USER_STATUS',p_user_status);
209: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
210:
211: l_tag := pay_prl_xml_utils.getTag('PERSON_ID',p_person_id);
212: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
213:
214: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_NUMBER',p_assignment_number);
215: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 214: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_NUMBER',p_assignment_number);

210:
211: l_tag := pay_prl_xml_utils.getTag('PERSON_ID',p_person_id);
212: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
213:
214: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_NUMBER',p_assignment_number);
215: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
216:
217: l_tag := pay_prl_xml_utils.getTag('CF_ABSENCE_TYPE',p_cf_absence_type);
218: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 217: l_tag := pay_prl_xml_utils.getTag('CF_ABSENCE_TYPE',p_cf_absence_type);

213:
214: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_NUMBER',p_assignment_number);
215: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
216:
217: l_tag := pay_prl_xml_utils.getTag('CF_ABSENCE_TYPE',p_cf_absence_type);
218: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
219:
220: l_tag := pay_prl_xml_utils.getTag('CF_DATA_FOUND',p_cf_data_found);
221: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 220: l_tag := pay_prl_xml_utils.getTag('CF_DATA_FOUND',p_cf_data_found);

216:
217: l_tag := pay_prl_xml_utils.getTag('CF_ABSENCE_TYPE',p_cf_absence_type);
218: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
219:
220: l_tag := pay_prl_xml_utils.getTag('CF_DATA_FOUND',p_cf_data_found);
221: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
222:
223: end append_detail_group_data;
224: