1 package IGIPFUNK AUTHID CURRENT_USER as
2 -- $Header: igiexpas.pls 115.8 2002/11/18 06:31:18 sowsubra ship $
3 Procedure exp_num (ep_num IN igi_exp_numbering_all.EP_NUMBERING_CODE%type,
4 doc_class IN igi_exp_numbering_all.DOCUMENT_CLASS_CODE%type,
5 doc_type IN igi_exp_numbering_all.DOCUMENT_TYPE_CODE%type,
6 trx_type IN igi_exp_numbering_all.TRX_TYPE_CODE%type,
7 p_exp_num out NOCOPY varchar2);
8
9 Procedure insert_new_exp_row (l_ep_num IN Varchar2,
10 l_doc_class IN Varchar2,
11 l_doc_type IN Varchar2,
12 l_trx_type IN Varchar2,
13 pPrefix IN Varchar2,
14 PSuffix IN Varchar2,
15 b_fy IN Number,
16 l_app IN varchar2,
17 ep_num IN Varchar2,
18 doc_class IN Varchar2,
19 doc_type IN Varchar2,
20 trx_type IN varchar2,
21 p_num_id OUT NOCOPY number) ;
22
23 PROCEDURE create_trx(pnumber_id in number,
24 pPrefix in out NOCOPY varchar2,
25 pSuffix in out NOCOPY varchar2,
26 pnext_seq_val in out NOCOPY number,
27 pGL_date in date,
28 p_fy in number,
29 l_app IN Varchar2);
30
31
32 PROCEDURE get_fiscal_year (aGl_date date, v_fy in out NOCOPY number) ;
33
34 PROCEDURE cancel_trx(gPrefix IN Varchar2,
35 gSeq_Num IN NUMBER,
36 gSuffix IN Varchar2
37 ) ;
38
39 Procedure ins_del(v_number_id in NUMBER,
40 vPrefix in varchar2,
41 vSuffix in varchar2,
42 vseq_num in number,
43 v_trx_date in date,
44 v_fy in number,
45 c_date in date,
46 l_app in varchar2);
47
48 PROCEDURE redo_trx(pnumber_id in number,
49 pPrefix in out NOCOPY varchar2,
50 pSuffix in out NOCOPY varchar2,
51 pseq_val in out NOCOPY number,
52 pGL_date in date,
53 p_fy in number,
54 l_app IN Varchar2,
55 p_exp_num in out NOCOPY varchar2);
56
57
58
59 END IGIPFUNK;
[Home] [Help]