[Home] [Help]
PACKAGE: APPS.GL_CONS_SEGMENT_ACTIONS_PKG
Source
1 PACKAGE GL_CONS_SEGMENT_ACTIONS_PKG as
2 /* $Header: glicosas.pls 120.5 2005/05/05 01:05:57 kvora ship $ */
3 --
4 -- Package
5 -- GL_CONS_SEGMENT_ACTIONS_PKG
6 -- Purpose
7 -- Package procedures for Chart of Accounts Mapping Setup form,
8 -- Chart of Accounts Mapping Segment Actions block
9 -- History
10 -- 19-Feb-97 U Thimmappa Created
11 --
12
13 --
14 -- PUBLIC VARIABLES
15 --
16 coa_mapping_id NUMBER;
17 to_chart_of_accounts_id NUMBER;
18 from_chart_of_accounts_id NUMBER;
19 --
20
21 --
22 -- Procedure
23 -- Insert_Row
24 -- Purpose
25 -- Insert new records into table GL_CONS_SEGMENT_MAP
26 -- Arguments
27 -- <table columns>
28 -- Example
29 -- GL_CONS_SEGMENT_ACTIONS_PKG.Insert_Row(<table columns>)
30 -- Notes
31 --
32 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
33 X_Segment_Map_Id IN OUT NOCOPY NUMBER,
34 X_Coa_Mapping_Id NUMBER,
35 X_Last_Update_Date DATE,
36 X_Last_Updated_By NUMBER,
37 X_To_Value_Set_Id NUMBER,
38 X_To_Application_Column_Name VARCHAR2,
39 X_Segment_Map_Type VARCHAR2,
40 X_Creation_Date DATE,
41 X_Created_By NUMBER,
42 X_Last_Update_Login NUMBER,
43 X_From_Value_Set_Id NUMBER,
44 X_From_Application_Column_Name VARCHAR2,
45 X_Single_Value VARCHAR2,
46 X_Attribute1 VARCHAR2,
47 X_Attribute2 VARCHAR2,
48 X_Attribute3 VARCHAR2,
49 X_Attribute4 VARCHAR2,
50 X_Attribute5 VARCHAR2,
51 X_Context VARCHAR2,
52 X_Parent_Rollup_Value VARCHAR2
53 );
54
55 --
56 -- Procedure
57 -- Lock_Row
58 -- Purpose
59 -- Lock records in table GL_CONS_SEGMENT_MAP
60 -- Arguments
61 -- <table columns>
62 -- Example
63 -- GL_CONS_SEGMENT_ACTIONS_PKG.Lock_Row(<table columns>)
64 -- Notes
65 --
66 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
67 X_Segment_Map_Id NUMBER
68 );
69
70 --
71 -- Procedure
72 -- Update_Row
73 -- Purpose
74 -- Update table GL_CONS_SEGMENT_MAP
75 -- Arguments
76 -- <table columns>
77 -- Example
78 -- GL_CONS_SEGMENT_ACTIONS_PKG.Update_Row(<table columns>)
79 -- Notes
80 --
81 PROCEDURE Update_Row(X_Rowid VARCHAR2,
82 X_Segment_Map_Id NUMBER,
83 X_Coa_Mapping_Id NUMBER,
84 X_Last_Update_Date DATE,
85 X_Last_Updated_By NUMBER,
86 X_To_Value_Set_Id NUMBER,
87 X_To_Application_Column_Name VARCHAR2,
88 X_Segment_Map_Type VARCHAR2,
89 X_Last_Update_Login NUMBER,
90 X_From_Value_Set_Id NUMBER,
91 X_From_Application_Column_Name VARCHAR2,
92 X_Single_Value VARCHAR2,
93 X_Attribute1 VARCHAR2,
94 X_Attribute2 VARCHAR2,
95 X_Attribute3 VARCHAR2,
96 X_Attribute4 VARCHAR2,
97 X_Attribute5 VARCHAR2,
98 X_Context VARCHAR2,
99 X_Parent_Rollup_Value VARCHAR2
100 );
101
102 --
103 -- Procedure
104 -- Delete_Row
105 -- Purpose
106 -- Delete records from table GL_CONS_SEGMENT_MAP
107 -- Arguments
108 -- Row_Id Rowid of row to be deleted
109 -- Example
110 -- GL_CONS_SEGMENT_ACTIONS_PKG.Delete_Row(:SEGMENT_MAP.Row_Id)
111 -- Notes
112 --
113 PROCEDURE Delete_Row( X_Coa_Mapping_Id NUMBER, X_to_application_column_name VARCHAR2 );
114
115 --
116 -- Procedure
117 -- Check_Duplicate_Rules
118 -- Purpose
119 -- Check for duplicate chart of accounts segment map rules
120 -- Arguments
121 -- Segment_Map_Type Type of segment rule - Rollup Ranges,
122 -- Single Value, or Copy Value
123 -- Coa_Mapping_Id Chart of Accounts Mapping Id
124 -- To_Application_Column_Name Parent segment column name
125 -- To_Value_Set_Id Parent segment column value set
126 -- RowId Segment mapping rule row id
127 -- Example
128 -- Check_Duplicate_Rules(:SEGMENT_MAP.rowid,
129 -- :SEGMENT_MAP.Coa_Mapping_Id,
130 -- :SEGMENT_MAP.To_Application_Column_Name,
131 -- :SEGMENT_MAP.To_Value_Set_Id,
132 -- :SEGMENT_MAP.Segment_Map_Type)
133 -- Notes
134 --
135 PROCEDURE Check_Duplicate_Rules(X_Rowid VARCHAR2,
136 X_Single_Value VARCHAR2,
137 X_Parent_Rollup_Value VARCHAR2,
138 X_Coa_Mapping_Id NUMBER,
139 X_To_Application_Column_Name VARCHAR2,
140 X_From_Application_Column_Name VARCHAR2,
141 X_To_Value_Set_Id NUMBER,
142 X_From_Value_Set_Id NUMBER,
143 X_Segment_Map_Type VARCHAR2);
144 --
145 -- Procedure
146 -- Get_Validation_Type
147 -- Purpose
148 -- Get the validation type for segment value when rule is
149 -- Single Value
150 -- Arguments
151 -- To_Value_Set_Id Parent segment column value set
152 -- Validation_Type Validation type return value
153 -- Example
154 -- Get_Validation_Type(:SEGMENT_MAP.To_Value_Set_Id,
155 -- :SEGMENT_MAP.Validation_Type)
156 -- Notes
157 --
158 PROCEDURE Get_Validation_Type(X_To_Value_Set_Id NUMBER,
159 X_Validation_Type IN OUT NOCOPY VARCHAR2);
160 --
161 -- Procedure
162 -- set_criteria
163 -- PURPOSE sets ALL (non-secondary) the package (global) variables
164 -- History: 19-Feb-97 U Thimmappa Created
165 -- Arguments: All the global values of this package
166 -- Notes:
167 PROCEDURE set_criteria (X_coa_mapping_id NUMBER,
168 X_to_chart_of_accounts_id NUMBER,
169 X_from_chart_of_accounts_id NUMBER);
170
171 --
172 -- Function
173 -- Validate_From_Segment
174 -- Purpose
175 -- Validate that the value set of the "From" subsidiary segment has a
176 -- less than or equal maximum size as the value set of the
177 -- "To" parent segment.
178 -- History
179 -- 13-Jun-01 T Cheng Created
180 -- 01-Aug-02 T Cheng Now returns BOOLEAN
181 -- Arguments
182 -- X_from_value_set_id from_segment's value set id
183 -- X_to_value_set_id to_segment's value set id
184 -- Notes
185 --
186 FUNCTION Validate_From_Segment (X_from_value_set_id NUMBER,
187 X_to_value_set_id NUMBER) RETURN BOOLEAN;
188
189 --
190 -- PUBLIC FUNCTIONS
191 --
192 --
193 -- Procedure
194 -- get_coa_mapping_id
195 -- PURPOSE gets the package (global) variable, USED in base view's where part
196 -- History: 19-Feb-97 U Thimmappa Created
197 -- Notes
198 --
199 FUNCTION get_coa_mapping_id RETURN NUMBER;
200 PRAGMA RESTRICT_REFERENCES(get_coa_mapping_id,WNDS,WNPS);
201
202 --
203 -- Procedure
204 -- get_to_coa_id
205 -- PURPOSE gets the package (global) variable, USED in base view's where part
206 -- History: 19-Feb-97 U Thimmappa Created
207 -- Notes
208 --
209 FUNCTION get_to_coa_id RETURN NUMBER;
210 PRAGMA RESTRICT_REFERENCES(get_to_coa_id,WNDS,WNPS);
211 --
212 -- Procedure
213 -- get_from_coa_id
214 -- PURPOSE gets the package (global) variable, USED in base view's where part
215 -- History: 19-Feb-97 U Thimmappa Created
216 -- Notes
217 --
218 FUNCTION get_from_coa_id RETURN NUMBER;
219 PRAGMA RESTRICT_REFERENCES(get_from_coa_id,WNDS,WNPS);
220
221 END GL_CONS_SEGMENT_ACTIONS_PKG;