DBA Data[Home] [Help]

APPS.OKL_BCT_PVT dependencies on OKL_API

Line 8: USER_ID NUMBER := OKL_API.G_MISS_NUM ,

4: --------------------------------------------------------------------------------
5: --GLOBAL DATASTRUCTURES
6: --------------------------------------------------------------------------------
7: TYPE okl_bct_rec IS RECORD (
8: USER_ID NUMBER := OKL_API.G_MISS_NUM ,
9: ORG_ID NUMBER := OKL_API.G_MISS_NUM ,
10: BATCH_NUMBER NUMBER := OKL_API.G_MISS_NUM ,
11: PROCESSING_SRL_NUMBER NUMBER := OKL_API.G_MISS_NUM ,
12: KHR_ID NUMBER := OKL_API.G_MISS_NUM ,

Line 9: ORG_ID NUMBER := OKL_API.G_MISS_NUM ,

5: --GLOBAL DATASTRUCTURES
6: --------------------------------------------------------------------------------
7: TYPE okl_bct_rec IS RECORD (
8: USER_ID NUMBER := OKL_API.G_MISS_NUM ,
9: ORG_ID NUMBER := OKL_API.G_MISS_NUM ,
10: BATCH_NUMBER NUMBER := OKL_API.G_MISS_NUM ,
11: PROCESSING_SRL_NUMBER NUMBER := OKL_API.G_MISS_NUM ,
12: KHR_ID NUMBER := OKL_API.G_MISS_NUM ,
13: PROGRAM_NAME OKL_BOOK_CONTROLLER_TRX.PROGRAM_NAME%TYPE := OKL_API.G_MISS_CHAR ,

Line 10: BATCH_NUMBER NUMBER := OKL_API.G_MISS_NUM ,

6: --------------------------------------------------------------------------------
7: TYPE okl_bct_rec IS RECORD (
8: USER_ID NUMBER := OKL_API.G_MISS_NUM ,
9: ORG_ID NUMBER := OKL_API.G_MISS_NUM ,
10: BATCH_NUMBER NUMBER := OKL_API.G_MISS_NUM ,
11: PROCESSING_SRL_NUMBER NUMBER := OKL_API.G_MISS_NUM ,
12: KHR_ID NUMBER := OKL_API.G_MISS_NUM ,
13: PROGRAM_NAME OKL_BOOK_CONTROLLER_TRX.PROGRAM_NAME%TYPE := OKL_API.G_MISS_CHAR ,
14: PROG_SHORT_NAME OKL_BOOK_CONTROLLER_TRX.PROG_SHORT_NAME%TYPE := OKL_API.G_MISS_CHAR ,

Line 11: PROCESSING_SRL_NUMBER NUMBER := OKL_API.G_MISS_NUM ,

7: TYPE okl_bct_rec IS RECORD (
8: USER_ID NUMBER := OKL_API.G_MISS_NUM ,
9: ORG_ID NUMBER := OKL_API.G_MISS_NUM ,
10: BATCH_NUMBER NUMBER := OKL_API.G_MISS_NUM ,
11: PROCESSING_SRL_NUMBER NUMBER := OKL_API.G_MISS_NUM ,
12: KHR_ID NUMBER := OKL_API.G_MISS_NUM ,
13: PROGRAM_NAME OKL_BOOK_CONTROLLER_TRX.PROGRAM_NAME%TYPE := OKL_API.G_MISS_CHAR ,
14: PROG_SHORT_NAME OKL_BOOK_CONTROLLER_TRX.PROG_SHORT_NAME%TYPE := OKL_API.G_MISS_CHAR ,
15: CONC_REQ_ID NUMBER := OKL_API.G_MISS_NUM ,

Line 12: KHR_ID NUMBER := OKL_API.G_MISS_NUM ,

8: USER_ID NUMBER := OKL_API.G_MISS_NUM ,
9: ORG_ID NUMBER := OKL_API.G_MISS_NUM ,
10: BATCH_NUMBER NUMBER := OKL_API.G_MISS_NUM ,
11: PROCESSING_SRL_NUMBER NUMBER := OKL_API.G_MISS_NUM ,
12: KHR_ID NUMBER := OKL_API.G_MISS_NUM ,
13: PROGRAM_NAME OKL_BOOK_CONTROLLER_TRX.PROGRAM_NAME%TYPE := OKL_API.G_MISS_CHAR ,
14: PROG_SHORT_NAME OKL_BOOK_CONTROLLER_TRX.PROG_SHORT_NAME%TYPE := OKL_API.G_MISS_CHAR ,
15: CONC_REQ_ID NUMBER := OKL_API.G_MISS_NUM ,
16: PROGRESS_STATUS OKL_BOOK_CONTROLLER_TRX.PROGRESS_STATUS%TYPE := OKL_API.G_MISS_CHAR ,

Line 13: PROGRAM_NAME OKL_BOOK_CONTROLLER_TRX.PROGRAM_NAME%TYPE := OKL_API.G_MISS_CHAR ,

9: ORG_ID NUMBER := OKL_API.G_MISS_NUM ,
10: BATCH_NUMBER NUMBER := OKL_API.G_MISS_NUM ,
11: PROCESSING_SRL_NUMBER NUMBER := OKL_API.G_MISS_NUM ,
12: KHR_ID NUMBER := OKL_API.G_MISS_NUM ,
13: PROGRAM_NAME OKL_BOOK_CONTROLLER_TRX.PROGRAM_NAME%TYPE := OKL_API.G_MISS_CHAR ,
14: PROG_SHORT_NAME OKL_BOOK_CONTROLLER_TRX.PROG_SHORT_NAME%TYPE := OKL_API.G_MISS_CHAR ,
15: CONC_REQ_ID NUMBER := OKL_API.G_MISS_NUM ,
16: PROGRESS_STATUS OKL_BOOK_CONTROLLER_TRX.PROGRESS_STATUS%TYPE := OKL_API.G_MISS_CHAR ,
17: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,

Line 14: PROG_SHORT_NAME OKL_BOOK_CONTROLLER_TRX.PROG_SHORT_NAME%TYPE := OKL_API.G_MISS_CHAR ,

10: BATCH_NUMBER NUMBER := OKL_API.G_MISS_NUM ,
11: PROCESSING_SRL_NUMBER NUMBER := OKL_API.G_MISS_NUM ,
12: KHR_ID NUMBER := OKL_API.G_MISS_NUM ,
13: PROGRAM_NAME OKL_BOOK_CONTROLLER_TRX.PROGRAM_NAME%TYPE := OKL_API.G_MISS_CHAR ,
14: PROG_SHORT_NAME OKL_BOOK_CONTROLLER_TRX.PROG_SHORT_NAME%TYPE := OKL_API.G_MISS_CHAR ,
15: CONC_REQ_ID NUMBER := OKL_API.G_MISS_NUM ,
16: PROGRESS_STATUS OKL_BOOK_CONTROLLER_TRX.PROGRESS_STATUS%TYPE := OKL_API.G_MISS_CHAR ,
17: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,
18: CREATION_DATE OKL_BOOK_CONTROLLER_TRX.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,

Line 15: CONC_REQ_ID NUMBER := OKL_API.G_MISS_NUM ,

11: PROCESSING_SRL_NUMBER NUMBER := OKL_API.G_MISS_NUM ,
12: KHR_ID NUMBER := OKL_API.G_MISS_NUM ,
13: PROGRAM_NAME OKL_BOOK_CONTROLLER_TRX.PROGRAM_NAME%TYPE := OKL_API.G_MISS_CHAR ,
14: PROG_SHORT_NAME OKL_BOOK_CONTROLLER_TRX.PROG_SHORT_NAME%TYPE := OKL_API.G_MISS_CHAR ,
15: CONC_REQ_ID NUMBER := OKL_API.G_MISS_NUM ,
16: PROGRESS_STATUS OKL_BOOK_CONTROLLER_TRX.PROGRESS_STATUS%TYPE := OKL_API.G_MISS_CHAR ,
17: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,
18: CREATION_DATE OKL_BOOK_CONTROLLER_TRX.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,
19: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,

Line 16: PROGRESS_STATUS OKL_BOOK_CONTROLLER_TRX.PROGRESS_STATUS%TYPE := OKL_API.G_MISS_CHAR ,

12: KHR_ID NUMBER := OKL_API.G_MISS_NUM ,
13: PROGRAM_NAME OKL_BOOK_CONTROLLER_TRX.PROGRAM_NAME%TYPE := OKL_API.G_MISS_CHAR ,
14: PROG_SHORT_NAME OKL_BOOK_CONTROLLER_TRX.PROG_SHORT_NAME%TYPE := OKL_API.G_MISS_CHAR ,
15: CONC_REQ_ID NUMBER := OKL_API.G_MISS_NUM ,
16: PROGRESS_STATUS OKL_BOOK_CONTROLLER_TRX.PROGRESS_STATUS%TYPE := OKL_API.G_MISS_CHAR ,
17: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,
18: CREATION_DATE OKL_BOOK_CONTROLLER_TRX.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,
19: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,
20: LAST_UPDATE_DATE OKL_BOOK_CONTROLLER_TRX.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE ,

Line 17: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,

13: PROGRAM_NAME OKL_BOOK_CONTROLLER_TRX.PROGRAM_NAME%TYPE := OKL_API.G_MISS_CHAR ,
14: PROG_SHORT_NAME OKL_BOOK_CONTROLLER_TRX.PROG_SHORT_NAME%TYPE := OKL_API.G_MISS_CHAR ,
15: CONC_REQ_ID NUMBER := OKL_API.G_MISS_NUM ,
16: PROGRESS_STATUS OKL_BOOK_CONTROLLER_TRX.PROGRESS_STATUS%TYPE := OKL_API.G_MISS_CHAR ,
17: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,
18: CREATION_DATE OKL_BOOK_CONTROLLER_TRX.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,
19: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,
20: LAST_UPDATE_DATE OKL_BOOK_CONTROLLER_TRX.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE ,
21: LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM ,

Line 18: CREATION_DATE OKL_BOOK_CONTROLLER_TRX.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,

14: PROG_SHORT_NAME OKL_BOOK_CONTROLLER_TRX.PROG_SHORT_NAME%TYPE := OKL_API.G_MISS_CHAR ,
15: CONC_REQ_ID NUMBER := OKL_API.G_MISS_NUM ,
16: PROGRESS_STATUS OKL_BOOK_CONTROLLER_TRX.PROGRESS_STATUS%TYPE := OKL_API.G_MISS_CHAR ,
17: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,
18: CREATION_DATE OKL_BOOK_CONTROLLER_TRX.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,
19: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,
20: LAST_UPDATE_DATE OKL_BOOK_CONTROLLER_TRX.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE ,
21: LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM ,
22: ACTIVE_FLAG OKL_BOOK_CONTROLLER_TRX.ACTIVE_FLAG%TYPE := OKL_API.G_MISS_CHAR );

Line 19: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,

15: CONC_REQ_ID NUMBER := OKL_API.G_MISS_NUM ,
16: PROGRESS_STATUS OKL_BOOK_CONTROLLER_TRX.PROGRESS_STATUS%TYPE := OKL_API.G_MISS_CHAR ,
17: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,
18: CREATION_DATE OKL_BOOK_CONTROLLER_TRX.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,
19: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,
20: LAST_UPDATE_DATE OKL_BOOK_CONTROLLER_TRX.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE ,
21: LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM ,
22: ACTIVE_FLAG OKL_BOOK_CONTROLLER_TRX.ACTIVE_FLAG%TYPE := OKL_API.G_MISS_CHAR );
23:

Line 20: LAST_UPDATE_DATE OKL_BOOK_CONTROLLER_TRX.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE ,

16: PROGRESS_STATUS OKL_BOOK_CONTROLLER_TRX.PROGRESS_STATUS%TYPE := OKL_API.G_MISS_CHAR ,
17: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,
18: CREATION_DATE OKL_BOOK_CONTROLLER_TRX.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,
19: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,
20: LAST_UPDATE_DATE OKL_BOOK_CONTROLLER_TRX.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE ,
21: LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM ,
22: ACTIVE_FLAG OKL_BOOK_CONTROLLER_TRX.ACTIVE_FLAG%TYPE := OKL_API.G_MISS_CHAR );
23:
24: TYPE okl_bct_tbl IS TABLE OF okl_bct_rec

Line 21: LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM ,

17: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,
18: CREATION_DATE OKL_BOOK_CONTROLLER_TRX.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,
19: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,
20: LAST_UPDATE_DATE OKL_BOOK_CONTROLLER_TRX.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE ,
21: LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM ,
22: ACTIVE_FLAG OKL_BOOK_CONTROLLER_TRX.ACTIVE_FLAG%TYPE := OKL_API.G_MISS_CHAR );
23:
24: TYPE okl_bct_tbl IS TABLE OF okl_bct_rec
25: INDEX BY BINARY_INTEGER;

Line 22: ACTIVE_FLAG OKL_BOOK_CONTROLLER_TRX.ACTIVE_FLAG%TYPE := OKL_API.G_MISS_CHAR );

18: CREATION_DATE OKL_BOOK_CONTROLLER_TRX.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,
19: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,
20: LAST_UPDATE_DATE OKL_BOOK_CONTROLLER_TRX.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE ,
21: LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM ,
22: ACTIVE_FLAG OKL_BOOK_CONTROLLER_TRX.ACTIVE_FLAG%TYPE := OKL_API.G_MISS_CHAR );
23:
24: TYPE okl_bct_tbl IS TABLE OF okl_bct_rec
25: INDEX BY BINARY_INTEGER;
26:

Line 30: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;

26:
27: --------------------------------------------------------------------------------
28: -- GLOBAL MESSAGE CONSTANTS
29: --------------------------------------------------------------------------------
30: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
31: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
32: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

Line 31: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;

27: --------------------------------------------------------------------------------
28: -- GLOBAL MESSAGE CONSTANTS
29: --------------------------------------------------------------------------------
30: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
31: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
32: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

Line 32: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;

28: -- GLOBAL MESSAGE CONSTANTS
29: --------------------------------------------------------------------------------
30: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
31: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
32: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
36: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

Line 33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;

29: --------------------------------------------------------------------------------
30: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
31: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
32: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
36: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
37: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

Line 34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

30: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
31: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
32: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
36: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
37: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
38: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

Line 35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

31: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
32: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
36: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
37: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
38: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
39: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

Line 36: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

32: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
36: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
37: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
38: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
39: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
40: --------------------------------------------------------------------------------

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

33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
36: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
37: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
38: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
39: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
40: --------------------------------------------------------------------------------
41: -- GLOBAL VARIABLES

Line 38: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
36: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
37: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
38: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
39: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
40: --------------------------------------------------------------------------------
41: -- GLOBAL VARIABLES
42: --------------------------------------------------------------------------------

Line 39: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
36: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
37: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
38: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
39: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
40: --------------------------------------------------------------------------------
41: -- GLOBAL VARIABLES
42: --------------------------------------------------------------------------------
43: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_BCT_PVT';

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

40: --------------------------------------------------------------------------------
41: -- GLOBAL VARIABLES
42: --------------------------------------------------------------------------------
43: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_BCT_PVT';
44: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
45:
46: --------------------------------------------------------------------------------
47: -- Procedures and Functions
48: --------------------------------------------------------------------------------

Line 66: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

62: -- History : XX-XXX-XXXX TAPI Generator Created
63: -- End of comments
64: PROCEDURE insert_row(
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_bct_rec IN okl_bct_rec,

Line 88: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

84: -- History : XX-XXX-XXXX TAPI Generator Created
85: -- End of comments
86: PROCEDURE insert_row(
87: p_api_version IN NUMBER ,
88: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2,
92: p_bct_tbl IN okl_bct_tbl,

Line 109: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

105: -- History : XX-XXX-XXXX TAPI Generator Created
106: -- End of comments
107: PROCEDURE update_row(
108: p_api_version IN NUMBER ,
109: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
113: p_bct_rec IN okl_bct_rec,

Line 131: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

127: -- History : XX-XXX-XXXX TAPI Generator Created
128: -- End of comments
129: PROCEDURE update_row(
130: p_api_version IN NUMBER ,
131: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_bct_tbl IN okl_bct_tbl,

Line 152: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

148: -- History : XX-XXX-XXXX TAPI Generator Created
149: -- End of comments
150: PROCEDURE delete_row(
151: p_api_version IN NUMBER ,
152: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_bct_rec IN okl_bct_rec);

Line 173: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

169: -- History : XX-XXX-XXXX TAPI Generator Created
170: -- End of comments
171: PROCEDURE delete_row(
172: p_api_version IN NUMBER ,
173: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_bct_tbl IN okl_bct_tbl);