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.OKI_REFRESH_PVT dependencies on OKI_COV_PRD_LINES

Line 67: -- 3. Index created on new column is_exp_not_renewed_yn of oki_cov_prd_lines table.

63: -- So, indexes of these tables are removed
64: -- 2. Indexes on columns which are not populated in the table are removed.
65: -- Index on salesrep_name of oki_k_salesrep and
66: -- customer_name of oki_sales_k_hdrs are removed.
67: -- 3. Index created on new column is_exp_not_renewed_yn of oki_cov_prd_lines table.
68: PROCEDURE create_indicies (p_object_name IN VARCHAR2
69: ,p_parm_rec IN index_info_csr%ROWTYPE) IS
70:
71: l_contract_number VARCHAR2(1000);

Line 240: ELSIF p_object_name = 'OKI_COV_PRD_LINES' THEN

236: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
237: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
238: EXECUTE IMMEDIATE l_sql_string;
239: 11510 Changes End */
240: ELSIF p_object_name = 'OKI_COV_PRD_LINES' THEN
241: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N1 ON';
242: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(CHR_ID)'||' PARALLEL ';
243: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
244: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;

Line 241: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N1 ON';

237: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
238: EXECUTE IMMEDIATE l_sql_string;
239: 11510 Changes End */
240: ELSIF p_object_name = 'OKI_COV_PRD_LINES' THEN
241: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N1 ON';
242: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(CHR_ID)'||' PARALLEL ';
243: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
244: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
245: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 242: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(CHR_ID)'||' PARALLEL ';

238: EXECUTE IMMEDIATE l_sql_string;
239: 11510 Changes End */
240: ELSIF p_object_name = 'OKI_COV_PRD_LINES' THEN
241: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N1 ON';
242: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(CHR_ID)'||' PARALLEL ';
243: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
244: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
245: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
246: EXECUTE IMMEDIATE l_sql_string;

Line 247: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N2 ON';

243: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
244: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
245: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
246: EXECUTE IMMEDIATE l_sql_string;
247: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N2 ON';
248: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(CONTRACT_NUMBER)'||' PARALLEL ';
249: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
250: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
251: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 248: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(CONTRACT_NUMBER)'||' PARALLEL ';

244: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
245: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
246: EXECUTE IMMEDIATE l_sql_string;
247: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N2 ON';
248: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(CONTRACT_NUMBER)'||' PARALLEL ';
249: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
250: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
251: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
252: EXECUTE IMMEDIATE l_sql_string;

Line 253: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N3 ON';

249: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
250: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
251: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
252: EXECUTE IMMEDIATE l_sql_string;
253: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N3 ON';
254: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(COVERED_PRODUCT_ID)'||' PARALLEL ';
255: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
256: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
257: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 254: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(COVERED_PRODUCT_ID)'||' PARALLEL ';

250: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
251: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
252: EXECUTE IMMEDIATE l_sql_string;
253: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N3 ON';
254: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(COVERED_PRODUCT_ID)'||' PARALLEL ';
255: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
256: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
257: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
258: EXECUTE IMMEDIATE l_sql_string;

Line 259: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N4 ON';

255: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
256: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
257: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
258: EXECUTE IMMEDIATE l_sql_string;
259: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N4 ON';
260: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(PARENT_CLE_ID)'||' PARALLEL ';
261: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
262: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
263: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 260: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(PARENT_CLE_ID)'||' PARALLEL ';

256: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
257: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
258: EXECUTE IMMEDIATE l_sql_string;
259: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N4 ON';
260: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(PARENT_CLE_ID)'||' PARALLEL ';
261: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
262: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
263: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
264: EXECUTE IMMEDIATE l_sql_string;

Line 265: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N5 ON';

261: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
262: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
263: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
264: EXECUTE IMMEDIATE l_sql_string;
265: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N5 ON';
266: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(START_DATE)'
267: ||' PARALLEL ';
268: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
269: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;

Line 266: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(START_DATE)'

262: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
263: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
264: EXECUTE IMMEDIATE l_sql_string;
265: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N5 ON';
266: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(START_DATE)'
267: ||' PARALLEL ';
268: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
269: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
270: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 272: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N6 ON';

268: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
269: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
270: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
271: EXECUTE IMMEDIATE l_sql_string;
272: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N6 ON';
273: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(COMPLETE_CONTRACT_NUMBER)'
274: ||' PARALLEL ';
275: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
276: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;

Line 273: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(COMPLETE_CONTRACT_NUMBER)'

269: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
270: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
271: EXECUTE IMMEDIATE l_sql_string;
272: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N6 ON';
273: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(COMPLETE_CONTRACT_NUMBER)'
274: ||' PARALLEL ';
275: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
276: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
277: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 279: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N7 ON';

275: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
276: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
277: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
278: EXECUTE IMMEDIATE l_sql_string;
279: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N7 ON';
280: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(system_name)'
281: ||' PARALLEL ';
282: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
283: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;

Line 280: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(system_name)'

276: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
277: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
278: EXECUTE IMMEDIATE l_sql_string;
279: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N7 ON';
280: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(system_name)'
281: ||' PARALLEL ';
282: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
283: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
284: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 286: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N8 ON';

282: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
283: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
284: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
285: EXECUTE IMMEDIATE l_sql_string;
286: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N8 ON';
287: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(end_date)'
288: ||' PARALLEL ';
289: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
290: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;

Line 287: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(end_date)'

283: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
284: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
285: EXECUTE IMMEDIATE l_sql_string;
286: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N8 ON';
287: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(end_date)'
288: ||' PARALLEL ';
289: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
290: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
291: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 294: Adding new index on oki_cov_prd_lines table. */

290: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
291: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
292: EXECUTE IMMEDIATE l_sql_string;
293: /* 11510 Changes Start
294: Adding new index on oki_cov_prd_lines table. */
295: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N9 ON';
296: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(IS_EXP_NOT_RENEWED_YN)'||' PARALLEL ';
297: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
298: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;

Line 295: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N9 ON';

291: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
292: EXECUTE IMMEDIATE l_sql_string;
293: /* 11510 Changes Start
294: Adding new index on oki_cov_prd_lines table. */
295: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N9 ON';
296: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(IS_EXP_NOT_RENEWED_YN)'||' PARALLEL ';
297: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
298: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
299: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 296: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(IS_EXP_NOT_RENEWED_YN)'||' PARALLEL ';

292: EXECUTE IMMEDIATE l_sql_string;
293: /* 11510 Changes Start
294: Adding new index on oki_cov_prd_lines table. */
295: l_sql_string := 'CREATE INDEX OKI.OKI_COV_PRD_LINES_N9 ON';
296: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(IS_EXP_NOT_RENEWED_YN)'||' PARALLEL ';
297: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
298: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
299: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
300: EXECUTE IMMEDIATE l_sql_string;

Line 303: l_sql_string := 'CREATE UNIQUE INDEX OKI.OKI_COV_PRD_LINES_U1 ON';

299: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
300: EXECUTE IMMEDIATE l_sql_string;
301: /* 11510 Changes End */
302:
303: l_sql_string := 'CREATE UNIQUE INDEX OKI.OKI_COV_PRD_LINES_U1 ON';
304: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(CLE_ID)'||' PARALLEL ';
305: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
306: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
307: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 304: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(CLE_ID)'||' PARALLEL ';

300: EXECUTE IMMEDIATE l_sql_string;
301: /* 11510 Changes End */
302:
303: l_sql_string := 'CREATE UNIQUE INDEX OKI.OKI_COV_PRD_LINES_U1 ON';
304: l_sql_string := l_sql_string||' OKI.OKI_COV_PRD_LINES(CLE_ID)'||' PARALLEL ';
305: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
306: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
307: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
308: EXECUTE IMMEDIATE l_sql_string;

Line 762: l_table_name := 'OKI_COV_PRD_LINES' ;

758: -- Truncate failed, exit immediately.
759: RAISE l_excp_exit_immediate ;
760: END IF ;
761:
762: l_table_name := 'OKI_COV_PRD_LINES' ;
763: l_loc := 'Calling truncate_table with ' || l_table_owner || '.' || l_table_name ;
764: truncate_table( p_table_owner => l_table_owner
765: , p_table_name => l_table_name
766: , x_errbuf => x_errbuf

Line 843: l_table_name := 'OKI_COV_PRD_LINES' ;

839: -- Truncate failed, exit immediately.
840: RAISE l_excp_exit_immediate ;
841: END IF ;
842:
843: l_table_name := 'OKI_COV_PRD_LINES' ;
844: l_loc := 'Updating OKI_REFRESHS for || l_table_name' ;
845: -- update oki_refreshes
846: update_oki_refresh( p_object_name => l_table_name
847: , p_job_run_id => l_job_run_id

Line 3916: OPEN index_info_csr('OKI_COV_PRD_LINES','OKI_COV_PRD_LINES_U1','OKI');

3912: BEGIN
3913: retcode := '0';
3914:
3915: -- get representative index storage parms for later use
3916: OPEN index_info_csr('OKI_COV_PRD_LINES','OKI_COV_PRD_LINES_U1','OKI');
3917: FETCH index_info_csr INTO l_ind_rec;
3918: CLOSE index_info_csr;
3919: l_errpos := 1;
3920:

Line 3922: OPEN index_name_csr('OKI_COV_PRD_LINES');

3918: CLOSE index_info_csr;
3919: l_errpos := 1;
3920:
3921: -- drop indexes
3922: OPEN index_name_csr('OKI_COV_PRD_LINES');
3923: FETCH index_name_csr BULK COLLECT INTO l_index_tab;
3924: CLOSE index_name_csr;
3925:
3926: IF l_index_tab.first IS NOT NULL THEN

Line 3935: l_sql_string := 'TRUNCATE TABLE OKI.OKI_COV_PRD_LINES';

3931: END IF;
3932: l_errpos := 2;
3933:
3934: -- truncate table
3935: l_sql_string := 'TRUNCATE TABLE OKI.OKI_COV_PRD_LINES';
3936: EXECUTE IMMEDIATE l_sql_string;
3937: l_errpos := 3;
3938:
3939: l_sql_string := 'ALTER SESSION ENABLE PARALLEL DML';

Line 3949: INSERT /+ append / INTO OKI_COV_PRD_LINES

3945: l_sql_string := 'alter session set sort_area_size=100000000';
3946: EXECUTE IMMEDIATE l_sql_string;
3947:
3948: -- insert data
3949: INSERT /*+ append */ INTO OKI_COV_PRD_LINES
3950: (
3951: CLE_ID,
3952: CHR_ID,
3953: PARENT_CLE_ID,

Line 4182: create_indicies(p_object_name => 'OKI_COV_PRD_LINES'

4178: COMMIT;
4179: l_errpos := 5;
4180:
4181: -- recreate indexes
4182: create_indicies(p_object_name => 'OKI_COV_PRD_LINES'
4183: ,p_parm_rec => l_ind_rec);
4184: l_errpos := 6;
4185:
4186: OPEN g_latest_job_run_id_csr ;

Line 4195: update_oki_refresh( p_object_name => 'OKI_COV_PRD_LINES'

4191: l_job_run_id := rec_g_latest_job_run_id_csr.job_run_id ;
4192: CLOSE g_latest_job_run_id_csr ;
4193:
4194: -- update oki_refreshes
4195: update_oki_refresh( p_object_name => 'OKI_COV_PRD_LINES'
4196: , p_job_run_id => l_job_run_id
4197: , x_retcode => retcode);
4198: if retcode =2 THEN
4199: raise l_no_update_refresh;

Line 4205: ,tabname => 'OKI_COV_PRD_LINES',percent=> 10);

4201: l_errpos := 8;
4202:
4203: -- analyze table
4204: fnd_stats.gather_table_stats(ownname => 'OKI'
4205: ,tabname => 'OKI_COV_PRD_LINES',percent=> 10);
4206: l_errpos := 9;
4207:
4208: fnd_message.set_name(application => 'OKI'
4209: ,name => 'OKI_TABLE_LOAD_SUCCESS');

Line 4211: ,value => 'OKI_COV_PRD_LINES');

4207:
4208: fnd_message.set_name(application => 'OKI'
4209: ,name => 'OKI_TABLE_LOAD_SUCCESS');
4210: fnd_message.set_token(token => 'TABLE_NAME'
4211: ,value => 'OKI_COV_PRD_LINES');
4212: fnd_file.put_line(which => fnd_file.log
4213: ,buff => fnd_message.get);
4214:
4215: EXCEPTION

Line 4220: , value => 'OKI_COV_PRD_LINES');

4216: WHEN l_no_update_refresh THEN
4217: fnd_message.set_name( application => 'OKI'
4218: , name => 'OKI_TABLE_LOAD_FAILURE');
4219: fnd_message.set_token( token => 'TABLE_NAME'
4220: , value => 'OKI_COV_PRD_LINES');
4221: fnd_file.put_line( which => fnd_file.log
4222: , buff => fnd_message.get);
4223: fnd_file.put_line( which => fnd_file.log
4224: , buff =>'Update of OKI_REFRESHS failed' );

Line 4233: , value => 'OKI_COV_PRD_LINES');

4229:
4230: fnd_message.set_name( application => 'OKI'
4231: , name => 'OKI_TABLE_LOAD_FAILURE');
4232: fnd_message.set_token( token => 'TABLE_NAME'
4233: , value => 'OKI_COV_PRD_LINES');
4234: fnd_file.put_line( which => fnd_file.log
4235: , buff => fnd_message.get);
4236:
4237: fnd_message.set_name( application => 'OKI'

Line 4250: , value => 'OKI_COV_PRD_LINES');

4246:
4247: fnd_message.set_name( application => 'OKI'
4248: , name => 'OKI_TABLE_LOAD_FAILURE');
4249: fnd_message.set_token( token => 'TABLE_NAME'
4250: , value => 'OKI_COV_PRD_LINES');
4251: fnd_file.put_line( which => fnd_file.log
4252: , buff => fnd_message.get);
4253: fnd_file.put_line( which => fnd_file.log
4254: , buff => l_sqlcode||' '||l_sqlerrm);

Line 4256: create_indicies( p_object_name => 'OKI_COV_PRD_LINES'

4252: , buff => fnd_message.get);
4253: fnd_file.put_line( which => fnd_file.log
4254: , buff => l_sqlcode||' '||l_sqlerrm);
4255: IF l_errpos < 5 THEN
4256: create_indicies( p_object_name => 'OKI_COV_PRD_LINES'
4257: , p_parm_rec => l_ind_rec);
4258: ELSIF l_errpos = 5 THEN
4259: -- truncate table
4260: l_sql_string := 'TRUNCATE TABLE OKI.OKI_COV_PRD_LINES';

Line 4260: l_sql_string := 'TRUNCATE TABLE OKI.OKI_COV_PRD_LINES';

4256: create_indicies( p_object_name => 'OKI_COV_PRD_LINES'
4257: , p_parm_rec => l_ind_rec);
4258: ELSIF l_errpos = 5 THEN
4259: -- truncate table
4260: l_sql_string := 'TRUNCATE TABLE OKI.OKI_COV_PRD_LINES';
4261: EXECUTE IMMEDIATE l_sql_string;
4262: END IF;
4263: END refresh_cov_prd_lines;
4264:

Line 4267: -- Procedure to load data into oki_cov_prd_lines without a complete

4263: END refresh_cov_prd_lines;
4264:
4265: ---------------------------------------------------------------------
4266: --
4267: -- Procedure to load data into oki_cov_prd_lines without a complete
4268: -- refresh
4269: --
4270: ---------------------------------------------------------------------
4271: procedure fast_cov_prd_lines

Line 4295: l_table_name := 'OKI_COV_PRD_LINES' ;

4291:
4292:
4293: BEGIN
4294: l_retcode := '0';
4295: l_table_name := 'OKI_COV_PRD_LINES' ;
4296:
4297: l_loc := 'Calling process_refresh_check.' ;
4298: process_refresh_check(
4299: p_object_name => 'OKI_COV_PRD_LINES'

Line 4299: p_object_name => 'OKI_COV_PRD_LINES'

4295: l_table_name := 'OKI_COV_PRD_LINES' ;
4296:
4297: l_loc := 'Calling process_refresh_check.' ;
4298: process_refresh_check(
4299: p_object_name => 'OKI_COV_PRD_LINES'
4300: , x_job_run_id => l_job_run_id
4301: , x_process_yn => l_process_yn
4302: , x_errbuf => x_errbuf
4303: , x_retcode => l_retcode ) ;

Line 4330: DELETE FROM oki_cov_prd_lines cpl

4326: RAISE l_excp_exit_immediate ;
4327: END IF ;
4328:
4329: l_loc := 'Deleting from ' || l_table_name ;
4330: DELETE FROM oki_cov_prd_lines cpl
4331: WHERE chr_id in ( SELECT /*+ index_ffs(jrd oki_job_run_dtl_u1)*/
4332: jrd.chr_id
4333: FROM oki_job_run_dtl jrd
4334: WHERE jrd.job_run_id = l_job_run_id ) ;

Line 4338: INSERT INTO oki_cov_prd_lines (

4334: WHERE jrd.job_run_id = l_job_run_id ) ;
4335:
4336: l_loc := 'Inserting into ' || l_table_name ;
4337: -- insert data
4338: INSERT INTO oki_cov_prd_lines (
4339: cle_id
4340: , chr_id
4341: , parent_cle_id
4342: , scs_code

Line 4568: update_oki_refresh(p_object_name => 'OKI_COV_PRD_LINES'

4564: ;
4565:
4566: l_loc := 'Updating OKI_REFRESHS.' ;
4567: -- update oki_refreshes
4568: update_oki_refresh(p_object_name => 'OKI_COV_PRD_LINES'
4569: , p_job_run_id => l_job_run_id
4570: , x_retcode => l_retcode ) ;
4571: COMMIT;
4572:

Line 4605: ,value => 'OKI_COV_PRD_LINES');

4601: when l_no_update_refresh then
4602: fnd_message.set_name(application => 'OKI'
4603: ,name => 'OKI_TABLE_LOAD_FAILURE');
4604: fnd_message.set_token(token => 'TABLE_NAME'
4605: ,value => 'OKI_COV_PRD_LINES');
4606: fnd_file.put_line(which => fnd_file.log
4607: ,buff => fnd_message.get);
4608:
4609: fnd_file.put_line(which => fnd_file.log

Line 5309: FROM oki_cov_prd_lines cpl

5305: = (SELECT
5306: SUM(price_negotiated),
5307: SUM(sob_price_negotiated),
5308: SUM(base_price_negotiated)
5309: FROM oki_cov_prd_lines cpl
5310: where cpl.parent_cle_id = sil.cle_id
5311: )
5312: where sil.chr_id in (select shd.chr_id
5313: from oki_job_run_dtl jrd, oki_sales_k_hdrs shd