[Home] [Help]
PACKAGE: APPS.RG_REPORT_PARAMETERS_PKG
Source
1 PACKAGE RG_REPORT_PARAMETERS_PKG AS
2 /* $Header: rgirpars.pls 120.4 2003/04/29 00:47:52 djogg ship $ */
3
4
5 --
6 -- NAME
7 -- Get_New_Id
8 --
9 -- DESCRIPTION
10 -- get a new parameter set id
11 --
12 -- PARAMETERS
13 -- None
14 --
15
16 FUNCTION get_new_id
17 RETURN NUMBER;
18
19 --
20 -- NAME
21 -- Dup_Parameter_Num
22 --
23 -- DESCRIPTION
24 -- Check whether the parameter_num exists in the same
25 -- parameter set already.
26 -- PARAMETERS
27 -- 1. parameter_set_id
28 -- 2. parameter_num
29 -- 3. parameter_type
30 -- 4. row_id
31 --
32
33 FUNCTION dup_parameter_num(para_set_id IN NUMBER,
34 para_num IN NUMBER,
35 para_type IN VARCHAR2,
36 row_id IN VARCHAR2)
37 RETURN BOOLEAN;
38
39 --
40 -- NAME
41 -- Insert_Row
42 --
43 -- DESCRIPTION
44 -- Duplicate parameter set
45 --
46 -- PARAMETERS
47 -- Listed Below
48 --
49
50 FUNCTION Duplicate_Row(from_parameter_set_id IN NUMBER)
51 RETURN NUMBER;
52
53 --
54 -- NAME
55 -- Insert_Row
56 --
57 -- DESCRIPTION
58 -- Insert a row into rg_report_parameters
59 --
60 -- PARAMETERS
61 -- Listed Below
62 --
63
64 FUNCTION Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
65 X_Parameter_Set_Id IN OUT NOCOPY NUMBER,
66 X_Last_Update_Date DATE,
67 X_Last_Updated_By NUMBER,
68 X_Last_Update_Login NUMBER,
69 X_Creation_Date DATE,
70 X_Created_By NUMBER,
71 X_Parameter_Num NUMBER,
72 X_Data_Type VARCHAR2,
73 X_Parameter_Id NUMBER,
74 X_Currency_Type VARCHAR2,
75 X_Entered_Currency VARCHAR2,
76 X_Ledger_Currency VARCHAR2,
77 X_Period_Num NUMBER,
78 X_Fiscal_Year_Offset NUMBER,
79 X_Context VARCHAR2,
80 X_Attribute1 VARCHAR2,
81 X_Attribute2 VARCHAR2,
82 X_Attribute3 VARCHAR2,
83 X_Attribute4 VARCHAR2,
84 X_Attribute5 VARCHAR2,
85 X_Attribute6 VARCHAR2,
86 X_Attribute7 VARCHAR2,
87 X_Attribute8 VARCHAR2,
88 X_Attribute9 VARCHAR2,
89 X_Attribute10 VARCHAR2,
90 X_Attribute11 VARCHAR2,
91 X_Attribute12 VARCHAR2,
92 X_Attribute13 VARCHAR2,
93 X_Attribute14 VARCHAR2,
94 X_Attribute15 VARCHAR2
95 ) RETURN BOOLEAN;
96 --
97 -- NAME
98 -- Lock_Row
99 --
100 -- DESCRIPTION
101 -- Insert a row into rg_report_parameters
102 --
103 -- PARAMETERS
104 -- Listed Below
105 --
106
107 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
108 X_Parameter_Set_Id NUMBER,
109 X_Parameter_Num NUMBER,
110 X_Data_Type VARCHAR2,
111 X_Parameter_Id NUMBER,
112 X_Currency_Type VARCHAR2,
113 X_Entered_Currency VARCHAR2,
114 X_Ledger_Currency VARCHAR2,
115 X_Period_Num NUMBER,
116 X_Fiscal_Year_Offset NUMBER,
117 X_Context VARCHAR2,
118 X_Attribute1 VARCHAR2,
119 X_Attribute2 VARCHAR2,
120 X_Attribute3 VARCHAR2,
121 X_Attribute4 VARCHAR2,
122 X_Attribute5 VARCHAR2,
123 X_Attribute6 VARCHAR2,
124 X_Attribute7 VARCHAR2,
125 X_Attribute8 VARCHAR2,
126 X_Attribute9 VARCHAR2,
127 X_Attribute10 VARCHAR2,
128 X_Attribute11 VARCHAR2,
129 X_Attribute12 VARCHAR2,
130 X_Attribute13 VARCHAR2,
131 X_Attribute14 VARCHAR2,
132 X_Attribute15 VARCHAR2
133 );
134
135 --
136 -- NAME
137 -- Update_Row
138 --
139 -- DESCRIPTION
140 -- Update a row in rg_report_parameters
141 --
142 -- PARAMETERS
143 -- Listed Below
144 --
145
146 FUNCTION update_row(X_Rowid VARCHAR2,
147 X_Parameter_Set_Id NUMBER,
148 X_Last_Update_Date DATE,
149 X_Last_Updated_By NUMBER,
150 X_Last_Update_Login NUMBER,
151 X_Parameter_Num NUMBER,
152 X_Data_Type VARCHAR2,
153 X_Parameter_Id NUMBER,
154 X_Currency_Type VARCHAR2,
155 X_Entered_Currency VARCHAR2,
156 X_Ledger_Currency VARCHAR2,
157 X_Period_Num NUMBER,
158 X_Fiscal_Year_Offset NUMBER,
159 X_Context VARCHAR2,
160 X_Attribute1 VARCHAR2,
161 X_Attribute2 VARCHAR2,
162 X_Attribute3 VARCHAR2,
163 X_Attribute4 VARCHAR2,
164 X_Attribute5 VARCHAR2,
165 X_Attribute6 VARCHAR2,
166 X_Attribute7 VARCHAR2,
167 X_Attribute8 VARCHAR2,
168 X_Attribute9 VARCHAR2,
169 X_Attribute10 VARCHAR2,
170 X_Attribute11 VARCHAR2,
171 X_Attribute12 VARCHAR2,
172 X_Attribute13 VARCHAR2,
173 X_Attribute14 VARCHAR2,
174 X_Attribute15 VARCHAR2
175 ) RETURN BOOLEAN;
176
177 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
178
179 END RG_REPORT_PARAMETERS_PKG;