DBA Data[Home] [Help]

APPS.OKL_XMP_PVT dependencies on OKL_API

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

37: INDEX BY BINARY_INTEGER;
38: ---------------------------------------------------------------------------
39: -- GLOBAL MESSAGE CONSTANTS
40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

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

38: ---------------------------------------------------------------------------
39: -- GLOBAL MESSAGE CONSTANTS
40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

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

39: -- GLOBAL MESSAGE CONSTANTS
40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

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

40: ---------------------------------------------------------------------------
41: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

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

41: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

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

42: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

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

43: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
51: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

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

44: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
51: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
52: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

45: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
51: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
52: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
53: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

46: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
47: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
48: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
49: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
51: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
52: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
53: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
54: G_RET_STS_ERROR CONSTANT VARCHAR2(200) := OKL_API.G_RET_STS_ERROR;

Line 54: G_RET_STS_ERROR CONSTANT VARCHAR2(200) := OKL_API.G_RET_STS_ERROR;

50: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
51: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
52: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
53: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
54: G_RET_STS_ERROR CONSTANT VARCHAR2(200) := OKL_API.G_RET_STS_ERROR;
55: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(200) := OKL_API.G_RET_STS_UNEXP_ERROR;
56: G_DB_ERROR CONSTANT VARCHAR2(30) := 'OKL_DB_ERROR';
57: G_COL_ERROR CONSTANT VARCHAR2(30) := 'OKL_COL_ERROR';
58: G_OVN_ERROR CONSTANT VARCHAR2(30) := 'OKL_OVN_ERROR';

Line 55: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(200) := OKL_API.G_RET_STS_UNEXP_ERROR;

51: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
52: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
53: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
54: G_RET_STS_ERROR CONSTANT VARCHAR2(200) := OKL_API.G_RET_STS_ERROR;
55: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(200) := OKL_API.G_RET_STS_UNEXP_ERROR;
56: G_DB_ERROR CONSTANT VARCHAR2(30) := 'OKL_DB_ERROR';
57: G_COL_ERROR CONSTANT VARCHAR2(30) := 'OKL_COL_ERROR';
58: G_OVN_ERROR CONSTANT VARCHAR2(30) := 'OKL_OVN_ERROR';
59: G_OVN_ERROR2 CONSTANT VARCHAR2(30) := 'OKL_OVN_ERROR2';

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

74: ---------------------------------------------------------------------------
75: -- GLOBAL VARIABLES
76: ---------------------------------------------------------------------------
77: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_XMP_PVT';
78: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
79: ---------------------------------------------------------------------------
80: -- Procedures and Functions
81: ---------------------------------------------------------------------------
82:

Line 88: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

84: PROCEDURE change_version;
85: PROCEDURE api_copy;
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_xmp_rec IN xmp_rec_type,

Line 96: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

92: p_xmp_rec IN xmp_rec_type,
93: x_xmp_rec OUT NOCOPY xmp_rec_type);
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_xmp_tbl IN xmp_tbl_type,

Line 104: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

100: p_xmp_tbl IN xmp_tbl_type,
101: x_xmp_tbl OUT NOCOPY xmp_tbl_type);
102: PROCEDURE lock_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_xmp_rec IN xmp_rec_type);

Line 111: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

107: x_msg_data OUT NOCOPY VARCHAR2,
108: p_xmp_rec IN xmp_rec_type);
109: PROCEDURE lock_row(
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_xmp_tbl IN xmp_tbl_type,

Line 116: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_xmp_tbl IN xmp_tbl_type,
116: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
117: PROCEDURE lock_row(
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
120: x_return_status OUT NOCOPY VARCHAR2,

Line 119: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

115: p_xmp_tbl IN xmp_tbl_type,
116: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
117: PROCEDURE lock_row(
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: p_xmp_tbl IN xmp_tbl_type);

Line 126: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

122: x_msg_data OUT NOCOPY VARCHAR2,
123: p_xmp_tbl IN xmp_tbl_type);
124: PROCEDURE update_row(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_xmp_rec IN xmp_rec_type,

Line 134: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

130: p_xmp_rec IN xmp_rec_type,
131: x_xmp_rec OUT NOCOPY xmp_rec_type);
132: PROCEDURE update_row(
133: p_api_version IN NUMBER,
134: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
135: x_return_status OUT NOCOPY VARCHAR2,
136: x_msg_count OUT NOCOPY NUMBER,
137: x_msg_data OUT NOCOPY VARCHAR2,
138: p_xmp_tbl IN xmp_tbl_type,

Line 140: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

136: x_msg_count OUT NOCOPY NUMBER,
137: x_msg_data OUT NOCOPY VARCHAR2,
138: p_xmp_tbl IN xmp_tbl_type,
139: x_xmp_tbl OUT NOCOPY xmp_tbl_type,
140: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
141: PROCEDURE update_row(
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
144: x_return_status OUT NOCOPY VARCHAR2,

Line 143: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

139: x_xmp_tbl OUT NOCOPY xmp_tbl_type,
140: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
141: PROCEDURE update_row(
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_xmp_tbl IN xmp_tbl_type,

Line 151: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

147: p_xmp_tbl IN xmp_tbl_type,
148: x_xmp_tbl OUT NOCOPY xmp_tbl_type);
149: PROCEDURE delete_row(
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_xmp_rec IN xmp_rec_type);

Line 158: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_xmp_rec IN xmp_rec_type);
156: PROCEDURE delete_row(
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_xmp_tbl IN xmp_tbl_type,

Line 163: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_xmp_tbl IN xmp_tbl_type,
163: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
164: PROCEDURE delete_row(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,

Line 166: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

162: p_xmp_tbl IN xmp_tbl_type,
163: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
164: PROCEDURE delete_row(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_xmp_tbl IN xmp_tbl_type);

Line 173: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_xmp_tbl IN xmp_tbl_type);
171: PROCEDURE validate_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_xmp_rec IN xmp_rec_type);

Line 180: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_xmp_rec IN xmp_rec_type);
178: PROCEDURE validate_row(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_xmp_tbl IN xmp_tbl_type,

Line 185: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_xmp_tbl IN xmp_tbl_type,
185: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
186: PROCEDURE validate_row(
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
189: x_return_status OUT NOCOPY VARCHAR2,

Line 188: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

184: p_xmp_tbl IN xmp_tbl_type,
185: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
186: PROCEDURE validate_row(
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_xmp_tbl IN xmp_tbl_type);