DBA Data[Home] [Help]

PACKAGE: APPS.OKL_PURGE_STRM_INTF_PVT

Source


1 PACKAGE OKL_PURGE_STRM_INTF_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRPSIS.pls 115.2 2002/11/30 08:55:29 spillaip noship $ */
3   ---------------------------------------------------------------------------
4   -- GLOBAL DATASTRUCTURES
5   ---------------------------------------------------------------------------
6   -- Record type which holds the account generator rule lines.
7   G_FND_APP			CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
8   G_UNEXPECTED_ERROR		CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
9   G_SQLERRM_TOKEN		CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
10   G_SQLCODE_TOKEN		CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
11   ---------------------------------------------------------------------------
12   -- GLOBAL EXCEPTION
13   ---------------------------------------------------------------------------
14   G_EXCEPTION_HALT_VALIDATION  EXCEPTION;
15   ---------------------------------------------------------------------------
16   ---------------------------------------------------------------------------
17   -- GLOBAL VARIABLES
18   ---------------------------------------------------------------------------
19   G_PKG_NAME			CONSTANT VARCHAR2(200) := 'OKL_PURGE_STRM_INTF_PVT';
20   G_APP_NAME			CONSTANT VARCHAR2(3)   :=  OKL_API.G_APP_NAME;
21   G_RET_STS_SUCCESS		 CONSTANT VARCHAR2(1) 	:= OKL_API.G_RET_STS_SUCCESS;
22   G_RET_STS_UNEXP_ERROR		 CONSTANT VARCHAR2(1) 	:= OKL_API.G_RET_STS_UNEXP_ERROR;
23   G_RET_STS_ERROR		 CONSTANT VARCHAR2(1) 	:= OKL_API.G_RET_STS_ERROR;
24   G_EXCEPTION_ERROR		 EXCEPTION;
25   G_EXCEPTION_UNEXPECTED_ERROR	 EXCEPTION;
26   SUBTYPE error_message_type IS OKL_ACCOUNTING_UTIL.ERROR_MESSAGE_TYPE;
27   SUBTYPE sifv_rec_type IS okl_sif_pvt.sifv_rec_type;
28   SUBTYPE sitv_rec_type IS okl_sit_pvt.sitv_rec_type;
29   SUBTYPE sfev_rec_type IS okl_sfe_pvt.sfev_rec_type;
30   SUBTYPE silv_rec_type IS okl_sil_pvt.silv_rec_type;
31   SUBTYPE sxpv_rec_type IS okl_sxp_pvt.sxpv_rec_type;
32   SUBTYPE siyv_rec_type IS okl_siy_pvt.siyv_rec_type;
33   SUBTYPE sirv_rec_type IS okl_sir_pvt.sirv_rec_type;
34   SUBTYPE srsv_rec_type IS okl_srs_pvt.srsv_rec_type;
35   SUBTYPE srlv_rec_type IS okl_srl_pvt.okl_sif_ret_levels_v_rec_type;
36   SUBTYPE srmv_rec_type IS okl_srm_pvt.srmv_rec_type;
37   ---------------------------------------------------------------------------
38   -- Procedures and Functions
39   ---------------------------------------------------------------------------
40   PROCEDURE PURGE_INTERFACE_TABLES(
41                                    x_errbuf OUT NOCOPY VARCHAR2
42                                   ,x_retcode OUT NOCOPY NUMBER
43                                   ,p_end_date IN VARCHAR2);
44 
45 END OKL_PURGE_STRM_INTF_PVT;