[Home] [Help]
PACKAGE: APPS.RG_DSS_HIERARCHIES_PKG
Source
1 PACKAGE RG_DSS_HIERARCHIES_PKG as
2 /* $Header: rgidhrcs.pls 120.2 2002/11/14 02:58:32 djogg ship $ */
3
4
5 /* Name: get_new_id
6 * Desc: Gets a new id from the sequence RG_DSS_HIERARCHIES_S
7 *
8 * History:
9 * 11/02/95 S. Rahman Created.
10 */
11 FUNCTION get_new_id RETURN NUMBER;
12
13
14 /* Name: used_in_frozen_system
15 * Desc: Return TRUE if the hierarchy is used in a frozen system;
16 * FALSE otherwise.
17 *
18 * History:
19 * 06/26/95 S. Rahman Created.
20 */
21 FUNCTION used_in_frozen_system(X_Hierarchy_Id NUMBER) RETURN BOOLEAN;
22
23
24 /* Name: check_unique_name
25 * Desc: Check if the hierarchy name already exists. If it does,
26 * raise an exception. If it doesn't, do nothing.
27 *
28 * History:
29 * 06/20/95 S. Rahman Created.
30 */
31 PROCEDURE check_unique_name(X_Rowid VARCHAR2, X_Name VARCHAR2);
32
33
34 /* Name: details_exists
35 * Desc: Return TRUE if any details records exist; otherwise return FALSE.
36 *
37 * History:
38 * 06/20/95 S. Rahman Created.
39 */
40 FUNCTION details_exists(X_Hierarchy_Id NUMBER) RETURN BOOLEAN;
41
42
43 /* Name: num_details
44 * Desc: Return the number detail records for this hierarchy.
45 *
46 * History:
47 * 11/02/95 S. Rahman Created.
48 */
49 FUNCTION num_details(X_Hierarchy_Id NUMBER) RETURN NUMBER;
50
51
52 /* Name: check_references
53 * Desc: Check if the hierarchy is used in a system.
54 *
55 * History:
56 * 07/17/95 S. Rahman Created.
57 */
58 PROCEDURE check_references(X_Hierarchy_Id NUMBER);
59
60
61 /* Name: insert_row
62 * Desc: Insert a row into rg_dss_hierarchies. Ensure that the
63 * hierarchy name doesn't exist already. Assign the
64 * primary key (hierarchy_id). Return the rowid of the inserted
65 * row to the form.
66 *
67 * History:
68 * 06/20/95 S. Rahman Created.
69 */
70 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
71 X_Hierarchy_Id IN OUT NOCOPY NUMBER,
72 X_Name VARCHAR2,
73 X_Id_Flex_Code VARCHAR2,
74 X_Id_Flex_Num NUMBER,
75 X_Dimension_Id NUMBER,
76 X_Description VARCHAR2,
77 X_Last_Update_Date DATE,
78 X_Last_Updated_By NUMBER,
79 X_Last_Update_Login NUMBER,
80 X_Creation_Date DATE,
81 X_Created_By NUMBER,
82 X_Context VARCHAR2,
83 X_Attribute1 VARCHAR2,
84 X_Attribute2 VARCHAR2,
85 X_Attribute3 VARCHAR2,
86 X_Attribute4 VARCHAR2,
87 X_Attribute5 VARCHAR2,
88 X_Attribute6 VARCHAR2,
89 X_Attribute7 VARCHAR2,
90 X_Attribute8 VARCHAR2,
91 X_Attribute9 VARCHAR2,
92 X_Attribute10 VARCHAR2,
93 X_Attribute11 VARCHAR2,
94 X_Attribute12 VARCHAR2,
95 X_Attribute13 VARCHAR2,
96 X_Attribute14 VARCHAR2,
97 X_Attribute15 VARCHAR2
98 );
99
100
101 /* Name: lock_row
102 * Desc: Lock the row specified by X_Rowid.
103 *
104 * History:
105 * 06/20/95 S. Rahman Created.
106 */
107 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
108 X_Hierarchy_Id NUMBER,
109 X_Name VARCHAR2,
110 X_Id_Flex_Code VARCHAR2,
111 X_Id_Flex_Num NUMBER,
112 X_Dimension_Id NUMBER,
113 X_Description VARCHAR2,
114 X_Context VARCHAR2,
115 X_Attribute1 VARCHAR2,
116 X_Attribute2 VARCHAR2,
117 X_Attribute3 VARCHAR2,
118 X_Attribute4 VARCHAR2,
119 X_Attribute5 VARCHAR2,
120 X_Attribute6 VARCHAR2,
121 X_Attribute7 VARCHAR2,
122 X_Attribute8 VARCHAR2,
123 X_Attribute9 VARCHAR2,
124 X_Attribute10 VARCHAR2,
125 X_Attribute11 VARCHAR2,
126 X_Attribute12 VARCHAR2,
127 X_Attribute13 VARCHAR2,
128 X_Attribute14 VARCHAR2,
129 X_Attribute15 VARCHAR2
130 );
131
132
133 /* Name: update_row
134 * Desc: Update the row specified by X_Rowid.
135 *
136 * History:
137 * 06/20/95 S. Rahman Created.
138 */
139 PROCEDURE Update_Row(X_Rowid VARCHAR2,
140 X_Hierarchy_Id NUMBER,
141 X_Name VARCHAR2,
142 X_Id_Flex_Code VARCHAR2,
143 X_Id_Flex_Num NUMBER,
144 X_Dimension_Id NUMBER,
145 X_Description VARCHAR2,
146 X_Last_Update_Date DATE,
147 X_Last_Updated_By NUMBER,
148 X_Last_Update_Login NUMBER,
149 X_Context VARCHAR2,
150 X_Attribute1 VARCHAR2,
151 X_Attribute2 VARCHAR2,
152 X_Attribute3 VARCHAR2,
153 X_Attribute4 VARCHAR2,
154 X_Attribute5 VARCHAR2,
155 X_Attribute6 VARCHAR2,
156 X_Attribute7 VARCHAR2,
157 X_Attribute8 VARCHAR2,
158 X_Attribute9 VARCHAR2,
159 X_Attribute10 VARCHAR2,
160 X_Attribute11 VARCHAR2,
161 X_Attribute12 VARCHAR2,
162 X_Attribute13 VARCHAR2,
163 X_Attribute14 VARCHAR2,
164 X_Attribute15 VARCHAR2
165 );
166
167
168 /* Name: delete_row
169 * Desc: Delete the row specified by X_Rowid.
170 *
171 * History:
172 * 06/20/95 S. Rahman Created.
173 */
174 PROCEDURE Delete_Row(X_Rowid VARCHAR2, X_Hierarchy_Id NUMBER);
175
176
177 END RG_DSS_HIERARCHIES_PKG;