PACKAGE: APPS.FUN_AR_BATCH_TRANSFER

Source

1 PACKAGE FUN_AR_BATCH_TRANSFER AUTHID CURRENT_USER AS
2 /* $Header: funartrs.pls 120.3 2006/05/25 11:28:39 cjain noship $ */
3 
4     -- The record type for AR transfer
5 
6      TYPE AR_interface_line IS RECORD(
7      AMOUNT NUMBER,
8      BATCH_SOURCE_NAME Varchar2(50),
9      CONVERSION_TYPE Varchar2(30),
10      CURRENCY_CODE Varchar2(15),
11      CUSTOMER_TRX_TYPE_ID Number,
12      DESCRIPTION Varchar2(240),
13      GL_DATE Date,
14      INTERFACE_LINE_ATTRIBUTE1 Varchar2(30),
15      INTERFACE_LINE_ATTRIBUTE2 Varchar2(30),
16      INTERFACE_LINE_ATTRIBUTE3 Varchar2(30),
17      INTERFACE_LINE_CONTEXT Varchar2(30),
18      LINE_TYPE Varchar2(20) ,
19      MEMO_LINE_ID Number,
20      ORG_ID Number,
21      ORIG_SYSTEM_BILL_ADDRESS_ID Number,
22      ORIG_SYSTEM_BILL_CUSTOMER_ID Number,
23      SET_OF_BOOKS_ID Number,
24      TRX_DATE Date,
25      UOM_NAME Varchar2(25)
26      );
27 
28      TYPE AR_interface_Dist_line IS RECORD(
29      ACCOUNT_CLASS RA_CUST_TRX_LINE_GL_DIST_ALL.account_class%TYPE,
30      AMOUNT NUMBER,
31      percent RA_CUST_TRX_LINE_GL_DIST_ALL.percent%TYPE,
32      CODE_COMBINATION_ID Number,
33      INTERFACE_LINE_ATTRIBUTE1 Varchar2(30),
34      INTERFACE_LINE_ATTRIBUTE2 Varchar2(30),
35      INTERFACE_LINE_ATTRIBUTE3 Varchar2(30),
36      INTERFACE_LINE_CONTEXT Varchar2(30),
37      ORG_ID Number
38      );
39 
40 
41 	FUNCTION has_valid_conversion_rate (
42 	    p_from_currency IN varchar2,
43 	    p_to_currency   IN varchar2,
44 	    p_exchange_type IN varchar2,
45 	    p_exchange_date IN date) RETURN NUMBER;
46 
47 	Procedure ar_batch_transfer  (errbuf    OUT NOCOPY VARCHAR2,
48                                 retcode     OUT NOCOPY NUMBER,
49                                 p_org_id    IN VARCHAR2 DEFAULT NULL,
50                                 p_le_id     IN VARCHAR2 DEFAULT NULL,
51                                 p_date_low  IN VARCHAR2 DEFAULT NULL,
52                                 p_date_high IN VARCHAR2 DEFAULT NULL,
53                                 p_run_autoinvoice_import IN VARCHAR2 DEFAULT 'N'
54                                 );
55 
56 
57 
58     END;
59