[Home] [Help]
PACKAGE: APPS.RG_DSS_VAR_DIMENSIONS_PKG
Source
1 PACKAGE RG_DSS_VAR_DIMENSIONS_PKG as
2 /* $Header: rgidvdms.pls 120.2 2002/11/14 02:59:34 djogg ship $ */
3
4
5 /* Name: check_unique_sequence
6 * Desc: Check if sequence already exists for specified variable. If it does,
7 * raise an exception. If it doesn't, do nothing.
8 *
9 * History:
10 * 06/26/95 S. Rahman Created.
11 */
12 PROCEDURE check_unique_sequence(X_Rowid VARCHAR2,
13 X_Variable_Id NUMBER,
14 X_Sequence NUMBER);
15
16
17 /* Name: check_unique
18 * Desc: Check if dimension already exists for specified variable. If it
19 * does raise an exception. If it doesn't, do nothing.
20 *
21 * History:
22 * 06/26/95 S. Rahman Created.
23 */
24 PROCEDURE check_unique_dimension(X_Rowid VARCHAR2,
25 X_Variable_Id NUMBER,
26 X_Dimension_Id NUMBER);
27
28
29 /* Name: insert_row
30 * Desc: Insert a row into rg_dss_var_dimensions. Ensure that the variable id
31 * and sequence combination doesn't exist already.Return the rowid
32 * of the inserted row to the form.
33 *
34 * History:
35 * 06/26/95 S. Rahman Created.
36 */
37 PROCEDURE Insert_Row(
38 X_Master_Variable_Id IN OUT NOCOPY NUMBER,
39 X_Rowid IN OUT NOCOPY VARCHAR2,
40 X_Variable_Id IN OUT NOCOPY NUMBER,
41 X_Sequence NUMBER,
42 X_Dimension_Id NUMBER,
43 X_Last_Update_Date DATE,
44 X_Last_Updated_By NUMBER,
45 X_Last_Update_Login NUMBER,
46 X_Creation_Date DATE,
47 X_Created_By NUMBER,
48 X_Context VARCHAR2,
49 X_Attribute1 VARCHAR2,
50 X_Attribute2 VARCHAR2,
51 X_Attribute3 VARCHAR2,
52 X_Attribute4 VARCHAR2,
53 X_Attribute5 VARCHAR2,
54 X_Attribute6 VARCHAR2,
55 X_Attribute7 VARCHAR2,
56 X_Attribute8 VARCHAR2,
57 X_Attribute9 VARCHAR2,
58 X_Attribute10 VARCHAR2,
59 X_Attribute11 VARCHAR2,
60 X_Attribute12 VARCHAR2,
61 X_Attribute13 VARCHAR2,
62 X_Attribute14 VARCHAR2,
63 X_Attribute15 VARCHAR2
64 );
65
66
67 /* Name: lock_row
68 * Desc: Lock the row specified by X_Rowid.
69 *
70 * History:
71 * 06/26/95 S. Rahman Created.
72 */
73 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
74 X_Variable_Id NUMBER,
75 X_Sequence NUMBER,
76 X_Dimension_Id NUMBER,
77 X_Context VARCHAR2,
78 X_Attribute1 VARCHAR2,
79 X_Attribute2 VARCHAR2,
80 X_Attribute3 VARCHAR2,
81 X_Attribute4 VARCHAR2,
82 X_Attribute5 VARCHAR2,
83 X_Attribute6 VARCHAR2,
84 X_Attribute7 VARCHAR2,
85 X_Attribute8 VARCHAR2,
86 X_Attribute9 VARCHAR2,
87 X_Attribute10 VARCHAR2,
88 X_Attribute11 VARCHAR2,
89 X_Attribute12 VARCHAR2,
90 X_Attribute13 VARCHAR2,
91 X_Attribute14 VARCHAR2,
92 X_Attribute15 VARCHAR2
93 );
94
95
96 /* Name: update_row
97 * Desc: Update the row specified by X_Rowid.
98 *
99 * History:
100 * 06/26/95 S. Rahman Created.
101 */
102 PROCEDURE Update_Row(X_Rowid VARCHAR2,
103 X_Variable_Id NUMBER,
104 X_Sequence NUMBER,
105 X_Dimension_Id NUMBER,
106 X_Last_Update_Date DATE,
107 X_Last_Updated_By NUMBER,
108 X_Last_Update_Login NUMBER,
109 X_Context VARCHAR2,
110 X_Attribute1 VARCHAR2,
111 X_Attribute2 VARCHAR2,
112 X_Attribute3 VARCHAR2,
113 X_Attribute4 VARCHAR2,
114 X_Attribute5 VARCHAR2,
115 X_Attribute6 VARCHAR2,
116 X_Attribute7 VARCHAR2,
117 X_Attribute8 VARCHAR2,
118 X_Attribute9 VARCHAR2,
119 X_Attribute10 VARCHAR2,
120 X_Attribute11 VARCHAR2,
121 X_Attribute12 VARCHAR2,
122 X_Attribute13 VARCHAR2,
123 X_Attribute14 VARCHAR2,
124 X_Attribute15 VARCHAR2
125 );
126
127
128 /* Name: delete_row
129 * Desc: Delete the row specified by X_Rowid.
130 *
131 * History:
132 * 06/26/95 S. Rahman Created.
133 */
134 PROCEDURE Delete_Row(X_Rowid VARCHAR2, X_Variable_Id NUMBER);
135
136
137 END RG_DSS_VAR_DIMENSIONS_PKG;