[Home] [Help]
PACKAGE: APPS.RG_DSS_SYSTEM_VARIABLES_PKG
Source
1 PACKAGE RG_DSS_SYSTEM_VARIABLES_PKG as
2 /* $Header: rgidsvrs.pls 120.2 2002/11/14 02:59:09 djogg ship $ */
3
4
5 /* Name: check_unique
6 * Desc: Check if the financial data already exists for the system. If it
7 * does, raise an exception. If it doesn't, do nothing.
8 *
9 * History:
10 * 07/03/95 S. Rahman Created.
11 */
12 PROCEDURE check_unique(X_Rowid VARCHAR2,
13 X_System_Id NUMBER,
14 X_Variable_Id NUMBER);
15
16
17 /* Name: insert_row
18 * Desc: Insert a row into rg_dss_system_variables. Ensure that the
19 * financial data doesn't exist already. Assign the
20 * primary key (system_variable_id). Return the rowid of the inserted
21 * row to the form.
22 *
23 * History:
24 * 07/03/95 S. Rahman Created.
25 */
26 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
27 X_System_Id NUMBER,
28 X_Variable_Id NUMBER,
29 X_System_Variable_Id IN OUT NOCOPY NUMBER,
30 X_Last_Update_Date DATE,
31 X_Last_Updated_By NUMBER,
32 X_Last_Update_Login NUMBER,
33 X_Creation_Date DATE,
34 X_Created_By NUMBER,
35 X_Context VARCHAR2,
36 X_Attribute1 VARCHAR2,
37 X_Attribute2 VARCHAR2,
38 X_Attribute3 VARCHAR2,
39 X_Attribute4 VARCHAR2,
40 X_Attribute5 VARCHAR2,
41 X_Attribute6 VARCHAR2,
42 X_Attribute7 VARCHAR2,
43 X_Attribute8 VARCHAR2,
44 X_Attribute9 VARCHAR2,
45 X_Attribute10 VARCHAR2,
46 X_Attribute11 VARCHAR2,
47 X_Attribute12 VARCHAR2,
48 X_Attribute13 VARCHAR2,
49 X_Attribute14 VARCHAR2,
50 X_Attribute15 VARCHAR2
51 );
52
53
54 /* Name: lock_row
55 * Desc: Lock the row specified by X_Rowid.
56 *
57 * History:
58 * 07/03/95 S. Rahman Created.
59 */
60 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
61 X_System_Id NUMBER,
62 X_Variable_Id NUMBER,
63 X_System_Variable_Id NUMBER,
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: update_row
84 * Desc: Update the row specified by X_Rowid.
85 *
86 * History:
87 * 07/03/95 S. Rahman Created.
88 */
89 PROCEDURE Update_Row(X_Rowid VARCHAR2,
90 X_System_Id NUMBER,
91 X_Variable_Id NUMBER,
92 X_System_Variable_Id NUMBER,
93 X_Last_Update_Date DATE,
94 X_Last_Updated_By NUMBER,
95 X_Last_Update_Login NUMBER,
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: delete_row
116 * Desc: Delete the row specified by X_Rowid.
117 *
118 * History:
119 * 07/03/95 S. Rahman Created.
120 */
121 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
122
123
124 END RG_DSS_SYSTEM_VARIABLES_PKG;