APPS.WMS_DB_OBJ_REF_MEMBERS_PKG dependencies on WMS_DB_OBJ_REF_MEMBERS

Line 1: PACKAGE BODY WMS_DB_OBJ_REF_MEMBERS_PKG AS

1: PACKAGE BODY WMS_DB_OBJ_REF_MEMBERS_PKG AS
2: /* $Header: WMSPPRMB.pls 120.1 2005/06/20 03:08:16 appldev ship $ */
3: --
4: PROCEDURE INSERT_ROW (
5: x_rowid IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 33: CURSOR C IS SELECT ROWID FROM WMS_DB_OBJ_REF_MEMBERS

29: ,x_attribute14 IN VARCHAR2
30: ,x_attribute15 IN VARCHAR2
31: ,x_attribute_category IN VARCHAR2
32: )IS
33: CURSOR C IS SELECT ROWID FROM WMS_DB_OBJ_REF_MEMBERS
34: WHERE db_object_reference_id = x_db_object_reference_id
35: AND sequence_number = x_sequence_number;
36: BEGIN
37:

Line 38: INSERT INTO WMS_DB_OBJ_REF_MEMBERS (

34: WHERE db_object_reference_id = x_db_object_reference_id
35: AND sequence_number = x_sequence_number;
36: BEGIN
37:
38: INSERT INTO WMS_DB_OBJ_REF_MEMBERS (
39: db_object_reference_id
40: ,sequence_number
41: ,db_object_id
42: ,table_alias

Line 149: FROM WMS_DB_OBJ_REF_MEMBERS

145: ,attribute13
146: ,attribute14
147: ,attribute15
148: ,attribute_category
149: FROM WMS_DB_OBJ_REF_MEMBERS
150: WHERE rowid = x_rowid
151: FOR UPDATE OF db_object_reference_id NOWAIT;
152:
153: recinfo c%ROWTYPE;

Line 253: UPDATE WMS_DB_OBJ_REF_MEMBERS SET

249: ,x_attribute15 IN VARCHAR2
250: ,x_attribute_category IN VARCHAR2
251: )IS
252: BEGIN
253: UPDATE WMS_DB_OBJ_REF_MEMBERS SET
254: db_object_id = x_db_object_id
255: ,table_alias = x_table_alias
256: ,user_defined_flag = x_user_defined_flag
257: ,last_updated_by = x_last_updated_by

Line 288: DELETE FROM WMS_DB_OBJ_REF_MEMBERS

284: PROCEDURE DELETE_ROW (
285: x_rowid IN VARCHAR2
286: )IS
287: BEGIN
288: DELETE FROM WMS_DB_OBJ_REF_MEMBERS
289: WHERE rowid = x_rowid;
290:
291: IF (SQL%NOTFOUND) THEN
292: RAISE NO_DATA_FOUND;

Line 341: wms_db_obj_ref_members_pkg.update_row

337: l_sequence_number :=
338: fnd_number.canonical_to_number(x_sequence_number);
339: l_db_object_id :=
340: fnd_number.canonical_to_number(x_db_object_id);
341: wms_db_obj_ref_members_pkg.update_row
342: (
343: x_db_object_reference_id => l_db_object_reference_id
344: ,x_sequence_number => l_sequence_number
345: ,x_db_object_id => l_db_object_id

Line 370: wms_db_obj_ref_members_pkg.insert_row

366: ,x_attribute_category => x_attribute_category
367: );
368: EXCEPTION
369: WHEN no_data_found THEN
370: wms_db_obj_ref_members_pkg.insert_row
371: (
372: x_rowid => l_row_id
373: ,x_db_object_reference_id => l_db_object_reference_id
374: ,x_sequence_number => l_sequence_number

Line 402: END WMS_DB_OBJ_REF_MEMBERS_PKG;

398: ,x_attribute_category => x_attribute_category
399: );
400: END;
401: END load_row;
402: END WMS_DB_OBJ_REF_MEMBERS_PKG;