[Home] [Help]
PACKAGE: APPS.OKL_PROCESS_PROVISIONS_PVT
Source
1 PACKAGE OKL_PROCESS_PROVISIONS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRPRVS.pls 115.2 2002/02/11 19:40:50 pkm ship $ */
3
4 SUBTYPE pvnv_rec_type IS OKL_PROVISIONS_PUB.pvnv_rec_type;
5 SUBTYPE pvnv_tbl_type IS OKL_PROVISIONS_PUB.pvnv_tbl_type;
6
7 ---------------------------------------------------------------------------
8 -- GLOBAL VARIABLES
9 ---------------------------------------------------------------------------
10 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
11 G_VERSION_OVERLAPS CONSTANT VARCHAR2(200) := 'OKL_VERSION_OVERLAPS';
12 G_DATES_MISMATCH CONSTANT VARCHAR2(200) := 'OKL_DATES_MISMATCH';
13 G_PAST_RECORDS CONSTANT VARCHAR2(200) := 'OKL_PAST_RECORDS';
14 G_START_DATE CONSTANT VARCHAR2(200) := 'OKL_START_DATE';
15 G_END_DATE CONSTANT VARCHAR2(200) := 'OKL_END_DATE';
16 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
17 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
18 G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
19 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
20 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
21 G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
22
23 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
24 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_PROCESS_PROVISIONS_PVT';
25
26 G_INIT_VERSION CONSTANT NUMBER := 1.0;
27 G_VERSION_MAJOR_INCREMENT CONSTANT NUMBER := 1.0;
28 G_VERSION_MINOR_INCREMENT CONSTANT NUMBER := 0.1;
29 G_VERSION_FORMAT CONSTANT VARCHAR2(100) := 'FM999.0999';
30 G_FORMULA_TYPE CONSTANT VARCHAR2(10) := 'GRNC';
31
32 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
33 G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
34 G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
35 G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
36
37 PROCEDURE create_provisions(
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2,
43 p_pvnv_rec IN pvnv_rec_type,
44 x_pvnv_rec OUT NOCOPY pvnv_rec_type);
45
46 PROCEDURE create_provisions(
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 p_pvnv_tbl IN pvnv_tbl_type,
53 x_pvnv_tbl OUT NOCOPY pvnv_tbl_type);
54
55
56 PROCEDURE update_provisions(
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_pvnv_rec IN pvnv_rec_type,
63 x_pvnv_rec OUT NOCOPY pvnv_rec_type);
64
65 PROCEDURE update_provisions(
66 p_api_version IN NUMBER,
67 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2,
71 p_pvnv_tbl IN pvnv_tbl_type,
72 x_pvnv_tbl OUT NOCOPY pvnv_tbl_type);
73
74 PROCEDURE delete_provisions(
75 p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2,
80 p_pvnv_rec IN pvnv_rec_type);
81
82 PROCEDURE delete_provisions(
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 p_pvnv_tbl IN pvnv_tbl_type);
89
90
91 END OKL_PROCESS_PROVISIONS_PVT;