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