1 PACKAGE GL_FLATTEN_LEDGER_SEG_VALS AUTHID CURRENT_USER AS
2 /* $Header: glufllvs.pls 120.4 2005/05/05 01:38:35 kvora ship $ */
3
4 -- ********************************************************************
5 -- Function
6 -- Fix_By_Coa
7 -- Purpose
8 -- This Function is the entry point When Flattening program is called in
9 -- mode LV, it indicates changes in the Ledger definition.
10 -- History
11 -- 06-04-2001 Srini Pala Created
12 -- Arguments
13
14 -- Example
15 -- ret_status := Fix_By_Coa()
16 --
17 Function Fix_By_Coa RETURN BOOLEAN ;
18
19
20 -- ******************************************************************
21 -- Function
22 -- Fix_By Value_Set()
23 -- Purpose
24 -- This Function is the entry point When Flattening program is called in
25 -- mode SH, it indicates changes in Segment hierarchy.
26 -- History
27 -- 06-04-2001 Srini Pala Created
28 -- Arguments
29
30 -- Example
31 -- ret_status := Fix_By_Value_set()
32 --
33 Function Fix_By_Value_Set RETURN BOOLEAN;
34
35 -- *****************************************************************
36 -- FUNCTION
37 -- Clean_Up_By_Coa
38 -- Purpose
39 -- This Function is to clean the tables GL_LEDGER_NORM_SEG_VALUES
40 -- and GL_LEDGER_SEGMENT_VALUES for a particular chart of accounts.
41 -- History
42 -- 06-04-2001 Srini Pala Created
43 -- Arguments
44
45 -- Example
46 -- ret_status := Clean_Up_By_Coa();
47 --
48
49 FUNCTION Clean_Up_By_Coa RETURN BOOLEAN ;
50
51
52
53 -- ******************************************************************
54
55 -- FUNCTION
56 -- Clean_Up_By_Value_Set
57 -- Purpose
58 -- This FUNCTION is to clean the tables GL_LEDGER_NORM_SEG_VALUES
59 -- and GL_LEDGER_SEGMENT_VALUES for a particular value set.
60 -- History
61 -- 06-04-2001 Srini Pala Created
62 -- Arguments
63
64 -- Example
65 -- ret_status := Clean_Up_By_Value_Set();
66 --
67
68 FUNCTION Clean_Up_By_Value_Set RETURN BOOLEAN ;
69
70
71
72 -- ******************************************************************
73
74 -- FUNCTION
75 -- Error_check
76 -- Purpose
77 -- This FUNCTION checks if a segment value has been assigned to a
78 -- particular ledger more than once on a given date.
79 -- If it returns TRUE then program should error out
80 -- History
81 -- 06-04-2001 Srini Pala Created
82 -- Arguments
83 --
84 -- Example
85 -- ret_status := Error_Check();
86 --
87
88 FUNCTION Error_Check RETURN BOOLEAN ;
89
90
91
92 -- ******************************************************************
93
94 END GL_FLATTEN_LEDGER_SEG_VALS;
95