1 PACKAGE GL_CARRYFORWARD_RANGES_PKG AUTHID CURRENT_USER as
2 /* $Header: glicfras.pls 120.2 2005/05/05 01:03:46 kvora ship $ */
3
4 --
5 -- Package
6 -- GL_CARRYFORWARD_RANGES_PKG
7 -- Purpose
8 -- To implement various data checking needed for the
9 -- gl_carryforward_ranges
10 -- History
11 -- 06-15-94 Kai Pigg Created
12
13 --
14 -- Procedure
15 -- get_unique_id
16 -- Purpose
17 -- Gets a unique range id
18 -- History
19 -- 06-15-94 Kai Pigg Created
20 -- Arguments
21 -- none
22 -- Example
23 -- bid := gl_carryforward_ranges_pkg.get_unique_id;
24 -- Notes
25 --
26 FUNCTION get_unique_id RETURN NUMBER;
27
28 --
29 -- Procedure
30 -- check_overlapping
31 -- Purpose
32 -- Checks to make sure that there are not overlapping
33 -- ranges in your carryforward ranges
34 -- History
35 -- 08-08-94 Kai Pigg Created
36 -- Arguments
37 -- x_carryforward_range_id Unique ID generated in the form.
38 -- Note that this ID may be the same for bunch
39 -- of rows
40 -- x_segment1_low Lower limit of segment value.
41 -- x_segment1_high Higher limit of segment value.
42 -- ... there are 30 ranges in the row
43 -- x_segment30_low Lower limit of segment value.
44 -- x_segment30_high Higher limit of segment value.
45 -- row_id The id of the row
46 -- containing the period
47 -- Example
48 -- periods.check_overlapping(1232, '000', 'ZZZ',...,(30 pairs of ranges)
49 -- 'AA01');
50 -- Notes
51 --
52 PROCEDURE check_overlapping(x_carryforward_range_id IN NUMBER,
53 x_segment1_low IN VARCHAR2,
54 x_segment1_high IN VARCHAR2,
55 x_segment2_low IN VARCHAR2,
56 x_segment2_high IN VARCHAR2,
57 x_segment3_low IN VARCHAR2,
58 x_segment3_high IN VARCHAR2,
59 x_segment4_low IN VARCHAR2,
60 x_segment4_high IN VARCHAR2,
61 x_segment5_low IN VARCHAR2,
62 x_segment5_high IN VARCHAR2,
63 x_segment6_low IN VARCHAR2,
64 x_segment6_high IN VARCHAR2,
65 x_segment7_low IN VARCHAR2,
66 x_segment7_high IN VARCHAR2,
67 x_segment8_low IN VARCHAR2,
68 x_segment8_high IN VARCHAR2,
69 x_segment9_low IN VARCHAR2,
70 x_segment9_high IN VARCHAR2,
71 x_segment10_low IN VARCHAR2,
72 x_segment10_high IN VARCHAR2,
73 x_segment11_low IN VARCHAR2,
74 x_segment11_high IN VARCHAR2,
75 x_segment12_low IN VARCHAR2,
76 x_segment12_high IN VARCHAR2,
77 x_segment13_low IN VARCHAR2,
78 x_segment13_high IN VARCHAR2,
79 x_segment14_low IN VARCHAR2,
80 x_segment14_high IN VARCHAR2,
81 x_segment15_low IN VARCHAR2,
82 x_segment15_high IN VARCHAR2,
83 x_segment16_low IN VARCHAR2,
84 x_segment16_high IN VARCHAR2,
85 x_segment17_low IN VARCHAR2,
86 x_segment17_high IN VARCHAR2,
87 x_segment18_low IN VARCHAR2,
88 x_segment18_high IN VARCHAR2,
89 x_segment19_low IN VARCHAR2,
90 x_segment19_high IN VARCHAR2,
91 x_segment20_low IN VARCHAR2,
92 x_segment20_high IN VARCHAR2,
93 x_segment21_low IN VARCHAR2,
94 x_segment21_high IN VARCHAR2,
95 x_segment22_low IN VARCHAR2,
96 x_segment22_high IN VARCHAR2,
97 x_segment23_low IN VARCHAR2,
98 x_segment23_high IN VARCHAR2,
99 x_segment24_low IN VARCHAR2,
100 x_segment24_high IN VARCHAR2,
101 x_segment25_low IN VARCHAR2,
102 x_segment25_high IN VARCHAR2,
103 x_segment26_low IN VARCHAR2,
104 x_segment26_high IN VARCHAR2,
105 x_segment27_low IN VARCHAR2,
106 x_segment27_high IN VARCHAR2,
107 x_segment28_low IN VARCHAR2,
108 x_segment28_high IN VARCHAR2,
109 x_segment29_low IN VARCHAR2,
110 x_segment29_high IN VARCHAR2,
111 x_segment30_low IN VARCHAR2,
112 x_segment30_high IN VARCHAR2,
113 row_id IN VARCHAR2);
114
115 END GL_CARRYFORWARD_RANGES_PKG;