[Home] [Help]
PACKAGE: APPS.GL_CONS_SEGMENT_MAP_PKG
Source
1 PACKAGE GL_CONS_SEGMENT_MAP_PKG AUTHID CURRENT_USER as
2 /* $Header: glicosrs.pls 120.7 2005/05/05 01:06:11 kvora ship $ */
3 --
4 -- Package
5 -- gl_cons_segment_map_pkg
6 -- Purpose
7 -- Package procedures for Consolidation Setup form,
8 -- Consolidation Segment Rules block
9 -- History
10 -- 03-JAN-94 E Wilson Created
11 --
12
13 --
14 -- Procedure
15 -- Insert_Row
16 -- Purpose
17 -- Insert new records into table GL_CONS_SEGMENT_MAP
18 -- Arguments
19 -- <table columns>
20 -- Example
21 -- GL_CONS_SEGMENT_MAP_PKG.Insert_Row(<table columns>)
22 -- Notes
23 --
24 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
25 X_Segment_Map_Id IN OUT NOCOPY NUMBER,
26 X_Coa_Mapping_Id NUMBER,
27 X_Last_Update_Date DATE,
28 X_Last_Updated_By NUMBER,
29 X_To_Value_Set_Id NUMBER,
30 X_To_Application_Column_Name VARCHAR2,
31 X_Segment_Map_Type VARCHAR2,
32 X_Creation_Date DATE,
33 X_Created_By NUMBER,
34 X_Last_Update_Login NUMBER,
35 X_From_Value_Set_Id NUMBER,
36 X_From_Application_Column_Name VARCHAR2,
37 X_Single_Value VARCHAR2,
38 X_Attribute1 VARCHAR2,
39 X_Attribute2 VARCHAR2,
40 X_Attribute3 VARCHAR2,
41 X_Attribute4 VARCHAR2,
42 X_Attribute5 VARCHAR2,
43 X_Context VARCHAR2,
44 X_Parent_Rollup_Value VARCHAR2
45 );
46
47 --
48 -- Procedure
49 -- Lock_Row
50 -- Purpose
51 -- Lock records in table GL_CONS_SEGMENT_MAP
52 -- Arguments
53 -- <table columns>
54 -- Example
55 -- GL_CONS_SEGMENT_MAP_PKG.Lock_Row(<table columns>)
56 -- Notes
57 --
58 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
59 X_Segment_Map_Id NUMBER,
60 X_Coa_Mapping_Id NUMBER,
61 X_To_Value_Set_Id NUMBER,
62 X_To_Application_Column_Name VARCHAR2,
63 X_Segment_Map_Type VARCHAR2,
64 X_From_Value_Set_Id NUMBER,
65 X_From_Application_Column_Name VARCHAR2,
66 X_Single_Value VARCHAR2,
67 X_Attribute1 VARCHAR2,
68 X_Attribute2 VARCHAR2,
69 X_Attribute3 VARCHAR2,
70 X_Attribute4 VARCHAR2,
71 X_Attribute5 VARCHAR2,
72 X_Context VARCHAR2,
73 X_Parent_Rollup_Value VARCHAR2
74 );
75
76 --
77 -- Procedure
78 -- Update_Row
79 -- Purpose
80 -- Update table GL_CONS_SEGMENT_MAP
81 -- Arguments
82 -- <table columns>
83 -- Example
84 -- GL_CONS_SEGMENT_MAP_PKG.Update_Row(<table columns>)
85 -- Notes
86 --
87 PROCEDURE Update_Row(X_Rowid VARCHAR2,
88 X_Segment_Map_Id NUMBER,
89 X_Coa_Mapping_Id NUMBER,
90 X_Last_Update_Date DATE,
91 X_Last_Updated_By NUMBER,
92 X_To_Value_Set_Id NUMBER,
93 X_To_Application_Column_Name VARCHAR2,
94 X_Segment_Map_Type VARCHAR2,
95 X_Last_Update_Login NUMBER,
96 X_From_Value_Set_Id NUMBER,
97 X_From_Application_Column_Name VARCHAR2,
98 X_Single_Value VARCHAR2,
99 X_Attribute1 VARCHAR2,
100 X_Attribute2 VARCHAR2,
101 X_Attribute3 VARCHAR2,
102 X_Attribute4 VARCHAR2,
103 X_Attribute5 VARCHAR2,
104 X_Context VARCHAR2,
105 X_Parent_Rollup_Value VARCHAR2
106 );
107
108 --
109 -- Procedure
110 -- Delete_Row
111 -- Purpose
112 -- Delete records from table GL_CONS_SEGMENT_MAP
113 -- Arguments
114 -- Row_Id Rowid of row to be deleted
115 -- Example
116 -- GL_CONS_SEGMENT_MAP_PKG.Delete_Row(:SEGMENT_MAP.Row_Id)
117 -- Notes
118 --
119 PROCEDURE Delete_Row(X_Rowid VARCHAR2, X_Segment_Map_Id NUMBER );
120
121 --
122 -- Procedure
123 -- Check_Duplicate_Rules
124 -- Purpose
125 -- Check for duplicate consolidation segment map rules
126 -- Arguments
127 -- Segment_Map_Type Type of segment rule - Rollup Ranges,
128 -- Single Value, or Copy Value
129 -- Coa_Mapping_Id COA Mapping ID
130 -- To_Application_Column_Name Parent segment column name
131 -- To_Value_Set_Id Parent segment column value set
132 -- RowId Segment mapping rule row id
133 -- Returns
134 -- 0 Success, no duplicates
135 -- 1 Overlap with different targets
136 --
137 -- If an overlap with the same target multiple times occurs, an exception
138 -- is raised.
139 -- Example
140 -- Check_Duplicate_Rules(:SEGMENT_MAP.rowid,
141 -- :SEGMENT_MAP.Mapping_Id,
142 -- :SEGMENT_MAP.To_Application_Column_Name,
143 -- :SEGMENT_MAP.To_Value_Set_Id,
144 -- :SEGMENT_MAP.Segment_Map_Type)
145 -- Notes
146 --
147 FUNCTION Check_Duplicate_Rules(X_Rowid VARCHAR2,
148 X_Single_Value VARCHAR2,
149 X_Parent_Rollup_Value VARCHAR2,
150 X_Coa_Mapping_Id NUMBER,
151 X_To_Application_Column_Name VARCHAR2,
152 X_From_Application_Column_Name VARCHAR2,
153 X_To_Value_Set_Id NUMBER,
154 X_From_Value_Set_Id NUMBER,
155 X_Segment_Map_Type VARCHAR2) RETURN NUMBER;
156 --
157 -- Procedure
158 -- Get_Validation_Type
159 -- Purpose
160 -- Get the validation type for segment value when rule is
161 -- Single Value
162 -- Arguments
163 -- To_Value_Set_Id Parent segment column value set
164 -- Validation_Type Validation type return value
165 -- Example
166 -- Get_Validation_Type(:SEGMENT_MAP.To_Value_Set_Id,
167 -- :SEGMENT_MAP.Validation_Type)
168 -- Notes
169 --
170 PROCEDURE Get_Validation_Type(X_To_Value_Set_Id NUMBER,
171 X_Validation_Type IN OUT NOCOPY VARCHAR2);
172
173 --
174 -- Procedure
175 -- Check_Any_Parent_Rules
176 -- Purpose
177 -- Check to see whether there any summary rules defined
178 -- Arguments
179 -- X_Coa_Mapping_Id Coa_Mapping_ID
180 -- X_Parent_Rules_Present Parent Rules Present
181 -- Example
182 -- Check_Any_Parent_Rules(X_Coa_Mapping_Id
183 -- X_Parent_Rules_Present)
184 -- Notes
185 --
186 PROCEDURE Check_Any_Parent_Rules(X_Coa_Mapping_Id IN OUT NOCOPY NUMBER,
187 X_Parent_Rules_Present IN OUT NOCOPY VARCHAR2);
188
189 END GL_CONS_SEGMENT_MAP_PKG;