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