DBA Data[Home] [Help]

PACKAGE: APPS.FV_SLA_AP_PROCESSING_PKG

Source


1 PACKAGE fv_sla_ap_processing_pkg AUTHID CURRENT_USER as
2 --$Header: FVXLAAPS.pls 120.1 2010/10/05 14:14:29 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   PROCEDURE process_payments
109   (
110     p_application_id    IN xla_events_gt.application_id%TYPE,
111     p_fv_extract_detail IN OUT NOCOPY fv_sla_utl_processing_pkg.fv_ref_detail,
112     p_error_code        OUT NOCOPY NUMBER,
113     p_error_desc        OUT NOCOPY VARCHAR2
114   );
115 
116 END fv_sla_ap_processing_pkg; -- Package spec