APPS.WMS_DB_OBJECT_REF_PKG dependencies on WMS_DB_OBJECT_REFERENCES

Line 31: CURSOR C IS SELECT ROWID FROM WMS_DB_OBJECT_REFERENCES

27: ,x_attribute14 IN VARCHAR2
28: ,x_attribute15 IN VARCHAR2
29: ,x_attribute_category IN VARCHAR2
30: )IS
31: CURSOR C IS SELECT ROWID FROM WMS_DB_OBJECT_REFERENCES
32: WHERE db_object_reference_id = x_db_object_reference_id;
33: BEGIN
34:
35: INSERT INTO WMS_DB_OBJECT_REFERENCES (

Line 35: INSERT INTO WMS_DB_OBJECT_REFERENCES (

31: CURSOR C IS SELECT ROWID FROM WMS_DB_OBJECT_REFERENCES
32: WHERE db_object_reference_id = x_db_object_reference_id;
33: BEGIN
34:
35: INSERT INTO WMS_DB_OBJECT_REFERENCES (
36: db_object_reference_id
37: ,last_updated_by
38: ,last_update_date
39: ,created_by

Line 138: FROM WMS_DB_OBJECT_REFERENCES

134: ,attribute13
135: ,attribute14
136: ,attribute15
137: ,attribute_category
138: FROM WMS_DB_OBJECT_REFERENCES
139: WHERE rowid = x_rowid
140: FOR UPDATE OF db_object_reference_id NOWAIT;
141:
142: recinfo c%ROWTYPE;

Line 238: UPDATE WMS_DB_OBJECT_REFERENCES SET

234: ,x_attribute15 IN VARCHAR2
235: ,x_attribute_category IN VARCHAR2
236: )IS
237: BEGIN
238: UPDATE WMS_DB_OBJECT_REFERENCES SET
239: last_updated_by = x_last_updated_by
240: ,last_update_date = x_last_update_date
241: ,last_update_login = x_last_update_login
242: ,description = x_description

Line 271: DELETE FROM WMS_DB_OBJECT_REFERENCES

267: x_rowid IN VARCHAR2
268: )IS
269: BEGIN
270:
271: DELETE FROM WMS_DB_OBJECT_REFERENCES
272: WHERE rowid = x_rowid;
273:
274: IF (SQL%NOTFOUND) THEN
275: RAISE NO_DATA_FOUND;