APPS.OKL_INTEREST_MAINT_PVT dependencies on OKL_INDICES

Line 36: FROM OKL_INDICES_V idx, OKL_INDEX_VALUES_V idxv

32:
33:
34: l_stmt_org := ' SELECT datetime_valid,
35: datetime_invalid
36: FROM OKL_INDICES_V idx, OKL_INDEX_VALUES_V idxv
37: WHERE idx.id = idxv.idx_id
38: AND idx.name = ' || '''' || ':1' || '''' ||
39: ' AND idx.idx_type = ' || '''' || ':2' || '''' ;
40:

Line 177: FROM OKL_INDICES_V idx, OKL_INDEX_VALUES_V idxv

173:
174:
175: l_stmt_org := ' SELECT datetime_valid,
176: datetime_invalid
177: FROM OKL_INDICES_V idx, OKL_INDEX_VALUES_V idxv
178: WHERE idx.id = idxv.idx_id
179: AND idx.id = ' || ':1' ;
180:
181:

Line 299: l_idx_frequency OKL_INDICES.IDX_FREQUENCY%TYPE;

295: l_msg_count NUMBER;
296: l_msg_data VARCHAR2(2000);
297: l_api_name VARCHAR2(30) := 'INT_HDR_INS_UPDT';
298: l_api_version NUMBER := 1.0;
299: l_idx_frequency OKL_INDICES.IDX_FREQUENCY%TYPE;
300:
301: CURSOR freq_csr(v_idx_id NUMBER) IS
302: SELECT idx_frequency
303: FROM OKL_INDICES idx,

Line 303: FROM OKL_INDICES idx,

299: l_idx_frequency OKL_INDICES.IDX_FREQUENCY%TYPE;
300:
301: CURSOR freq_csr(v_idx_id NUMBER) IS
302: SELECT idx_frequency
303: FROM OKL_INDICES idx,
304: OKL_INDEX_VALUES ive
305: WHERE ive.idx_id = idx.id
306: AND idx.ID = v_idx_id;
307:

Line 330: OKL_INDICES_PUB.CREATE_INDICES(p_api_version => 1.0,

326:
327: IF (p_idxv_rec.id = OKL_API.G_MISS_NUM) OR
328: (p_idxv_rec.ID IS NULL) THEN
329:
330: OKL_INDICES_PUB.CREATE_INDICES(p_api_version => 1.0,
331: p_init_msg_list => l_init_msg_list,
332: x_return_status => l_return_status,
333: x_msg_count => l_msg_count,
334: x_msg_data => l_msg_data,

Line 353: OKL_INDICES_PUB.UPDATE_INDICES(p_api_version => 1.0,

349: END IF;
350: END IF;
351: CLOSE freq_csr;
352:
353: OKL_INDICES_PUB.UPDATE_INDICES(p_api_version => 1.0,
354: p_init_msg_list => l_init_msg_list,
355: x_return_status => l_return_status,
356: x_msg_count => l_msg_count,
357: x_msg_data => l_msg_data,

Line 534: OKL_INDICES_PUB.create_index_values(p_api_version => 1.0,

530:
531: IF (l_ivev_rec_in.ID = OKL_API.G_MISS_NUM) OR
532: (l_ivev_rec_in.ID IS NULL) THEN
533:
534: OKL_INDICES_PUB.create_index_values(p_api_version => 1.0,
535: p_init_msg_list => l_init_msg_list,
536: x_return_status => l_return_status,
537: x_msg_count => l_msg_count,
538: x_msg_data => l_msg_data,

Line 543: OKL_INDICES_PUB.update_index_values(p_api_version => 1.0,

539: p_ivev_rec => l_ivev_rec_in,
540: x_ivev_rec => l_ivev_rec_out);
541: ELSE
542:
543: OKL_INDICES_PUB.update_index_values(p_api_version => 1.0,
544: p_init_msg_list => l_init_msg_list,
545: x_return_status => l_return_status,
546: x_msg_count => l_msg_count,
547: x_msg_data => l_msg_data,