1 PACKAGE FEM_INTG_BAL_ENG_LOAD_PKG AUTHID CURRENT_USER as
2 /* $Header: fem_intg_be_load.pls 120.0 2005/06/06 21:44:18 appldev noship $ */
3 --
4 -- Package
5 -- fem_intg_bal_eng_load_pkg
6 -- Purpose
7 -- Balances engine program for OGL-FEM integration
8 -- History
9 -- 11-NOV-04 M Ward Created
10 --
11
12 --
13 -- Procedure
14 -- Load_Std_Balances
15 -- Purpose
16 -- Load standard balances into the FEM_BAL_POST_INTERIM_GT table. This
17 -- handles both the snapshot and incremental loads.
18 -- Arguments
19 -- x_completion_code 0 (Success), 1 (Warning), or 2 (Failure)
20 -- x_num_rows_inserted Total number of rows inserted
21 -- p_bsv_range_low Low value for the range of balancing segment
22 -- values to be filtered in
23 -- p_bsv_range_high High value for the range of balancing segment
24 -- values to be filtered in
25 -- p_maintain_qtd Whether or not to track QTD balances
26 -- Example
27 -- FEM_INTG_BAL_ENG_LOAD_PKG.Load_Std_Balances(completion_code, num_rows, list);
28 -- Notes
29 --
30 PROCEDURE Load_Std_Balances( x_completion_code OUT NOCOPY NUMBER,
31 x_num_rows_inserted OUT NOCOPY NUMBER,
32 p_bsv_range_low VARCHAR2,
33 p_bsv_range_high VARCHAR2,
34 p_maintain_qtd VARCHAR2);
35
36 --
37 -- Procedure
38 -- Load_Avg_Balances
39 -- Purpose
40 -- Load average balances into the FEM_BAL_POST_INTERIM_GT table.
41 -- Arguments
42 -- x_completion_code 0 (Success), 1 (Warning), or 2 (Failure)
43 -- x_num_rows_inserted Total number of rows inserted
44 -- p_bsv_range_low Low value for the range of balancing segment
45 -- values to be filtered in
46 -- p_bsv_range_high High value for the range of balancing segment
47 -- values to be filtered in
48 -- Example
49 -- FEM_INTG_BAL_ENG_LOAD_PKG.Load_Avg_Balances(completion_code, num_rows,
50 -- sysdate);
51 -- Notes
52 --
53 PROCEDURE Load_Avg_Balances( x_completion_code OUT NOCOPY NUMBER,
54 x_num_rows_inserted OUT NOCOPY NUMBER,
55 p_effective_date DATE,
56 p_bsv_range_low VARCHAR2,
57 p_bsv_range_high VARCHAR2);
58
59 --
60 -- Procedure
61 -- Load_Post_Process
62 -- Purpose
63 -- A post-process for loading which will back out functional converted
64 -- amounts to get the correct functional entered amounts.
65 -- Arguments
66 -- x_completion_code 0 (Success), 1 (Warning), or 2 (Failure)
67 -- Example
68 -- FEM_INTG_BAL_ENG_LOAD_PKG.Load_Post_Process(completion_code);
69 -- Notes
70 --
71 PROCEDURE Load_Post_Process(x_completion_code OUT NOCOPY NUMBER);
72
73 --
74 -- Procedure
75 -- Map_Adv_LI_FE
76 -- Purpose
77 -- Using the natural account, override the amount in the line item and
78 -- financial element columns if an override is specified.
79 -- Arguments
80 -- x_completion_code 0 (Success), 1 (Warning), or 2 (Failure)
81 -- Example
82 -- FEM_INTG_BAL_ENG_LOAD_PKG.Map_Adv_LI_FE(completion_code);
83 -- Notes
84 --
85 PROCEDURE Map_Adv_LI_FE(x_completion_code OUT NOCOPY NUMBER);
86
87 --
88 -- Procedure
89 -- Mark_Posted_Incr_Bal
90 -- Purpose
91 -- Mark GL and FEM tables with information regarding the incremental runs
92 -- that have or have not been uploaded.
93 -- Arguments
94 -- x_completion_code 0 (Success), 1 (Warning), or 2 (Failure)
95 -- p_bsv_range_low Low value for the range of balancing segment
96 -- values to be filtered in
97 -- p_bsv_range_high High value for the range of balancing segment
98 -- values to be filtered in
99 -- Example
100 -- FEM_INTG_BAL_ENG_LOAD_PKG.Mark_Posted_Incr_Bal(completion_code);
101 -- Notes
102 --
103 PROCEDURE Mark_Posted_Incr_Bal(x_completion_code OUT NOCOPY NUMBER,
104 p_bsv_range_low VARCHAR2,
105 p_bsv_range_high VARCHAR2);
106
107
108 END FEM_INTG_BAL_ENG_LOAD_PKG;