1 PACKAGE JE_GR_STATUTORY as
2 /* $Header: jegrstas.pls 120.2 2006/05/06 08:15:02 anvijaya ship $ */
3
4 PROCEDURE gl_sequence (p_posting_run_id IN NUMBER,
5 p_retcode IN OUT NOCOPY NUMBER,
6 p_errmsg IN OUT NOCOPY VARCHAR2);
7
8 PROCEDURE gl_cutoff (p_posting_run_id IN NUMBER,
9 p_retcode IN OUT NOCOPY NUMBER,
10 p_errmsg IN OUT NOCOPY VARCHAR2);
11
12 PROCEDURE check_cutoff(p_ledger_id IN NUMBER,
13 p_gldate IN DATE,
14 p_category_code IN VARCHAR2,
15 p_cat_application_id IN NUMBER,
16 p_retcode IN OUT NOCOPY NUMBER,
17 p_errmsg IN OUT NOCOPY VARCHAR2);
18
19 TYPE g_cutoff_rules_rec is RECORD (
20 category_code VARCHAR2(30),
21 cat_application_id NUMBER,
22 ledger_id NUMBER,
23 days NUMBER,
24 violation_response VARCHAR2(10));
25
26 TYPE g_cutoff_rules_tab is TABLE of g_cutoff_rules_rec
27 INDEX BY BINARY_INTEGER;
28
29 g_cutoff_rules g_cutoff_rules_tab;
30 g_idx BINARY_INTEGER := 0;
31
32 END JE_GR_STATUTORY;