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.JA_CN_CFS_IMA_PKG dependencies on DUAL

Line 263: SELECT XMLELEMENT("P_APPLICATION_NAME",l_Application_Name) INTO l_xml_item FROM dual;

259: l_characterset :=Fnd_Profile.VALUE(NAME => 'ICX_CLIENT_IANA_ENCODING');
260: FND_FILE.put_line(FND_FILE.output,'');
261: --FND_FILE.put_line(FND_FILE.output,'');
262: l_xml_report := NULL;
263: SELECT XMLELEMENT("P_APPLICATION_NAME",l_Application_Name) INTO l_xml_item FROM dual;
264: l_xml_parameter := l_xml_item;
265: SELECT XMLELEMENT("P_SUPPORTING_REFERENCE_CODE",l_Analyciatl_Criterion_Code ) INTO l_xml_item FROM dual;
266: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
267: SELECT XMLELEMENT("P_EVENT_CLASS_NAME",l_Event_Class_Name) INTO l_xml_item FROM dual;

Line 265: SELECT XMLELEMENT("P_SUPPORTING_REFERENCE_CODE",l_Analyciatl_Criterion_Code ) INTO l_xml_item FROM dual;

261: --FND_FILE.put_line(FND_FILE.output,'');
262: l_xml_report := NULL;
263: SELECT XMLELEMENT("P_APPLICATION_NAME",l_Application_Name) INTO l_xml_item FROM dual;
264: l_xml_parameter := l_xml_item;
265: SELECT XMLELEMENT("P_SUPPORTING_REFERENCE_CODE",l_Analyciatl_Criterion_Code ) INTO l_xml_item FROM dual;
266: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
267: SELECT XMLELEMENT("P_EVENT_CLASS_NAME",l_Event_Class_Name) INTO l_xml_item FROM dual;
268: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
269: SELECT XMLCONCAT(l_xml_report,l_xml_parameter) INTO l_xml_report FROM dual;

Line 266: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;

262: l_xml_report := NULL;
263: SELECT XMLELEMENT("P_APPLICATION_NAME",l_Application_Name) INTO l_xml_item FROM dual;
264: l_xml_parameter := l_xml_item;
265: SELECT XMLELEMENT("P_SUPPORTING_REFERENCE_CODE",l_Analyciatl_Criterion_Code ) INTO l_xml_item FROM dual;
266: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
267: SELECT XMLELEMENT("P_EVENT_CLASS_NAME",l_Event_Class_Name) INTO l_xml_item FROM dual;
268: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
269: SELECT XMLCONCAT(l_xml_report,l_xml_parameter) INTO l_xml_report FROM dual;
270:

Line 267: SELECT XMLELEMENT("P_EVENT_CLASS_NAME",l_Event_Class_Name) INTO l_xml_item FROM dual;

263: SELECT XMLELEMENT("P_APPLICATION_NAME",l_Application_Name) INTO l_xml_item FROM dual;
264: l_xml_parameter := l_xml_item;
265: SELECT XMLELEMENT("P_SUPPORTING_REFERENCE_CODE",l_Analyciatl_Criterion_Code ) INTO l_xml_item FROM dual;
266: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
267: SELECT XMLELEMENT("P_EVENT_CLASS_NAME",l_Event_Class_Name) INTO l_xml_item FROM dual;
268: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
269: SELECT XMLCONCAT(l_xml_report,l_xml_parameter) INTO l_xml_report FROM dual;
270:
271: --get head infomation according to the parameters inputed.

Line 268: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;

264: l_xml_parameter := l_xml_item;
265: SELECT XMLELEMENT("P_SUPPORTING_REFERENCE_CODE",l_Analyciatl_Criterion_Code ) INTO l_xml_item FROM dual;
266: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
267: SELECT XMLELEMENT("P_EVENT_CLASS_NAME",l_Event_Class_Name) INTO l_xml_item FROM dual;
268: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
269: SELECT XMLCONCAT(l_xml_report,l_xml_parameter) INTO l_xml_report FROM dual;
270:
271: --get head infomation according to the parameters inputed.
272: --for each head, get its lines infomation.

Line 269: SELECT XMLCONCAT(l_xml_report,l_xml_parameter) INTO l_xml_report FROM dual;

265: SELECT XMLELEMENT("P_SUPPORTING_REFERENCE_CODE",l_Analyciatl_Criterion_Code ) INTO l_xml_item FROM dual;
266: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
267: SELECT XMLELEMENT("P_EVENT_CLASS_NAME",l_Event_Class_Name) INTO l_xml_item FROM dual;
268: SELECT XMLCONCAT(l_xml_parameter,l_xml_item) INTO l_xml_parameter FROM dual;
269: SELECT XMLCONCAT(l_xml_report,l_xml_parameter) INTO l_xml_report FROM dual;
270:
271: --get head infomation according to the parameters inputed.
272: --for each head, get its lines infomation.
273:

Line 299: SELECT XMLELEMENT("APPLICATION_NAME",l_Application_Name) INTO l_xml_item FROM dual;

295: FETCH c_source_name INTO l_source_name;
296: CLOSE c_source_name;
297: --write head infomation to l_xml_head, then into l_xml_head_line
298: l_xml_head:=NULL;
299: SELECT XMLELEMENT("APPLICATION_NAME",l_Application_Name) INTO l_xml_item FROM dual;
300: l_xml_head:=l_xml_item;
301: SELECT XMLELEMENT("EVENT_CLASS_NAME",l_Event_Class_Name) INTO l_xml_item FROM dual;
302: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
303: SELECT XMLELEMENT("SUPPORTING_REFERENCE_CODE",l_Analyciatl_Criterion_Code) INTO l_xml_item FROM dual;

Line 301: SELECT XMLELEMENT("EVENT_CLASS_NAME",l_Event_Class_Name) INTO l_xml_item FROM dual;

297: --write head infomation to l_xml_head, then into l_xml_head_line
298: l_xml_head:=NULL;
299: SELECT XMLELEMENT("APPLICATION_NAME",l_Application_Name) INTO l_xml_item FROM dual;
300: l_xml_head:=l_xml_item;
301: SELECT XMLELEMENT("EVENT_CLASS_NAME",l_Event_Class_Name) INTO l_xml_item FROM dual;
302: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
303: SELECT XMLELEMENT("SUPPORTING_REFERENCE_CODE",l_Analyciatl_Criterion_Code) INTO l_xml_item FROM dual;
304: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
305: SELECT XMLELEMENT("SOURCE_NAME",l_source_name) INTO l_xml_item FROM dual;

Line 302: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;

298: l_xml_head:=NULL;
299: SELECT XMLELEMENT("APPLICATION_NAME",l_Application_Name) INTO l_xml_item FROM dual;
300: l_xml_head:=l_xml_item;
301: SELECT XMLELEMENT("EVENT_CLASS_NAME",l_Event_Class_Name) INTO l_xml_item FROM dual;
302: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
303: SELECT XMLELEMENT("SUPPORTING_REFERENCE_CODE",l_Analyciatl_Criterion_Code) INTO l_xml_item FROM dual;
304: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
305: SELECT XMLELEMENT("SOURCE_NAME",l_source_name) INTO l_xml_item FROM dual;
306: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;

Line 303: SELECT XMLELEMENT("SUPPORTING_REFERENCE_CODE",l_Analyciatl_Criterion_Code) INTO l_xml_item FROM dual;

299: SELECT XMLELEMENT("APPLICATION_NAME",l_Application_Name) INTO l_xml_item FROM dual;
300: l_xml_head:=l_xml_item;
301: SELECT XMLELEMENT("EVENT_CLASS_NAME",l_Event_Class_Name) INTO l_xml_item FROM dual;
302: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
303: SELECT XMLELEMENT("SUPPORTING_REFERENCE_CODE",l_Analyciatl_Criterion_Code) INTO l_xml_item FROM dual;
304: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
305: SELECT XMLELEMENT("SOURCE_NAME",l_source_name) INTO l_xml_item FROM dual;
306: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
307: SELECT XMLELEMENT("H_EFFECTIVE_START_DATE",l_h_effective_start_date) INTO l_xml_item FROM dual;

Line 304: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;

300: l_xml_head:=l_xml_item;
301: SELECT XMLELEMENT("EVENT_CLASS_NAME",l_Event_Class_Name) INTO l_xml_item FROM dual;
302: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
303: SELECT XMLELEMENT("SUPPORTING_REFERENCE_CODE",l_Analyciatl_Criterion_Code) INTO l_xml_item FROM dual;
304: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
305: SELECT XMLELEMENT("SOURCE_NAME",l_source_name) INTO l_xml_item FROM dual;
306: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
307: SELECT XMLELEMENT("H_EFFECTIVE_START_DATE",l_h_effective_start_date) INTO l_xml_item FROM dual;
308: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;

Line 305: SELECT XMLELEMENT("SOURCE_NAME",l_source_name) INTO l_xml_item FROM dual;

301: SELECT XMLELEMENT("EVENT_CLASS_NAME",l_Event_Class_Name) INTO l_xml_item FROM dual;
302: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
303: SELECT XMLELEMENT("SUPPORTING_REFERENCE_CODE",l_Analyciatl_Criterion_Code) INTO l_xml_item FROM dual;
304: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
305: SELECT XMLELEMENT("SOURCE_NAME",l_source_name) INTO l_xml_item FROM dual;
306: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
307: SELECT XMLELEMENT("H_EFFECTIVE_START_DATE",l_h_effective_start_date) INTO l_xml_item FROM dual;
308: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
309: SELECT XMLELEMENT("H_EFFECTIVE_END_DATE",l_h_effective_end_date) INTO l_xml_item FROM dual;

Line 306: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;

302: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
303: SELECT XMLELEMENT("SUPPORTING_REFERENCE_CODE",l_Analyciatl_Criterion_Code) INTO l_xml_item FROM dual;
304: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
305: SELECT XMLELEMENT("SOURCE_NAME",l_source_name) INTO l_xml_item FROM dual;
306: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
307: SELECT XMLELEMENT("H_EFFECTIVE_START_DATE",l_h_effective_start_date) INTO l_xml_item FROM dual;
308: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
309: SELECT XMLELEMENT("H_EFFECTIVE_END_DATE",l_h_effective_end_date) INTO l_xml_item FROM dual;
310: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;

Line 307: SELECT XMLELEMENT("H_EFFECTIVE_START_DATE",l_h_effective_start_date) INTO l_xml_item FROM dual;

303: SELECT XMLELEMENT("SUPPORTING_REFERENCE_CODE",l_Analyciatl_Criterion_Code) INTO l_xml_item FROM dual;
304: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
305: SELECT XMLELEMENT("SOURCE_NAME",l_source_name) INTO l_xml_item FROM dual;
306: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
307: SELECT XMLELEMENT("H_EFFECTIVE_START_DATE",l_h_effective_start_date) INTO l_xml_item FROM dual;
308: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
309: SELECT XMLELEMENT("H_EFFECTIVE_END_DATE",l_h_effective_end_date) INTO l_xml_item FROM dual;
310: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
311: SELECT XMLCONCAT(l_xml_head_line,l_xml_head) INTO l_xml_head_line FROM dual;

Line 308: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;

304: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
305: SELECT XMLELEMENT("SOURCE_NAME",l_source_name) INTO l_xml_item FROM dual;
306: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
307: SELECT XMLELEMENT("H_EFFECTIVE_START_DATE",l_h_effective_start_date) INTO l_xml_item FROM dual;
308: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
309: SELECT XMLELEMENT("H_EFFECTIVE_END_DATE",l_h_effective_end_date) INTO l_xml_item FROM dual;
310: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
311: SELECT XMLCONCAT(l_xml_head_line,l_xml_head) INTO l_xml_head_line FROM dual;
312:

Line 309: SELECT XMLELEMENT("H_EFFECTIVE_END_DATE",l_h_effective_end_date) INTO l_xml_item FROM dual;

305: SELECT XMLELEMENT("SOURCE_NAME",l_source_name) INTO l_xml_item FROM dual;
306: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
307: SELECT XMLELEMENT("H_EFFECTIVE_START_DATE",l_h_effective_start_date) INTO l_xml_item FROM dual;
308: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
309: SELECT XMLELEMENT("H_EFFECTIVE_END_DATE",l_h_effective_end_date) INTO l_xml_item FROM dual;
310: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
311: SELECT XMLCONCAT(l_xml_head_line,l_xml_head) INTO l_xml_head_line FROM dual;
312:
313: --get the lines infomation for this head

Line 310: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;

306: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
307: SELECT XMLELEMENT("H_EFFECTIVE_START_DATE",l_h_effective_start_date) INTO l_xml_item FROM dual;
308: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
309: SELECT XMLELEMENT("H_EFFECTIVE_END_DATE",l_h_effective_end_date) INTO l_xml_item FROM dual;
310: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
311: SELECT XMLCONCAT(l_xml_head_line,l_xml_head) INTO l_xml_head_line FROM dual;
312:
313: --get the lines infomation for this head
314: OPEN c_mapping_lines;

Line 311: SELECT XMLCONCAT(l_xml_head_line,l_xml_head) INTO l_xml_head_line FROM dual;

307: SELECT XMLELEMENT("H_EFFECTIVE_START_DATE",l_h_effective_start_date) INTO l_xml_item FROM dual;
308: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
309: SELECT XMLELEMENT("H_EFFECTIVE_END_DATE",l_h_effective_end_date) INTO l_xml_item FROM dual;
310: SELECT XMLCONCAT(l_xml_head,l_xml_item) INTO l_xml_head FROM dual;
311: SELECT XMLCONCAT(l_xml_head_line,l_xml_head) INTO l_xml_head_line FROM dual;
312:
313: --get the lines infomation for this head
314: OPEN c_mapping_lines;
315: LOOP

Line 333: SELECT XMLELEMENT("ORG_NAME",l_org_name) INTO l_xml_item FROM dual;

329: FETCH c_org_name INTO l_org_name;
330: close c_org_name;
331: --write lines infomation into l_xml_line, then concat to l_xml_head_line into l_xml_head_line.
332: l_xml_line:=NULL;
333: SELECT XMLELEMENT("ORG_NAME",l_org_name) INTO l_xml_item FROM dual;
334: l_xml_line:=l_xml_item;
335: SELECT XMLELEMENT("AC_VALUE",l_ac_value) INTO l_xml_item FROM dual;
336: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
337: SELECT XMLELEMENT("DETAILED_CFS_ITEM",l_detailed_cfs_item) INTO l_xml_item FROM dual;

Line 335: SELECT XMLELEMENT("AC_VALUE",l_ac_value) INTO l_xml_item FROM dual;

331: --write lines infomation into l_xml_line, then concat to l_xml_head_line into l_xml_head_line.
332: l_xml_line:=NULL;
333: SELECT XMLELEMENT("ORG_NAME",l_org_name) INTO l_xml_item FROM dual;
334: l_xml_line:=l_xml_item;
335: SELECT XMLELEMENT("AC_VALUE",l_ac_value) INTO l_xml_item FROM dual;
336: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
337: SELECT XMLELEMENT("DETAILED_CFS_ITEM",l_detailed_cfs_item) INTO l_xml_item FROM dual;
338: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
339: SELECT XMLELEMENT("DETAILED_ITEM_DESC",l_cash_flow_item_desc) INTO l_xml_item FROM dual;

Line 336: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;

332: l_xml_line:=NULL;
333: SELECT XMLELEMENT("ORG_NAME",l_org_name) INTO l_xml_item FROM dual;
334: l_xml_line:=l_xml_item;
335: SELECT XMLELEMENT("AC_VALUE",l_ac_value) INTO l_xml_item FROM dual;
336: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
337: SELECT XMLELEMENT("DETAILED_CFS_ITEM",l_detailed_cfs_item) INTO l_xml_item FROM dual;
338: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
339: SELECT XMLELEMENT("DETAILED_ITEM_DESC",l_cash_flow_item_desc) INTO l_xml_item FROM dual;
340: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;

Line 337: SELECT XMLELEMENT("DETAILED_CFS_ITEM",l_detailed_cfs_item) INTO l_xml_item FROM dual;

333: SELECT XMLELEMENT("ORG_NAME",l_org_name) INTO l_xml_item FROM dual;
334: l_xml_line:=l_xml_item;
335: SELECT XMLELEMENT("AC_VALUE",l_ac_value) INTO l_xml_item FROM dual;
336: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
337: SELECT XMLELEMENT("DETAILED_CFS_ITEM",l_detailed_cfs_item) INTO l_xml_item FROM dual;
338: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
339: SELECT XMLELEMENT("DETAILED_ITEM_DESC",l_cash_flow_item_desc) INTO l_xml_item FROM dual;
340: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
341: SELECT XMLELEMENT("EFFECTIVE_START_DATE",l_effective_start_date) INTO l_xml_item FROM dual;

Line 338: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;

334: l_xml_line:=l_xml_item;
335: SELECT XMLELEMENT("AC_VALUE",l_ac_value) INTO l_xml_item FROM dual;
336: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
337: SELECT XMLELEMENT("DETAILED_CFS_ITEM",l_detailed_cfs_item) INTO l_xml_item FROM dual;
338: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
339: SELECT XMLELEMENT("DETAILED_ITEM_DESC",l_cash_flow_item_desc) INTO l_xml_item FROM dual;
340: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
341: SELECT XMLELEMENT("EFFECTIVE_START_DATE",l_effective_start_date) INTO l_xml_item FROM dual;
342: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;

Line 339: SELECT XMLELEMENT("DETAILED_ITEM_DESC",l_cash_flow_item_desc) INTO l_xml_item FROM dual;

335: SELECT XMLELEMENT("AC_VALUE",l_ac_value) INTO l_xml_item FROM dual;
336: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
337: SELECT XMLELEMENT("DETAILED_CFS_ITEM",l_detailed_cfs_item) INTO l_xml_item FROM dual;
338: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
339: SELECT XMLELEMENT("DETAILED_ITEM_DESC",l_cash_flow_item_desc) INTO l_xml_item FROM dual;
340: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
341: SELECT XMLELEMENT("EFFECTIVE_START_DATE",l_effective_start_date) INTO l_xml_item FROM dual;
342: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
343: SELECT XMLELEMENT("EFFECTIVE_END_DATE",l_effective_end_date ) INTO l_xml_item FROM dual;

Line 340: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;

336: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
337: SELECT XMLELEMENT("DETAILED_CFS_ITEM",l_detailed_cfs_item) INTO l_xml_item FROM dual;
338: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
339: SELECT XMLELEMENT("DETAILED_ITEM_DESC",l_cash_flow_item_desc) INTO l_xml_item FROM dual;
340: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
341: SELECT XMLELEMENT("EFFECTIVE_START_DATE",l_effective_start_date) INTO l_xml_item FROM dual;
342: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
343: SELECT XMLELEMENT("EFFECTIVE_END_DATE",l_effective_end_date ) INTO l_xml_item FROM dual;
344: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;

Line 341: SELECT XMLELEMENT("EFFECTIVE_START_DATE",l_effective_start_date) INTO l_xml_item FROM dual;

337: SELECT XMLELEMENT("DETAILED_CFS_ITEM",l_detailed_cfs_item) INTO l_xml_item FROM dual;
338: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
339: SELECT XMLELEMENT("DETAILED_ITEM_DESC",l_cash_flow_item_desc) INTO l_xml_item FROM dual;
340: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
341: SELECT XMLELEMENT("EFFECTIVE_START_DATE",l_effective_start_date) INTO l_xml_item FROM dual;
342: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
343: SELECT XMLELEMENT("EFFECTIVE_END_DATE",l_effective_end_date ) INTO l_xml_item FROM dual;
344: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
345: SELECT XMLELEMENT("LINE",l_xml_line) INTO l_xml_line FROM dual;--line circulation

Line 342: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;

338: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
339: SELECT XMLELEMENT("DETAILED_ITEM_DESC",l_cash_flow_item_desc) INTO l_xml_item FROM dual;
340: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
341: SELECT XMLELEMENT("EFFECTIVE_START_DATE",l_effective_start_date) INTO l_xml_item FROM dual;
342: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
343: SELECT XMLELEMENT("EFFECTIVE_END_DATE",l_effective_end_date ) INTO l_xml_item FROM dual;
344: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
345: SELECT XMLELEMENT("LINE",l_xml_line) INTO l_xml_line FROM dual;--line circulation
346: SELECT XMLCONCAT(l_xml_head_line,l_xml_line) INTO l_xml_head_line FROM dual;

Line 343: SELECT XMLELEMENT("EFFECTIVE_END_DATE",l_effective_end_date ) INTO l_xml_item FROM dual;

339: SELECT XMLELEMENT("DETAILED_ITEM_DESC",l_cash_flow_item_desc) INTO l_xml_item FROM dual;
340: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
341: SELECT XMLELEMENT("EFFECTIVE_START_DATE",l_effective_start_date) INTO l_xml_item FROM dual;
342: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
343: SELECT XMLELEMENT("EFFECTIVE_END_DATE",l_effective_end_date ) INTO l_xml_item FROM dual;
344: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
345: SELECT XMLELEMENT("LINE",l_xml_line) INTO l_xml_line FROM dual;--line circulation
346: SELECT XMLCONCAT(l_xml_head_line,l_xml_line) INTO l_xml_head_line FROM dual;
347:

Line 344: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;

340: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
341: SELECT XMLELEMENT("EFFECTIVE_START_DATE",l_effective_start_date) INTO l_xml_item FROM dual;
342: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
343: SELECT XMLELEMENT("EFFECTIVE_END_DATE",l_effective_end_date ) INTO l_xml_item FROM dual;
344: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
345: SELECT XMLELEMENT("LINE",l_xml_line) INTO l_xml_line FROM dual;--line circulation
346: SELECT XMLCONCAT(l_xml_head_line,l_xml_line) INTO l_xml_head_line FROM dual;
347:
348: END LOOP;

Line 345: SELECT XMLELEMENT("LINE",l_xml_line) INTO l_xml_line FROM dual;--line circulation

341: SELECT XMLELEMENT("EFFECTIVE_START_DATE",l_effective_start_date) INTO l_xml_item FROM dual;
342: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
343: SELECT XMLELEMENT("EFFECTIVE_END_DATE",l_effective_end_date ) INTO l_xml_item FROM dual;
344: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
345: SELECT XMLELEMENT("LINE",l_xml_line) INTO l_xml_line FROM dual;--line circulation
346: SELECT XMLCONCAT(l_xml_head_line,l_xml_line) INTO l_xml_head_line FROM dual;
347:
348: END LOOP;
349: CLOSE c_mapping_lines;

Line 346: SELECT XMLCONCAT(l_xml_head_line,l_xml_line) INTO l_xml_head_line FROM dual;

342: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
343: SELECT XMLELEMENT("EFFECTIVE_END_DATE",l_effective_end_date ) INTO l_xml_item FROM dual;
344: SELECT XMLCONCAT(l_xml_line,l_xml_item) INTO l_xml_line FROM dual;
345: SELECT XMLELEMENT("LINE",l_xml_line) INTO l_xml_line FROM dual;--line circulation
346: SELECT XMLCONCAT(l_xml_head_line,l_xml_line) INTO l_xml_head_line FROM dual;
347:
348: END LOOP;
349: CLOSE c_mapping_lines;
350: SELECT XMLELEMENT("HEAD",l_xml_head_line) INTO l_xml_item FROM dual;--head circulation

Line 350: SELECT XMLELEMENT("HEAD",l_xml_head_line) INTO l_xml_item FROM dual;--head circulation

346: SELECT XMLCONCAT(l_xml_head_line,l_xml_line) INTO l_xml_head_line FROM dual;
347:
348: END LOOP;
349: CLOSE c_mapping_lines;
350: SELECT XMLELEMENT("HEAD",l_xml_head_line) INTO l_xml_item FROM dual;--head circulation
351: SELECT XMLCONCAT(l_xml_report,l_xml_item) INTO l_xml_report FROM dual;
352: END LOOP;
353: CLOSE c_mapping_headers;
354:

Line 351: SELECT XMLCONCAT(l_xml_report,l_xml_item) INTO l_xml_report FROM dual;

347:
348: END LOOP;
349: CLOSE c_mapping_lines;
350: SELECT XMLELEMENT("HEAD",l_xml_head_line) INTO l_xml_item FROM dual;--head circulation
351: SELECT XMLCONCAT(l_xml_report,l_xml_item) INTO l_xml_report FROM dual;
352: END LOOP;
353: CLOSE c_mapping_headers;
354:
355: SELECT XMLELEMENT( "REPORT",l_xml_report) INTO l_xml_root FROM dual;--generate the whole report.

Line 355: SELECT XMLELEMENT( "REPORT",l_xml_report) INTO l_xml_root FROM dual;--generate the whole report.

351: SELECT XMLCONCAT(l_xml_report,l_xml_item) INTO l_xml_report FROM dual;
352: END LOOP;
353: CLOSE c_mapping_headers;
354:
355: SELECT XMLELEMENT( "REPORT",l_xml_report) INTO l_xml_root FROM dual;--generate the whole report.
356: JA_CN_UTILITY.Output_Conc(l_xml_root.getclobval());
357:
358: IF (l_proc_level >= l_dbg_level)
359: THEN