APPS.OKL_INTEREST_IMP_PVT dependencies on OKL_INDICES

Line 34: l_name OKL_INDICES.name%TYPE;

30: l_msg_count NUMBER;
31: l_msg_data VARCHAR2(2000);
32:
33: i NUMBER := 0;
34: l_name OKL_INDICES.name%TYPE;
35: l_idx OKL_INDICES.id%TYPE;
36: l_error_flag VARCHAR2(1);
37:
38:

Line 35: l_idx OKL_INDICES.id%TYPE;

31: l_msg_data VARCHAR2(2000);
32:
33: i NUMBER := 0;
34: l_name OKL_INDICES.name%TYPE;
35: l_idx OKL_INDICES.id%TYPE;
36: l_error_flag VARCHAR2(1);
37:
38:
39: CURSOR interface_csr IS

Line 54: CURSOR idx_csr(v_name okl_indices_v.name%TYPE,

50: ORDER BY idi_type, datetime_valid
51: FOR UPDATE;
52:
53:
54: CURSOR idx_csr(v_name okl_indices_v.name%TYPE,
55: v_idx_type OKL_INDICES_V.idx_type%TYPE) IS
56: SELECT name,
57: id
58: FROM okl_indices_v

Line 55: v_idx_type OKL_INDICES_V.idx_type%TYPE) IS

51: FOR UPDATE;
52:
53:
54: CURSOR idx_csr(v_name okl_indices_v.name%TYPE,
55: v_idx_type OKL_INDICES_V.idx_type%TYPE) IS
56: SELECT name,
57: id
58: FROM okl_indices_v
59: WHERE name = v_name

Line 58: FROM okl_indices_v

54: CURSOR idx_csr(v_name okl_indices_v.name%TYPE,
55: v_idx_type OKL_INDICES_V.idx_type%TYPE) IS
56: SELECT name,
57: id
58: FROM okl_indices_v
59: WHERE name = v_name
60: AND idx_type = v_idx_type;
61:
62:

Line 147: OKL_INDICES_PUB.create_indices(p_api_version => 1.0,

143: FETCH idx_csr INTO l_name, l_idx;
144: IF idx_csr%NOTFOUND THEN
145:
146:
147: OKL_INDICES_PUB.create_indices(p_api_version => 1.0,
148: p_init_msg_list => l_init_msg_list,
149: x_return_status => l_return_status,
150: x_msg_count => l_msg_count,
151: x_msg_data => l_msg_data,

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

169:
170: CLOSE idx_csr;
171:
172:
173: OKL_INDICES_PUB.create_index_values(p_api_version => 1.0,
174: p_init_msg_list => l_init_msg_list,
175: x_return_status => l_return_status,
176: x_msg_count => l_msg_count,
177: x_msg_data => l_msg_data,