1 PACKAGE GL_PARENT_SEGMENT_PKG AS
2 /* $Header: glfcpsgs.pls 120.2 2005/05/05 02:04:58 kvora noship $ */
3
4 --
5 -- PACKAGE
6 -- GL_PARENT_SEGMENT_PKG
7 -- PURPOSE
8 -- This package will merge the child ranges of the parent value(s) of a
9 -- specific segment. All parent value(s) should be inserted to the
10 -- temporary table GL_REVAL_CHD_RANGES_GT before calling this package to
11 -- merge child ranges.
12 -- HISTORY
13 -- 07/29/03 L Poon Created
14 --
15
16 -- PROCEDURE
17 -- merge_child_ranges
18 -- PURPOSE
19 -- It will merge the child ranges of all parent values stored in
20 -- GL_REVAL_CHD_RANGES_GT for the passed segment and store the merged
21 -- child ranges back to GL_REVAL_CHD_RANGES_GT.
22 -- HISTORY
23 -- 07/29/03 L Poon Created
24 -- ARGUMENTS
25 -- fv_set_id Flex Value Set ID
26 -- debug_mode Debug Mode (Y or N)
27 PROCEDURE merge_child_ranges(fv_set_id IN NUMBER,
28 debug_mode IN VARCHAR2);
29
30 -- PROCEDURE
31 -- get_min_max
32 -- PURPOSE
33 -- It will get the record count, the minimum and maximum child flex
34 -- values of the child ranges for the passed segment stored in
35 -- GL_REVAL_CHD_RANGES_GT.
36 -- HISTORY
37 -- 07/29/03 L Poon Created
38 -- ARGUMENTS
39 -- seg_num Segment Number
40 -- parent_val Parent Flex Value to be processed
41 -- rec_count Record Count
42 -- min_val Minimum Child Flex Value
43 -- max_val Maximum Child Flex Value
44 PROCEDURE get_min_max(fv_set_id IN NUMBER,
45 parent_val IN VARCHAR2,
46 rec_count OUT NOCOPY NUMBER,
47 min_val OUT NOCOPY VARCHAR2,
48 max_val OUT NOCOPY VARCHAR2);
49
50 -- PROCEDURE
51 -- get_fv_table
52 -- PURPOSE
53 -- It will get the name of the table which contains the flex values for
54 -- the passed segment.
55 -- HISTORY
56 -- 07/29/03 L Poon Created
57 -- ARGUMENTS
58 -- fv_set_id Flex Value Set ID
59 -- fv_table Flex Value Table Name
60 -- fv_col Flex Value Column Name
61 -- fv_type Flex Value Validation Type
62 PROCEDURE get_fv_table(fv_set_id IN NUMBER,
63 fv_table OUT NOCOPY VARCHAR2,
64 fv_col OUT NOCOPY VARCHAR2,
65 fv_type OUT NOCOPY VARCHAR2);
66
67 -- PROCEDURE
68 -- check_overlapping
69 -- PURPOSE
70 -- It will check whether any expanded and merged account ranges
71 -- in GL_REVAL_EXP_RANGES_GT overlap
72 -- HISTORY
73 -- 08/29/03 L Poon Created
74 -- ARGUMENTS
75 -- debug_mode Debug Mode (Y or N)
76 -- is_overlapping Indicate if any ranges overlap (Y or N)
77 PROCEDURE check_overlapping(debug_mode IN VARCHAR2,
78 is_overlapping OUT NOCOPY VARCHAR2);
79
80 -- PROCEDURE
81 -- debug_msg
82 -- PURPOSE
83 -- It will print the debug message
84 -- HISTORY
85 -- 07/29/03 L Poon Created
86 -- ARGUMENTS
87 -- name Procedure/Function name
88 -- msg Debug Message
89 PROCEDURE debug_msg(name IN VARCHAR2,
90 msg IN VARCHAR2);
91
92 END GL_PARENT_SEGMENT_PKG;