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 DBMS_LOB

Line 77: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
81:

Line 80: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
84:

Line 83: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
87:

Line 86: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
90:

Line 89: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
93:

Line 92: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
96:

Line 95: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
99:

Line 98: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
102:

Line 101: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
105:

Line 104: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
108:

Line 107: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
111:

Line 110: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
114:

Line 113: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
117:

Line 116: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
120:

Line 119: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
123:

Line 122: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
126:

Line 125: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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:
129: --

Line 143: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
147:

Line 146: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
150:

Line 149: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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:
153: --

Line 179: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
183:

Line 182: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
186:

Line 185: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
189:

Line 188: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
192:

Line 191: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
195:

Line 194: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
198:

Line 197: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
201:

Line 200: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
204:

Line 203: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
207:

Line 206: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
210:

Line 209: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
213:

Line 212: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
216:

Line 215: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
219:

Line 218: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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);
222:

Line 221: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

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:
225: --

Line 649: dbms_lob.createtemporary(g_xml_data,false,dbms_lob.call);

645: ' and NVL ('|| l_group_column3 || ' , ''-1'' ) = NVL( :5, ''-1'')' ||
646: ' order by '||l_order_by_clause;
647:
648:
649: dbms_lob.createtemporary(g_xml_data,false,dbms_lob.call);
650: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
651:
652: l_tag :='';
653: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 650: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);

646: ' order by '||l_order_by_clause;
647:
648:
649: dbms_lob.createtemporary(g_xml_data,false,dbms_lob.call);
650: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
651:
652: l_tag :='';
653: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
654:

Line 653: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

649: dbms_lob.createtemporary(g_xml_data,false,dbms_lob.call);
650: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
651:
652: l_tag :='';
653: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
654:
655: l_tag := '';
656: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
657:

Line 656: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

652: l_tag :='';
653: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
654:
655: l_tag := '';
656: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
657:
658: l_tag := '';
659: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
660:

Line 659: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

655: l_tag := '';
656: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
657:
658: l_tag := '';
659: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
660:
661: cf_data_found := 0;
662:
663: open csr_master for l_master_statement using fnd_date.canonical_to_date(p_start_date_char),

Line 671: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

667: fetch csr_master into l_master_column1,l_master_column2,l_master_column3;
668: exit when csr_master%notfound;
669:
670: l_tag := '';
671: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
672:
673: append_master_group_data(
674: l_master_column1,
675: l_master_column2,

Line 686: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

682: l_master_column2,
683: l_master_column3;
684:
685: l_tag := '';
686: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
687:
688: loop
689:
690: fetch csr_detail into c_detail_rec;

Line 704: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

700: ,c_detail_rec.person_id
701: );
702:
703: l_tag := '';
704: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
705: append_detail_group_data(
706: c_detail_rec.ICX_period_start_date
707: ,c_detail_rec.ICX_period_end_date
708: ,c_detail_rec.order_name

Line 724: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

720: ,cf_absence_type
721: ,cf_data_found
722: );
723: l_tag := '';
724: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
725:
726: --dbms_output.put_line('Full Name = ' || c_detail_rec.full_name);
727: end loop;
728: close csr_detail;

Line 731: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

727: end loop;
728: close csr_detail;
729:
730: l_tag := '';
731: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
732:
733: l_tag := '';
734: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
735:

Line 734: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

730: l_tag := '';
731: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
732:
733: l_tag := '';
734: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
735:
736: end loop;
737: close csr_master;
738:

Line 740: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

736: end loop;
737: close csr_master;
738:
739: l_tag := '';
740: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
741:
742: --
743: --
744: --

Line 771: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

767: ,l_template_name
768: );
769:
770: l_tag := '';
771: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
772:
773: p_xml := g_xml_data;
774:
775: end emp_asg_not_processed;