APPS.OKL_RESI_CAT_SETS_PVT dependencies on OKL_API

Line 10: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

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';

Line 15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

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;

Line 25: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

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

Line 36: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

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

Line 47: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

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

Line 57: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

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

Line 66: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

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);