[Home] [Help]
PACKAGE: APPS.OKL_RESI_CAT_SETS_PVT
Source
1 PACKAGE OKL_RESI_CAT_SETS_PVT authid current_user as
2 /* $Header: OKLRRCSS.pls 120.2 2005/09/14 06:42:33 smadhava noship $ */
3 -- Header record type
4 subtype okl_rcsv_rec is okl_rcs_pvt.okl_rcsv_rec;
5 -- Lines table type
6 subtype okl_res_tbl is okl_res_pvt.okl_res_tbl;
7
8 -- Global Constants
9 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RESI_CAT_SETS_PVT';
10 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
11 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
12 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
13 G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
14 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROG_NAME';
15 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
16 G_CAT_ITEM CONSTANT VARCHAR2(30) := OKL_RCS_PVT.G_CAT_ITEM;
17 G_CAT_ITEM_CAT CONSTANT VARCHAR2(30) := OKL_RCS_PVT.G_CAT_ITEM_CAT;
18 G_STS_INACTIVE CONSTANT VARCHAR2(30) := OKL_RCS_PVT.G_STS_INACTIVE;
19 G_STS_ACTIVE CONSTANT VARCHAR2(30) := OKL_RCS_PVT.G_STS_ACTIVE;
20 -- Global exceptions
21 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
22
23 procedure create_rcs (
24 p_api_version IN NUMBER
25 , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
26 , x_return_status OUT NOCOPY VARCHAR2
27 , x_msg_count OUT NOCOPY NUMBER
28 , x_msg_data OUT NOCOPY VARCHAR2
29 , p_rcsv_rec IN okl_rcsv_rec
30 , p_res_tbl IN okl_res_tbl
31 , x_rcsv_rec OUT NOCOPY okl_rcsv_rec
32 , x_res_tbl OUT NOCOPY okl_res_tbl
33 );
34 PROCEDURE update_rcs (
35 p_api_version IN NUMBER
36 , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
37 , x_return_status OUT NOCOPY VARCHAR2
38 , x_msg_count OUT NOCOPY NUMBER
39 , x_msg_data OUT NOCOPY VARCHAR2
40 , p_rcsv_rec IN okl_rcsv_rec
41 , p_res_tbl IN okl_res_tbl
42 , x_rcsv_rec OUT NOCOPY okl_rcsv_rec
43 );
44
45 PROCEDURE activate_rcs (
46 p_api_version IN NUMBER
47 , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
48 , x_return_status OUT NOCOPY VARCHAR2
49 , x_msg_count OUT NOCOPY NUMBER
50 , x_msg_data OUT NOCOPY VARCHAR2
51 , p_rcsv_rec IN okl_rcsv_rec
52 , p_res_tbl IN okl_res_tbl
53 , x_rcsv_rec OUT NOCOPY okl_rcsv_rec
54 );
55 PROCEDURE Inactivate_rcs (
56 p_api_version IN NUMBER
57 , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
58 , x_return_status OUT NOCOPY VARCHAR2
59 , x_msg_count OUT NOCOPY NUMBER
60 , x_msg_data OUT NOCOPY VARCHAR2
61 , p_rcs_id IN NUMBER
62 , p_obj_ver_number IN NUMBER
63 );
64 PROCEDURE delete_objects(
65 p_api_version IN NUMBER
66 , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
67 , x_return_status OUT NOCOPY VARCHAR2
68 , x_msg_count OUT NOCOPY NUMBER
69 , x_msg_data OUT NOCOPY VARCHAR2
70 , p_res_tbl IN okl_res_tbl);
71 end OKL_RESI_CAT_SETS_PVT;