DBA Data[Home] [Help]

PACKAGE: APPS.OKS_WARRDATA_PUB

Source


1 Package OKS_WARRDATA_PUB AUTHID CURRENT_USER As
2 /* $Header: OKSPWDFS.pls 120.0 2005/05/25 17:37:28 appldev noship $ */
3 
4 
5  ---------------------------------------------------------------------------
6   -- GLOBAL MESSAGE CONSTANTS
7   ---------------------------------------------------------------------------
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_COL_NAME_TOKEN		CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
11   G_PARENT_TABLE_TOKEN		CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
12   G_CHILD_TABLE_TOKEN		CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
13   G_UNEXPECTED_ERROR            CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
14   G_SQLERRM_TOKEN               CONSTANT VARCHAR2(200) := 'SQLerrm';
15   G_SQLCODE_TOKEN               CONSTANT VARCHAR2(200) := 'SQLcode';
16   G_UPPERCASE_REQUIRED		CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';
17 
18   ------------------------------------------------------------------------------------
19   -- GLOBAL EXCEPTION
20   ---------------------------------------------------------------------------
21   G_EXCEPTION_HALT_VALIDATION	EXCEPTION;
22 
23   -- GLOBAL VARIABLES
24   ---------------------------------------------------------------------------
25   G_PKG_NAME			CONSTANT VARCHAR2(200) := 'OKSOMINT';
26   G_APP_NAME			CONSTANT VARCHAR2(3)   := 'OKS';
27   ---------------------------------------------------------------------------
28 
29 PROCEDURE WARRANTY_DATAFIX (
30 P_INSTANCE_ID         IN               NUMBER,
31 X_msg_Count           OUT NOCOPY       NUMBER,
32 X_msg_Data            OUT NOCOPY       Varchar2,
33 x_return_status       OUT NOCOPY       Varchar2
34 
35 );
36 
37 
38 END OKS_WARRDATA_PUB;
39 
40 
41