DBA Data[Home] [Help]

APPS.OKL_SETUPPQVALUES_PUB dependencies on OKL_API

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

10: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
11: G_PAST_RECORDS CONSTANT VARCHAR2(200) := 'OKL_PAST_RECORDS';
12: G_START_DATE CONSTANT VARCHAR2(200) := 'OKL_START_DATE';
13: G_INVALID_DATES CONSTANT VARCHAR2(200) := 'OKL_INVALID_DATES';
14: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
15: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
16:
17: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
18: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPPQVALUES_PUB';

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

11: G_PAST_RECORDS CONSTANT VARCHAR2(200) := 'OKL_PAST_RECORDS';
12: G_START_DATE CONSTANT VARCHAR2(200) := 'OKL_START_DATE';
13: G_INVALID_DATES CONSTANT VARCHAR2(200) := 'OKL_INVALID_DATES';
14: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
15: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
16:
17: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
18: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPPQVALUES_PUB';
19:

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

13: G_INVALID_DATES CONSTANT VARCHAR2(200) := 'OKL_INVALID_DATES';
14: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
15: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
16:
17: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
18: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPPQVALUES_PUB';
19:
20: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
21:

Line 43: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

39: x_pqvv_rec OUT NOCOPY pqvv_rec_type);
40:
41: PROCEDURE insert_pqvalues(
42: p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
44: x_return_status OUT NOCOPY VARCHAR2,
45: x_msg_count OUT NOCOPY NUMBER,
46: x_msg_data OUT NOCOPY VARCHAR2,
47: p_pqyv_rec IN pqyv_rec_type,

Line 54: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

50: x_pqvv_rec OUT NOCOPY pqvv_rec_type
51: );
52: PROCEDURE insert_pqvalues(
53: p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
55: x_return_status OUT NOCOPY VARCHAR2,
56: x_msg_count OUT NOCOPY NUMBER,
57: x_msg_data OUT NOCOPY VARCHAR2,
58: p_pqyv_rec IN pqyv_rec_type,

Line 65: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

61: x_pqvv_tbl OUT NOCOPY pqvv_tbl_type);
62:
63: PROCEDURE update_pqvalues(
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2,
69: p_pqyv_rec IN pqyv_rec_type,

Line 75: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

71: p_pqvv_rec IN pqvv_rec_type,
72: x_pqvv_rec OUT NOCOPY pqvv_rec_type
73: );
74: PROCEDURE update_pqvalues(p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_data OUT NOCOPY VARCHAR2,
79: p_pqyv_rec IN pqyv_rec_type,