[Home] [Help]
PACKAGE: APPS.GL_CONS_FLEX_MAP_PKG
Source
1 PACKAGE GL_CONS_FLEX_MAP_PKG as
2 /* $Header: glicofrs.pls 120.4 2005/05/05 01:04:59 kvora ship $ */
3 --
4 -- Package
5 -- gl_cons_flexfield_map_pkg
6 -- Purpose
7 -- Package procedures for Consolidation Setup form,
8 -- Flexfield Mapping Rules block
9 -- History
10 -- 01/03/94 E Wilson Created
11 --
12
13 --
14 -- Procedure
15 -- Check_Overlap
16 -- Purpose
17 -- Check for overlapping subsidiary flexfield ranges
18 -- Arguments
19 -- X_Coa_Mapping_Id COA mapping id
20 -- X_Segment**_Low Subsidiary range low segment value
21 -- X_Segment**_High Subsidiary range high segment value
22 -- Example
23 -- GL_CONS_FLEXFIELD_MAP_PKG.Check_Overlap(
24 -- :FLEXFIELD_MAP.coa_mapping_id, :FLEXFIELD_MAP.row_id,
25 -- :FLEXFIELD_MAP.segment1_low, :FLEXFIELD_MAP.segment1_high,
26 -- :FLEXFIELD_MAP.segment2_low, :FLEXFIELD_MAP.segment2_high,
27 -- .
28 -- .
29 -- .
30 -- :FLEXFIELD_MAP.segment30_low, :FLEXFIELD_MAP.segmen30_high);
31 -- Notes
32 --
33 PROCEDURE Check_Overlap(X_Coa_Mapping_Id NUMBER,
34 row_id VARCHAR2,
35 X_Segment1_Low VARCHAR2,
36 X_Segment1_High VARCHAR2,
37 X_Segment2_Low VARCHAR2,
38 X_Segment2_High VARCHAR2,
39 X_Segment3_Low VARCHAR2,
40 X_Segment3_High VARCHAR2,
41 X_Segment4_Low VARCHAR2,
42 X_Segment4_High VARCHAR2,
43 X_Segment5_Low VARCHAR2,
44 X_Segment5_High VARCHAR2,
45 X_Segment6_Low VARCHAR2,
46 X_Segment6_High VARCHAR2,
47 X_Segment7_Low VARCHAR2,
48 X_Segment7_High VARCHAR2,
49 X_Segment8_Low VARCHAR2,
50 X_Segment8_High VARCHAR2,
51 X_Segment9_Low VARCHAR2,
52 X_Segment9_High VARCHAR2,
53 X_Segment10_Low VARCHAR2,
54 X_Segment10_High VARCHAR2,
55 X_Segment11_Low VARCHAR2,
56 X_Segment11_High VARCHAR2,
57 X_Segment12_Low VARCHAR2,
58 X_Segment12_High VARCHAR2,
59 X_Segment13_Low VARCHAR2,
60 X_Segment13_High VARCHAR2,
61 X_Segment14_Low VARCHAR2,
62 X_Segment14_High VARCHAR2,
63 X_Segment15_Low VARCHAR2,
64 X_Segment15_High VARCHAR2,
65 X_Segment16_Low VARCHAR2,
66 X_Segment16_High VARCHAR2,
67 X_Segment17_Low VARCHAR2,
68 X_Segment17_High VARCHAR2,
69 X_Segment18_Low VARCHAR2,
70 X_Segment18_High VARCHAR2,
71 X_Segment19_Low VARCHAR2,
72 X_Segment19_High VARCHAR2,
73 X_Segment20_Low VARCHAR2,
74 X_Segment20_High VARCHAR2,
75 X_Segment21_Low VARCHAR2,
76 X_Segment21_High VARCHAR2,
77 X_Segment22_Low VARCHAR2,
78 X_Segment22_High VARCHAR2,
79 X_Segment23_Low VARCHAR2,
80 X_Segment23_High VARCHAR2,
81 X_Segment24_Low VARCHAR2,
82 X_Segment24_High VARCHAR2,
83 X_Segment25_Low VARCHAR2,
84 X_Segment25_High VARCHAR2,
85 X_Segment26_Low VARCHAR2,
86 X_Segment26_High VARCHAR2,
87 X_Segment27_Low VARCHAR2,
88 X_Segment27_High VARCHAR2,
89 X_Segment28_Low VARCHAR2,
90 X_Segment28_High VARCHAR2,
91 X_Segment29_Low VARCHAR2,
92 X_Segment29_High VARCHAR2,
93 X_Segment30_Low VARCHAR2,
94 X_Segment30_High VARCHAR2
95 );
96
97 --
98 -- Procedure
99 -- Get_New_Id
100 -- Purpose
101 -- Get next value from GL_CONS_FLEXFIELD_MAP_S
102 -- Arguments
103 -- next_val Return next value in sequence
104 -- Example
105 -- GL_CONS_FLEXFIELD_MAP_PKG.Get_New_Id(:FLEXFIELD_MAP.flexfield_map_id)
106 -- Notes
107 --
108 PROCEDURE Get_New_Id(next_val IN OUT NOCOPY NUMBER);
109
110 END GL_CONS_FLEX_MAP_PKG;