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 831: select XMLConcat(l_xmlTypeOperation,operation_record.Operation) into l_xmlTypeOperation from dual;

827:
828: if p_operation_flag = 1 then
829: begin
830: for operation_record in operation_cursor(p_wip_entity_id(i)) loop
831: select XMLConcat(l_xmlTypeOperation,operation_record.Operation) into l_xmlTypeOperation from dual;
832: end loop;
833: select XMLELEMENT("OPERATION_LIST",l_xmlTypeOperation) into l_xmlTypeOperation from dual;
834: exception
835: when NO_DATA_FOUND then

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

829: begin
830: for operation_record in operation_cursor(p_wip_entity_id(i)) loop
831: select XMLConcat(l_xmlTypeOperation,operation_record.Operation) into l_xmlTypeOperation from dual;
832: end loop;
833: select XMLELEMENT("OPERATION_LIST",l_xmlTypeOperation) into l_xmlTypeOperation from dual;
834: exception
835: when NO_DATA_FOUND then
836: null;
837: end;

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

840: --Adding Materials
841: if p_material_flag = 1 then
842: begin
843: for material_record in material_cursor(p_wip_entity_id(i)) loop
844: select XMLConcat(l_xmlTypeMaterial,material_record.Material) into l_xmlTypeMaterial from dual;
845: end loop;
846: select XMLELEMENT("MATERIAL_LIST",l_xmlTypeMaterial) into l_xmlTypeMaterial from dual;
847: exception
848: when NO_DATA_FOUND then

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

842: begin
843: for material_record in material_cursor(p_wip_entity_id(i)) loop
844: select XMLConcat(l_xmlTypeMaterial,material_record.Material) into l_xmlTypeMaterial from dual;
845: end loop;
846: select XMLELEMENT("MATERIAL_LIST",l_xmlTypeMaterial) into l_xmlTypeMaterial from dual;
847: exception
848: when NO_DATA_FOUND then
849: null;
850: end;

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

853: --Adding Resources
854: if p_resource_flag = 1 then
855: begin
856: for resource_record in resource_cursor(p_wip_entity_id(i)) loop
857: select XMLConcat(l_xmlTypeResource,resource_record.Resources) into l_xmlTypeResource from dual;
858: end loop;
859: select XMLELEMENT("RESOURCE_LIST",l_xmlTypeResource) into l_xmlTypeResource from dual;
860: --Adding Employees
861: for employee_record in employee_cursor(p_wip_entity_id(i)) loop

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

855: begin
856: for resource_record in resource_cursor(p_wip_entity_id(i)) loop
857: select XMLConcat(l_xmlTypeResource,resource_record.Resources) into l_xmlTypeResource from dual;
858: end loop;
859: select XMLELEMENT("RESOURCE_LIST",l_xmlTypeResource) into l_xmlTypeResource from dual;
860: --Adding Employees
861: for employee_record in employee_cursor(p_wip_entity_id(i)) loop
862: select XMLConcat(l_xmlTypeEmployee,employee_record.Employees) into l_xmlTypeEmployee from dual;
863: end loop;

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

858: end loop;
859: select XMLELEMENT("RESOURCE_LIST",l_xmlTypeResource) into l_xmlTypeResource from dual;
860: --Adding Employees
861: for employee_record in employee_cursor(p_wip_entity_id(i)) loop
862: select XMLConcat(l_xmlTypeEmployee,employee_record.Employees) into l_xmlTypeEmployee from dual;
863: end loop;
864: select XMLELEMENT("EMPLOYEE_LIST",l_xmlTypeEmployee) into l_xmlTypeEmployee from dual;
865: select XMLConcat(l_xmlTypeResource,l_xmlTypeEmployee) into l_xmlTypeResource from dual;
866: exception

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

860: --Adding Employees
861: for employee_record in employee_cursor(p_wip_entity_id(i)) loop
862: select XMLConcat(l_xmlTypeEmployee,employee_record.Employees) into l_xmlTypeEmployee from dual;
863: end loop;
864: select XMLELEMENT("EMPLOYEE_LIST",l_xmlTypeEmployee) into l_xmlTypeEmployee from dual;
865: select XMLConcat(l_xmlTypeResource,l_xmlTypeEmployee) into l_xmlTypeResource from dual;
866: exception
867: when NO_DATA_FOUND then
868: null;

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

861: for employee_record in employee_cursor(p_wip_entity_id(i)) loop
862: select XMLConcat(l_xmlTypeEmployee,employee_record.Employees) into l_xmlTypeEmployee from dual;
863: end loop;
864: select XMLELEMENT("EMPLOYEE_LIST",l_xmlTypeEmployee) into l_xmlTypeEmployee from dual;
865: select XMLConcat(l_xmlTypeResource,l_xmlTypeEmployee) into l_xmlTypeResource from dual;
866: exception
867: when NO_DATA_FOUND then
868: null;
869: end;

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

872: --Adding Direct Materials
873: if p_direct_material_flag = 1 then
874: begin
875: for directmaterial_record in directmaterial_cursor(p_wip_entity_id(i)) loop
876: select XMLConcat(l_xmlTypeDirectMaterial,directmaterial_record.DirectMaterial) into l_xmlTypeDirectMaterial from dual;
877: end loop;
878: select XMLELEMENT("DIRECTMATERIAL_LIST",l_xmlTypeDirectMaterial) into l_xmlTypeDirectMaterial from dual;
879: exception
880: when NO_DATA_FOUND then

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

874: begin
875: for directmaterial_record in directmaterial_cursor(p_wip_entity_id(i)) loop
876: select XMLConcat(l_xmlTypeDirectMaterial,directmaterial_record.DirectMaterial) into l_xmlTypeDirectMaterial from dual;
877: end loop;
878: select XMLELEMENT("DIRECTMATERIAL_LIST",l_xmlTypeDirectMaterial) into l_xmlTypeDirectMaterial from dual;
879: exception
880: when NO_DATA_FOUND then
881: null;
882: end;

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

885: --Adding Work Order Short Text Attachments
886: if p_short_attachment_flag =1 then
887: begin
888: for attachment_record in shortattachment_cursor(p_wip_entity_id(i),l_org_id) loop
889: select XMLConcat(l_xmlTypeShortAttachment,attachment_record.ShortAttachment) into l_xmlTypeShortAttachment from dual;
890: end loop;
891: select XMLELEMENT("WOSHORTATTACHMENT_LIST",l_xmlTypeShortAttachment) into l_xmlTypeShortAttachment from dual;
892: exception
893: when NO_DATA_FOUND then

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

887: begin
888: for attachment_record in shortattachment_cursor(p_wip_entity_id(i),l_org_id) loop
889: select XMLConcat(l_xmlTypeShortAttachment,attachment_record.ShortAttachment) into l_xmlTypeShortAttachment from dual;
890: end loop;
891: select XMLELEMENT("WOSHORTATTACHMENT_LIST",l_xmlTypeShortAttachment) into l_xmlTypeShortAttachment from dual;
892: exception
893: when NO_DATA_FOUND then
894: null;
895: end;

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

896:
897: --Adding Operation Short Text Attachments
898: begin
899: for opattachment_record in opshortattachment(p_wip_entity_id(i),l_org_id) loop
900: select XMLConcat(l_xmlTypeOpShortAttachment,opattachment_record.OpShortAttachment) into l_xmlTypeOpShortAttachment from dual;
901: end loop;
902: select XMLELEMENT("OPSHORTATTACHMENT_LIST",l_xmlTypeOpShortAttachment) into l_xmlTypeOpShortAttachment from dual;
903: select XMLConcat(l_xmlTypeShortAttachment,l_xmlTypeOpShortAttachment) into l_xmlTypeShortAttachment from dual;
904: exception

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

898: begin
899: for opattachment_record in opshortattachment(p_wip_entity_id(i),l_org_id) loop
900: select XMLConcat(l_xmlTypeOpShortAttachment,opattachment_record.OpShortAttachment) into l_xmlTypeOpShortAttachment from dual;
901: end loop;
902: select XMLELEMENT("OPSHORTATTACHMENT_LIST",l_xmlTypeOpShortAttachment) into l_xmlTypeOpShortAttachment from dual;
903: select XMLConcat(l_xmlTypeShortAttachment,l_xmlTypeOpShortAttachment) into l_xmlTypeShortAttachment from dual;
904: exception
905: when NO_DATA_FOUND then
906: null;

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

899: for opattachment_record in opshortattachment(p_wip_entity_id(i),l_org_id) loop
900: select XMLConcat(l_xmlTypeOpShortAttachment,opattachment_record.OpShortAttachment) into l_xmlTypeOpShortAttachment from dual;
901: end loop;
902: select XMLELEMENT("OPSHORTATTACHMENT_LIST",l_xmlTypeOpShortAttachment) into l_xmlTypeOpShortAttachment from dual;
903: select XMLConcat(l_xmlTypeShortAttachment,l_xmlTypeOpShortAttachment) into l_xmlTypeShortAttachment from dual;
904: exception
905: when NO_DATA_FOUND then
906: null;
907: end;

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

910: --Adding Work Order Long Text Attachments
911: if p_long_attachment_flag =1 then
912: begin
913: for longattachment_record in longattachment_cursor(p_wip_entity_id(i),l_org_id) loop
914: select longattachment_record.LongAttachment into l_xmlTemp from dual;
915: select extractValue(l_xmlTemp,'/ALONGMEDIAID') into l_media_id from dual;
916: l_temp:=getLong(p_wip_entity_id(i),l_org_id,l_media_id,1);
917: l_temp := replace(l_temp, '&', '&');
918: l_temp := replace(l_temp, '<', '<');

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

911: if p_long_attachment_flag =1 then
912: begin
913: for longattachment_record in longattachment_cursor(p_wip_entity_id(i),l_org_id) loop
914: select longattachment_record.LongAttachment into l_xmlTemp from dual;
915: select extractValue(l_xmlTemp,'/ALONGMEDIAID') into l_media_id from dual;
916: l_temp:=getLong(p_wip_entity_id(i),l_org_id,l_media_id,1);
917: l_temp := replace(l_temp, '&', '&');
918: l_temp := replace(l_temp, '<', '<');
919: l_temp := replace(l_temp, '>', '>');

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

916: l_temp:=getLong(p_wip_entity_id(i),l_org_id,l_media_id,1);
917: l_temp := replace(l_temp, '&', '&');
918: l_temp := replace(l_temp, '<', '<');
919: l_temp := replace(l_temp, '>', '>');
920: select XMLConcat(l_xmlTemp,xmlType(''||l_temp||'')) into l_xmlTemp from dual;
921: select XMLELEMENT("LONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;
922: select XMLConcat(l_xmlTemp,l_xmlTypeLongAttachment) into l_xmlTypeLongAttachment from dual;
923: l_xmlTemp:=null;
924: end loop;

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

917: l_temp := replace(l_temp, '&', '&');
918: l_temp := replace(l_temp, '<', '<');
919: l_temp := replace(l_temp, '>', '>');
920: select XMLConcat(l_xmlTemp,xmlType(''||l_temp||'')) into l_xmlTemp from dual;
921: select XMLELEMENT("LONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;
922: select XMLConcat(l_xmlTemp,l_xmlTypeLongAttachment) into l_xmlTypeLongAttachment from dual;
923: l_xmlTemp:=null;
924: end loop;
925: select XMLELEMENT("WOLONGATTACHMENT_LIST",l_xmlTypeLongAttachment) into l_xmlTypeLongAttachment from dual;

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

918: l_temp := replace(l_temp, '<', '<');
919: l_temp := replace(l_temp, '>', '>');
920: select XMLConcat(l_xmlTemp,xmlType(''||l_temp||'')) into l_xmlTemp from dual;
921: select XMLELEMENT("LONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;
922: select XMLConcat(l_xmlTemp,l_xmlTypeLongAttachment) into l_xmlTypeLongAttachment from dual;
923: l_xmlTemp:=null;
924: end loop;
925: select XMLELEMENT("WOLONGATTACHMENT_LIST",l_xmlTypeLongAttachment) into l_xmlTypeLongAttachment from dual;
926: exception

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

921: select XMLELEMENT("LONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;
922: select XMLConcat(l_xmlTemp,l_xmlTypeLongAttachment) into l_xmlTypeLongAttachment from dual;
923: l_xmlTemp:=null;
924: end loop;
925: select XMLELEMENT("WOLONGATTACHMENT_LIST",l_xmlTypeLongAttachment) into l_xmlTypeLongAttachment from dual;
926: exception
927: when NO_DATA_FOUND then
928: null;
929: end;

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

930:
931: --Adding Operation Long Text Attachments
932: begin
933: for oplongattachment_record in oplongattachment_cursor(p_wip_entity_id(i),l_org_id) loop
934: select oplongattachment_record.OpLongAttachment into l_xmlTemp from dual;
935: select extractValue(l_xmlTemp,'/OPALONGMEDIAID') into l_media_id from dual;
936: l_temp:=getLong(p_wip_entity_id(i),l_org_id,l_media_id,2);
937: l_temp := replace(l_temp, '&', '&');
938: l_temp := replace(l_temp, '<', '<');

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

931: --Adding Operation Long Text Attachments
932: begin
933: for oplongattachment_record in oplongattachment_cursor(p_wip_entity_id(i),l_org_id) loop
934: select oplongattachment_record.OpLongAttachment into l_xmlTemp from dual;
935: select extractValue(l_xmlTemp,'/OPALONGMEDIAID') into l_media_id from dual;
936: l_temp:=getLong(p_wip_entity_id(i),l_org_id,l_media_id,2);
937: l_temp := replace(l_temp, '&', '&');
938: l_temp := replace(l_temp, '<', '<');
939: l_temp := replace(l_temp, '>', '>');

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

936: l_temp:=getLong(p_wip_entity_id(i),l_org_id,l_media_id,2);
937: l_temp := replace(l_temp, '&', '&');
938: l_temp := replace(l_temp, '<', '<');
939: l_temp := replace(l_temp, '>', '>');
940: select XMLConcat(l_xmlTemp,xmlType(''||l_temp||'')) into l_xmlTemp from dual;
941: select XMLELEMENT("OPLONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;
942: select XMLConcat(l_xmlTemp,l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;
943: l_xmlTemp:=null;
944: end loop;

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

937: l_temp := replace(l_temp, '&', '&');
938: l_temp := replace(l_temp, '<', '<');
939: l_temp := replace(l_temp, '>', '>');
940: select XMLConcat(l_xmlTemp,xmlType(''||l_temp||'')) into l_xmlTemp from dual;
941: select XMLELEMENT("OPLONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;
942: select XMLConcat(l_xmlTemp,l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;
943: l_xmlTemp:=null;
944: end loop;
945: select XMLELEMENT("OPLONGATTACHMENT_LIST",l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;

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

938: l_temp := replace(l_temp, '<', '<');
939: l_temp := replace(l_temp, '>', '>');
940: select XMLConcat(l_xmlTemp,xmlType(''||l_temp||'')) into l_xmlTemp from dual;
941: select XMLELEMENT("OPLONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;
942: select XMLConcat(l_xmlTemp,l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;
943: l_xmlTemp:=null;
944: end loop;
945: select XMLELEMENT("OPLONGATTACHMENT_LIST",l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;
946: select XMLConcat(l_xmlTypeLongAttachment,l_xmlTypeOpLongAttachment) into l_xmlTypeLongAttachment from dual;

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

941: select XMLELEMENT("OPLONGATTACHMENT",l_xmlTemp) into l_xmlTemp from dual;
942: select XMLConcat(l_xmlTemp,l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;
943: l_xmlTemp:=null;
944: end loop;
945: select XMLELEMENT("OPLONGATTACHMENT_LIST",l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;
946: select XMLConcat(l_xmlTypeLongAttachment,l_xmlTypeOpLongAttachment) into l_xmlTypeLongAttachment from dual;
947: exception
948: when NO_DATA_FOUND then
949: null;

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

942: select XMLConcat(l_xmlTemp,l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;
943: l_xmlTemp:=null;
944: end loop;
945: select XMLELEMENT("OPLONGATTACHMENT_LIST",l_xmlTypeOpLongAttachment) into l_xmlTypeOpLongAttachment from dual;
946: select XMLConcat(l_xmlTypeLongAttachment,l_xmlTypeOpLongAttachment) into l_xmlTypeLongAttachment from dual;
947: exception
948: when NO_DATA_FOUND then
949: null;
950: end;

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

953: --Adding File Attachments
954: if p_file_attachment_flag = 1 then
955: begin
956: for fileattachment_record in fileattachment_cursor(p_wip_entity_id(i),l_org_id) loop
957: select XMLConcat(l_xmlTypefileattachment,fileattachment_record.FileAttachment) into l_xmlTypefileattachment from dual;
958: end loop;
959: select XMLELEMENT("FILEATTACHMENT_LIST",l_xmlTypefileattachment) into l_xmlTypefileattachment from dual;
960: exception
961: when NO_DATA_FOUND then

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

955: begin
956: for fileattachment_record in fileattachment_cursor(p_wip_entity_id(i),l_org_id) loop
957: select XMLConcat(l_xmlTypefileattachment,fileattachment_record.FileAttachment) into l_xmlTypefileattachment from dual;
958: end loop;
959: select XMLELEMENT("FILEATTACHMENT_LIST",l_xmlTypefileattachment) into l_xmlTypefileattachment from dual;
960: exception
961: when NO_DATA_FOUND then
962: null;
963: end;

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

966: --Adding Work Request
967: if p_work_request_flag =1 then
968: begin
969: for workrequest_record in workrequest_cursor(p_wip_entity_id(i),l_org_id) loop
970: select XMLConcat(l_xmlTypeWorkRequest,workrequest_record.WorkRequest) into l_xmlTypeWorkRequest from dual;
971: end loop;
972: select XMLELEMENT("WORKREQUEST_LIST",l_xmlTypeWorkRequest) into l_xmlTypeWorkRequest from dual;
973: exception
974: when NO_DATA_FOUND then

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

968: begin
969: for workrequest_record in workrequest_cursor(p_wip_entity_id(i),l_org_id) loop
970: select XMLConcat(l_xmlTypeWorkRequest,workrequest_record.WorkRequest) into l_xmlTypeWorkRequest from dual;
971: end loop;
972: select XMLELEMENT("WORKREQUEST_LIST",l_xmlTypeWorkRequest) into l_xmlTypeWorkRequest from dual;
973: exception
974: when NO_DATA_FOUND then
975: null;
976: end;

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

980: --Adding Meters
981: if p_meter_flag =1 then
982: begin
983: for meter_record in meter_cursor(p_wip_entity_id(i)) loop
984: select XMLConcat(l_xmlTypeMeter,meter_record.Meter) into l_xmlTypeMeter from dual;
985: end loop;
986: select XMLELEMENT("METER_LIST",l_xmlTypeMeter) into l_xmlTypeMeter from dual;
987: exception
988: when NO_DATA_FOUND then

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

982: begin
983: for meter_record in meter_cursor(p_wip_entity_id(i)) loop
984: select XMLConcat(l_xmlTypeMeter,meter_record.Meter) into l_xmlTypeMeter from dual;
985: end loop;
986: select XMLELEMENT("METER_LIST",l_xmlTypeMeter) into l_xmlTypeMeter from dual;
987: exception
988: when NO_DATA_FOUND then
989: null;
990: end;

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

1019: null;
1020: end;
1021:
1022: 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
1023: select XMLConcat(l_xmlTypeQualityPlan,qualityplan_record.QualityPlan) into l_xmlTypeQualityPlan from dual;
1024: select extractValue(l_xmlTypeQualityPlan,'/PLANID') into l_plan_id from dual;
1025: l_xmlTemp2 := null;
1026: for qplanelement_record in qplanelement_cursor(l_plan_id) loop
1027: select qplanelement_record.QPlanElement into l_xmlTemp from dual;

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

1020: end;
1021:
1022: 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
1023: select XMLConcat(l_xmlTypeQualityPlan,qualityplan_record.QualityPlan) into l_xmlTypeQualityPlan from dual;
1024: select extractValue(l_xmlTypeQualityPlan,'/PLANID') into l_plan_id from dual;
1025: l_xmlTemp2 := null;
1026: for qplanelement_record in qplanelement_cursor(l_plan_id) loop
1027: select qplanelement_record.QPlanElement into l_xmlTemp from dual;
1028: select XMLConcat(l_xmlTemp,xmlType(' ')) into l_xmlTemp from dual;

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

1023: select XMLConcat(l_xmlTypeQualityPlan,qualityplan_record.QualityPlan) into l_xmlTypeQualityPlan from dual;
1024: select extractValue(l_xmlTypeQualityPlan,'/PLANID') into l_plan_id from dual;
1025: l_xmlTemp2 := null;
1026: for qplanelement_record in qplanelement_cursor(l_plan_id) loop
1027: select qplanelement_record.QPlanElement into l_xmlTemp from dual;
1028: select XMLConcat(l_xmlTemp,xmlType(' ')) into l_xmlTemp from dual;
1029: select XMLELEMENT("ELEMENT",l_xmlTemp) into l_xmlTemp from dual;
1030: select XMLConcat(l_xmlTemp2,l_xmlTemp) into l_xmlTemp2 from dual;
1031: end loop;

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

1024: select extractValue(l_xmlTypeQualityPlan,'/PLANID') into l_plan_id from dual;
1025: l_xmlTemp2 := null;
1026: for qplanelement_record in qplanelement_cursor(l_plan_id) loop
1027: select qplanelement_record.QPlanElement into l_xmlTemp from dual;
1028: select XMLConcat(l_xmlTemp,xmlType(' ')) into l_xmlTemp from dual;
1029: select XMLELEMENT("ELEMENT",l_xmlTemp) into l_xmlTemp from dual;
1030: select XMLConcat(l_xmlTemp2,l_xmlTemp) into l_xmlTemp2 from dual;
1031: end loop;
1032: select XMLELEMENT("ELEMENT_LIST",l_xmlTemp2) into l_xmlTemp2 from dual;

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

1025: l_xmlTemp2 := null;
1026: for qplanelement_record in qplanelement_cursor(l_plan_id) loop
1027: select qplanelement_record.QPlanElement into l_xmlTemp from dual;
1028: select XMLConcat(l_xmlTemp,xmlType(' ')) into l_xmlTemp from dual;
1029: select XMLELEMENT("ELEMENT",l_xmlTemp) into l_xmlTemp from dual;
1030: select XMLConcat(l_xmlTemp2,l_xmlTemp) into l_xmlTemp2 from dual;
1031: end loop;
1032: select XMLELEMENT("ELEMENT_LIST",l_xmlTemp2) into l_xmlTemp2 from dual;
1033: select XMLConcat(l_xmlTypeQualityPlan,l_xmlTemp2) into l_xmlTypeQualityPlan from dual;

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

1026: for qplanelement_record in qplanelement_cursor(l_plan_id) loop
1027: select qplanelement_record.QPlanElement into l_xmlTemp from dual;
1028: select XMLConcat(l_xmlTemp,xmlType(' ')) into l_xmlTemp from dual;
1029: select XMLELEMENT("ELEMENT",l_xmlTemp) into l_xmlTemp from dual;
1030: select XMLConcat(l_xmlTemp2,l_xmlTemp) into l_xmlTemp2 from dual;
1031: end loop;
1032: select XMLELEMENT("ELEMENT_LIST",l_xmlTemp2) into l_xmlTemp2 from dual;
1033: select XMLConcat(l_xmlTypeQualityPlan,l_xmlTemp2) into l_xmlTypeQualityPlan from dual;
1034: select XMLELEMENT("QUALITYPLAN",l_xmlTypeQualityPlan) into l_xmlTypeQualityPlan from dual;

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

1028: select XMLConcat(l_xmlTemp,xmlType(' ')) into l_xmlTemp from dual;
1029: select XMLELEMENT("ELEMENT",l_xmlTemp) into l_xmlTemp from dual;
1030: select XMLConcat(l_xmlTemp2,l_xmlTemp) into l_xmlTemp2 from dual;
1031: end loop;
1032: select XMLELEMENT("ELEMENT_LIST",l_xmlTemp2) into l_xmlTemp2 from dual;
1033: select XMLConcat(l_xmlTypeQualityPlan,l_xmlTemp2) into l_xmlTypeQualityPlan from dual;
1034: select XMLELEMENT("QUALITYPLAN",l_xmlTypeQualityPlan) into l_xmlTypeQualityPlan from dual;
1035: --changed bug fix 8289633
1036: SELECT XMLConcat(l_xmlTemp4,l_xmlTypeQualityPlan)INTO l_xmlTemp4 FROM dual;

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

1029: select XMLELEMENT("ELEMENT",l_xmlTemp) into l_xmlTemp from dual;
1030: select XMLConcat(l_xmlTemp2,l_xmlTemp) into l_xmlTemp2 from dual;
1031: end loop;
1032: select XMLELEMENT("ELEMENT_LIST",l_xmlTemp2) into l_xmlTemp2 from dual;
1033: select XMLConcat(l_xmlTypeQualityPlan,l_xmlTemp2) into l_xmlTypeQualityPlan from dual;
1034: select XMLELEMENT("QUALITYPLAN",l_xmlTypeQualityPlan) into l_xmlTypeQualityPlan from dual;
1035: --changed bug fix 8289633
1036: SELECT XMLConcat(l_xmlTemp4,l_xmlTypeQualityPlan)INTO l_xmlTemp4 FROM dual;
1037: l_xmlTypeQualityPlan:=NULL;

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

1030: select XMLConcat(l_xmlTemp2,l_xmlTemp) into l_xmlTemp2 from dual;
1031: end loop;
1032: select XMLELEMENT("ELEMENT_LIST",l_xmlTemp2) into l_xmlTemp2 from dual;
1033: select XMLConcat(l_xmlTypeQualityPlan,l_xmlTemp2) into l_xmlTypeQualityPlan from dual;
1034: select XMLELEMENT("QUALITYPLAN",l_xmlTypeQualityPlan) into l_xmlTypeQualityPlan from dual;
1035: --changed bug fix 8289633
1036: SELECT XMLConcat(l_xmlTemp4,l_xmlTypeQualityPlan)INTO l_xmlTemp4 FROM dual;
1037: l_xmlTypeQualityPlan:=NULL;
1038: end loop;

Line 1036: SELECT XMLConcat(l_xmlTemp4,l_xmlTypeQualityPlan)INTO l_xmlTemp4 FROM dual;

1032: select XMLELEMENT("ELEMENT_LIST",l_xmlTemp2) into l_xmlTemp2 from dual;
1033: select XMLConcat(l_xmlTypeQualityPlan,l_xmlTemp2) into l_xmlTypeQualityPlan from dual;
1034: select XMLELEMENT("QUALITYPLAN",l_xmlTypeQualityPlan) into l_xmlTypeQualityPlan from dual;
1035: --changed bug fix 8289633
1036: SELECT XMLConcat(l_xmlTemp4,l_xmlTypeQualityPlan)INTO l_xmlTemp4 FROM dual;
1037: l_xmlTypeQualityPlan:=NULL;
1038: end loop;
1039: select XMLELEMENT("QUALITYPLAN_LIST",l_xmlTemp4) into l_xmlTypeQualityPlan from dual;
1040: --end of change bug fix 8289633

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

1035: --changed bug fix 8289633
1036: SELECT XMLConcat(l_xmlTemp4,l_xmlTypeQualityPlan)INTO l_xmlTemp4 FROM dual;
1037: l_xmlTypeQualityPlan:=NULL;
1038: end loop;
1039: select XMLELEMENT("QUALITYPLAN_LIST",l_xmlTemp4) into l_xmlTypeQualityPlan from dual;
1040: --end of change bug fix 8289633
1041:
1042: exception
1043: when NO_DATA_FOUND then

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

1048: --Adding Asset BOM
1049: if p_asset_bom_flag =1 then
1050: begin
1051: for assetbom_record in assetbom_cursor(p_wip_entity_id(i)) loop
1052: select XMLConcat(l_xmlTypeAssetBom,assetbom_record.AssetBom) into l_xmlTypeAssetBom from dual;
1053: end loop;
1054: select XMLELEMENT("ASSETBOM_LIST",l_xmlTypeAssetBom) into l_xmlTypeAssetBom from dual;
1055: exception
1056: when NO_DATA_FOUND then

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

1050: begin
1051: for assetbom_record in assetbom_cursor(p_wip_entity_id(i)) loop
1052: select XMLConcat(l_xmlTypeAssetBom,assetbom_record.AssetBom) into l_xmlTypeAssetBom from dual;
1053: end loop;
1054: select XMLELEMENT("ASSETBOM_LIST",l_xmlTypeAssetBom) into l_xmlTypeAssetBom from dual;
1055: exception
1056: when NO_DATA_FOUND then
1057: null;
1058: end;

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

1063: if l_asset_route_flag = 'Y' then
1064: begin
1065:
1066: for asset_route_record in assetroutecomp_cursor(l_serial_number,l_inventory_id) loop
1067: select XMLConcat(l_xmlTypeAssetroutecomp,asset_route_record.AssetRoutecomp) into l_xmlTypeAssetroutecomp from dual;
1068: end loop;
1069: select XMLELEMENT("ASSETROUTECOMP_LIST",l_xmlTypeAssetroutecomp) into l_xmlTypeAssetroutecomp from dual;
1070: exception
1071: when NO_DATA_FOUND then

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

1065:
1066: for asset_route_record in assetroutecomp_cursor(l_serial_number,l_inventory_id) loop
1067: select XMLConcat(l_xmlTypeAssetroutecomp,asset_route_record.AssetRoutecomp) into l_xmlTypeAssetroutecomp from dual;
1068: end loop;
1069: select XMLELEMENT("ASSETROUTECOMP_LIST",l_xmlTypeAssetroutecomp) into l_xmlTypeAssetroutecomp from dual;
1070: exception
1071: when NO_DATA_FOUND then
1072: null;
1073: end;

Line 1081: select XMLConcat(l_xmlTypePermits,permits_record.workpermit) into l_xmlTypePermits from dual;

1077: --begin adding safety permit
1078: if p_safety_permit_flag = 1 then
1079: begin
1080: for permits_record in workpermit_cursor(p_wip_entity_id(i),l_org_id) loop
1081: select XMLConcat(l_xmlTypePermits,permits_record.workpermit) into l_xmlTypePermits from dual;
1082: end loop;
1083: select XMLELEMENT("WORKPERMIT_LIST",l_xmlTypePermits) into l_xmlTypePermits from dual;
1084: exception
1085: when NO_DATA_FOUND then

Line 1083: select XMLELEMENT("WORKPERMIT_LIST",l_xmlTypePermits) into l_xmlTypePermits from dual;

1079: begin
1080: for permits_record in workpermit_cursor(p_wip_entity_id(i),l_org_id) loop
1081: select XMLConcat(l_xmlTypePermits,permits_record.workpermit) into l_xmlTypePermits from dual;
1082: end loop;
1083: select XMLELEMENT("WORKPERMIT_LIST",l_xmlTypePermits) into l_xmlTypePermits from dual;
1084: exception
1085: when NO_DATA_FOUND then
1086: null;
1087: end;

Line 1095: select XMLConcat(l_xmlTypeClearances,clearances_record.workclearance) into l_xmlTypeClearances from dual;

1091: --begin adding safety clearance
1092: if p_safety_clearance_flag = 1 then
1093: begin
1094: for clearances_record in workclearance_cursor(p_wip_entity_id(i)) loop
1095: select XMLConcat(l_xmlTypeClearances,clearances_record.workclearance) into l_xmlTypeClearances from dual;
1096: end loop;
1097: select XMLELEMENT("WORKCLEARANCE_LIST",l_xmlTypeClearances) into l_xmlTypeClearances from dual;
1098: exception
1099: when NO_DATA_FOUND then

Line 1097: select XMLELEMENT("WORKCLEARANCE_LIST",l_xmlTypeClearances) into l_xmlTypeClearances from dual;

1093: begin
1094: for clearances_record in workclearance_cursor(p_wip_entity_id(i)) loop
1095: select XMLConcat(l_xmlTypeClearances,clearances_record.workclearance) into l_xmlTypeClearances from dual;
1096: end loop;
1097: select XMLELEMENT("WORKCLEARANCE_LIST",l_xmlTypeClearances) into l_xmlTypeClearances from dual;
1098: exception
1099: when NO_DATA_FOUND then
1100: null;
1101: end;

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

1287: l_xmlTypePermits :=NULL; --permit safety report
1288: l_xmlTypeClearances :=NULL; -- safety clearance
1289: end loop;
1290:
1291: select XMLELEMENT("WORKORDER_LIST", l_xmlType) into l_xmlType from dual;
1292:
1293: return l_xmlType.getClobVal();
1294: -- End of API body.
1295: