DBA Data[Home] [Help]

APPS.WIP_DISCRETE_J_PKG dependencies on WIP_ENTITIES_S

Line 93: CURSOR C2 IS SELECT wip_entities_s.nextval FROM DUAL;

89: CURSOR C(we_id NUMBER) IS SELECT rowid FROM WIP_DISCRETE_JOBS
90: WHERE wip_entity_id = we_id
91: AND organization_id = X_Organization_Id;
92:
93: CURSOR C2 IS SELECT wip_entities_s.nextval FROM DUAL;
94:
95: CURSOR C3(we_id NUMBER) IS SELECT rowid FROM WIP_ENTITIES
96: WHERE wip_entity_id = we_id
97: AND organization_id = X_Organization_Id;

Line 564: UPDATE WIP_ENTITIES SET

560: CLOSE C3;
561: else
562:
563: IF X_Update_Wip_Entities = 'Y' THEN
564: UPDATE WIP_ENTITIES SET
565: wip_entity_id = X_Wip_Entity_Id,
566: organization_id = X_Organization_Id,
567: last_update_date = X_Last_Update_Date,
568: last_updated_by = X_Last_Updated_By,