APPS.CSI_II_RELATIONSHIPS_H_PKG dependencies on CSI_II_RELATIONSHIPS_H

Line 1: PACKAGE BODY csi_ii_relationships_h_pkg AS

1: PACKAGE BODY csi_ii_relationships_h_pkg AS
2: /* $Header: csitirhb.pls 115.14 2003/09/04 00:20:36 sguthiva ship $ */
3: -- start of comments
4: -- package name : csi_ii_relationships_h_pkg
5: -- purpose :

Line 4: -- package name : csi_ii_relationships_h_pkg

1: PACKAGE BODY csi_ii_relationships_h_pkg AS
2: /* $Header: csitirhb.pls 115.14 2003/09/04 00:20:36 sguthiva ship $ */
3: -- start of comments
4: -- package name : csi_ii_relationships_h_pkg
5: -- purpose :
6: -- history :
7: -- note :
8: -- end of comments

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

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

Line 69: CURSOR c2 IS SELECT csi_ii_relationships_h_s.NEXTVAL FROM sys.dual;

65: p_last_update_login NUMBER ,
66: p_object_version_number NUMBER )
67:
68: IS
69: CURSOR c2 IS SELECT csi_ii_relationships_h_s.NEXTVAL FROM sys.dual;
70: BEGIN
71: IF (px_relationship_history_id IS NULL) OR (px_relationship_history_id = fnd_api.g_miss_num) THEN
72: OPEN c2;
73: FETCH c2 INTO px_relationship_history_id;

Line 76: INSERT INTO csi_ii_relationships_h(

72: OPEN c2;
73: FETCH c2 INTO px_relationship_history_id;
74: CLOSE c2;
75: END IF;
76: INSERT INTO csi_ii_relationships_h(
77: relationship_history_id,
78: relationship_id,
79: transaction_id,
80: old_subject_id,

Line 241: UPDATE csi_ii_relationships_h

237: p_object_version_number NUMBER )
238:
239: IS
240: BEGIN
241: UPDATE csi_ii_relationships_h
242: SET
243: relationship_id = DECODE( p_relationship_id, fnd_api.g_miss_num, relationship_id, p_relationship_id),
244: transaction_id = DECODE( p_transaction_id, fnd_api.g_miss_num, transaction_id, p_transaction_id),
245: old_subject_id = DECODE( p_old_subject_id, fnd_api.g_miss_num, old_subject_id, p_old_subject_id),

Line 302: END csi_ii_relationships_h_pkg;

298: RAISE NO_DATA_FOUND;
299: END IF;
300: END Update_Row;
301:
302: END csi_ii_relationships_h_pkg;