[Home] [Help]
PACKAGE: APPS.XTR_TRANS_INTERFACE
Source
1 PACKAGE XTR_TRANS_INTERFACE AS
2 /*$Header: xtrtrins.pls 120.1 2005/06/29 07:57:54 rjose ship $ */
3
4 -- CONTEXT: CALL = XTR_TRANS_INTERFACE.Transfer_From_Interface.
5 -- GLOBAL variables
6 --
7 --
8 l_div varchar2(1);
9 l_divisor NUMBER;
10 l_count NUMBER;
11 l_error NUMBER;
12 l_import_nos NUMBER;
13 l_num_trans NUMBER;
14 l_db_total NUMBER;
15 l_cr_total NUMBER;
16 l_total NUMBER;
17 l_source varchar2(20);
18 l_tsfr_trailer varchar2(1);
19 l_rev_trailer varchar2(1);
20 l_verify_total varchar2(1);
21 l_ccy varchar2(15);
22 l_cre_date DATE;
23 l_net_amount NUMBER;
24 l_net_debit NUMBER;
25 l_net_credit NUMBER;
26 l_dr_trans NUMBER;
27 l_cr_trans NUMBER;
28 l_net_trans NUMBER;
29 l_debit NUMBER;
30 l_company VARCHAR2(7);
31 l_acct VARCHAR2(20);
32 l_batch_acct VARCHAR2(20);
33 l_imp_source VARCHAR2(20);
34 fnd_user_id NUMBER;
35 x_user VARCHAR2(30);
36 --
37 -- Pass in Parameter
38 --
39 G_source VARCHAR2(20);
40 G_creation_date DATE;
41 G_currency VARCHAR2(15);
42
43 PROCEDURE TRANSFER_FROM_INTERFACE ( errbuf OUT NOCOPY VARCHAR2,
44 retcode OUT NOCOPY NUMBER,
45 p_source VARCHAR2,
46 p_creation_date VARCHAR2,
47 p_currency VARCHAR2 );
48
49
50 END XTR_TRANS_INTERFACE;