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_WORKORDERREP_PVT dependencies on DUAL

Line 618: select XMLConcat(l_xmlTypeOperation,operation_record.Operation) into l_xmlTypeOperation from dual;

614:
615: if p_operation_flag = 1 then
616: begin
617: for operation_record in operation_cursor(p_wip_entity_id(i)) loop
618: select XMLConcat(l_xmlTypeOperation,operation_record.Operation) into l_xmlTypeOperation from dual;
619: end loop;
620: select XMLELEMENT("OPERATION_LIST",l_xmlTypeOperation) into l_xmlTypeOperation from dual;
621: exception
622: when NO_DATA_FOUND then

Line 620: select XMLELEMENT("OPERATION_LIST",l_xmlTypeOperation) into l_xmlTypeOperation from dual;

616: begin
617: for operation_record in operation_cursor(p_wip_entity_id(i)) loop
618: select XMLConcat(l_xmlTypeOperation,operation_record.Operation) into l_xmlTypeOperation from dual;
619: end loop;
620: select XMLELEMENT("OPERATION_LIST",l_xmlTypeOperation) into l_xmlTypeOperation from dual;
621: exception
622: when NO_DATA_FOUND then
623: null;
624: end;

Line 631: select XMLConcat(l_xmlTypeMaterial,material_record.Material) into l_xmlTypeMaterial from dual;

627: --Adding Materials
628: if p_material_flag = 1 then
629: begin
630: for material_record in material_cursor(p_wip_entity_id(i)) loop
631: select XMLConcat(l_xmlTypeMaterial,material_record.Material) into l_xmlTypeMaterial from dual;
632: end loop;
633: select XMLELEMENT("MATERIAL_LIST",l_xmlTypeMaterial) into l_xmlTypeMaterial from dual;
634: exception
635: when NO_DATA_FOUND then

Line 633: select XMLELEMENT("MATERIAL_LIST",l_xmlTypeMaterial) into l_xmlTypeMaterial from dual;

629: begin
630: for material_record in material_cursor(p_wip_entity_id(i)) loop
631: select XMLConcat(l_xmlTypeMaterial,material_record.Material) into l_xmlTypeMaterial from dual;
632: end loop;
633: select XMLELEMENT("MATERIAL_LIST",l_xmlTypeMaterial) into l_xmlTypeMaterial from dual;
634: exception
635: when NO_DATA_FOUND then
636: null;
637: end;

Line 644: select XMLConcat(l_xmlTypeResource,resource_record.Resources) into l_xmlTypeResource from dual;

640: --Adding Resources
641: if p_resource_flag = 1 then
642: begin
643: for resource_record in resource_cursor(p_wip_entity_id(i)) loop
644: select XMLConcat(l_xmlTypeResource,resource_record.Resources) into l_xmlTypeResource from dual;
645: end loop;
646: select XMLELEMENT("RESOURCE_LIST",l_xmlTypeResource) into l_xmlTypeResource from dual;
647: --Adding Employees
648: for employee_record in employee_cursor(p_wip_entity_id(i)) loop

Line 646: select XMLELEMENT("RESOURCE_LIST",l_xmlTypeResource) into l_xmlTypeResource from dual;

642: begin
643: for resource_record in resource_cursor(p_wip_entity_id(i)) loop
644: select XMLConcat(l_xmlTypeResource,resource_record.Resources) into l_xmlTypeResource from dual;
645: end loop;
646: select XMLELEMENT("RESOURCE_LIST",l_xmlTypeResource) into l_xmlTypeResource from dual;
647: --Adding Employees
648: for employee_record in employee_cursor(p_wip_entity_id(i)) loop
649: select XMLConcat(l_xmlTypeEmployee,employee_record.Employees) into l_xmlTypeEmployee from dual;
650: end loop;

Line 649: select XMLConcat(l_xmlTypeEmployee,employee_record.Employees) into l_xmlTypeEmployee from dual;

645: end loop;
646: select XMLELEMENT("RESOURCE_LIST",l_xmlTypeResource) into l_xmlTypeResource from dual;
647: --Adding Employees
648: for employee_record in employee_cursor(p_wip_entity_id(i)) loop
649: select XMLConcat(l_xmlTypeEmployee,employee_record.Employees) into l_xmlTypeEmployee from dual;
650: end loop;
651: select XMLELEMENT("EMPLOYEE_LIST",l_xmlTypeEmployee) into l_xmlTypeEmployee from dual;
652: select XMLConcat(l_xmlTypeResource,l_xmlTypeEmployee) into l_xmlTypeResource from dual;
653: exception

Line 651: select XMLELEMENT("EMPLOYEE_LIST",l_xmlTypeEmployee) into l_xmlTypeEmployee from dual;

647: --Adding Employees
648: for employee_record in employee_cursor(p_wip_entity_id(i)) loop
649: select XMLConcat(l_xmlTypeEmployee,employee_record.Employees) into l_xmlTypeEmployee from dual;
650: end loop;
651: select XMLELEMENT("EMPLOYEE_LIST",l_xmlTypeEmployee) into l_xmlTypeEmployee from dual;
652: select XMLConcat(l_xmlTypeResource,l_xmlTypeEmployee) into l_xmlTypeResource from dual;
653: exception
654: when NO_DATA_FOUND then
655: null;

Line 652: select XMLConcat(l_xmlTypeResource,l_xmlTypeEmployee) into l_xmlTypeResource from dual;

648: for employee_record in employee_cursor(p_wip_entity_id(i)) loop
649: select XMLConcat(l_xmlTypeEmployee,employee_record.Employees) into l_xmlTypeEmployee from dual;
650: end loop;
651: select XMLELEMENT("EMPLOYEE_LIST",l_xmlTypeEmployee) into l_xmlTypeEmployee from dual;
652: select XMLConcat(l_xmlTypeResource,l_xmlTypeEmployee) into l_xmlTypeResource from dual;
653: exception
654: when NO_DATA_FOUND then
655: null;
656: end;

Line 663: select XMLConcat(l_xmlTypeDirectMaterial,directmaterial_record.DirectMaterial) into l_xmlTypeDirectMaterial from dual;

659: --Adding Direct Materials
660: if p_direct_material_flag = 1 then
661: begin
662: for directmaterial_record in directmaterial_cursor(p_wip_entity_id(i)) loop
663: select XMLConcat(l_xmlTypeDirectMaterial,directmaterial_record.DirectMaterial) into l_xmlTypeDirectMaterial from dual;
664: end loop;
665: select XMLELEMENT("DIRECTMATERIAL_LIST",l_xmlTypeDirectMaterial) into l_xmlTypeDirectMaterial from dual;
666: exception
667: when NO_DATA_FOUND then

Line 665: select XMLELEMENT("DIRECTMATERIAL_LIST",l_xmlTypeDirectMaterial) into l_xmlTypeDirectMaterial from dual;

661: begin
662: for directmaterial_record in directmaterial_cursor(p_wip_entity_id(i)) loop
663: select XMLConcat(l_xmlTypeDirectMaterial,directmaterial_record.DirectMaterial) into l_xmlTypeDirectMaterial from dual;
664: end loop;
665: select XMLELEMENT("DIRECTMATERIAL_LIST",l_xmlTypeDirectMaterial) into l_xmlTypeDirectMaterial from dual;
666: exception
667: when NO_DATA_FOUND then
668: null;
669: end;

Line 676: select XMLConcat(l_xmlTypeShortAttachment,attachment_record.ShortAttachment) into l_xmlTypeShortAttachment from dual;

672: --Adding Work Order Short Text Attachments
673: if p_short_attachment_flag =1 then
674: begin
675: for attachment_record in shortattachment_cursor(p_wip_entity_id(i),l_org_id) loop
676: select XMLConcat(l_xmlTypeShortAttachment,attachment_record.ShortAttachment) into l_xmlTypeShortAttachment from dual;
677: end loop;
678: select XMLELEMENT("WOSHORTATTACHMENT_LIST",l_xmlTypeShortAttachment) into l_xmlTypeShortAttachment from dual;
679: exception
680: when NO_DATA_FOUND then

Line 678: select XMLELEMENT("WOSHORTATTACHMENT_LIST",l_xmlTypeShortAttachment) into l_xmlTypeShortAttachment from dual;

674: begin
675: for attachment_record in shortattachment_cursor(p_wip_entity_id(i),l_org_id) loop
676: select XMLConcat(l_xmlTypeShortAttachment,attachment_record.ShortAttachment) into l_xmlTypeShortAttachment from dual;
677: end loop;
678: select XMLELEMENT("WOSHORTATTACHMENT_LIST",l_xmlTypeShortAttachment) into l_xmlTypeShortAttachment from dual;
679: exception
680: when NO_DATA_FOUND then
681: null;
682: end;

Line 687: select XMLConcat(l_xmlTypeOpShortAttachment,opattachment_record.OpShortAttachment) into l_xmlTypeOpShortAttachment from dual;

683:
684: --Adding Operation Short Text Attachments
685: begin
686: for opattachment_record in opshortattachment(p_wip_entity_id(i),l_org_id) loop
687: select XMLConcat(l_xmlTypeOpShortAttachment,opattachment_record.OpShortAttachment) into l_xmlTypeOpShortAttachment from dual;
688: end loop;
689: select XMLELEMENT("OPSHORTATTACHMENT_LIST",l_xmlTypeOpShortAttachment) into l_xmlTypeOpShortAttachment from dual;
690: select XMLConcat(l_xmlTypeShortAttachment,l_xmlTypeOpShortAttachment) into l_xmlTypeShortAttachment from dual;
691: exception

Line 689: select XMLELEMENT("OPSHORTATTACHMENT_LIST",l_xmlTypeOpShortAttachment) into l_xmlTypeOpShortAttachment from dual;

685: begin
686: for opattachment_record in opshortattachment(p_wip_entity_id(i),l_org_id) loop
687: select XMLConcat(l_xmlTypeOpShortAttachment,opattachment_record.OpShortAttachment) into l_xmlTypeOpShortAttachment from dual;
688: end loop;
689: select XMLELEMENT("OPSHORTATTACHMENT_LIST",l_xmlTypeOpShortAttachment) into l_xmlTypeOpShortAttachment from dual;
690: select XMLConcat(l_xmlTypeShortAttachment,l_xmlTypeOpShortAttachment) into l_xmlTypeShortAttachment from dual;
691: exception
692: when NO_DATA_FOUND then
693: null;

Line 690: select XMLConcat(l_xmlTypeShortAttachment,l_xmlTypeOpShortAttachment) into l_xmlTypeShortAttachment from dual;

686: for opattachment_record in opshortattachment(p_wip_entity_id(i),l_org_id) loop
687: select XMLConcat(l_xmlTypeOpShortAttachment,opattachment_record.OpShortAttachment) into l_xmlTypeOpShortAttachment from dual;
688: end loop;
689: select XMLELEMENT("OPSHORTATTACHMENT_LIST",l_xmlTypeOpShortAttachment) into l_xmlTypeOpShortAttachment from dual;
690: select XMLConcat(l_xmlTypeShortAttachment,l_xmlTypeOpShortAttachment) into l_xmlTypeShortAttachment from dual;
691: exception
692: when NO_DATA_FOUND then
693: null;
694: end;

Line 701: select longattachment_record.LongAttachment into l_xmlTemp from dual;

697: --Adding Work Order Long Text Attachments
698: if p_long_attachment_flag =1 then
699: begin
700: for longattachment_record in longattachment_cursor(p_wip_entity_id(i),l_org_id) loop
701: select longattachment_record.LongAttachment into l_xmlTemp from dual;
702: select extractValue(l_xmlTemp,'/ALONGMEDIAID') into l_media_id from dual;
703: l_temp:=getLong(p_wip_entity_id(i),l_org_id,l_media_id,1);
704: select XMLConcat(l_xmlTemp,xmlType(''||l_temp||'')) into l_xmlTemp from dual;
705: select XMLELEMENT("LONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;

Line 702: select extractValue(l_xmlTemp,'/ALONGMEDIAID') into l_media_id from dual;

698: if p_long_attachment_flag =1 then
699: begin
700: for longattachment_record in longattachment_cursor(p_wip_entity_id(i),l_org_id) loop
701: select longattachment_record.LongAttachment into l_xmlTemp from dual;
702: select extractValue(l_xmlTemp,'/ALONGMEDIAID') into l_media_id from dual;
703: l_temp:=getLong(p_wip_entity_id(i),l_org_id,l_media_id,1);
704: select XMLConcat(l_xmlTemp,xmlType(''||l_temp||'')) into l_xmlTemp from dual;
705: select XMLELEMENT("LONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;
706: select XMLConcat(l_xmlTemp,l_xmlTypeLongAttachment) into l_xmlTypeLongAttachment from dual;

Line 704: select XMLConcat(l_xmlTemp,xmlType(''||l_temp||'')) into l_xmlTemp from dual;

700: for longattachment_record in longattachment_cursor(p_wip_entity_id(i),l_org_id) loop
701: select longattachment_record.LongAttachment into l_xmlTemp from dual;
702: select extractValue(l_xmlTemp,'/ALONGMEDIAID') into l_media_id from dual;
703: l_temp:=getLong(p_wip_entity_id(i),l_org_id,l_media_id,1);
704: select XMLConcat(l_xmlTemp,xmlType(''||l_temp||'')) into l_xmlTemp from dual;
705: select XMLELEMENT("LONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;
706: select XMLConcat(l_xmlTemp,l_xmlTypeLongAttachment) into l_xmlTypeLongAttachment from dual;
707: l_xmlTemp:=null;
708: end loop;

Line 705: select XMLELEMENT("LONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;

701: select longattachment_record.LongAttachment into l_xmlTemp from dual;
702: select extractValue(l_xmlTemp,'/ALONGMEDIAID') into l_media_id from dual;
703: l_temp:=getLong(p_wip_entity_id(i),l_org_id,l_media_id,1);
704: select XMLConcat(l_xmlTemp,xmlType(''||l_temp||'')) into l_xmlTemp from dual;
705: select XMLELEMENT("LONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;
706: select XMLConcat(l_xmlTemp,l_xmlTypeLongAttachment) into l_xmlTypeLongAttachment from dual;
707: l_xmlTemp:=null;
708: end loop;
709: select XMLELEMENT("WOLONGATTACHMENT_LIST",l_xmlTypeLongAttachment) into l_xmlTypeLongAttachment from dual;

Line 706: select XMLConcat(l_xmlTemp,l_xmlTypeLongAttachment) into l_xmlTypeLongAttachment from dual;

702: select extractValue(l_xmlTemp,'/ALONGMEDIAID') into l_media_id from dual;
703: l_temp:=getLong(p_wip_entity_id(i),l_org_id,l_media_id,1);
704: select XMLConcat(l_xmlTemp,xmlType(''||l_temp||'')) into l_xmlTemp from dual;
705: select XMLELEMENT("LONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;
706: select XMLConcat(l_xmlTemp,l_xmlTypeLongAttachment) into l_xmlTypeLongAttachment from dual;
707: l_xmlTemp:=null;
708: end loop;
709: select XMLELEMENT("WOLONGATTACHMENT_LIST",l_xmlTypeLongAttachment) into l_xmlTypeLongAttachment from dual;
710: exception

Line 709: select XMLELEMENT("WOLONGATTACHMENT_LIST",l_xmlTypeLongAttachment) into l_xmlTypeLongAttachment from dual;

705: select XMLELEMENT("LONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;
706: select XMLConcat(l_xmlTemp,l_xmlTypeLongAttachment) into l_xmlTypeLongAttachment from dual;
707: l_xmlTemp:=null;
708: end loop;
709: select XMLELEMENT("WOLONGATTACHMENT_LIST",l_xmlTypeLongAttachment) into l_xmlTypeLongAttachment from dual;
710: exception
711: when NO_DATA_FOUND then
712: null;
713: end;

Line 718: select oplongattachment_record.OpLongAttachment into l_xmlTemp from dual;

714:
715: --Adding Operation Long Text Attachments
716: begin
717: for oplongattachment_record in oplongattachment_cursor(p_wip_entity_id(i),l_org_id) loop
718: select oplongattachment_record.OpLongAttachment into l_xmlTemp from dual;
719: select extractValue(l_xmlTemp,'/OPALONGMEDIAID') into l_media_id from dual;
720: l_temp:=getLong(p_wip_entity_id(i),l_org_id,l_media_id,2);
721: select XMLConcat(l_xmlTemp,xmlType(''||l_temp||'')) into l_xmlTemp from dual;
722: select XMLELEMENT("OPLONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;

Line 719: select extractValue(l_xmlTemp,'/OPALONGMEDIAID') into l_media_id from dual;

715: --Adding Operation Long Text Attachments
716: begin
717: for oplongattachment_record in oplongattachment_cursor(p_wip_entity_id(i),l_org_id) loop
718: select oplongattachment_record.OpLongAttachment into l_xmlTemp from dual;
719: select extractValue(l_xmlTemp,'/OPALONGMEDIAID') into l_media_id from dual;
720: l_temp:=getLong(p_wip_entity_id(i),l_org_id,l_media_id,2);
721: select XMLConcat(l_xmlTemp,xmlType(''||l_temp||'')) into l_xmlTemp from dual;
722: select XMLELEMENT("OPLONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;
723: select XMLConcat(l_xmlTemp,l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;

Line 721: select XMLConcat(l_xmlTemp,xmlType(''||l_temp||'')) into l_xmlTemp from dual;

717: for oplongattachment_record in oplongattachment_cursor(p_wip_entity_id(i),l_org_id) loop
718: select oplongattachment_record.OpLongAttachment into l_xmlTemp from dual;
719: select extractValue(l_xmlTemp,'/OPALONGMEDIAID') into l_media_id from dual;
720: l_temp:=getLong(p_wip_entity_id(i),l_org_id,l_media_id,2);
721: select XMLConcat(l_xmlTemp,xmlType(''||l_temp||'')) into l_xmlTemp from dual;
722: select XMLELEMENT("OPLONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;
723: select XMLConcat(l_xmlTemp,l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;
724: l_xmlTemp:=null;
725: end loop;

Line 722: select XMLELEMENT("OPLONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;

718: select oplongattachment_record.OpLongAttachment into l_xmlTemp from dual;
719: select extractValue(l_xmlTemp,'/OPALONGMEDIAID') into l_media_id from dual;
720: l_temp:=getLong(p_wip_entity_id(i),l_org_id,l_media_id,2);
721: select XMLConcat(l_xmlTemp,xmlType(''||l_temp||'')) into l_xmlTemp from dual;
722: select XMLELEMENT("OPLONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;
723: select XMLConcat(l_xmlTemp,l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;
724: l_xmlTemp:=null;
725: end loop;
726: select XMLELEMENT("OPLONGATTACHMENT_LIST",l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;

Line 723: select XMLConcat(l_xmlTemp,l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;

719: select extractValue(l_xmlTemp,'/OPALONGMEDIAID') into l_media_id from dual;
720: l_temp:=getLong(p_wip_entity_id(i),l_org_id,l_media_id,2);
721: select XMLConcat(l_xmlTemp,xmlType(''||l_temp||'')) into l_xmlTemp from dual;
722: select XMLELEMENT("OPLONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;
723: select XMLConcat(l_xmlTemp,l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;
724: l_xmlTemp:=null;
725: end loop;
726: select XMLELEMENT("OPLONGATTACHMENT_LIST",l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;
727: select XMLConcat(l_xmlTypeLongAttachment,l_xmlTypeOpLongAttachment) into l_xmlTypeLongAttachment from dual;

Line 726: select XMLELEMENT("OPLONGATTACHMENT_LIST",l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;

722: select XMLELEMENT("OPLONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;
723: select XMLConcat(l_xmlTemp,l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;
724: l_xmlTemp:=null;
725: end loop;
726: select XMLELEMENT("OPLONGATTACHMENT_LIST",l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;
727: select XMLConcat(l_xmlTypeLongAttachment,l_xmlTypeOpLongAttachment) into l_xmlTypeLongAttachment from dual;
728: exception
729: when NO_DATA_FOUND then
730: null;

Line 727: select XMLConcat(l_xmlTypeLongAttachment,l_xmlTypeOpLongAttachment) into l_xmlTypeLongAttachment from dual;

723: select XMLConcat(l_xmlTemp,l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;
724: l_xmlTemp:=null;
725: end loop;
726: select XMLELEMENT("OPLONGATTACHMENT_LIST",l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;
727: select XMLConcat(l_xmlTypeLongAttachment,l_xmlTypeOpLongAttachment) into l_xmlTypeLongAttachment from dual;
728: exception
729: when NO_DATA_FOUND then
730: null;
731: end;

Line 738: select XMLConcat(l_xmlTypefileattachment,fileattachment_record.FileAttachment) into l_xmlTypefileattachment from dual;

734: --Adding File Attachments
735: if p_file_attachment_flag = 1 then
736: begin
737: for fileattachment_record in fileattachment_cursor(p_wip_entity_id(i),l_org_id) loop
738: select XMLConcat(l_xmlTypefileattachment,fileattachment_record.FileAttachment) into l_xmlTypefileattachment from dual;
739: end loop;
740: select XMLELEMENT("FILEATTACHMENT_LIST",l_xmlTypefileattachment) into l_xmlTypefileattachment from dual;
741: exception
742: when NO_DATA_FOUND then

Line 740: select XMLELEMENT("FILEATTACHMENT_LIST",l_xmlTypefileattachment) into l_xmlTypefileattachment from dual;

736: begin
737: for fileattachment_record in fileattachment_cursor(p_wip_entity_id(i),l_org_id) loop
738: select XMLConcat(l_xmlTypefileattachment,fileattachment_record.FileAttachment) into l_xmlTypefileattachment from dual;
739: end loop;
740: select XMLELEMENT("FILEATTACHMENT_LIST",l_xmlTypefileattachment) into l_xmlTypefileattachment from dual;
741: exception
742: when NO_DATA_FOUND then
743: null;
744: end;

Line 751: select XMLConcat(l_xmlTypeWorkRequest,workrequest_record.WorkRequest) into l_xmlTypeWorkRequest from dual;

747: --Adding Work Request
748: if p_work_request_flag =1 then
749: begin
750: for workrequest_record in workrequest_cursor(p_wip_entity_id(i),l_org_id) loop
751: select XMLConcat(l_xmlTypeWorkRequest,workrequest_record.WorkRequest) into l_xmlTypeWorkRequest from dual;
752: end loop;
753: select XMLELEMENT("WORKREQUEST_LIST",l_xmlTypeWorkRequest) into l_xmlTypeWorkRequest from dual;
754: exception
755: when NO_DATA_FOUND then

Line 753: select XMLELEMENT("WORKREQUEST_LIST",l_xmlTypeWorkRequest) into l_xmlTypeWorkRequest from dual;

749: begin
750: for workrequest_record in workrequest_cursor(p_wip_entity_id(i),l_org_id) loop
751: select XMLConcat(l_xmlTypeWorkRequest,workrequest_record.WorkRequest) into l_xmlTypeWorkRequest from dual;
752: end loop;
753: select XMLELEMENT("WORKREQUEST_LIST",l_xmlTypeWorkRequest) into l_xmlTypeWorkRequest from dual;
754: exception
755: when NO_DATA_FOUND then
756: null;
757: end;

Line 765: select XMLConcat(l_xmlTypeMeter,meter_record.Meter) into l_xmlTypeMeter from dual;

761: --Adding Meters
762: if p_meter_flag =1 then
763: begin
764: for meter_record in meter_cursor(p_wip_entity_id(i)) loop
765: select XMLConcat(l_xmlTypeMeter,meter_record.Meter) into l_xmlTypeMeter from dual;
766: end loop;
767: select XMLELEMENT("METER_LIST",l_xmlTypeMeter) into l_xmlTypeMeter from dual;
768: exception
769: when NO_DATA_FOUND then

Line 767: select XMLELEMENT("METER_LIST",l_xmlTypeMeter) into l_xmlTypeMeter from dual;

763: begin
764: for meter_record in meter_cursor(p_wip_entity_id(i)) loop
765: select XMLConcat(l_xmlTypeMeter,meter_record.Meter) into l_xmlTypeMeter from dual;
766: end loop;
767: select XMLELEMENT("METER_LIST",l_xmlTypeMeter) into l_xmlTypeMeter from dual;
768: exception
769: when NO_DATA_FOUND then
770: null;
771: end;

Line 804: select XMLConcat(l_xmlTypeQualityPlan,qualityplan_record.QualityPlan) into l_xmlTypeQualityPlan from dual;

800: null;
801: end;
802:
803: for qualityplan_record in qualityplan_cursor(p_quality_plan_flag,l_organization_id,l_wip_entity_name,l_asset_group,l_instance_number,l_serial_number,l_asset_activity) loop
804: select XMLConcat(l_xmlTypeQualityPlan,qualityplan_record.QualityPlan) into l_xmlTypeQualityPlan from dual;
805: select extractValue(l_xmlTypeQualityPlan,'/PLANID') into l_plan_id from dual;
806: l_xmlTemp2 := null;
807: for qplanelement_record in qplanelement_cursor(l_plan_id) loop
808: select qplanelement_record.QPlanElement into l_xmlTemp from dual;

Line 805: select extractValue(l_xmlTypeQualityPlan,'/PLANID') into l_plan_id from dual;

801: end;
802:
803: for qualityplan_record in qualityplan_cursor(p_quality_plan_flag,l_organization_id,l_wip_entity_name,l_asset_group,l_instance_number,l_serial_number,l_asset_activity) loop
804: select XMLConcat(l_xmlTypeQualityPlan,qualityplan_record.QualityPlan) into l_xmlTypeQualityPlan from dual;
805: select extractValue(l_xmlTypeQualityPlan,'/PLANID') into l_plan_id from dual;
806: l_xmlTemp2 := null;
807: for qplanelement_record in qplanelement_cursor(l_plan_id) loop
808: select qplanelement_record.QPlanElement into l_xmlTemp from dual;
809: select XMLConcat(l_xmlTemp,xmlType(' ')) into l_xmlTemp from dual;

Line 808: select qplanelement_record.QPlanElement into l_xmlTemp from dual;

804: select XMLConcat(l_xmlTypeQualityPlan,qualityplan_record.QualityPlan) into l_xmlTypeQualityPlan from dual;
805: select extractValue(l_xmlTypeQualityPlan,'/PLANID') into l_plan_id from dual;
806: l_xmlTemp2 := null;
807: for qplanelement_record in qplanelement_cursor(l_plan_id) loop
808: select qplanelement_record.QPlanElement into l_xmlTemp from dual;
809: select XMLConcat(l_xmlTemp,xmlType(' ')) into l_xmlTemp from dual;
810: select XMLELEMENT("ELEMENT",l_xmlTemp) into l_xmlTemp from dual;
811: select XMLConcat(l_xmlTemp2,l_xmlTemp) into l_xmlTemp2 from dual;
812: end loop;

Line 809: select XMLConcat(l_xmlTemp,xmlType(' ')) into l_xmlTemp from dual;

805: select extractValue(l_xmlTypeQualityPlan,'/PLANID') into l_plan_id from dual;
806: l_xmlTemp2 := null;
807: for qplanelement_record in qplanelement_cursor(l_plan_id) loop
808: select qplanelement_record.QPlanElement into l_xmlTemp from dual;
809: select XMLConcat(l_xmlTemp,xmlType(' ')) into l_xmlTemp from dual;
810: select XMLELEMENT("ELEMENT",l_xmlTemp) into l_xmlTemp from dual;
811: select XMLConcat(l_xmlTemp2,l_xmlTemp) into l_xmlTemp2 from dual;
812: end loop;
813: select XMLELEMENT("ELEMENT_LIST",l_xmlTemp2) into l_xmlTemp2 from dual;

Line 810: select XMLELEMENT("ELEMENT",l_xmlTemp) into l_xmlTemp from dual;

806: l_xmlTemp2 := null;
807: for qplanelement_record in qplanelement_cursor(l_plan_id) loop
808: select qplanelement_record.QPlanElement into l_xmlTemp from dual;
809: select XMLConcat(l_xmlTemp,xmlType(' ')) into l_xmlTemp from dual;
810: select XMLELEMENT("ELEMENT",l_xmlTemp) into l_xmlTemp from dual;
811: select XMLConcat(l_xmlTemp2,l_xmlTemp) into l_xmlTemp2 from dual;
812: end loop;
813: select XMLELEMENT("ELEMENT_LIST",l_xmlTemp2) into l_xmlTemp2 from dual;
814: select XMLConcat(l_xmlTypeQualityPlan,l_xmlTemp2) into l_xmlTypeQualityPlan from dual;

Line 811: select XMLConcat(l_xmlTemp2,l_xmlTemp) into l_xmlTemp2 from dual;

807: for qplanelement_record in qplanelement_cursor(l_plan_id) loop
808: select qplanelement_record.QPlanElement into l_xmlTemp from dual;
809: select XMLConcat(l_xmlTemp,xmlType(' ')) into l_xmlTemp from dual;
810: select XMLELEMENT("ELEMENT",l_xmlTemp) into l_xmlTemp from dual;
811: select XMLConcat(l_xmlTemp2,l_xmlTemp) into l_xmlTemp2 from dual;
812: end loop;
813: select XMLELEMENT("ELEMENT_LIST",l_xmlTemp2) into l_xmlTemp2 from dual;
814: select XMLConcat(l_xmlTypeQualityPlan,l_xmlTemp2) into l_xmlTypeQualityPlan from dual;
815: select XMLELEMENT("QUALITYPLAN",l_xmlTypeQualityPlan) into l_xmlTypeQualityPlan from dual;

Line 813: select XMLELEMENT("ELEMENT_LIST",l_xmlTemp2) into l_xmlTemp2 from dual;

809: select XMLConcat(l_xmlTemp,xmlType(' ')) into l_xmlTemp from dual;
810: select XMLELEMENT("ELEMENT",l_xmlTemp) into l_xmlTemp from dual;
811: select XMLConcat(l_xmlTemp2,l_xmlTemp) into l_xmlTemp2 from dual;
812: end loop;
813: select XMLELEMENT("ELEMENT_LIST",l_xmlTemp2) into l_xmlTemp2 from dual;
814: select XMLConcat(l_xmlTypeQualityPlan,l_xmlTemp2) into l_xmlTypeQualityPlan from dual;
815: select XMLELEMENT("QUALITYPLAN",l_xmlTypeQualityPlan) into l_xmlTypeQualityPlan from dual;
816: end loop;
817: select XMLELEMENT("QUALITYPLAN_LIST",l_xmlTypeQualityPlan) into l_xmlTypeQualityPlan from dual;

Line 814: select XMLConcat(l_xmlTypeQualityPlan,l_xmlTemp2) into l_xmlTypeQualityPlan from dual;

810: select XMLELEMENT("ELEMENT",l_xmlTemp) into l_xmlTemp from dual;
811: select XMLConcat(l_xmlTemp2,l_xmlTemp) into l_xmlTemp2 from dual;
812: end loop;
813: select XMLELEMENT("ELEMENT_LIST",l_xmlTemp2) into l_xmlTemp2 from dual;
814: select XMLConcat(l_xmlTypeQualityPlan,l_xmlTemp2) into l_xmlTypeQualityPlan from dual;
815: select XMLELEMENT("QUALITYPLAN",l_xmlTypeQualityPlan) into l_xmlTypeQualityPlan from dual;
816: end loop;
817: select XMLELEMENT("QUALITYPLAN_LIST",l_xmlTypeQualityPlan) into l_xmlTypeQualityPlan from dual;
818:

Line 815: select XMLELEMENT("QUALITYPLAN",l_xmlTypeQualityPlan) into l_xmlTypeQualityPlan from dual;

811: select XMLConcat(l_xmlTemp2,l_xmlTemp) into l_xmlTemp2 from dual;
812: end loop;
813: select XMLELEMENT("ELEMENT_LIST",l_xmlTemp2) into l_xmlTemp2 from dual;
814: select XMLConcat(l_xmlTypeQualityPlan,l_xmlTemp2) into l_xmlTypeQualityPlan from dual;
815: select XMLELEMENT("QUALITYPLAN",l_xmlTypeQualityPlan) into l_xmlTypeQualityPlan from dual;
816: end loop;
817: select XMLELEMENT("QUALITYPLAN_LIST",l_xmlTypeQualityPlan) into l_xmlTypeQualityPlan from dual;
818:
819: exception

Line 817: select XMLELEMENT("QUALITYPLAN_LIST",l_xmlTypeQualityPlan) into l_xmlTypeQualityPlan from dual;

813: select XMLELEMENT("ELEMENT_LIST",l_xmlTemp2) into l_xmlTemp2 from dual;
814: select XMLConcat(l_xmlTypeQualityPlan,l_xmlTemp2) into l_xmlTypeQualityPlan from dual;
815: select XMLELEMENT("QUALITYPLAN",l_xmlTypeQualityPlan) into l_xmlTypeQualityPlan from dual;
816: end loop;
817: select XMLELEMENT("QUALITYPLAN_LIST",l_xmlTypeQualityPlan) into l_xmlTypeQualityPlan from dual;
818:
819: exception
820: when NO_DATA_FOUND then
821: null;

Line 829: select XMLConcat(l_xmlTypeAssetBom,assetbom_record.AssetBom) into l_xmlTypeAssetBom from dual;

825: --Adding Asset BOM
826: if p_asset_bom_flag =1 then
827: begin
828: for assetbom_record in assetbom_cursor(p_wip_entity_id(i)) loop
829: select XMLConcat(l_xmlTypeAssetBom,assetbom_record.AssetBom) into l_xmlTypeAssetBom from dual;
830: end loop;
831: select XMLELEMENT("ASSETBOM_LIST",l_xmlTypeAssetBom) into l_xmlTypeAssetBom from dual;
832: exception
833: when NO_DATA_FOUND then

Line 831: select XMLELEMENT("ASSETBOM_LIST",l_xmlTypeAssetBom) into l_xmlTypeAssetBom from dual;

827: begin
828: for assetbom_record in assetbom_cursor(p_wip_entity_id(i)) loop
829: select XMLConcat(l_xmlTypeAssetBom,assetbom_record.AssetBom) into l_xmlTypeAssetBom from dual;
830: end loop;
831: select XMLELEMENT("ASSETBOM_LIST",l_xmlTypeAssetBom) into l_xmlTypeAssetBom from dual;
832: exception
833: when NO_DATA_FOUND then
834: null;
835: end;

Line 844: select XMLConcat(l_xmlTypeAssetroutecomp,asset_route_record.AssetRoutecomp) into l_xmlTypeAssetroutecomp from dual;

840: if l_asset_route_flag = 'Y' then
841: begin
842:
843: for asset_route_record in assetroutecomp_cursor(l_serial_number,l_inventory_id) loop
844: select XMLConcat(l_xmlTypeAssetroutecomp,asset_route_record.AssetRoutecomp) into l_xmlTypeAssetroutecomp from dual;
845: end loop;
846: select XMLELEMENT("ASSETROUTECOMP_LIST",l_xmlTypeAssetroutecomp) into l_xmlTypeAssetroutecomp from dual;
847: exception
848: when NO_DATA_FOUND then

Line 846: select XMLELEMENT("ASSETROUTECOMP_LIST",l_xmlTypeAssetroutecomp) into l_xmlTypeAssetroutecomp from dual;

842:
843: for asset_route_record in assetroutecomp_cursor(l_serial_number,l_inventory_id) loop
844: select XMLConcat(l_xmlTypeAssetroutecomp,asset_route_record.AssetRoutecomp) into l_xmlTypeAssetroutecomp from dual;
845: end loop;
846: select XMLELEMENT("ASSETROUTECOMP_LIST",l_xmlTypeAssetroutecomp) into l_xmlTypeAssetroutecomp from dual;
847: exception
848: when NO_DATA_FOUND then
849: null;
850: end;

Line 1035: select XMLELEMENT("WORKORDER_LIST", l_xmlType) into l_xmlType from dual;

1031: l_xmlTemp3:=null;
1032: l_xmlTypeAssetroutecomp:=null;
1033: end loop;
1034:
1035: select XMLELEMENT("WORKORDER_LIST", l_xmlType) into l_xmlType from dual;
1036:
1037: return l_xmlType.getClobVal();
1038: -- End of API body.
1039: