PACKAGE: APPS.AR_ECAPP_PKG

Source

1 PACKAGE AR_ECAPP_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARECAPPS.pls 120.2.12010000.1 2009/03/23 07:40:26 mpsingh noship $*/
3 
4 TYPE t_cash_receipt_id	IS TABLE OF ar_cash_receipts.cash_receipt_id%TYPE
5 			INDEX BY BINARY_INTEGER;
6 TYPE t_receipt_number	IS TABLE OF ar_cash_receipts.receipt_number%TYPE
7 			INDEX BY BINARY_INTEGER;
8 TYPE t_org_id		IS TABLE OF ar_cash_receipts.org_id%TYPE
9 			INDEX BY BINARY_INTEGER;
10 TYPE t_bepcode		IS TABLE OF iby_trxn_summaries_all.bepcode%TYPE
11 			INDEX BY BINARY_INTEGER;
12 TYPE t_bepmessage	IS TABLE OF iby_trxn_summaries_all.bepmessage%TYPE
13 			INDEX BY BINARY_INTEGER;
14 TYPE t_instrtype	IS TABLE OF iby_trxn_summaries_all.instrtype%TYPE
15 			INDEX BY BINARY_INTEGER;
16 TYPE t_request_id	IS TABLE OF ar_cash_receipts.request_id%TYPE
17 			INDEX BY BINARY_INTEGER;
18 
19 PROCEDURE correct_settlement_error ;
20 
21 
22 PROCEDURE UPDATE_STATUS(
23 			totalRows	IN NUMBER,
24 			txn_id_Tab	IN JTF_VARCHAR2_TABLE_100,
25 			req_type_Tab	IN JTF_VARCHAR2_TABLE_100,
26 			Status_Tab	IN JTF_NUMBER_TABLE,
27 			updatedt_Tab	IN JTF_DATE_TABLE,
28 			refcode_Tab	IN JTF_VARCHAR2_TABLE_100,
29 			o_status	OUT NOCOPY VARCHAR2,
30 			o_errcode	OUT NOCOPY VARCHAR2,
31 			o_errmsg	OUT NOCOPY VARCHAR2,
32 			o_statusindiv_Tab IN OUT NOCOPY JTF_VARCHAR2_TABLE_100
33 			);
34 
35 
36 END AR_ECAPP_PKG;