[Home] [Help]
516: if((nvl(l_return_status,'S'))='S') then
517:
518: X_wip_entity_id := l_workorder_rec1.wip_entity_id;
519:
520: select rowid into X_We_Rowid from WIP_ENTITIES where wip_entity_id=X_wip_entity_id;
521: select rowid into X_Rowid from WIP_DISCRETE_JOBS where wip_entity_id=X_wip_entity_id;
522: COMMIT;
523:
524: else
542: savepoint create_relation;
543:
544: select wip_entity_id
545: into temp
546: from wip_entities
547: where wip_entity_name = X_Parent_Wip_Name AND organization_id=X_organization_id ;
548:
549:
550: l_eam_wo_relations_rec3.batch_id := 1;
822: X_attribute15 IN OUT NOCOPY VARCHAR2,
823: X_We_Rowid IN OUT NOCOPY VARCHAR2,
824: X_Entity_Type NUMBER,
825: X_Wip_Entity_Name VARCHAR2,
826: X_Update_Wip_Entities VARCHAR2,
827: X_Schedule_Group_Id NUMBER,
828: X_Project_Id NUMBER,
829: X_Task_Id NUMBER,
830: X_priority IN OUT NOCOPY NUMBER,
1525:
1526:
1527: if((nvl(l_return_status,'S'))='S') then
1528:
1529: select rowid into X_We_Rowid from WIP_ENTITIES where wip_entity_id=X_wip_entity_id;
1530:
1531: else
1532: ROLLBACK TO UPDATE_WO;
1533: l_msg_count := FND_MSG_PUB.count_msg;
1731: X_attribute15 VARCHAR2,
1732: X_We_Rowid VARCHAR2,
1733: X_Entity_Type NUMBER,
1734: X_Wip_Entity_Name VARCHAR2,
1735: X_Update_Wip_Entities VARCHAR2,
1736: X_Schedule_Group_Id NUMBER,
1737: X_Project_Id NUMBER,
1738: X_Task_Id NUMBER,
1739: X_priority NUMBER,
1750: FOR UPDATE of Wip_Entity_Id NOWAIT;
1751:
1752: CURSOR C_WE IS
1753: SELECT *
1754: FROM WIP_ENTITIES
1755: WHERE rowid = X_We_Rowid
1756: FOR UPDATE of Wip_Entity_Id NOWAIT;
1757:
1758: CURSOR C_ewod IS
1900: APP_EXCEPTION.Raise_Exception;
1901: null;
1902: end if;
1903:
1904: -- Wip Entities
1905: -- Wip Discrete Jobs
1906: OPEN C_WE;
1907: FETCH C_WE INTO Recinfo2;
1908: if (C_WE%NOTFOUND) then