85:
86: l_end_date_char := fnd_date.date_to_displaydate(p_end_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* BUG 11830805 */
87:
88:
89: l_tag := pay_prl_xml_utils.getTag('CP_CONSOLIDATION_SET_NAME', p_consolidation_set_name );
90: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
91:
92: l_tag := pay_prl_xml_utils.getTag('CP_PAYROLL_NAME',p_payroll_name);
93: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
88:
89: l_tag := pay_prl_xml_utils.getTag('CP_CONSOLIDATION_SET_NAME', p_consolidation_set_name );
90: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
91:
92: l_tag := pay_prl_xml_utils.getTag('CP_PAYROLL_NAME',p_payroll_name);
93: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
94:
95: l_tag := pay_prl_xml_utils.getTag('CP_BUSINESS_GROUP_NAME',p_business_group_name);
96: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
91:
92: l_tag := pay_prl_xml_utils.getTag('CP_PAYROLL_NAME',p_payroll_name);
93: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
94:
95: l_tag := pay_prl_xml_utils.getTag('CP_BUSINESS_GROUP_NAME',p_business_group_name);
96: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
97:
98: l_tag := pay_prl_xml_utils.getTag('CP_RECORD_COUNT',p_record_counter);
99: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
94:
95: l_tag := pay_prl_xml_utils.getTag('CP_BUSINESS_GROUP_NAME',p_business_group_name);
96: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
97:
98: l_tag := pay_prl_xml_utils.getTag('CP_RECORD_COUNT',p_record_counter);
99: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
100:
101: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_NAME',p_report_name);
102: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
97:
98: l_tag := pay_prl_xml_utils.getTag('CP_RECORD_COUNT',p_record_counter);
99: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
100:
101: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_NAME',p_report_name);
102: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
103:
104: l_tag := pay_prl_xml_utils.getTag('CP_MODE_DESC',p_mode_desc);
105: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
100:
101: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_NAME',p_report_name);
102: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
103:
104: l_tag := pay_prl_xml_utils.getTag('CP_MODE_DESC',p_mode_desc);
105: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
106:
107: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_DATE', p_report_date );
108: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
103:
104: l_tag := pay_prl_xml_utils.getTag('CP_MODE_DESC',p_mode_desc);
105: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
106:
107: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_DATE', p_report_date );
108: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
109:
110: l_tag := pay_prl_xml_utils.getTag('CP_START_DATE',l_start_date_char);
111: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
106:
107: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_DATE', p_report_date );
108: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
109:
110: l_tag := pay_prl_xml_utils.getTag('CP_START_DATE',l_start_date_char);
111: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
112:
113: l_tag := pay_prl_xml_utils.getTag('CP_END_DATE',l_end_date_char);
114: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
109:
110: l_tag := pay_prl_xml_utils.getTag('CP_START_DATE',l_start_date_char);
111: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
112:
113: l_tag := pay_prl_xml_utils.getTag('CP_END_DATE',l_end_date_char);
114: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
115:
116: l_tag := pay_prl_xml_utils.getTag('CP_TEMPLATE_NAME',p_template_name);
117: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
112:
113: l_tag := pay_prl_xml_utils.getTag('CP_END_DATE',l_end_date_char);
114: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
115:
116: l_tag := pay_prl_xml_utils.getTag('CP_TEMPLATE_NAME',p_template_name);
117: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
118:
119: end;
120:
138:
139: l_tag varchar2(200);
140:
141: begin
142: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);
143: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
144:
145: l_tag := pay_prl_xml_utils.getTag('PAYROLL_NAME',p_payroll_name);
146: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
141: begin
142: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);
143: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
144:
145: l_tag := pay_prl_xml_utils.getTag('PAYROLL_NAME',p_payroll_name);
146: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
147:
148: l_tag := pay_prl_xml_utils.getTag('EFFECTIVE_DATE',p_effective_date);
149: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
144:
145: l_tag := pay_prl_xml_utils.getTag('PAYROLL_NAME',p_payroll_name);
146: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
147:
148: l_tag := pay_prl_xml_utils.getTag('EFFECTIVE_DATE',p_effective_date);
149: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
150:
151: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_NUMBER',p_assignment_number);
152: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
147:
148: l_tag := pay_prl_xml_utils.getTag('EFFECTIVE_DATE',p_effective_date);
149: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
150:
151: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_NUMBER',p_assignment_number);
152: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
153:
154: l_tag := pay_prl_xml_utils.getTag('ACTION_TYPE',p_action_type);
155: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
150:
151: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_NUMBER',p_assignment_number);
152: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
153:
154: l_tag := pay_prl_xml_utils.getTag('ACTION_TYPE',p_action_type);
155: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
156:
157: l_tag := pay_prl_xml_utils.getTag('ACTION_NUMBER',p_action_number);
158: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
153:
154: l_tag := pay_prl_xml_utils.getTag('ACTION_TYPE',p_action_type);
155: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
156:
157: l_tag := pay_prl_xml_utils.getTag('ACTION_NUMBER',p_action_number);
158: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
159:
160: l_tag := pay_prl_xml_utils.getTag('PERSON_ID',p_person_id);
161: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
156:
157: l_tag := pay_prl_xml_utils.getTag('ACTION_NUMBER',p_action_number);
158: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
159:
160: l_tag := pay_prl_xml_utils.getTag('PERSON_ID',p_person_id);
161: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
162:
163: l_tag := pay_prl_xml_utils.getTag('FULL_NAME',p_full_name);
164: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
159:
160: l_tag := pay_prl_xml_utils.getTag('PERSON_ID',p_person_id);
161: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
162:
163: l_tag := pay_prl_xml_utils.getTag('FULL_NAME',p_full_name);
164: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
165:
166: l_tag := pay_prl_xml_utils.getTag('EMPLOYEE_NUMBER',p_employee_number);
167: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
162:
163: l_tag := pay_prl_xml_utils.getTag('FULL_NAME',p_full_name);
164: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
165:
166: l_tag := pay_prl_xml_utils.getTag('EMPLOYEE_NUMBER',p_employee_number);
167: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
168:
169: l_tag := pay_prl_xml_utils.getTag('CF_ACTION_TYPE',p_action_type_meaning);
170: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
165:
166: l_tag := pay_prl_xml_utils.getTag('EMPLOYEE_NUMBER',p_employee_number);
167: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
168:
169: l_tag := pay_prl_xml_utils.getTag('CF_ACTION_TYPE',p_action_type_meaning);
170: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
171:
172: l_tag := pay_prl_xml_utils.getTag('CF_RECORD_COUNTER',p_record_counter);
173: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
168:
169: l_tag := pay_prl_xml_utils.getTag('CF_ACTION_TYPE',p_action_type_meaning);
170: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
171:
172: l_tag := pay_prl_xml_utils.getTag('CF_RECORD_COUNTER',p_record_counter);
173: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
174:
175: end append_group_data;
176: