eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_INDICES_PVT dependencies on OKC_API

Line 12: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

8: SUBTYPE ivev_tbl_type IS okl_ive_pvt.ivev_tbl_type;
9: ------------------------------------------------------------------------------
10: -- Global Variables
11: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_INDICES_PVT';
12: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
16: ------------------------------------------------------------------------------

Line 25: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

21:
22: --Object type procedure for insert
23: PROCEDURE create_indices(
24: p_api_version IN NUMBER
25: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
26: ,x_return_status OUT NOCOPY VARCHAR2
27: ,x_msg_count OUT NOCOPY NUMBER
28: ,x_msg_data OUT NOCOPY VARCHAR2
29: ,p_idxv_rec IN idxv_rec_type

Line 38: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

34:
35: --Object type procedure for update
36: PROCEDURE update_indices(
37: p_api_version IN NUMBER
38: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
39: ,x_return_status OUT NOCOPY VARCHAR2
40: ,x_msg_count OUT NOCOPY NUMBER
41: ,x_msg_data OUT NOCOPY VARCHAR2
42: ,p_idxv_rec IN idxv_rec_type

Line 51: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

47:
48: --Object type procedure for validate
49: PROCEDURE validate_indices(
50: p_api_version IN NUMBER
51: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
52: ,x_return_status OUT NOCOPY VARCHAR2
53: ,x_msg_count OUT NOCOPY NUMBER
54: ,x_msg_data OUT NOCOPY VARCHAR2
55: ,p_idxv_rec IN idxv_rec_type

Line 61: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

57: );
58:
59: PROCEDURE create_indices(
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2,
65: p_idxv_tbl IN idxv_tbl_type,

Line 70: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

66: x_idxv_tbl OUT NOCOPY idxv_tbl_type);
67:
68: PROCEDURE create_indices(
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
74: p_idxv_rec IN idxv_rec_type,

Line 79: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

75: x_idxv_rec OUT NOCOPY idxv_rec_type);
76:
77: PROCEDURE lock_indices(
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2,
83: p_idxv_tbl IN idxv_tbl_type);

Line 87: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

83: p_idxv_tbl IN idxv_tbl_type);
84:
85: PROCEDURE lock_indices(
86: p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
90: x_msg_data OUT NOCOPY VARCHAR2,
91: p_idxv_rec IN idxv_rec_type);

Line 95: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

91: p_idxv_rec IN idxv_rec_type);
92:
93: PROCEDURE update_indices(
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,
98: x_msg_data OUT NOCOPY VARCHAR2,
99: p_idxv_tbl IN idxv_tbl_type,

Line 104: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

100: x_idxv_tbl OUT NOCOPY idxv_tbl_type);
101:
102: PROCEDURE update_indices(
103: p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_idxv_rec IN idxv_rec_type,

Line 113: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

109: x_idxv_rec OUT NOCOPY idxv_rec_type);
110:
111: PROCEDURE delete_indices(
112: p_api_version IN NUMBER,
113: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
114: x_return_status OUT NOCOPY VARCHAR2,
115: x_msg_count OUT NOCOPY NUMBER,
116: x_msg_data OUT NOCOPY VARCHAR2,
117: p_idxv_tbl IN idxv_tbl_type);

Line 121: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

117: p_idxv_tbl IN idxv_tbl_type);
118:
119: PROCEDURE delete_indices(
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: p_idxv_rec IN idxv_rec_type);

Line 129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

125: p_idxv_rec IN idxv_rec_type);
126:
127: PROCEDURE validate_indices(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_idxv_tbl IN idxv_tbl_type);

Line 137: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

133: p_idxv_tbl IN idxv_tbl_type);
134:
135: PROCEDURE validate_indices(
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
138: x_return_status OUT NOCOPY VARCHAR2,
139: x_msg_count OUT NOCOPY NUMBER,
140: x_msg_data OUT NOCOPY VARCHAR2,
141: p_idxv_rec IN idxv_rec_type);

Line 146: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

142:
143:
144: PROCEDURE create_index_values(
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: p_ivev_tbl IN ivev_tbl_type,

Line 155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

151: x_ivev_tbl OUT NOCOPY ivev_tbl_type);
152:
153: PROCEDURE create_index_values(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_ivev_rec IN ivev_rec_type,

Line 164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

160: x_ivev_rec OUT NOCOPY ivev_rec_type);
161:
162: PROCEDURE lock_index_values(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_ivev_tbl IN ivev_tbl_type);

Line 172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

168: p_ivev_tbl IN ivev_tbl_type);
169:
170: PROCEDURE lock_index_values(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_ivev_rec IN ivev_rec_type);

Line 180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

176: p_ivev_rec IN ivev_rec_type);
177:
178: PROCEDURE update_index_values(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ivev_tbl IN ivev_tbl_type,

Line 189: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

185: x_ivev_tbl OUT NOCOPY ivev_tbl_type);
186:
187: PROCEDURE update_index_values(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_ivev_rec IN ivev_rec_type,

Line 198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

194: x_ivev_rec OUT NOCOPY ivev_rec_type);
195:
196: PROCEDURE delete_index_values(
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_ivev_tbl IN ivev_tbl_type);

Line 206: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

202: p_ivev_tbl IN ivev_tbl_type);
203:
204: PROCEDURE delete_index_values(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
207: x_return_status OUT NOCOPY VARCHAR2,
208: x_msg_count OUT NOCOPY NUMBER,
209: x_msg_data OUT NOCOPY VARCHAR2,
210: p_ivev_rec IN ivev_rec_type);

Line 214: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

210: p_ivev_rec IN ivev_rec_type);
211:
212: PROCEDURE validate_index_values(
213: p_api_version IN NUMBER,
214: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_ivev_tbl IN ivev_tbl_type);

Line 222: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

218: p_ivev_tbl IN ivev_tbl_type);
219:
220: PROCEDURE validate_index_values(
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,
225: x_msg_data OUT NOCOPY VARCHAR2,
226: p_ivev_rec IN ivev_rec_type);