DBA Data[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;