DBA Data[Home] [Help]

PACKAGE: APPS.OKC_DELETE_CONTRACT_PVT

Source


1 package OKC_DELETE_CONTRACT_PVT AUTHID CURRENT_USER as
2 /* $Header: OKCRDELS.pls 120.0 2005/05/25 19:03:50 appldev noship $ */
3 
4   -- GLOBAL VARIABLES
5   ---------------------------------------------------------------------------
6   G_UNEXPECTED_ERROR           CONSTANT   varchar2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
7   G_PKG_NAME			CONSTANT VARCHAR2(200) := 'OKC_DELETE_PVT';
8   G_APP_NAME			CONSTANT VARCHAR2(3)   :=  OKC_API.G_APP_NAME;
9   G_CANNOT_DELETE		CONSTANT VARCHAR2(200)   :=  'OKC_CANNOT_DELETE';
10   G_SQLERRM_TOKEN        CONSTANT   varchar2(200) := 'SQLerrm';
11   G_SQLCODE_TOKEN        CONSTANT   varchar2(200) := 'SQLcode';
12   G_TABLE_NAME_TOKEN     CONSTANT   varchar2(200) := 'TABLE_NAME';
13   G_COL_NAME_TOKEN		CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
14   G_EXCEPTION_HALT_VALIDATION           EXCEPTION;
15   ---------------------------------------------------------------------------
16 
17 --Procedures pertaining to deleting a contract
18 
19 PROCEDURE delete_contract(
20 	p_api_version 		IN NUMBER,
21 	p_init_msg_list 	IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
22 	x_return_status	OUT NOCOPY VARCHAR2,
23 	x_msg_count		OUT NOCOPY NUMBER,
24 	x_msg_data		OUT NOCOPY VARCHAR2,
25 	p_chrv_rec		IN OKC_CONTRACT_PUB.chrv_rec_type);
26 
27 END OKC_DELETE_CONTRACT_PVT;