1 PACKAGE FV_SLA_PROCESSING_PKG as
2 --$Header: FVXLAACS.pls 120.2 2007/08/07 19:35:00 sasukuma ship $
3
4 /* $Header: FVXLAACS.pls 120.2 2007/08/07 19:35:00 sasukuma ship $ */
5
6 /*------------------------------------------------------
7 | Procedure name : Preaccounting
8 +------------------------------------------------------
9 | DESCRIPTION
10 | This procedure is the Federal SLA pre-accounting procedure.
11 | This procedure will be called by SLA through an API.
12 |
13 | Purpose : Pre accouting requirements during accounting process.
14 | Currently for Federal not in use
15 |
16 |
17 | Modification history
18 +------------------------------------------------------*/
19 PROCEDURE preaccounting
20 (
21 p_application_id IN NUMBER,
22 p_ledger_id IN INTEGER,
23 p_process_category IN VARCHAR2,
24 p_end_date IN DATE,
25 p_accounting_mode IN VARCHAR2,
26 p_valuation_method IN VARCHAR2,
27 p_security_id_int_1 IN INTEGER,
28 p_security_id_int_2 IN INTEGER,
29 p_security_id_int_3 IN INTEGER,
30 p_security_id_char_1 IN VARCHAR2,
31 p_security_id_char_2 IN VARCHAR2,
32 p_security_id_char_3 IN VARCHAR2,
33 p_report_request_id IN INTEGER
34 );
35
36 /*------------------------------------------------------
37 | Procedure name : Extract
38 +------------------------------------------------------
39 | DESCRIPTION
40 | This procedure is the Federal SLA EXtarct procedure.
41 | This procedure will be called by SLA through an API.
42 |
43 | Purpose : Extract will be processed based on each product.
44 | Required Federal sources for product wil be
45 | Popluated for accounting based on
46 | product extract objects and xla_events_GT
47 |
48 |
49 |
50 | Modification history
51 +------------------------------------------------------*/
52
53 PROCEDURE extract
54 (
55 p_application_id IN NUMBER,
56 p_accounting_mode IN VARCHAR2
57 );
58
59 /*------------------------------------------------------
60 | Procedure name : PostProcessing
61 +------------------------------------------------------
62 | DESCRIPTION
63 | This procedure is the Federal SLA post-Processing procedure.
64 | This procedure will be called by SLA through an API.
65 |
66 | Purpose : Post processing requirements during accounting process.
67 | Federal currently does not use any post processing
68 |
69 |
70 | Modification history
71 +------------------------------------------------------*/
72
73 PROCEDURE postprocessing
74 (
75 p_application_id IN NUMBER,
76 p_accounting_mode IN VARCHAR2
77 );
78
79 /*------------------------------------------------------
80 | Procedure name : Postaccounting
81 +------------------------------------------------------
82 | DESCRIPTION
83 | This procedure is the Federal SLA post-accounting procedure.
84 | This procedure will be called by SLA through an API.
85 |
86 | Purpose : Post accouting requirements during accounting process.
87 | Federal Budget execution
88 |
89 |
90 | Modification history
91 +------------------------------------------------------*/
92
93 PROCEDURE postaccounting
94 (
95 p_application_id IN NUMBER,
96 p_ledger_id IN INTEGER,
97 p_process_category IN VARCHAR2,
98 p_end_date IN DATE,
99 p_accounting_mode IN VARCHAR2,
100 p_valuation_method IN VARCHAR2,
101 p_security_id_int_1 IN INTEGER,
102 p_security_id_int_2 IN INTEGER,
103 p_security_id_int_3 IN INTEGER,
104 p_security_id_char_1 IN VARCHAR2,
105 p_security_id_char_2 IN VARCHAR2,
106 p_security_id_char_3 IN VARCHAR2,
107 p_report_request_id IN INTEGER
108 );
109
110 END fv_sla_processing_pkg; -- Package spec
111