APPS.WMS_ORG_HIER_OBJS_PKG dependencies on WMS_ORG_HIERARCHY_OBJS

Line 32: CURSOR C IS SELECT ROWID FROM WMS_ORG_HIERARCHY_OBJS

28: ,x_attribute14 IN VARCHAR2
29: ,x_attribute15 IN VARCHAR2
30: ,x_type_code IN NUMBER
31: )IS
32: CURSOR C IS SELECT ROWID FROM WMS_ORG_HIERARCHY_OBJS
33: WHERE organization_id = x_organization_id
34: AND object_id = x_object_id
35: AND type_code = x_type_code;
36: BEGIN

Line 38: INSERT INTO WMS_ORG_HIERARCHY_OBJS (

34: AND object_id = x_object_id
35: AND type_code = x_type_code;
36: BEGIN
37:
38: INSERT INTO WMS_ORG_HIERARCHY_OBJS (
39: organization_id
40: ,object_id
41: ,last_updated_by
42: ,last_update_date

Line 145: FROM WMS_ORG_HIERARCHY_OBJS

141: ,attribute13
142: ,attribute14
143: ,attribute15
144: ,type_code
145: FROM WMS_ORG_HIERARCHY_OBJS
146: WHERE rowid = x_rowid
147: FOR UPDATE OF organization_id NOWAIT;
148:
149: recinfo c%ROWTYPE;

Line 248: UPDATE WMS_ORG_HIERARCHY_OBJS SET

244: ,x_attribute15 IN VARCHAR2
245: ,x_type_code IN NUMBER
246: )IS
247: BEGIN
248: UPDATE WMS_ORG_HIERARCHY_OBJS SET
249: organization_id = x_organization_id
250: ,object_id = x_object_id
251: ,last_updated_by = x_last_updated_by
252: ,last_update_date = x_last_update_date

Line 284: DELETE FROM WMS_ORG_HIERARCHY_OBJS

280: x_rowid IN VARCHAR2
281: )IS
282: BEGIN
283:
284: DELETE FROM WMS_ORG_HIERARCHY_OBJS
285: WHERE rowid = x_rowid;
286:
287: IF (SQL%NOTFOUND) THEN
288: RAISE NO_DATA_FOUND;