[Home] [Help]
PACKAGE: APPS.OKS_QP_INT
Source
1 PACKAGE OKS_QP_INT AUTHID CURRENT_USER AS
2 /* $Header: OKSGPINS.pls 120.0 2005/05/25 18:01:06 appldev noship $ */
3
4 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
5 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
6 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
7 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
8 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
9 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
10
11 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
12 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
13 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
14
15 ------------------------------------------------------------------
16 -- GLOBAL EXCEPTION
17 ------------------------------------------------------------------
18 G_EXC_ERROR EXCEPTION;
19 G_EXC_UNEXPECTED_ERROR EXCEPTION;
20
21 ------------------------------------------------------------------
22 -- Global constant holding the package name
23 ------------------------------------------------------------------
24 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKS_QP_INT';
25 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKS';
26
27 PROCEDURE GET_CONVERSION_FACTOR (
28 p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2,
30 p_start_date IN DATE,
31 p_end_date IN DATE,
32 p_pb_uom IN VARCHAR2,
33 x_factor OUT NOCOPY NUMBER,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2
37 );
38
39 END OKS_QP_INT;