APPS.EAM_SAFETY_REPORTS_PVT dependencies on DUAL

Line 306: FROM dual;

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
310: NULL;

Line 319: FROM dual;

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
323: FROM dual;

Line 323: FROM dual;

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;
327: END;

Line 337: FROM dual;

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
341: FROM dual;

Line 341: FROM dual;

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;
345: END;

Line 355: FROM dual;

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
359: FROM dual;

Line 359: FROM dual;

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;
363: END;

Line 373: FROM dual;

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
377: FROM dual;

Line 377: FROM dual;

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;
381: END;

Line 391: FROM dual;

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
395: FROM dual;

Line 395: FROM dual;

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;
399: END;

Line 409: FROM dual;

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
413: FROM dual;

Line 413: FROM dual;

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;
417: END;

Line 443: FROM dual;

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;
447: l_xmlTypeAssociatedClearance:=NULL;

Line 458: FROM dual;

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:
462: END getWorkPermitReportXML;