[Home] [Help]
PACKAGE: APPS.CSI_II_RELATIONSHIPS_H_PKG
Source
1 PACKAGE csi_ii_relationships_h_pkg AUTHID CURRENT_USER AS
2 /* $Header: csitirhs.pls 115.12 2003/09/04 00:20:45 sguthiva ship $ */
3 -- start of comments
4 -- package name : csi_ii_relationships_h_pkg
5 -- purpose :
6 -- history :
7 -- note :
8 -- end of comments
9 PROCEDURE insert_row(
10 px_relationship_history_id IN OUT NOCOPY NUMBER ,
11 p_relationship_id NUMBER ,
12 p_transaction_id NUMBER ,
13 p_old_subject_id NUMBER ,
14 p_new_subject_id NUMBER ,
15 p_old_position_reference VARCHAR2,
16 p_new_position_reference VARCHAR2,
17 p_old_active_start_date DATE ,
18 p_new_active_start_date DATE ,
19 p_old_active_end_date DATE ,
20 p_new_active_end_date DATE ,
21 p_old_mandatory_flag VARCHAR2,
22 p_new_mandatory_flag VARCHAR2,
23 p_old_context VARCHAR2,
24 p_new_context VARCHAR2,
25 p_old_attribute1 VARCHAR2,
26 p_new_attribute1 VARCHAR2,
27 p_old_attribute2 VARCHAR2,
28 p_new_attribute2 VARCHAR2,
29 p_old_attribute3 VARCHAR2,
30 p_new_attribute3 VARCHAR2,
31 p_old_attribute4 VARCHAR2,
32 p_new_attribute4 VARCHAR2,
33 p_old_attribute5 VARCHAR2,
34 p_new_attribute5 VARCHAR2,
35 p_old_attribute6 VARCHAR2,
36 p_new_attribute6 VARCHAR2,
37 p_old_attribute7 VARCHAR2,
38 p_new_attribute7 VARCHAR2,
39 p_old_attribute8 VARCHAR2,
40 p_new_attribute8 VARCHAR2,
41 p_old_attribute9 VARCHAR2,
42 p_new_attribute9 VARCHAR2,
43 p_old_attribute10 VARCHAR2,
44 p_new_attribute10 VARCHAR2,
45 p_old_attribute11 VARCHAR2,
46 p_new_attribute11 VARCHAR2,
47 p_old_attribute12 VARCHAR2,
48 p_new_attribute12 VARCHAR2,
49 p_old_attribute13 VARCHAR2,
50 p_new_attribute13 VARCHAR2,
51 p_old_attribute14 VARCHAR2,
52 p_new_attribute14 VARCHAR2,
53 p_old_attribute15 VARCHAR2,
54 p_new_attribute15 VARCHAR2,
55 p_full_dump_flag VARCHAR2,
56 p_created_by NUMBER ,
57 p_creation_date DATE ,
58 p_last_updated_by NUMBER ,
59 p_last_update_date DATE ,
60 p_last_update_login NUMBER ,
61 p_object_version_number NUMBER );
62
63 PROCEDURE update_row(
64 p_relationship_history_id NUMBER ,
65 p_relationship_id NUMBER ,
66 p_transaction_id NUMBER ,
67 p_old_subject_id NUMBER ,
68 p_new_subject_id NUMBER ,
69 p_old_position_reference VARCHAR2,
70 p_new_position_reference VARCHAR2,
71 p_old_active_start_date DATE ,
72 p_new_active_start_date DATE ,
73 p_old_active_end_date DATE ,
74 p_new_active_end_date DATE ,
75 p_old_mandatory_flag VARCHAR2,
76 p_new_mandatory_flag VARCHAR2,
77 p_old_context VARCHAR2,
78 p_new_context VARCHAR2,
79 p_old_attribute1 VARCHAR2,
80 p_new_attribute1 VARCHAR2,
81 p_old_attribute2 VARCHAR2,
82 p_new_attribute2 VARCHAR2,
83 p_old_attribute3 VARCHAR2,
84 p_new_attribute3 VARCHAR2,
85 p_old_attribute4 VARCHAR2,
86 p_new_attribute4 VARCHAR2,
87 p_old_attribute5 VARCHAR2,
88 p_new_attribute5 VARCHAR2,
89 p_old_attribute6 VARCHAR2,
90 p_new_attribute6 VARCHAR2,
91 p_old_attribute7 VARCHAR2,
92 p_new_attribute7 VARCHAR2,
93 p_old_attribute8 VARCHAR2,
94 p_new_attribute8 VARCHAR2,
95 p_old_attribute9 VARCHAR2,
96 p_new_attribute9 VARCHAR2,
97 p_old_attribute10 VARCHAR2,
98 p_new_attribute10 VARCHAR2,
99 p_old_attribute11 VARCHAR2,
100 p_new_attribute11 VARCHAR2,
101 p_old_attribute12 VARCHAR2,
102 p_new_attribute12 VARCHAR2,
103 p_old_attribute13 VARCHAR2,
104 p_new_attribute13 VARCHAR2,
105 p_old_attribute14 VARCHAR2,
106 p_new_attribute14 VARCHAR2,
107 p_old_attribute15 VARCHAR2,
108 p_new_attribute15 VARCHAR2,
109 p_full_dump_flag VARCHAR2,
110 p_created_by NUMBER ,
111 p_creation_date DATE ,
112 p_last_updated_by NUMBER ,
113 p_last_update_date DATE ,
114 p_last_update_login NUMBER ,
115 p_object_version_number NUMBER );
116
117
118
119 END csi_ii_relationships_h_pkg;