[Home] [Help]
PACKAGE: APPS.OKL_VP_STS_PVT
Source
1 PACKAGE OKL_VP_STS_PVT AUTHID CURRENT_USER AS
2 /*$Header: OKLRSSCS.pls 115.5 2002/12/18 12:51:25 kjinger noship $*/
3
4
5 TYPE sts_rec_type IS RECORD (
6 status OKC_STATUSES_V.MEANING%TYPE,
7 status_code OKC_STATUSES_V.CODE%TYPE);
8
9 TYPE vp_sts_tbl_type IS TABLE OF sts_rec_type
10 INDEX BY BINARY_INTEGER;
11
12 SUBTYPE sts_tbl_type IS vp_sts_tbl_type;
13
14 ---------------------------------------------------------------------------
15 -- GLOBAL MESSAGE CONSTANTS
16 ---------------------------------------------------------------------------
17
18 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
19 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
20 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
21 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
22 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
23 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
24 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
25 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
26 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
27 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
28
29 ------------------------------------------------------------------------------------
30 -- GLOBAL EXCEPTION
31 ---------------------------------------------------------------------------
32 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
33
34 -- GLOBAL VARIABLES
35 ---------------------------------------------------------------------------
36 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VP_STS_PVT';
37 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
38 ---------------------------------------------------------------------------
39
40 PROCEDURE get_listof_new_statuses(
41 p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_ste_code IN VARCHAR2,
47 p_sts_code IN VARCHAR2,
48 p_start_date IN DATE,
49 p_end_date IN DATE,
50 x_sts_tbl OUT NOCOPY sts_tbl_type);
51
52
53 PROCEDURE change_agreement_status(
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_chr_id IN NUMBER,
60 p_current_sts_code IN VARCHAR2,
61 p_new_sts_code IN VARCHAR2);
62
63
64
65
66 END OKL_VP_STS_PVT;