APPS.WMS_DB_OBJECT_JOINS_PKG dependencies on WMS_DB_OBJECT_JOINS

Line 1: PACKAGE BODY WMS_DB_OBJECT_JOINS_PKG AS

1: PACKAGE BODY WMS_DB_OBJECT_JOINS_PKG AS
2: /* $Header: WMSPDOJB.pls 120.1 2005/06/20 04:35:20 appldev ship $ */
3: --
4: PROCEDURE INSERT_ROW (
5: x_rowid IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 34: CURSOR C IS SELECT ROWID FROM WMS_DB_OBJECT_JOINS

30: ,x_attribute13 IN VARCHAR2
31: ,x_attribute14 IN VARCHAR2
32: ,x_attribute15 IN VARCHAR2
33: )IS
34: CURSOR C IS SELECT ROWID FROM WMS_DB_OBJECT_JOINS
35: WHERE db_object_id = x_db_object_id
36: AND sequence_number = x_sequence_number;
37: BEGIN
38:

Line 39: INSERT INTO WMS_DB_OBJECT_JOINS (

35: WHERE db_object_id = x_db_object_id
36: AND sequence_number = x_sequence_number;
37: BEGIN
38:
39: INSERT INTO WMS_DB_OBJECT_JOINS (
40: db_object_id
41: ,type_code
42: ,sequence_number
43: ,last_updated_by

Line 154: FROM WMS_DB_OBJECT_JOINS

150: ,attribute12
151: ,attribute13
152: ,attribute14
153: ,attribute15
154: FROM WMS_DB_OBJECT_JOINS
155: WHERE rowid = x_rowid
156: FOR UPDATE OF db_object_id NOWAIT;
157:
158: recinfo c%ROWTYPE;

Line 259: UPDATE WMS_DB_OBJECT_JOINS SET

255: ,x_attribute15 IN VARCHAR2
256: )IS
257:
258: BEGIN
259: UPDATE WMS_DB_OBJECT_JOINS SET
260: last_updated_by = x_last_updated_by
261: ,last_update_date = x_last_update_date
262: ,last_update_login = x_last_update_login
263: ,parameter_id = x_parameter_id

Line 295: DELETE FROM WMS_DB_OBJECT_JOINS

291: x_rowid IN VARCHAR2
292: )IS
293: BEGIN
294:
295: DELETE FROM WMS_DB_OBJECT_JOINS
296: WHERE rowid = x_rowid;
297:
298: IF (SQL%NOTFOUND) THEN
299: RAISE NO_DATA_FOUND;

Line 353: wms_db_object_joins_pkg.update_row

349: l_parameter_id :=
350: fnd_number.canonical_to_number(x_parameter_id);
351: l_parent_parameter_id :=
352: fnd_number.canonical_to_number(x_parent_parameter_id);
353: wms_db_object_joins_pkg.update_row
354: (
355: x_db_object_id => l_db_object_id
356: ,x_type_code => l_type_code
357: ,x_sequence_number => l_sequence_number

Line 383: wms_db_object_joins_pkg.insert_row

379: ,x_attribute15 => x_attribute15
380: );
381: EXCEPTION
382: WHEN no_data_found THEN
383: wms_db_object_joins_pkg.insert_row
384: (
385: x_rowid => l_row_id
386: ,x_db_object_id => l_db_object_id
387: ,x_type_code => l_type_code

Line 416: END WMS_DB_OBJECT_JOINS_PKG;

412: ,x_attribute15 => x_attribute15
413: );
414: END;
415: END load_row;
416: END WMS_DB_OBJECT_JOINS_PKG;