DBA Data[Home] [Help]

PACKAGE: APPS.JL_CO_GL_NIT_MANAGEMENT

Source


1 PACKAGE jl_co_gl_nit_management AUTHID CURRENT_USER AS
2 /*  $Header: jlcoglbs.pls 120.5.12020000.1 2012/06/27 09:55:12 appldev ship $  */
3 
4   TYPE reverse_rec_type IS RECORD (
5        code_combination_id    jl_co_gl_trx.code_combination_id%type,
6        account_code           jl_co_gl_trx.account_code%type,
7        period_name            jl_co_gl_trx.period_name%type,
8        je_batch_id            jl_co_gl_trx.je_batch_id%type,
9        je_header_id           jl_co_gl_trx.je_header_id%type,
10        category               jl_co_gl_trx.category%type,
11        subl_doc_num           jl_co_gl_trx.subledger_doc_number%type,
12        je_line_num            jl_co_gl_trx.je_line_num%type,
13        accounting_date        jl_co_gl_trx.accounting_date%type,
14        currency               jl_co_gl_trx.currency_code%type,
15        reversed_je_header_id  jl_co_gl_trx.je_header_id%type,
16        -- Bug 9441034 Start
17        entered_dr             jl_co_gl_trx.entered_dr%type,
18        entered_cr             jl_co_gl_trx.entered_cr%type,
19        accounted_dr           jl_co_gl_trx.accounted_dr%type,
20        accounted_cr           jl_co_gl_trx.accounted_cr%type);
21        -- Bug 9441034 End
22 
23   TYPE reverse_rec_tbl_type IS TABLE of reverse_rec_type
24           index by binary_integer;
25 
26   reverse_rec_tbl reverse_rec_tbl_type;
27 
28   PROCEDURE create_trx_balance(errbuf         OUT NOCOPY VARCHAR2,
29                                retcode        OUT NOCOPY NUMBER,
30 	                       p_proc_type IN            VARCHAR2,
31                                p_sobid     IN            NUMBER,
32                                p_period    IN            VARCHAR2,
33 	                       p_rcid      IN            NUMBER,
34                                p_batchid   IN            NUMBER );
35 
36   PROCEDURE calculate_balance(p_cid    IN NUMBER,
37                               p_sobid  IN NUMBER,
38 	                      p_userid IN NUMBER);
39 
40   PROCEDURE reverse_balance(p_rcid    IN NUMBER,
41                             p_cid     IN NUMBER,
42                             p_sobid   IN NUMBER,
43 	                    p_userid  IN NUMBER);
44 
45 END jl_co_gl_nit_management;