DBA Data[Home] [Help]

APPS.OKL_RCS_PVT dependencies on OKL_API

Line 41: RESI_CATEGORY_SET_ID NUMBER := OKL_API.G_MISS_NUM ,

37:
38: TYPE okl_rcsb_tbl IS TABLE OF okl_rcsb_rec
39: INDEX BY BINARY_INTEGER;
40: TYPE okl_rcstl_rec IS RECORD (
41: RESI_CATEGORY_SET_ID NUMBER := OKL_API.G_MISS_NUM ,
42: LANGUAGE OKL_FE_RESI_CAT_ALL_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR ,
43: SOURCE_LANG OKL_FE_RESI_CAT_ALL_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR ,
44: SFWT_FLAG OKL_FE_RESI_CAT_ALL_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR ,
45: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,

Line 42: LANGUAGE OKL_FE_RESI_CAT_ALL_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR ,

38: TYPE okl_rcsb_tbl IS TABLE OF okl_rcsb_rec
39: INDEX BY BINARY_INTEGER;
40: TYPE okl_rcstl_rec IS RECORD (
41: RESI_CATEGORY_SET_ID NUMBER := OKL_API.G_MISS_NUM ,
42: LANGUAGE OKL_FE_RESI_CAT_ALL_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR ,
43: SOURCE_LANG OKL_FE_RESI_CAT_ALL_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR ,
44: SFWT_FLAG OKL_FE_RESI_CAT_ALL_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR ,
45: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,
46: CREATION_DATE OKL_FE_RESI_CAT_ALL_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,

Line 43: SOURCE_LANG OKL_FE_RESI_CAT_ALL_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR ,

39: INDEX BY BINARY_INTEGER;
40: TYPE okl_rcstl_rec IS RECORD (
41: RESI_CATEGORY_SET_ID NUMBER := OKL_API.G_MISS_NUM ,
42: LANGUAGE OKL_FE_RESI_CAT_ALL_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR ,
43: SOURCE_LANG OKL_FE_RESI_CAT_ALL_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR ,
44: SFWT_FLAG OKL_FE_RESI_CAT_ALL_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR ,
45: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,
46: CREATION_DATE OKL_FE_RESI_CAT_ALL_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,
47: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,

Line 44: SFWT_FLAG OKL_FE_RESI_CAT_ALL_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR ,

40: TYPE okl_rcstl_rec IS RECORD (
41: RESI_CATEGORY_SET_ID NUMBER := OKL_API.G_MISS_NUM ,
42: LANGUAGE OKL_FE_RESI_CAT_ALL_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR ,
43: SOURCE_LANG OKL_FE_RESI_CAT_ALL_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR ,
44: SFWT_FLAG OKL_FE_RESI_CAT_ALL_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR ,
45: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,
46: CREATION_DATE OKL_FE_RESI_CAT_ALL_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,
47: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,
48: LAST_UPDATE_DATE OKL_FE_RESI_CAT_ALL_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE ,

Line 45: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,

41: RESI_CATEGORY_SET_ID NUMBER := OKL_API.G_MISS_NUM ,
42: LANGUAGE OKL_FE_RESI_CAT_ALL_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR ,
43: SOURCE_LANG OKL_FE_RESI_CAT_ALL_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR ,
44: SFWT_FLAG OKL_FE_RESI_CAT_ALL_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR ,
45: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,
46: CREATION_DATE OKL_FE_RESI_CAT_ALL_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,
47: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,
48: LAST_UPDATE_DATE OKL_FE_RESI_CAT_ALL_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE ,
49: LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM ,

Line 46: CREATION_DATE OKL_FE_RESI_CAT_ALL_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,

42: LANGUAGE OKL_FE_RESI_CAT_ALL_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR ,
43: SOURCE_LANG OKL_FE_RESI_CAT_ALL_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR ,
44: SFWT_FLAG OKL_FE_RESI_CAT_ALL_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR ,
45: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,
46: CREATION_DATE OKL_FE_RESI_CAT_ALL_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,
47: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,
48: LAST_UPDATE_DATE OKL_FE_RESI_CAT_ALL_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE ,
49: LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM ,
50: RESI_CAT_DESC OKL_FE_RESI_CAT_ALL_TL.RESI_CAT_DESC%TYPE := OKL_API.G_MISS_CHAR );

Line 47: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,

43: SOURCE_LANG OKL_FE_RESI_CAT_ALL_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR ,
44: SFWT_FLAG OKL_FE_RESI_CAT_ALL_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR ,
45: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,
46: CREATION_DATE OKL_FE_RESI_CAT_ALL_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,
47: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,
48: LAST_UPDATE_DATE OKL_FE_RESI_CAT_ALL_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE ,
49: LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM ,
50: RESI_CAT_DESC OKL_FE_RESI_CAT_ALL_TL.RESI_CAT_DESC%TYPE := OKL_API.G_MISS_CHAR );
51:

Line 48: LAST_UPDATE_DATE OKL_FE_RESI_CAT_ALL_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE ,

44: SFWT_FLAG OKL_FE_RESI_CAT_ALL_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR ,
45: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,
46: CREATION_DATE OKL_FE_RESI_CAT_ALL_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,
47: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,
48: LAST_UPDATE_DATE OKL_FE_RESI_CAT_ALL_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE ,
49: LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM ,
50: RESI_CAT_DESC OKL_FE_RESI_CAT_ALL_TL.RESI_CAT_DESC%TYPE := OKL_API.G_MISS_CHAR );
51:
52: TYPE okl_rcstl_tbl IS TABLE OF okl_rcstl_rec

Line 49: LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM ,

45: CREATED_BY NUMBER := OKL_API.G_MISS_NUM ,
46: CREATION_DATE OKL_FE_RESI_CAT_ALL_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,
47: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,
48: LAST_UPDATE_DATE OKL_FE_RESI_CAT_ALL_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE ,
49: LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM ,
50: RESI_CAT_DESC OKL_FE_RESI_CAT_ALL_TL.RESI_CAT_DESC%TYPE := OKL_API.G_MISS_CHAR );
51:
52: TYPE okl_rcstl_tbl IS TABLE OF okl_rcstl_rec
53: INDEX BY BINARY_INTEGER;

Line 50: RESI_CAT_DESC OKL_FE_RESI_CAT_ALL_TL.RESI_CAT_DESC%TYPE := OKL_API.G_MISS_CHAR );

46: CREATION_DATE OKL_FE_RESI_CAT_ALL_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE ,
47: LAST_UPDATED_BY NUMBER := OKL_API.G_MISS_NUM ,
48: LAST_UPDATE_DATE OKL_FE_RESI_CAT_ALL_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE ,
49: LAST_UPDATE_LOGIN NUMBER := OKL_API.G_MISS_NUM ,
50: RESI_CAT_DESC OKL_FE_RESI_CAT_ALL_TL.RESI_CAT_DESC%TYPE := OKL_API.G_MISS_CHAR );
51:
52: TYPE okl_rcstl_tbl IS TABLE OF okl_rcstl_rec
53: INDEX BY BINARY_INTEGER;
54:

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

54:
55: --------------------------------------------------------------------------------
56: -- GLOBAL MESSAGE CONSTANTS
57: --------------------------------------------------------------------------------
58: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
59: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
60: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
61: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
62: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

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

55: --------------------------------------------------------------------------------
56: -- GLOBAL MESSAGE CONSTANTS
57: --------------------------------------------------------------------------------
58: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
59: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
60: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
61: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
62: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
63: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

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

56: -- GLOBAL MESSAGE CONSTANTS
57: --------------------------------------------------------------------------------
58: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
59: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
60: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
61: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
62: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
63: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
64: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

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

57: --------------------------------------------------------------------------------
58: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
59: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
60: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
61: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
62: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
63: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
64: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
65: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

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

58: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
59: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
60: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
61: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
62: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
63: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
64: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
65: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
66: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

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

59: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
60: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
61: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
62: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
63: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
64: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
65: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
66: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
67: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

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

60: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
61: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
62: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
63: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
64: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
65: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
66: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
67: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
68: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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

61: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
62: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
63: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
64: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
65: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
66: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
67: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
68: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
69: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

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

62: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
63: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
64: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
65: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
66: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
67: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
68: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
69: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
70: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

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

63: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
64: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
65: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
66: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
67: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
68: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
69: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
70: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
71: G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';

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

76: --------------------------------------------------------------------------------
77: -- GLOBAL CONSTANTS
78: --------------------------------------------------------------------------------
79: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RCS_PVT';
80: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
81: G_CAT_ITEM CONSTANT VARCHAR2(30) := 'ITEM';
82: G_CAT_ITEM_CAT CONSTANT VARCHAR2(30) := 'ITEMCAT';
83: G_STS_ACTIVE CONSTANT VARCHAR2(30) := 'ACTIVE';
84: G_STS_INACTIVE CONSTANT VARCHAR2(30) := 'INACTIVE';

Line 96: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

92: PROCEDURE add_language;
93:
94: PROCEDURE insert_row(
95: p_api_version IN NUMBER ,
96: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,
100: p_rcsv_rec IN okl_rcsv_rec,

Line 104: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

100: p_rcsv_rec IN okl_rcsv_rec,
101: x_rcsv_rec OUT NOCOPY okl_rcsv_rec);
102: PROCEDURE insert_row(
103: p_api_version IN NUMBER ,
104: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
108: p_rcsv_tbl IN okl_rcsv_tbl,

Line 112: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

108: p_rcsv_tbl IN okl_rcsv_tbl,
109: x_rcsv_tbl OUT NOCOPY okl_rcsv_tbl);
110: PROCEDURE update_row(
111: p_api_version IN NUMBER ,
112: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_rcsv_rec IN okl_rcsv_rec,

Line 120: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

116: p_rcsv_rec IN okl_rcsv_rec,
117: x_rcsv_rec OUT NOCOPY okl_rcsv_rec);
118: PROCEDURE update_row(
119: p_api_version IN NUMBER ,
120: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,
124: p_rcsv_tbl IN okl_rcsv_tbl,

Line 128: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

124: p_rcsv_tbl IN okl_rcsv_tbl,
125: x_rcsv_tbl OUT NOCOPY okl_rcsv_tbl);
126: PROCEDURE delete_row(
127: p_api_version IN NUMBER ,
128: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
132: p_rcsv_rec IN okl_rcsv_rec);

Line 135: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

131: x_msg_data OUT NOCOPY VARCHAR2,
132: p_rcsv_rec IN okl_rcsv_rec);
133: PROCEDURE delete_row(
134: p_api_version IN NUMBER ,
135: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_rcsv_tbl IN okl_rcsv_tbl);