APPS.CSI_II_RELATIONSHIPS_PKG dependencies on CSI_II_RELATIONSHIPS

Line 1: PACKAGE BODY csi_ii_relationships_pkg AS

1: PACKAGE BODY csi_ii_relationships_pkg AS
2: /* $Header: csitiirb.pls 115.13 2003/09/04 00:18:58 sguthiva ship $ */
3: -- start of comments
4: -- package name : csi_ii_relationships_pkg
5: -- purpose :

Line 4: -- package name : csi_ii_relationships_pkg

1: PACKAGE BODY csi_ii_relationships_pkg AS
2: /* $Header: csitiirb.pls 115.13 2003/09/04 00:18:58 sguthiva ship $ */
3: -- start of comments
4: -- package name : csi_ii_relationships_pkg
5: -- purpose :
6: -- history :
7: -- note :
8: -- end of comments

Line 11: g_pkg_name CONSTANT VARCHAR2(30):= 'csi_ii_relationships_pkg';

7: -- note :
8: -- end of comments
9:
10:
11: g_pkg_name CONSTANT VARCHAR2(30):= 'csi_ii_relationships_pkg';
12: g_file_name CONSTANT VARCHAR2(12) := 'csitiirb.pls';
13:
14: PROCEDURE insert_row(
15: px_relationship_id IN OUT NOCOPY NUMBER,

Line 48: CURSOR c2 IS SELECT csi_ii_relationships_s.NEXTVAL FROM sys.dual;

44: p_last_update_login NUMBER,
45: p_object_version_number NUMBER)
46:
47: IS
48: CURSOR c2 IS SELECT csi_ii_relationships_s.NEXTVAL FROM sys.dual;
49: BEGIN
50: IF (px_relationship_id IS NULL) OR (px_relationship_id = fnd_api.g_miss_num) THEN
51: OPEN c2;
52: FETCH c2 INTO px_relationship_id;

Line 56: INSERT INTO csi_ii_relationships(

52: FETCH c2 INTO px_relationship_id;
53: CLOSE c2;
54: END IF;
55: --dbms_output.put_line('relationship_id'||px_relationship_id);
56: INSERT INTO csi_ii_relationships(
57: relationship_id,
58: relationship_type_code,
59: object_id,
60: subject_id,

Line 160: update csi_ii_relationships

156: p_object_version_number NUMBER)
157:
158: IS
159: BEGIN
160: update csi_ii_relationships
161: set
162: relationship_type_code = decode( p_relationship_type_code, fnd_api.g_miss_char, relationship_type_code, p_relationship_type_code),
163: object_id = decode( p_object_id, fnd_api.g_miss_num, object_id, p_object_id),
164: subject_id = decode( p_subject_id, fnd_api.g_miss_num, subject_id, p_subject_id),

Line 204: DELETE FROM csi_ii_relationships

200: PROCEDURE delete_row(
201: p_relationship_id NUMBER)
202: IS
203: BEGIN
204: DELETE FROM csi_ii_relationships
205: WHERE relationship_id = p_relationship_id;
206: IF (SQL%NOTFOUND) THEN
207: RAISE NO_DATA_FOUND;
208: END IF;

Line 247: FROM csi_ii_relationships

243:
244: IS
245: CURSOR c IS
246: SELECT *
247: FROM csi_ii_relationships
248: WHERE relationship_id = p_relationship_id
249: FOR UPDATE OF relationship_id NOWAIT;
250: recinfo c%ROWTYPE;
251: BEGIN

Line 360: END csi_ii_relationships_pkg;

356: app_exception.raise_exception;
357: END IF;
358: END lock_row;
359:
360: END csi_ii_relationships_pkg;