DBA Data[Home] [Help]

PACKAGE: APPS.OKC_QA_PRICE_PVT

Source


1 PACKAGE OKC_QA_PRICE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCRQARS.pls 120.0 2005/05/25 19:31:00 appldev noship $ */
3 
4   ---------------------------------------------------------------------------
5   -- GLOBAL MESSAGE CONSTANTS
6   ---------------------------------------------------------------------------
7   G_FND_APP			CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
8   G_REQUIRED_VALUE		CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
9   G_INVALID_VALUE		CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
10   G_UNEXPECTED_ERROR            CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
11 
12   G_SQLCODE_TOKEN               CONSTANT VARCHAR2(200) := 'ERROR_CODE';
13   G_SQLERRM_TOKEN               CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
14   --
15   G_QA_SUCCESS   		CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_QA_SUCCESS';
16 
17   ---------------------------------------------------------------------------
18   -- GLOBAL EXCEPTION
19   ---------------------------------------------------------------------------
20   G_EXCEPTION_HALT_VALIDATION	EXCEPTION;
21 
22   -- GLOBAL VARIABLES
23   ---------------------------------------------------------------------------
24   G_PKG_NAME			CONSTANT VARCHAR2(30)  := 'OKC_QA_PRICE_PVT';
25   G_APP_NAME			CONSTANT VARCHAR2(3)   :=  OKC_API.G_APP_NAME;
26   ---------------------------------------------------------------------------
27 
28   PROCEDURE check_price(
29     x_return_status            OUT NOCOPY VARCHAR2,
30     p_chr_id                   IN  NUMBER);
31 
32 
33   PROCEDURE check_covered_line_qty (
34     p_chr_id             IN  okc_k_headers_b.ID%TYPE,
35     x_return_status      OUT NOCOPY VARCHAR2);
36 
37 
38 END OKC_QA_PRICE_PVT;