DBA Data[Home] [Help]

APPS.OKL_SETUPOPTVALUES_PVT dependencies on OKL_API

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

13: G_INVALID_KEY CONSTANT VARCHAR2(200) := 'OKL_INVALID_KEY';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
16: G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
17: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
18: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
20:
21: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

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

14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
16: G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
17: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
18: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
20:
21: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
22: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPOPTVALUES_PVT';

Line 19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;

15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
16: G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
17: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
18: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
20:
21: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
22: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPOPTVALUES_PVT';
23:

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

17: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
18: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
20:
21: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
22: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPOPTVALUES_PVT';
23:
24: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
25:

Line 49: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

45: x_rulv_rec OUT NOCOPY rulv_rec_type);
46:
47: PROCEDURE insert_optvalues(
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_optv_rec IN optv_rec_type,

Line 59: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

55: x_ovev_rec OUT NOCOPY ovev_rec_type);
56:
57: PROCEDURE update_optvalues(
58: p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
60: x_return_status OUT NOCOPY VARCHAR2,
61: x_msg_count OUT NOCOPY NUMBER,
62: x_msg_data OUT NOCOPY VARCHAR2,
63: p_optv_rec IN optv_rec_type,