1 PACKAGE xla_je_funds_checker_pkg AS
2 /* $Header: xlajefck.pkh 120.4 2005/08/17 20:46:57 dcshah ship $ */
3 -------------------------------------------------------------------------------
4 -- declaring global constants
5 -------------------------------------------------------------------------------
6
7
8 -------------------------------------------------------------------------------
9 -- Public API
10 -------------------------------------------------------------------------------
11
12 FUNCTION reserve_funds
13 (p_ae_header_id IN INTEGER
14 ,p_application_id IN INTEGER
15 ,p_ledger_id IN INTEGER
16 ,p_packet_id OUT NOCOPY INTEGER)
17 RETURN VARCHAR2;
18
19 FUNCTION unreserve_funds
20 (p_ae_header_id IN INTEGER
21 ,p_application_id IN INTEGER
22 ,p_ledger_id IN INTEGER
23 ,p_packet_id IN INTEGER)
24 RETURN VARCHAR2;
25
26 PROCEDURE check_funds
27 (p_ae_header_id IN INTEGER
28 ,p_application_id IN INTEGER
29 ,p_ledger_id IN INTEGER
30 ,p_packet_id IN INTEGER
31 ,p_retcode OUT NOCOPY VARCHAR2);
32
33 PROCEDURE insert_check_funds_row
34 (p_packet_id IN INTEGER
35 ,p_ledger_id IN INTEGER
36 ,p_application_id IN INTEGER
37 ,p_ae_header_id IN INTEGER
38 ,p_ae_line_num IN INTEGER
39 ,p_gl_date IN DATE
40 ,p_balance_type_code IN VARCHAR2
41 ,p_je_category_name IN VARCHAR2
42 ,p_budget_version_id IN INTEGER
43 ,p_encumbrance_type_id IN INTEGER
44 ,p_code_combination_id IN INTEGER
45 ,p_currency_code IN VARCHAR2
46 ,p_entered_dr IN NUMBER
47 ,p_entered_cr IN NUMBER
48 ,p_accounted_dr IN NUMBER
49 ,p_accounted_cr IN NUMBER
50 ,p_ussgl_transaction_code IN VARCHAR2
51 ,p_event_id IN NUMBER);
52
53
54 END xla_je_funds_checker_pkg;