[Home] [Help]
514: if((nvl(l_return_status,'S'))='S') then
515:
516: X_wip_entity_id := l_workorder_rec1.wip_entity_id;
517:
518: select rowid into X_We_Rowid from WIP_ENTITIES where wip_entity_id=X_wip_entity_id;
519: select rowid into X_Rowid from WIP_DISCRETE_JOBS where wip_entity_id=X_wip_entity_id;
520: COMMIT;
521:
522: else
540: savepoint create_relation;
541:
542: select wip_entity_id
543: into temp
544: from wip_entities
545: where wip_entity_name = X_Parent_Wip_Name AND organization_id=X_organization_id ;
546:
547:
548: l_eam_wo_relations_rec3.batch_id := 1;
818: X_attribute15 IN OUT NOCOPY VARCHAR2,
819: X_We_Rowid IN OUT NOCOPY VARCHAR2,
820: X_Entity_Type NUMBER,
821: X_Wip_Entity_Name VARCHAR2,
822: X_Update_Wip_Entities VARCHAR2,
823: X_Schedule_Group_Id NUMBER,
824: X_Project_Id NUMBER,
825: X_Task_Id NUMBER,
826: X_priority IN OUT NOCOPY NUMBER,
1520:
1521:
1522: if((nvl(l_return_status,'S'))='S') then
1523:
1524: select rowid into X_We_Rowid from WIP_ENTITIES where wip_entity_id=X_wip_entity_id;
1525:
1526: else
1527: ROLLBACK TO UPDATE_WO;
1528: l_msg_count := FND_MSG_PUB.count_msg;
1725: X_attribute15 VARCHAR2,
1726: X_We_Rowid VARCHAR2,
1727: X_Entity_Type NUMBER,
1728: X_Wip_Entity_Name VARCHAR2,
1729: X_Update_Wip_Entities VARCHAR2,
1730: X_Schedule_Group_Id NUMBER,
1731: X_Project_Id NUMBER,
1732: X_Task_Id NUMBER,
1733: X_priority NUMBER,
1744: FOR UPDATE of Wip_Entity_Id NOWAIT;
1745:
1746: CURSOR C_WE IS
1747: SELECT *
1748: FROM WIP_ENTITIES
1749: WHERE rowid = X_We_Rowid
1750: FOR UPDATE of Wip_Entity_Id NOWAIT;
1751:
1752: CURSOR C_ewod IS
1894: APP_EXCEPTION.Raise_Exception;
1895: null;
1896: end if;
1897:
1898: -- Wip Entities
1899: -- Wip Discrete Jobs
1900: OPEN C_WE;
1901: FETCH C_WE INTO Recinfo2;
1902: if (C_WE%NOTFOUND) then