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.EAM_SAFETY_REPORTS_PVT dependencies on XMLTYPE

Line 40: l_xmlType XMLType :=NULL;

36: RETURN CLOB
37:
38: IS
39:
40: l_xmlType XMLType :=NULL;
41: l_xmlTypeParamList XMLType :=NULL;
42: l_xmlTypeTextAttachment XMLType :=NULL;
43: l_xmlTypeURLAttachment XMLType :=NULL;
44: l_xmlTypefileattachment XMLType :=NULL;

Line 41: l_xmlTypeParamList XMLType :=NULL;

37:
38: IS
39:
40: l_xmlType XMLType :=NULL;
41: l_xmlTypeParamList XMLType :=NULL;
42: l_xmlTypeTextAttachment XMLType :=NULL;
43: l_xmlTypeURLAttachment XMLType :=NULL;
44: l_xmlTypefileattachment XMLType :=NULL;
45: l_xmlTypeAssociatedWO XMLType :=NULL;

Line 42: l_xmlTypeTextAttachment XMLType :=NULL;

38: IS
39:
40: l_xmlType XMLType :=NULL;
41: l_xmlTypeParamList XMLType :=NULL;
42: l_xmlTypeTextAttachment XMLType :=NULL;
43: l_xmlTypeURLAttachment XMLType :=NULL;
44: l_xmlTypefileattachment XMLType :=NULL;
45: l_xmlTypeAssociatedWO XMLType :=NULL;
46: l_xmlTypeAssociatedClearance XMLType :=NULL;

Line 43: l_xmlTypeURLAttachment XMLType :=NULL;

39:
40: l_xmlType XMLType :=NULL;
41: l_xmlTypeParamList XMLType :=NULL;
42: l_xmlTypeTextAttachment XMLType :=NULL;
43: l_xmlTypeURLAttachment XMLType :=NULL;
44: l_xmlTypefileattachment XMLType :=NULL;
45: l_xmlTypeAssociatedWO XMLType :=NULL;
46: l_xmlTypeAssociatedClearance XMLType :=NULL;
47: l_xmlTypePermitHeader XMLType :=NULL;

Line 44: l_xmlTypefileattachment XMLType :=NULL;

40: l_xmlType XMLType :=NULL;
41: l_xmlTypeParamList XMLType :=NULL;
42: l_xmlTypeTextAttachment XMLType :=NULL;
43: l_xmlTypeURLAttachment XMLType :=NULL;
44: l_xmlTypefileattachment XMLType :=NULL;
45: l_xmlTypeAssociatedWO XMLType :=NULL;
46: l_xmlTypeAssociatedClearance XMLType :=NULL;
47: l_xmlTypePermitHeader XMLType :=NULL;
48: l_xmlTypeApprover XMLType :=NULL;

Line 45: l_xmlTypeAssociatedWO XMLType :=NULL;

41: l_xmlTypeParamList XMLType :=NULL;
42: l_xmlTypeTextAttachment XMLType :=NULL;
43: l_xmlTypeURLAttachment XMLType :=NULL;
44: l_xmlTypefileattachment XMLType :=NULL;
45: l_xmlTypeAssociatedWO XMLType :=NULL;
46: l_xmlTypeAssociatedClearance XMLType :=NULL;
47: l_xmlTypePermitHeader XMLType :=NULL;
48: l_xmlTypeApprover XMLType :=NULL;
49: l_organization_id NUMBER;

Line 46: l_xmlTypeAssociatedClearance XMLType :=NULL;

42: l_xmlTypeTextAttachment XMLType :=NULL;
43: l_xmlTypeURLAttachment XMLType :=NULL;
44: l_xmlTypefileattachment XMLType :=NULL;
45: l_xmlTypeAssociatedWO XMLType :=NULL;
46: l_xmlTypeAssociatedClearance XMLType :=NULL;
47: l_xmlTypePermitHeader XMLType :=NULL;
48: l_xmlTypeApprover XMLType :=NULL;
49: l_organization_id NUMBER;
50:

Line 47: l_xmlTypePermitHeader XMLType :=NULL;

43: l_xmlTypeURLAttachment XMLType :=NULL;
44: l_xmlTypefileattachment XMLType :=NULL;
45: l_xmlTypeAssociatedWO XMLType :=NULL;
46: l_xmlTypeAssociatedClearance XMLType :=NULL;
47: l_xmlTypePermitHeader XMLType :=NULL;
48: l_xmlTypeApprover XMLType :=NULL;
49: l_organization_id NUMBER;
50:
51:

Line 48: l_xmlTypeApprover XMLType :=NULL;

44: l_xmlTypefileattachment XMLType :=NULL;
45: l_xmlTypeAssociatedWO XMLType :=NULL;
46: l_xmlTypeAssociatedClearance XMLType :=NULL;
47: l_xmlTypePermitHeader XMLType :=NULL;
48: l_xmlTypeApprover XMLType :=NULL;
49: l_organization_id NUMBER;
50:
51:
52: --Cursor for permit header

Line 292: l_xmlTypeParamList := xmltype('

288: select ewp.organization_id into l_organization_id
289: from EAM_WORK_PERMITS ewp
290: where ewp.permit_id=p_permit_ids(i).permit_id;
291:
292: l_xmlTypeParamList := xmltype('
293: ' ||Nvl(p_work_clearance_flag,0)|| '
294: ' ||Nvl(p_work_order_flag,0)|| '
295: ' ||Nvl(p_text_attachment_flag,0)|| '
296: ' ||Nvl(p_url_attachment_flag,0)|| '

Line 304: SELECT XMLConcat(l_xmlTypePermitHeader,permit_header_record.PERMIT_HEADER)

300: --Adding Permit Header
301: BEGIN
302: FOR permit_header_record IN PERMIT_HEADER_CURSOR(p_permit_ids(i).permit_id,l_organization_id)
303: LOOP
304: SELECT XMLConcat(l_xmlTypePermitHeader,permit_header_record.PERMIT_HEADER)
305: INTO l_xmlTypePermitHeader
306: FROM dual;
307: END LOOP;
308: EXCEPTION

Line 305: INTO l_xmlTypePermitHeader

301: BEGIN
302: FOR permit_header_record IN PERMIT_HEADER_CURSOR(p_permit_ids(i).permit_id,l_organization_id)
303: LOOP
304: SELECT XMLConcat(l_xmlTypePermitHeader,permit_header_record.PERMIT_HEADER)
305: INTO l_xmlTypePermitHeader
306: FROM dual;
307: END LOOP;
308: EXCEPTION
309: WHEN NO_DATA_FOUND THEN

Line 317: SELECT XMLConcat(l_xmlTypeApprover,approver_record.APPROVER)

313: -- Adding approver
314: BEGIN
315: FOR approver_record IN APPROVER_CURSOR(p_permit_ids(i).permit_id,l_organization_id)
316: LOOP
317: SELECT XMLConcat(l_xmlTypeApprover,approver_record.APPROVER)
318: INTO l_xmlTypeApprover
319: FROM dual;
320: END LOOP;
321: SELECT XMLELEMENT("APPROVERS",l_xmlTypeApprover)

Line 318: INTO l_xmlTypeApprover

314: BEGIN
315: FOR approver_record IN APPROVER_CURSOR(p_permit_ids(i).permit_id,l_organization_id)
316: LOOP
317: SELECT XMLConcat(l_xmlTypeApprover,approver_record.APPROVER)
318: INTO l_xmlTypeApprover
319: FROM dual;
320: END LOOP;
321: SELECT XMLELEMENT("APPROVERS",l_xmlTypeApprover)
322: INTO l_xmlTypeApprover

Line 321: SELECT XMLELEMENT("APPROVERS",l_xmlTypeApprover)

317: SELECT XMLConcat(l_xmlTypeApprover,approver_record.APPROVER)
318: INTO l_xmlTypeApprover
319: FROM dual;
320: END LOOP;
321: SELECT XMLELEMENT("APPROVERS",l_xmlTypeApprover)
322: INTO l_xmlTypeApprover
323: FROM dual;
324: EXCEPTION
325: WHEN NO_DATA_FOUND THEN

Line 322: INTO l_xmlTypeApprover

318: INTO l_xmlTypeApprover
319: FROM dual;
320: END LOOP;
321: SELECT XMLELEMENT("APPROVERS",l_xmlTypeApprover)
322: INTO l_xmlTypeApprover
323: FROM dual;
324: EXCEPTION
325: WHEN NO_DATA_FOUND THEN
326: NULL;

Line 335: SELECT XMLConcat(l_xmlTypeAssociatedClearance,clearance_record.WORK_CLEARANCE)

331: IF p_work_clearance_flag = 1 THEN
332: BEGIN
333: FOR clearance_record IN PERMIT_WORKCLEARANCE_CURSOR(p_permit_ids(i).permit_id,l_organization_id)
334: LOOP
335: SELECT XMLConcat(l_xmlTypeAssociatedClearance,clearance_record.WORK_CLEARANCE)
336: INTO l_xmlTypeAssociatedClearance
337: FROM dual;
338: END LOOP;
339: SELECT XMLELEMENT("WORK_CLEARANCES",l_xmlTypeAssociatedClearance)

Line 336: INTO l_xmlTypeAssociatedClearance

332: BEGIN
333: FOR clearance_record IN PERMIT_WORKCLEARANCE_CURSOR(p_permit_ids(i).permit_id,l_organization_id)
334: LOOP
335: SELECT XMLConcat(l_xmlTypeAssociatedClearance,clearance_record.WORK_CLEARANCE)
336: INTO l_xmlTypeAssociatedClearance
337: FROM dual;
338: END LOOP;
339: SELECT XMLELEMENT("WORK_CLEARANCES",l_xmlTypeAssociatedClearance)
340: INTO l_xmlTypeAssociatedClearance

Line 339: SELECT XMLELEMENT("WORK_CLEARANCES",l_xmlTypeAssociatedClearance)

335: SELECT XMLConcat(l_xmlTypeAssociatedClearance,clearance_record.WORK_CLEARANCE)
336: INTO l_xmlTypeAssociatedClearance
337: FROM dual;
338: END LOOP;
339: SELECT XMLELEMENT("WORK_CLEARANCES",l_xmlTypeAssociatedClearance)
340: INTO l_xmlTypeAssociatedClearance
341: FROM dual;
342: EXCEPTION
343: WHEN NO_DATA_FOUND THEN

Line 340: INTO l_xmlTypeAssociatedClearance

336: INTO l_xmlTypeAssociatedClearance
337: FROM dual;
338: END LOOP;
339: SELECT XMLELEMENT("WORK_CLEARANCES",l_xmlTypeAssociatedClearance)
340: INTO l_xmlTypeAssociatedClearance
341: FROM dual;
342: EXCEPTION
343: WHEN NO_DATA_FOUND THEN
344: NULL;

Line 353: SELECT XMLConcat(l_xmlTypeAssociatedWO,wo_record.WORK_ORDER)

349: IF p_work_order_flag = 1 THEN
350: BEGIN
351: FOR wo_record IN PERMIT_WORKORDER_CURSOR(p_permit_ids(i).permit_id,l_organization_id)
352: LOOP
353: SELECT XMLConcat(l_xmlTypeAssociatedWO,wo_record.WORK_ORDER)
354: INTO l_xmlTypeAssociatedWO
355: FROM dual;
356: END LOOP;
357: SELECT XMLELEMENT("WORK_ORDERS",l_xmlTypeAssociatedWO)

Line 354: INTO l_xmlTypeAssociatedWO

350: BEGIN
351: FOR wo_record IN PERMIT_WORKORDER_CURSOR(p_permit_ids(i).permit_id,l_organization_id)
352: LOOP
353: SELECT XMLConcat(l_xmlTypeAssociatedWO,wo_record.WORK_ORDER)
354: INTO l_xmlTypeAssociatedWO
355: FROM dual;
356: END LOOP;
357: SELECT XMLELEMENT("WORK_ORDERS",l_xmlTypeAssociatedWO)
358: INTO l_xmlTypeAssociatedWO

Line 357: SELECT XMLELEMENT("WORK_ORDERS",l_xmlTypeAssociatedWO)

353: SELECT XMLConcat(l_xmlTypeAssociatedWO,wo_record.WORK_ORDER)
354: INTO l_xmlTypeAssociatedWO
355: FROM dual;
356: END LOOP;
357: SELECT XMLELEMENT("WORK_ORDERS",l_xmlTypeAssociatedWO)
358: INTO l_xmlTypeAssociatedWO
359: FROM dual;
360: EXCEPTION
361: WHEN NO_DATA_FOUND THEN

Line 358: INTO l_xmlTypeAssociatedWO

354: INTO l_xmlTypeAssociatedWO
355: FROM dual;
356: END LOOP;
357: SELECT XMLELEMENT("WORK_ORDERS",l_xmlTypeAssociatedWO)
358: INTO l_xmlTypeAssociatedWO
359: FROM dual;
360: EXCEPTION
361: WHEN NO_DATA_FOUND THEN
362: NULL;

Line 371: SELECT XMLConcat(l_xmlTypetextattachment,textattachment_record.textAttachment)

367: IF p_text_attachment_flag = 1 THEN
368: BEGIN
369: FOR textattachment_record IN textattachment_cursor(p_permit_ids(i).permit_id,l_organization_id)
370: LOOP
371: SELECT XMLConcat(l_xmlTypetextattachment,textattachment_record.textAttachment)
372: INTO l_xmlTypetextattachment
373: FROM dual;
374: END LOOP;
375: SELECT XMLELEMENT("TEXT_ATTACHMENTS",l_xmlTypeTextAttachment)

Line 372: INTO l_xmlTypetextattachment

368: BEGIN
369: FOR textattachment_record IN textattachment_cursor(p_permit_ids(i).permit_id,l_organization_id)
370: LOOP
371: SELECT XMLConcat(l_xmlTypetextattachment,textattachment_record.textAttachment)
372: INTO l_xmlTypetextattachment
373: FROM dual;
374: END LOOP;
375: SELECT XMLELEMENT("TEXT_ATTACHMENTS",l_xmlTypeTextAttachment)
376: INTO l_xmlTypeTextAttachment

Line 375: SELECT XMLELEMENT("TEXT_ATTACHMENTS",l_xmlTypeTextAttachment)

371: SELECT XMLConcat(l_xmlTypetextattachment,textattachment_record.textAttachment)
372: INTO l_xmlTypetextattachment
373: FROM dual;
374: END LOOP;
375: SELECT XMLELEMENT("TEXT_ATTACHMENTS",l_xmlTypeTextAttachment)
376: INTO l_xmlTypeTextAttachment
377: FROM dual;
378: EXCEPTION
379: WHEN NO_DATA_FOUND THEN

Line 376: INTO l_xmlTypeTextAttachment

372: INTO l_xmlTypetextattachment
373: FROM dual;
374: END LOOP;
375: SELECT XMLELEMENT("TEXT_ATTACHMENTS",l_xmlTypeTextAttachment)
376: INTO l_xmlTypeTextAttachment
377: FROM dual;
378: EXCEPTION
379: WHEN NO_DATA_FOUND THEN
380: NULL;

Line 389: SELECT XMLConcat(l_xmlTypeURLAttachment,urlAttachment_record.URLAttachment)

385: IF p_url_attachment_flag = 1 THEN
386: BEGIN
387: FOR urlAttachment_record IN urlAttachment_cursor(p_permit_ids(i).permit_id,l_organization_id)
388: LOOP
389: SELECT XMLConcat(l_xmlTypeURLAttachment,urlAttachment_record.URLAttachment)
390: INTO l_xmlTypeURLAttachment
391: FROM dual;
392: END LOOP;
393: SELECT XMLELEMENT("URL_ATTACHMENTS",l_xmlTypeURLAttachment)

Line 390: INTO l_xmlTypeURLAttachment

386: BEGIN
387: FOR urlAttachment_record IN urlAttachment_cursor(p_permit_ids(i).permit_id,l_organization_id)
388: LOOP
389: SELECT XMLConcat(l_xmlTypeURLAttachment,urlAttachment_record.URLAttachment)
390: INTO l_xmlTypeURLAttachment
391: FROM dual;
392: END LOOP;
393: SELECT XMLELEMENT("URL_ATTACHMENTS",l_xmlTypeURLAttachment)
394: INTO l_xmlTypeURLAttachment

Line 393: SELECT XMLELEMENT("URL_ATTACHMENTS",l_xmlTypeURLAttachment)

389: SELECT XMLConcat(l_xmlTypeURLAttachment,urlAttachment_record.URLAttachment)
390: INTO l_xmlTypeURLAttachment
391: FROM dual;
392: END LOOP;
393: SELECT XMLELEMENT("URL_ATTACHMENTS",l_xmlTypeURLAttachment)
394: INTO l_xmlTypeURLAttachment
395: FROM dual;
396: EXCEPTION
397: WHEN NO_DATA_FOUND THEN

Line 394: INTO l_xmlTypeURLAttachment

390: INTO l_xmlTypeURLAttachment
391: FROM dual;
392: END LOOP;
393: SELECT XMLELEMENT("URL_ATTACHMENTS",l_xmlTypeURLAttachment)
394: INTO l_xmlTypeURLAttachment
395: FROM dual;
396: EXCEPTION
397: WHEN NO_DATA_FOUND THEN
398: NULL;

Line 407: SELECT XMLConcat(l_xmlTypefileattachment,fileattachment_record.FileAttachment)

403: IF p_file_attachment_flag = 1 THEN
404: BEGIN
405: FOR fileattachment_record IN fileattachment_cursor(p_permit_ids(i).permit_id,l_organization_id)
406: LOOP
407: SELECT XMLConcat(l_xmlTypefileattachment,fileattachment_record.FileAttachment)
408: INTO l_xmlTypefileattachment
409: FROM dual;
410: END LOOP;
411: SELECT XMLELEMENT("FILE_ATTACHMENTS",l_xmlTypefileattachment)

Line 408: INTO l_xmlTypefileattachment

404: BEGIN
405: FOR fileattachment_record IN fileattachment_cursor(p_permit_ids(i).permit_id,l_organization_id)
406: LOOP
407: SELECT XMLConcat(l_xmlTypefileattachment,fileattachment_record.FileAttachment)
408: INTO l_xmlTypefileattachment
409: FROM dual;
410: END LOOP;
411: SELECT XMLELEMENT("FILE_ATTACHMENTS",l_xmlTypefileattachment)
412: INTO l_xmlTypefileattachment

Line 411: SELECT XMLELEMENT("FILE_ATTACHMENTS",l_xmlTypefileattachment)

407: SELECT XMLConcat(l_xmlTypefileattachment,fileattachment_record.FileAttachment)
408: INTO l_xmlTypefileattachment
409: FROM dual;
410: END LOOP;
411: SELECT XMLELEMENT("FILE_ATTACHMENTS",l_xmlTypefileattachment)
412: INTO l_xmlTypefileattachment
413: FROM dual;
414: EXCEPTION
415: WHEN NO_DATA_FOUND THEN

Line 412: INTO l_xmlTypefileattachment

408: INTO l_xmlTypefileattachment
409: FROM dual;
410: END LOOP;
411: SELECT XMLELEMENT("FILE_ATTACHMENTS",l_xmlTypefileattachment)
412: INTO l_xmlTypefileattachment
413: FROM dual;
414: EXCEPTION
415: WHEN NO_DATA_FOUND THEN
416: NULL;

Line 422: /* SELECT XMLCONCAT(l_xmlType,

418: END IF;
419:
420: -- concatinate all xml string into one
421:
422: /* SELECT XMLCONCAT(l_xmlType,
423: XMLELEMENT("PERMIT_HEADER"
424: XMLFOREST(EWP.PERMIT_NAME AS PERMIT_NAME,
425: EWP.PERMIT_TYPE AS PERMIT_TYPE,
426: EWP.DESCRIPTION AS PERMIT_DESC,

Line 431: XMLConcat(l_xmlTypeAssociatedClearance,l_xmlTypeAssociatedWO,l_xmlTypefileattachment)))AS "RESULT"

427: EPSV.PERMIT_STATUS AS PERMIT_STATUS,
428: fnd_date.date_to_displayDT(Convert_to_client_time(EWP.VALID_FROM)) AS PERMIT_VALID_FROM,
429: fnd_date.date_to_displayDT(Convert_to_client_time(EWP.VALID_TO)) AS PERMIT_VALID_TO,
430: EWP.APPROVED_BY AS approverName),
431: XMLConcat(l_xmlTypeAssociatedClearance,l_xmlTypeAssociatedWO,l_xmlTypefileattachment)))AS "RESULT"
432: INTO l_xmlType
433: FROM EAM_WORK_PERMITS EWP,
434: EAM_PERMIT_STATUSES_VL EPSV
435: WHERE EWP.PERMIT_ID =p_permit_ids(i).permit_id

Line 432: INTO l_xmlType

428: fnd_date.date_to_displayDT(Convert_to_client_time(EWP.VALID_FROM)) AS PERMIT_VALID_FROM,
429: fnd_date.date_to_displayDT(Convert_to_client_time(EWP.VALID_TO)) AS PERMIT_VALID_TO,
430: EWP.APPROVED_BY AS approverName),
431: XMLConcat(l_xmlTypeAssociatedClearance,l_xmlTypeAssociatedWO,l_xmlTypefileattachment)))AS "RESULT"
432: INTO l_xmlType
433: FROM EAM_WORK_PERMITS EWP,
434: EAM_PERMIT_STATUSES_VL EPSV
435: WHERE EWP.PERMIT_ID =p_permit_ids(i).permit_id
436: AND EWP.ORGANIZATION_ID =l_organization_id

Line 439: SELECT XMLCONCAT(l_xmlType,

435: WHERE EWP.PERMIT_ID =p_permit_ids(i).permit_id
436: AND EWP.ORGANIZATION_ID =l_organization_id
437: AND EPSV.STATUS_ID =EWP.USER_DEFINED_STATUS_ID;*/
438:
439: SELECT XMLCONCAT(l_xmlType,
440: XMLELEMENT("PERMIT",
441: XMLConcat(l_xmlTypePermitHeader,l_xmlTypeApprover,l_xmlTypeAssociatedClearance,l_xmlTypeAssociatedWO,l_xmlTypeTextAttachment,l_xmlTypeURLAttachment,l_xmlTypefileattachment))) "PERMIT"
442: INTO l_xmlType
443: FROM dual;

Line 441: XMLConcat(l_xmlTypePermitHeader,l_xmlTypeApprover,l_xmlTypeAssociatedClearance,l_xmlTypeAssociatedWO,l_xmlTypeTextAttachment,l_xmlTypeURLAttachment,l_xmlTypefileattachment))) "PERMIT"

437: AND EPSV.STATUS_ID =EWP.USER_DEFINED_STATUS_ID;*/
438:
439: SELECT XMLCONCAT(l_xmlType,
440: XMLELEMENT("PERMIT",
441: XMLConcat(l_xmlTypePermitHeader,l_xmlTypeApprover,l_xmlTypeAssociatedClearance,l_xmlTypeAssociatedWO,l_xmlTypeTextAttachment,l_xmlTypeURLAttachment,l_xmlTypefileattachment))) "PERMIT"
442: INTO l_xmlType
443: FROM dual;
444:
445: l_xmlTypefileattachment:=NULL;

Line 442: INTO l_xmlType

438:
439: SELECT XMLCONCAT(l_xmlType,
440: XMLELEMENT("PERMIT",
441: XMLConcat(l_xmlTypePermitHeader,l_xmlTypeApprover,l_xmlTypeAssociatedClearance,l_xmlTypeAssociatedWO,l_xmlTypeTextAttachment,l_xmlTypeURLAttachment,l_xmlTypefileattachment))) "PERMIT"
442: INTO l_xmlType
443: FROM dual;
444:
445: l_xmlTypefileattachment:=NULL;
446: l_xmlTypeAssociatedWO:=NULL;

Line 445: l_xmlTypefileattachment:=NULL;

441: XMLConcat(l_xmlTypePermitHeader,l_xmlTypeApprover,l_xmlTypeAssociatedClearance,l_xmlTypeAssociatedWO,l_xmlTypeTextAttachment,l_xmlTypeURLAttachment,l_xmlTypefileattachment))) "PERMIT"
442: INTO l_xmlType
443: FROM dual;
444:
445: l_xmlTypefileattachment:=NULL;
446: l_xmlTypeAssociatedWO:=NULL;
447: l_xmlTypeAssociatedClearance:=NULL;
448: l_xmlTypePermitHeader:=NULL;
449: l_xmlTypeApprover:=NULL;

Line 446: l_xmlTypeAssociatedWO:=NULL;

442: INTO l_xmlType
443: FROM dual;
444:
445: l_xmlTypefileattachment:=NULL;
446: l_xmlTypeAssociatedWO:=NULL;
447: l_xmlTypeAssociatedClearance:=NULL;
448: l_xmlTypePermitHeader:=NULL;
449: l_xmlTypeApprover:=NULL;
450: l_xmlTypeTextAttachment := NULL;

Line 447: l_xmlTypeAssociatedClearance:=NULL;

443: FROM dual;
444:
445: l_xmlTypefileattachment:=NULL;
446: l_xmlTypeAssociatedWO:=NULL;
447: l_xmlTypeAssociatedClearance:=NULL;
448: l_xmlTypePermitHeader:=NULL;
449: l_xmlTypeApprover:=NULL;
450: l_xmlTypeTextAttachment := NULL;
451: l_xmlTypeURLAttachment:=NULL;

Line 448: l_xmlTypePermitHeader:=NULL;

444:
445: l_xmlTypefileattachment:=NULL;
446: l_xmlTypeAssociatedWO:=NULL;
447: l_xmlTypeAssociatedClearance:=NULL;
448: l_xmlTypePermitHeader:=NULL;
449: l_xmlTypeApprover:=NULL;
450: l_xmlTypeTextAttachment := NULL;
451: l_xmlTypeURLAttachment:=NULL;
452:

Line 449: l_xmlTypeApprover:=NULL;

445: l_xmlTypefileattachment:=NULL;
446: l_xmlTypeAssociatedWO:=NULL;
447: l_xmlTypeAssociatedClearance:=NULL;
448: l_xmlTypePermitHeader:=NULL;
449: l_xmlTypeApprover:=NULL;
450: l_xmlTypeTextAttachment := NULL;
451: l_xmlTypeURLAttachment:=NULL;
452:
453: END LOOP;

Line 450: l_xmlTypeTextAttachment := NULL;

446: l_xmlTypeAssociatedWO:=NULL;
447: l_xmlTypeAssociatedClearance:=NULL;
448: l_xmlTypePermitHeader:=NULL;
449: l_xmlTypeApprover:=NULL;
450: l_xmlTypeTextAttachment := NULL;
451: l_xmlTypeURLAttachment:=NULL;
452:
453: END LOOP;
454: SELECT

Line 451: l_xmlTypeURLAttachment:=NULL;

447: l_xmlTypeAssociatedClearance:=NULL;
448: l_xmlTypePermitHeader:=NULL;
449: l_xmlTypeApprover:=NULL;
450: l_xmlTypeTextAttachment := NULL;
451: l_xmlTypeURLAttachment:=NULL;
452:
453: END LOOP;
454: SELECT
455: XMLELEMENT("PERMITS",

Line 456: XMLConcat(l_xmlTypeParamList,l_xmlType)) "PERMITS"

452:
453: END LOOP;
454: SELECT
455: XMLELEMENT("PERMITS",
456: XMLConcat(l_xmlTypeParamList,l_xmlType)) "PERMITS"
457: INTO l_xmlType
458: FROM dual;
459: --l_xmlType will have all concatenated work permit records
460: RETURN l_xmlType.getClobVal();

Line 457: INTO l_xmlType

453: END LOOP;
454: SELECT
455: XMLELEMENT("PERMITS",
456: XMLConcat(l_xmlTypeParamList,l_xmlType)) "PERMITS"
457: INTO l_xmlType
458: FROM dual;
459: --l_xmlType will have all concatenated work permit records
460: RETURN l_xmlType.getClobVal();
461:

Line 459: --l_xmlType will have all concatenated work permit records

455: XMLELEMENT("PERMITS",
456: XMLConcat(l_xmlTypeParamList,l_xmlType)) "PERMITS"
457: INTO l_xmlType
458: FROM dual;
459: --l_xmlType will have all concatenated work permit records
460: RETURN l_xmlType.getClobVal();
461:
462: END getWorkPermitReportXML;
463:

Line 460: RETURN l_xmlType.getClobVal();

456: XMLConcat(l_xmlTypeParamList,l_xmlType)) "PERMITS"
457: INTO l_xmlType
458: FROM dual;
459: --l_xmlType will have all concatenated work permit records
460: RETURN l_xmlType.getClobVal();
461:
462: END getWorkPermitReportXML;
463:
464: /********************************************************************