PACKAGE: APPS.OKL_EXT_BILLING_CHARGES_PVT

Source

1 Package Okl_Ext_Billing_Charges_Pvt AS
2 /* $Header: OKLRBCGS.pls 120.2 2007/09/04 10:43:50 vpanwar ship $ */
3 
4   G_PKG_NAME	CONSTANT VARCHAR2(30)  := 'OKL_EXT_BILLING_CHARGES_PVT';
5 
6 TYPE ext_rec_type IS RECORD (
7 		 ext_rowid                    rowid
8 		,TRX_STATUS_CODE              OKL_EXT_BILLING_INTERFACE.trx_status_code%TYPE
9 		,ERROR_MESSAGE                OKL_EXT_BILLING_INTERFACE.ERROR_MESSAGE%TYPE
10 		,CONTRACT_NUMBER              OKL_EXT_BILLING_INTERFACE.CONTRACT_NUMBER%TYPE
11 		,CONTRACT_ID                  OKL_EXT_BILLING_INTERFACE.CONTRACT_ID%TYPE
12 		,STY_ID                       OKL_EXT_BILLING_INTERFACE.STY_ID%TYPE
13 		,STY_NAME                     OKL_EXT_BILLING_INTERFACE.STY_NAME%TYPE
14 		,ASSET_ID                     OKL_EXT_BILLING_INTERFACE.ASSET_ID%TYPE
15 		,ASSET_NUMBER                 OKL_EXT_BILLING_INTERFACE.ASSET_NUMBER%TYPE
16 		,INVOICE_DATE                 OKL_EXT_BILLING_INTERFACE.INVOICE_DATE%TYPE
17 		,AMOUNT                       OKL_EXT_BILLING_INTERFACE.AMOUNT%TYPE
18 		,CURRENCY_CODE                OKL_EXT_BILLING_INTERFACE.CURRENCY_CODE%TYPE
19 		,ORG_ID                       OKL_EXT_BILLING_INTERFACE.ORG_ID%TYPE
20         ,JURSDCTN_TYPE                OKL_EXT_BILLING_INTERFACE.JURSDCTN_TYPE%TYPE
21         ,JURSDCTN_NAME                OKL_EXT_BILLING_INTERFACE.JURSDCTN_NAME%TYPE
22         ,MLRT_TAX                     OKL_EXT_BILLING_INTERFACE.MLRT_TAX%TYPE
23         ,TAX_VENDOR_ID                OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_ID%TYPE
24         ,TAX_VENDOR_NAME              OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_NAME%TYPE
25         ,TAX_VENDOR_SITE_ID           OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_SITE_ID%TYPE
26         ,TAX_VENDOR_SITE_NAME         OKL_EXT_BILLING_INTERFACE.TAX_VENDOR_SITE_NAME%TYPE
27         ,STREAM_TYPE_PURPOSE          OKL_EXT_BILLING_INTERFACE.STREAM_TYPE_PURPOSE%TYPE
28         ,TAX_ASSESSMENT_DATE          OKL_EXT_BILLING_INTERFACE.TAX_ASSESSMENT_DATE%TYPE --vpanwar FPbug#5891876
29 );
30 
31 type ext_tbl_type is table of ext_rec_type index by binary_integer;
32 
33   PROCEDURE billing_charges
34 	(p_api_version		  IN  NUMBER
35 	,p_init_msg_list	  IN  VARCHAR2	DEFAULT Okl_Api.G_FALSE
36 	,x_return_status	  OUT NOCOPY VARCHAR2
37 	,x_msg_count		  OUT NOCOPY NUMBER
38 	,x_msg_data			  OUT NOCOPY VARCHAR2
39 	,p_name               IN  VARCHAR2	DEFAULT NULL
40 	,p_sequence_number    IN 	NUMBER		DEFAULT NULL
41 	,p_date_transmission  IN	DATE		DEFAULT NULL
42 	,p_origin             IN	VARCHAR2	DEFAULT NULL
43 	,p_destination        IN 	VARCHAR2	DEFAULT NULL);
44 
45 END Okl_Ext_Billing_Charges_Pvt;