DBA Data[Home] [Help]

APPS.OKL_SETUPPQVALUES_PVT dependencies on OKL_API

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

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

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

12: G_IN_USE CONSTANT VARCHAR2(100) := 'OKL_IN_USE';
13: G_START_DATE CONSTANT VARCHAR2(200) := 'OKL_START_DATE';
14: G_INVALID_DATES CONSTANT VARCHAR2(200) := 'OKL_INVALID_DATES';
15: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
16: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
17:
18: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
19: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPPQVALUES_PVT';
20:

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

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

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 53: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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

Line 65: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

61:
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: PROCEDURE update_pqvalues(
74: 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,