DBA Data[Home] [Help]

PACKAGE: APPS.JL_CO_GL_NIT_MANAGEMENT

Source


1 PACKAGE jl_co_gl_nit_management AS
2 /*  $Header: jlcoglbs.pls 120.4.12010000.1 2008/07/31 04:23:54 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 
17   TYPE reverse_rec_tbl_type IS TABLE of reverse_rec_type
18           index by binary_integer;
19 
20   reverse_rec_tbl reverse_rec_tbl_type;
21 
22   PROCEDURE create_trx_balance(errbuf         OUT NOCOPY VARCHAR2,
23                                retcode        OUT NOCOPY NUMBER,
24 	                       p_proc_type IN            VARCHAR2,
25                                p_sobid     IN            NUMBER,
26                                p_period    IN            VARCHAR2,
27 	                       p_rcid      IN            NUMBER,
28                                p_batchid   IN            NUMBER );
29 
30   PROCEDURE calculate_balance(p_cid    IN NUMBER,
31                               p_sobid  IN NUMBER,
32 	                      p_userid IN NUMBER);
33 
34   PROCEDURE reverse_balance(p_rcid    IN NUMBER,
35                             p_cid     IN NUMBER,
36                             p_sobid   IN NUMBER,
37 	                    p_userid  IN NUMBER);
38 
39 END jl_co_gl_nit_management;