[Home] [Help]
PACKAGE: APPS.OKL_VP_STS_PUB
Source
1 PACKAGE OKL_VP_STS_PUB AUTHID CURRENT_USER AS
2 /*$Header: OKLPSSCS.pls 115.5 2002/12/18 12:39:48 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 OKL_VP_STS_PVT.vp_sts_tbl_type;
13
14
15 ---------------------------------------------------------------------------
16 -- GLOBAL MESSAGE CONSTANTS
17 ---------------------------------------------------------------------------
18
19 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
20 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
21 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
22 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
23 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
24 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
25 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
26 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
27 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
28
29
30 -- GLOBAL VARIABLES
31 ---------------------------------------------------------------------------
32 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VP_STS_PUB';
33 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
34 ---------------------------------------------------------------------------
35
36 PROCEDURE get_listof_new_statuses(
37 p_api_version IN NUMBER,
38 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2,
42 p_ste_code IN VARCHAR2,
43 p_sts_code IN VARCHAR2,
44 p_start_date IN DATE,
45 p_end_date IN DATE,
46 x_sts_tbl OUT NOCOPY sts_tbl_type);
47
48
49 PROCEDURE change_agreement_status(
50 p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 p_chr_id IN NUMBER,
56 p_current_sts_code IN VARCHAR2,
57 p_new_sts_code IN VARCHAR2);
58
59
60
61
62 END OKL_VP_STS_PUB;