[Home] [Help]
PACKAGE: APPS.GL_CONS_FLEX_HIER_PKG
Source
1 PACKAGE GL_CONS_FLEX_HIER_PKG as
2 /* $Header: glicocrs.pls 120.7 2005/05/05 01:04:46 kvora ship $ */
3 --
4 -- Package
5 -- gl_cons_flex_hierarchies_pkg
6 -- Purpose
7 -- Package procedures for Chart of Accounts Setup form,
8 -- Child Ranges block
9 -- History
10 -- 03-JAN-94 E Wilson Created
11 -- 14-OCT-96 U Thimmappa Added new functions
12 --
13
14 --
15 -- Procedure
16 -- Overlap
17 -- Purpose
18 -- Check for overlapping child segment ranges
19 -- Arguments
20 -- rowid
21 -- segment_map_id
22 -- parent_flex_value
23 -- child_flex_value_low
24 -- child_flex_value_high
25 -- Returns a number based on whether or not an overlap was found:
26 -- 0: success. No overlaps
27 -- 1: warning. The same source is mapped to two different targets
28 --
29 -- This raises an exception if one source is mapped to the same target
30 -- multiple times.
31 -- Notes
32 --
33 FUNCTION Overlap(X_Rowid VARCHAR2,
34 X_Segment_Map_Id NUMBER,
35 X_Coa_Mapping_Id NUMBER,
36 X_To_Value_Set_Id NUMBER,
37 X_From_Value_Set_Id NUMBER,
38 X_Segment_Map_Type VARCHAR2,
39 X_To_Application_Column_Name VARCHAR2,
40 X_From_Application_Column_Name VARCHAR2,
41 X_Parent_Flex_Value VARCHAR2,
42 X_Child_Flex_Value_Low VARCHAR2,
43 X_Child_Flex_Value_High VARCHAR2
44 ) RETURN NUMBER;
45
46 --
47 -- Procedure
48 -- Count_Ranges
49 -- Purpose
50 -- Verify that user has entered a range of accounts before committing
51 -- a consolidation whose method type is Balances
52 -- Arguments
53 -- segment_map_id
54 -- Notes
55 --
56 PROCEDURE Count_Ranges(X_Segment_Map_id NUMBER);
57
58 -- Procedure
59 -- Insert_Row
60 -- Purpose
61 -- Insert new records into table GL_CONS_FLEX_HIERARCHIES
62 -- Arguments
63 -- <table columns>
64 -- Example
65 -- GL_CONS_CHILD_RANGES_PKG.Insert_Row(<table columns>)
66 -- Notes
67 --
68 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
69 X_Segment_Map_Id IN OUT NOCOPY NUMBER,
70 X_Parent_Flex_Value VARCHAR2,
71 X_Child_Flex_Value_Low VARCHAR2,
72 X_Child_Flex_Value_High VARCHAR2,
73 X_Last_Update_Date DATE,
74 X_Last_Updated_By NUMBER,
75 X_Creation_Date DATE,
76 X_Created_By NUMBER,
77 X_Last_Update_Login NUMBER,
78 X_Attribute1 VARCHAR2,
79 X_Attribute2 VARCHAR2,
80 X_Attribute3 VARCHAR2,
81 X_Attribute4 VARCHAR2,
82 X_Attribute5 VARCHAR2,
83 X_Context VARCHAR2
84 );
85
86 --
87 -- Procedure
88 -- Lock_Row
89 -- Purpose
90 -- Lock records in table GL_CONS_CHILD_RANGES
91 -- Arguments
92 -- <table columns>
93 -- Example
94 -- GL_CONS_CHILD_RANGES.Lock_Row(<table columns>)
95 -- Notes
96 --
97 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
98 X_Segment_Map_Id NUMBER,
99 X_Parent_Flex_Value VARCHAR2,
100 X_Child_Flex_Value_Low VARCHAR2,
101 X_Child_Flex_Value_High VARCHAR2,
102 X_Last_Update_Date DATE,
103 X_Last_Updated_By NUMBER,
104 X_Creation_Date DATE,
105 X_Created_By NUMBER,
106 X_Last_Update_Login NUMBER,
107 X_Attribute1 VARCHAR2,
108 X_Attribute2 VARCHAR2,
109 X_Attribute3 VARCHAR2,
110 X_Attribute4 VARCHAR2,
111 X_Attribute5 VARCHAR2,
112 X_Context VARCHAR2
113 );
114
115 --
116 -- Procedure
117 -- Update_Row
118 -- Purpose
119 -- Update table GL_CONS_CHILD_RANGES
120 -- Arguments
121 -- <table columns>
122 -- Example
123 -- GL_CONS_CHILD_RANGES_PKG.Update_Row(<table columns>)
124 -- Notes
125 --
126 PROCEDURE Update_Row(X_Rowid VARCHAR2,
127 X_Segment_Map_Id NUMBER,
128 X_Parent_Flex_Value VARCHAR2,
129 X_Child_Flex_Value_Low VARCHAR2,
130 X_Child_Flex_Value_High VARCHAR2,
131 X_Last_Update_Date DATE,
132 X_Last_Updated_By NUMBER,
133 X_Creation_Date DATE,
134 X_Created_By NUMBER,
135 X_Last_Update_Login NUMBER,
136 X_Attribute1 VARCHAR2,
137 X_Attribute2 VARCHAR2,
138 X_Attribute3 VARCHAR2,
139 X_Attribute4 VARCHAR2,
140 X_Attribute5 VARCHAR2,
141 X_Context VARCHAR2
142 );
143
144 --
145 -- Procedure
146 -- Update_Row
147 -- Purpose
148 -- Update table GL_CONS_CHILD_RANGES
149 -- Arguments
150 -- <table columns>
151 -- Example
152 -- GL_CONS_CHILD_RANGES_PKG.Update_Parent_Values(<table columns>)
153 -- Notes
154 --
155 PROCEDURE Update_Parent_Values(
156 X_Segment_Map_Id NUMBER,
157 X_Parent_Flex_Value VARCHAR2,
158 X_Last_Update_Date DATE,
159 X_Last_Updated_By NUMBER,
160 X_Last_Update_Login NUMBER
161 );
162
163 --
164 -- Procedure
165 -- Delete_Row
166 -- Purpose
167 -- Delete records from table GL_CONS_CHILD_RANGES
168 -- Arguments
169 -- Row_Id Rowid of row to be deleted
170 -- Example
171 -- GL_CONS_CHILD_RANGES_PKG.Delete_Row(:SEGMENT_MAP.Row_Id)
172 -- Notes
173 --
174 PROCEDURE Delete_Row(X_Rowid VARCHAR2, X_Segment_Map_Id NUMBER );
175
176 END GL_CONS_FLEX_HIER_PKG;