DBA Data[Home] [Help]

APPS.OKL_SETUPCGRPARAMETERS_PVT dependencies on OKL_API

Line 12: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;

8: G_IN_USE CONSTANT VARCHAR2(200) := 'OKL_IN_USE';
9:
10: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
11: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
12: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
13: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
14:
15: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
16: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPCGRPARAMETERS_PVT';

Line 13: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;

9:
10: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
11: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
12: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
13: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
14:
15: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
16: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPCGRPARAMETERS_PVT';
17:

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

11: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
12: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
13: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
14:
15: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
16: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPCGRPARAMETERS_PVT';
17:
18: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
19:

Line 31: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

27: x_cgmv_rec OUT NOCOPY cgmv_rec_type);
28:
29: PROCEDURE insert_cgrparameters(
30: p_api_version IN NUMBER,
31: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2,
35: p_cgmv_rec IN cgmv_rec_type,

Line 40: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

36: x_cgmv_rec OUT NOCOPY cgmv_rec_type);
37:
38: PROCEDURE update_cgrparameters(
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2,
44: p_cgmv_rec IN cgmv_rec_type,

Line 49: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

45: x_cgmv_rec OUT NOCOPY cgmv_rec_type);
46:
47: PROCEDURE delete_cgrparameters(
48: p_api_version IN NUMBER,
49: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
50: x_return_status OUT NOCOPY VARCHAR2,
51: x_msg_count OUT NOCOPY NUMBER,
52: x_msg_data OUT NOCOPY VARCHAR2,
53: p_cgmv_tbl IN cgmv_tbl_type);

Line 58: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

54:
55: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_CNTX_GRP_PRMTRS_V - TBL : begin
56: PROCEDURE insert_cgrparameters(
57: p_api_version IN NUMBER,
58: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_cgmv_tbl IN cgmv_tbl_type,

Line 70: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

66:
67: -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_CNTX_GRP_PRMTRS_V - TBL : begin
68: PROCEDURE update_cgrparameters(
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
74: p_cgmv_tbl IN cgmv_tbl_type,