1 PACKAGE FEM_XGL_POST_ENGINE_PKG AS
2 /* $Header: fem_xgl_post_eng.pls 120.0 2005/06/06 19:48:58 appldev noship $ */
3
4 --
5 -- PUBLIC PROCEDURES
6 --
7
8 --
9 -- Procedure
10 -- Main
11 -- Purpose
12 -- This is the main routine of the XGL Posting Engine program
13 -- History
14 -- 10-23-03 S Kung Created
15 -- Arguments
16 -- p_errbuf : Output parameter required by
17 -- Concurrent Manager
18 -- p_retcode : Output parameter required by
19 -- Concurrent Manager
20 -- p_ledger_id : Ledger to load data for
21 -- p_cal_period_id : Period to load data for
22 -- p_dataset_code : Target dataset to load data into
23 -- p_xgl_int_obj_def_id : XGL/FEM integration rule object definition ID
24 -- p_execution_mode : Execution mode, S (Snapshot)/I (Incremental)
25 -- p_qtd_ytd_code : Specifies whether period-specific QTD and
26 -- YTD balances will be maintained
27 -- p_budget_id : Budget to be loaded
28 -- p_enc_type_id : Encumbrance type to be loaded
29 --
30 -- Example
31 -- result := FEM_XGL_POST_ENGINE_PKG.Main( );
32 -- Notes
33 --
34 PROCEDURE Main
35 (x_errbuf OUT NOCOPY VARCHAR2,
36 x_retcode OUT NOCOPY VARCHAR2,
37 p_execution_mode IN VARCHAR2 DEFAULT NULL,
38 p_ledger_id IN VARCHAR2 DEFAULT NULL,
39 p_cal_period_id IN VARCHAR2 DEFAULT NULL,
40 p_budget_id IN VARCHAR2 DEFAULT NULL,
41 p_enc_type_id IN VARCHAR2 DEFAULT NULL,
42 p_dataset_code IN VARCHAR2 DEFAULT NULL,
43 p_xgl_int_obj_def_id IN VARCHAR2 DEFAULT NULL,
44 p_qtd_ytd_code IN VARCHAR2 DEFAULT 'N');
45
46 PROCEDURE Process_Data_Slice
47 (x_slice_status_cd OUT NOCOPY NUMBER,
48 x_slice_msg OUT NOCOPY VARCHAR2,
49 x_slice_errors_reprocessed OUT NOCOPY NUMBER,
50 x_slice_output_rows OUT NOCOPY NUMBER,
51 x_slice_errors_reported OUT NOCOPY NUMBER,
52 p_eng_sql IN VARCHAR2,
53 p_data_slice_predicate IN VARCHAR2,
54 p_process_number IN NUMBER,
55 p_slice_id IN NUMBER,
56 p_fetch_limit IN NUMBER,
57 p_req_id IN VARCHAR2,
58 p_exec_mode IN VARCHAR2,
59 p_rule_obj_id IN VARCHAR2,
60 p_dataset_code IN VARCHAR2,
61 p_cal_period_id IN VARCHAR2,
62 p_ledger_id IN VARCHAR2,
63 p_qtd_ytd_code IN VARCHAR2,
64 p_entered_crncy_flag IN VARCHAR2,
65 p_cal_per_dim_grp_dsp_cd IN VARCHAR2,
66 p_cal_per_end_date IN VARCHAR2,
67 p_gl_per_number IN VARCHAR2,
68 p_ledger_dsp_cd IN VARCHAR2,
69 p_budget_dsp_cd IN VARCHAR2,
70 p_enc_type_dsp_cd IN VARCHAR2,
71 p_ds_balance_type_cd IN VARCHAR2,
72 p_schema_name IN VARCHAR2);
73
74 END FEM_XGL_POST_ENGINE_PKG;