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_SOLD_ITM_LINES

Line 194: ELSIF p_object_name = 'OKI_SOLD_ITM_LINES' THEN

190: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
191: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
192: EXECUTE IMMEDIATE l_sql_string;
193: */
194: ELSIF p_object_name = 'OKI_SOLD_ITM_LINES' THEN
195: l_sql_string := 'CREATE INDEX OKI.OKI_SOLD_ITM_LINES_N1 ON';
196: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(CHR_ID)'||' PARALLEL ';
197: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
198: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;

Line 195: l_sql_string := 'CREATE INDEX OKI.OKI_SOLD_ITM_LINES_N1 ON';

191: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
192: EXECUTE IMMEDIATE l_sql_string;
193: */
194: ELSIF p_object_name = 'OKI_SOLD_ITM_LINES' THEN
195: l_sql_string := 'CREATE INDEX OKI.OKI_SOLD_ITM_LINES_N1 ON';
196: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(CHR_ID)'||' PARALLEL ';
197: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
198: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
199: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 196: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(CHR_ID)'||' PARALLEL ';

192: EXECUTE IMMEDIATE l_sql_string;
193: */
194: ELSIF p_object_name = 'OKI_SOLD_ITM_LINES' THEN
195: l_sql_string := 'CREATE INDEX OKI.OKI_SOLD_ITM_LINES_N1 ON';
196: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(CHR_ID)'||' PARALLEL ';
197: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
198: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
199: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
200: EXECUTE IMMEDIATE l_sql_string;

Line 201: l_sql_string := 'CREATE INDEX OKI.OKI_SOLD_ITM_LINES_N2 ON';

197: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
198: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
199: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
200: EXECUTE IMMEDIATE l_sql_string;
201: l_sql_string := 'CREATE INDEX OKI.OKI_SOLD_ITM_LINES_N2 ON';
202: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(CONTRACT_NUMBER)'||' PARALLEL ';
203: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
204: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
205: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 202: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(CONTRACT_NUMBER)'||' PARALLEL ';

198: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
199: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
200: EXECUTE IMMEDIATE l_sql_string;
201: l_sql_string := 'CREATE INDEX OKI.OKI_SOLD_ITM_LINES_N2 ON';
202: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(CONTRACT_NUMBER)'||' PARALLEL ';
203: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
204: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
205: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
206: EXECUTE IMMEDIATE l_sql_string;

Line 207: l_sql_string := 'CREATE INDEX OKI.OKI_SOLD_ITM_LINES_N3 ON';

203: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
204: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
205: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
206: EXECUTE IMMEDIATE l_sql_string;
207: l_sql_string := 'CREATE INDEX OKI.OKI_SOLD_ITM_LINES_N3 ON';
208: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(COMPLETE_CONTRACT_NUMBER)'||' PARALLEL ';
209: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
210: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
211: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 208: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(COMPLETE_CONTRACT_NUMBER)'||' PARALLEL ';

204: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
205: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
206: EXECUTE IMMEDIATE l_sql_string;
207: l_sql_string := 'CREATE INDEX OKI.OKI_SOLD_ITM_LINES_N3 ON';
208: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(COMPLETE_CONTRACT_NUMBER)'||' PARALLEL ';
209: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
210: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
211: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
212: EXECUTE IMMEDIATE l_sql_string;

Line 213: l_sql_string := 'CREATE INDEX OKI.OKI_SOLD_ITM_LINES_N4 ON';

209: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
210: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
211: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
212: EXECUTE IMMEDIATE l_sql_string;
213: l_sql_string := 'CREATE INDEX OKI.OKI_SOLD_ITM_LINES_N4 ON';
214: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(ITEM_ID, INVENTORY_ORGANIZATION_ID)'||' PARALLEL ';
215: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
216: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
217: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 214: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(ITEM_ID, INVENTORY_ORGANIZATION_ID)'||' PARALLEL ';

210: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
211: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
212: EXECUTE IMMEDIATE l_sql_string;
213: l_sql_string := 'CREATE INDEX OKI.OKI_SOLD_ITM_LINES_N4 ON';
214: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(ITEM_ID, INVENTORY_ORGANIZATION_ID)'||' PARALLEL ';
215: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
216: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
217: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
218: EXECUTE IMMEDIATE l_sql_string;

Line 219: l_sql_string := 'CREATE UNIQUE INDEX OKI.OKI_SOLD_ITM_LINES_U1 ON';

215: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
216: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
217: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
218: EXECUTE IMMEDIATE l_sql_string;
219: l_sql_string := 'CREATE UNIQUE INDEX OKI.OKI_SOLD_ITM_LINES_U1 ON';
220: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(CLE_ID)'||' PARALLEL ';
221: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
222: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
223: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 220: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(CLE_ID)'||' PARALLEL ';

216: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
217: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
218: EXECUTE IMMEDIATE l_sql_string;
219: l_sql_string := 'CREATE UNIQUE INDEX OKI.OKI_SOLD_ITM_LINES_U1 ON';
220: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(CLE_ID)'||' PARALLEL ';
221: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
222: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
223: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
224: EXECUTE IMMEDIATE l_sql_string;

Line 226: l_sql_string := 'CREATE INDEX OKI.OKI_SOLD_ITM_LINES_N5 ON';

222: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
223: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
224: EXECUTE IMMEDIATE l_sql_string;
225: /*11.5.10 ADDED
226: l_sql_string := 'CREATE INDEX OKI.OKI_SOLD_ITM_LINES_N5 ON';
227: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(BILL_TO_SITE_USE_ID)'||' PARALLEL ';
228:
229: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
230: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;

Line 227: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(BILL_TO_SITE_USE_ID)'||' PARALLEL ';

223: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
224: EXECUTE IMMEDIATE l_sql_string;
225: /*11.5.10 ADDED
226: l_sql_string := 'CREATE INDEX OKI.OKI_SOLD_ITM_LINES_N5 ON';
227: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(BILL_TO_SITE_USE_ID)'||' PARALLEL ';
228:
229: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
230: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
231: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 233: l_sql_string := 'CREATE INDEX OKI.OKI_SOLD_ITM_LINES_N6 ON';

229: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
230: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
231: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
232: EXECUTE IMMEDIATE l_sql_string;
233: l_sql_string := 'CREATE INDEX OKI.OKI_SOLD_ITM_LINES_N6 ON';
234: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(SHIP_TO_SITE_USE_ID)'||' PARALLEL ';
235: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
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||')';

Line 234: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(SHIP_TO_SITE_USE_ID)'||' PARALLEL ';

230: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
231: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
232: EXECUTE IMMEDIATE l_sql_string;
233: l_sql_string := 'CREATE INDEX OKI.OKI_SOLD_ITM_LINES_N6 ON';
234: l_sql_string := l_sql_string||' OKI.OKI_SOLD_ITM_LINES(SHIP_TO_SITE_USE_ID)'||' PARALLEL ';
235: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
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;

Line 751: l_table_name := 'OKI_SOLD_ITM_LINES' ;

747: IF l_retcode = '2' THEN
748: -- Truncate failed, exit immediately.
749: RAISE l_excp_exit_immediate ;
750: END IF ;
751: l_table_name := 'OKI_SOLD_ITM_LINES' ;
752: l_loc := 'Calling truncate_table with ' || l_table_owner || '.' || l_table_name ;
753: truncate_table( p_table_owner => l_table_owner
754: , p_table_name => l_table_name
755: , x_errbuf => x_errbuf

Line 832: l_table_name := 'OKI_SOLD_ITM_LINES' ;

828: -- update_oki_refresh failed, exit immediately.
829: RAISE l_excp_exit_immediate ;
830: END IF ;
831:
832: l_table_name := 'OKI_SOLD_ITM_LINES' ;
833: l_loc := 'Updating OKI_REFRESHS for || l_table_name' ;
834: -- update oki_refreshes
835: update_oki_refresh( p_object_name => l_table_name
836: , p_job_run_id => l_job_run_id

Line 3371: OPEN index_info_csr('OKI_SOLD_ITM_LINES','OKI_SOLD_ITM_LINES_U1','OKI');

3367: BEGIN
3368: retcode := '0';
3369:
3370: -- get representative index storage parms for later use
3371: OPEN index_info_csr('OKI_SOLD_ITM_LINES','OKI_SOLD_ITM_LINES_U1','OKI');
3372: FETCH index_info_csr INTO l_ind_rec;
3373: CLOSE index_info_csr;
3374: l_errpos := 1;
3375:

Line 3377: OPEN index_name_csr('OKI_SOLD_ITM_LINES');

3373: CLOSE index_info_csr;
3374: l_errpos := 1;
3375:
3376: -- drop indexes
3377: OPEN index_name_csr('OKI_SOLD_ITM_LINES');
3378: FETCH index_name_csr BULK COLLECT INTO l_index_tab;
3379: CLOSE index_name_csr;
3380:
3381: IF l_index_tab.first IS NOT NULL THEN

Line 3390: l_sql_string := 'TRUNCATE TABLE OKI.OKI_SOLD_ITM_LINES';

3386: END IF;
3387: l_errpos := 2;
3388:
3389: -- truncate table
3390: l_sql_string := 'TRUNCATE TABLE OKI.OKI_SOLD_ITM_LINES';
3391: EXECUTE IMMEDIATE l_sql_string;
3392: l_errpos := 3;
3393:
3394: l_sql_string := 'ALTER SESSION ENABLE PARALLEL DML';

Line 3404: INSERT /+ append / INTO OKI_SOLD_ITM_LINES

3400: l_sql_string := 'alter session set sort_area_size=100000000';
3401: EXECUTE IMMEDIATE l_sql_string;
3402:
3403: -- insert data
3404: INSERT /*+ append */ INTO OKI_SOLD_ITM_LINES
3405: (
3406: CLE_ID,
3407: CHR_ID,
3408: CONTRACT_NUMBER,

Line 3541: create_indicies(p_object_name => 'OKI_SOLD_ITM_LINES'

3537: COMMIT;
3538: l_errpos := 5;
3539:
3540: -- recreate indexes
3541: create_indicies(p_object_name => 'OKI_SOLD_ITM_LINES'
3542: ,p_parm_rec => l_ind_rec);
3543: l_errpos := 6;
3544:
3545:

Line 3555: update_oki_refresh( p_object_name => 'OKI_SOLD_ITM_LINES'

3551: l_job_run_id := rec_g_latest_job_run_id_csr.job_run_id ;
3552: CLOSE g_latest_job_run_id_csr ;
3553:
3554: -- update oki_refreshes
3555: update_oki_refresh( p_object_name => 'OKI_SOLD_ITM_LINES'
3556: , p_job_run_id => l_job_run_id
3557: , x_retcode => retcode ) ;
3558: COMMIT ;
3559: IF retcode = '2' THEN

Line 3567: ,tabname => 'OKI_SOLD_ITM_LINES',percent=> 10);

3563: l_errpos := 8;
3564:
3565: -- analyze table
3566: fnd_stats.gather_table_stats(ownname => 'OKI'
3567: ,tabname => 'OKI_SOLD_ITM_LINES',percent=> 10);
3568: l_errpos := 9;
3569:
3570: fnd_message.set_name(application => 'OKI'
3571: ,name => 'OKI_TABLE_LOAD_SUCCESS');

Line 3573: ,value => 'OKI_SOLD_ITM_LINES');

3569:
3570: fnd_message.set_name(application => 'OKI'
3571: ,name => 'OKI_TABLE_LOAD_SUCCESS');
3572: fnd_message.set_token(token => 'TABLE_NAME'
3573: ,value => 'OKI_SOLD_ITM_LINES');
3574: fnd_file.put_line(which => fnd_file.log
3575: ,buff => fnd_message.get);
3576:
3577: EXCEPTION

Line 3584: , value => 'OKI_SOLD_ITM_LINES');

3580: retcode := '2';
3581: fnd_message.set_name( application => 'OKI'
3582: , name => 'OKI_TABLE_LOAD_FAILURE');
3583: fnd_message.set_token( token => 'TABLE_NAME'
3584: , value => 'OKI_SOLD_ITM_LINES');
3585: fnd_file.put_line( which => fnd_file.log
3586: , buff => fnd_message.get);
3587:
3588: fnd_message.set_name( application => 'OKI'

Line 3597: ,value => 'OKI_SOLD_ITM_LINES');

3593: WHEN l_no_update_refresh then
3594: fnd_message.set_name(application => 'OKI'
3595: ,name => 'OKI_TABLE_LOAD_FAILURE');
3596: fnd_message.set_token(token => 'TABLE_NAME'
3597: ,value => 'OKI_SOLD_ITM_LINES');
3598: fnd_file.put_line(which => fnd_file.log
3599: ,buff => fnd_message.get);
3600:
3601: fnd_file.put_line(which => fnd_file.log

Line 3611: , value => 'OKI_SOLD_ITM_LINES');

3607: retcode := '2';
3608: fnd_message.set_name( application => 'OKI'
3609: , name => 'OKI_TABLE_LOAD_FAILURE');
3610: fnd_message.set_token( token => 'TABLE_NAME'
3611: , value => 'OKI_SOLD_ITM_LINES');
3612: fnd_file.put_line( which => fnd_file.log
3613: , buff => fnd_message.get);
3614: fnd_file.put_line( which => fnd_file.log
3615: , buff => l_sqlcode||' '||l_sqlerrm);

Line 3617: create_indicies(p_object_name => 'OKI_SOLD_ITM_LINES'

3613: , buff => fnd_message.get);
3614: fnd_file.put_line( which => fnd_file.log
3615: , buff => l_sqlcode||' '||l_sqlerrm);
3616: IF l_errpos < 5 THEN
3617: create_indicies(p_object_name => 'OKI_SOLD_ITM_LINES'
3618: ,p_parm_rec => l_ind_rec);
3619: ELSIF l_errpos = 5 THEN
3620: -- truncate table
3621: l_sql_string := 'TRUNCATE TABLE OKI.OKI_SOLD_ITM_LINES';

Line 3621: l_sql_string := 'TRUNCATE TABLE OKI.OKI_SOLD_ITM_LINES';

3617: create_indicies(p_object_name => 'OKI_SOLD_ITM_LINES'
3618: ,p_parm_rec => l_ind_rec);
3619: ELSIF l_errpos = 5 THEN
3620: -- truncate table
3621: l_sql_string := 'TRUNCATE TABLE OKI.OKI_SOLD_ITM_LINES';
3622: EXECUTE IMMEDIATE l_sql_string;
3623: END IF;
3624:
3625: END refresh_sold_itm_lines;

Line 3629: -- Procedure to load data into oki_sold_itm_lines without a complete

3625: END refresh_sold_itm_lines;
3626:
3627: ---------------------------------------------------------------------
3628: --
3629: -- Procedure to load data into oki_sold_itm_lines without a complete
3630: -- refresh
3631: --
3632: ---------------------------------------------------------------------
3633: procedure fast_sold_itm_lines

Line 3656: l_table_name := 'OKI_SOLD_ITM_LINES' ;

3652: l_table_name VARCHAR2(30) ;
3653:
3654: BEGIN
3655: l_retcode := '0' ;
3656: l_table_name := 'OKI_SOLD_ITM_LINES' ;
3657:
3658: l_loc := 'Calling process_refresh_check.' ;
3659: process_refresh_check(
3660: p_object_name => l_table_name

Line 3691: DELETE FROM oki_sold_itm_lines sil

3687: RAISE l_excp_exit_immediate ;
3688: END IF ;
3689:
3690: l_loc := 'Deleting from ' || l_table_name ;
3691: DELETE FROM oki_sold_itm_lines sil
3692: WHERE chr_id in ( SELECT jrd.chr_id
3693: FROM oki_job_run_dtl jrd
3694: WHERE jrd.job_run_id = l_job_run_id ) ;
3695:

Line 3698: INSERT INTO oki_sold_itm_lines(

3694: WHERE jrd.job_run_id = l_job_run_id ) ;
3695:
3696: l_loc := 'Inserting into ' || l_table_name ;
3697: -- insert data
3698: INSERT INTO oki_sold_itm_lines(
3699: cle_id
3700: , chr_id
3701: , contract_number
3702: , contract_number_modifier

Line 3870: ,value => 'OKI_SOLD_ITM_LINES');

3866: when l_no_update_refresh then
3867: fnd_message.set_name(application => 'OKI'
3868: ,name => 'OKI_TABLE_LOAD_FAILURE');
3869: fnd_message.set_token(token => 'TABLE_NAME'
3870: ,value => 'OKI_SOLD_ITM_LINES');
3871: fnd_file.put_line(which => fnd_file.log
3872: ,buff => fnd_message.get);
3873:
3874: fnd_file.put_line(which => fnd_file.log

Line 4150: oki_sold_itm_lines sil

4146: ,'N')--if the contract is not expired 'N'
4147: is_exp_not_renewed_yn
4148: --Bug Fix 3469671 code changes-------------------------------------------------
4149: from
4150: oki_sold_itm_lines sil
4151: /*11510 changes added*/
4152: ,oki_job_run_dtl jrd
4153: ,okc_k_lines_b cle
4154: ,okc_k_items cim

Line 4539: , oki_sold_itm_lines sil

4535: is_exp_not_renewed_yn
4536: --Bug Fix 3469671 code changes-------------------------------------------------
4537: FROM
4538: okc_k_lines_b cle
4539: , oki_sold_itm_lines sil
4540: , okc_k_items cim
4541: , csi_item_instances cii
4542: , okc_statuses_b sts
4543: , oki_job_run_dtl jrd

Line 5166: UPDATE /+ parallel(v) bypass_ujvc / oki_sold_itm_lines_cpl_v v

5162: x_retcode := 0 ;
5163:
5164: l_loc := ' Updating price negotiated for Service Contracts ';
5165:
5166: UPDATE /*+ parallel(v) bypass_ujvc */ oki_sold_itm_lines_cpl_v v
5167: SET price_negotiated = cpl_price_negotiated
5168: , sob_price_negotiated = cpl_sob_price_negotiated
5169: , base_price_negotiated = cpl_base_price_negotiated ;
5170:

Line 5183: update_oki_refresh( p_object_name => 'OKI_SOLD_ITM_LINES_UPDATE'

5179: l_job_run_id := rec_g_latest_job_run_id_csr.job_run_id ;
5180: CLOSE g_latest_job_run_id_csr ;
5181:
5182: -- update oki_refreshes
5183: update_oki_refresh( p_object_name => 'OKI_SOLD_ITM_LINES_UPDATE'
5184: , p_job_run_id => l_job_run_id
5185: , x_retcode => x_retcode ) ;
5186: COMMIT ;
5187: if x_retcode = 2 then

Line 5194: ,value => 'OKI_SOLD_ITM_LINES');

5190:
5191: fnd_message.set_name(application => 'OKI'
5192: ,name => 'OKI_TABLE_LOAD_SUCCESS');
5193: fnd_message.set_token(token => 'TABLE_NAME'
5194: ,value => 'OKI_SOLD_ITM_LINES');
5195: fnd_file.put_line(which => fnd_file.log
5196: ,buff => fnd_message.get);
5197:
5198: EXCEPTION

Line 5205: , value => 'OKI_SOLD_ITM_LINES');

5201: x_retcode := '2';
5202: fnd_message.set_name( application => 'OKI'
5203: , name => 'OKI_TABLE_LOAD_FAILURE');
5204: fnd_message.set_token( token => 'TABLE_NAME'
5205: , value => 'OKI_SOLD_ITM_LINES');
5206: fnd_file.put_line( which => fnd_file.log
5207: , buff => fnd_message.get);
5208:
5209: fnd_message.set_name( application => 'OKI'

Line 5218: ,value => 'OKI_SOLD_ITM_LINES');

5214: when l_no_update_refresh then
5215: fnd_message.set_name(application => 'OKI'
5216: ,name => 'OKI_TABLE_LOAD_FAILURE');
5217: fnd_message.set_token(token => 'TABLE_NAME'
5218: ,value => 'OKI_SOLD_ITM_LINES');
5219: fnd_file.put_line(which => fnd_file.log
5220: ,buff => fnd_message.get);
5221:
5222: fnd_file.put_line(which => fnd_file.log

Line 5234: , value => 'OKI_SOLD_ITM_LINES');

5230: x_retcode := '2';
5231: fnd_message.set_name( application => 'OKI'
5232: , name => 'OKI_TABLE_LOAD_FAILURE');
5233: fnd_message.set_token( token => 'TABLE_NAME'
5234: , value => 'OKI_SOLD_ITM_LINES');
5235: fnd_file.put_line( which => fnd_file.log
5236: , buff => fnd_message.get);
5237:
5238: -- Log the location within the procedure where the error occurred

Line 5278: l_table_name := 'OKI_SOLD_ITM_LINES_UPDATE';

5274:
5275:
5276: BEGIN
5277: x_retcode := 0 ;
5278: l_table_name := 'OKI_SOLD_ITM_LINES_UPDATE';
5279:
5280: l_loc := 'Calling process_refresh_check.' ;
5281: process_refresh_check(
5282: p_object_name => l_table_name

Line 5301: UPDATE OKI_SOLD_ITM_LINES sil

5297: END IF ;
5298:
5299: l_loc := ' Updating price negotiated for Service Contracts ';
5300:
5301: UPDATE OKI_SOLD_ITM_LINES sil
5302: SET (price_negotiated,
5303: sob_price_negotiated,
5304: base_price_negotiated)
5305: = (SELECT

Line 5334: ,value => 'OKI_SOLD_ITM_LINES');

5330:
5331: fnd_message.set_name(application => 'OKI'
5332: ,name => 'OKI_TABLE_LOAD_SUCCESS');
5333: fnd_message.set_token(token => 'TABLE_NAME'
5334: ,value => 'OKI_SOLD_ITM_LINES');
5335: fnd_file.put_line(which => fnd_file.log
5336: ,buff => fnd_message.get);
5337:
5338: EXCEPTION

Line 5347: ,value => 'OKI_SOLD_ITM_LINES');

5343: when l_no_update_refresh then
5344: fnd_message.set_name(application => 'OKI'
5345: ,name => 'OKI_TABLE_LOAD_FAILURE');
5346: fnd_message.set_token(token => 'TABLE_NAME'
5347: ,value => 'OKI_SOLD_ITM_LINES');
5348: fnd_file.put_line(which => fnd_file.log
5349: ,buff => fnd_message.get);
5350:
5351: fnd_file.put_line(which => fnd_file.log

Line 5368: , value => 'OKI_SOLD_ITM_LINES');

5364: x_retcode := '2';
5365: fnd_message.set_name( application => 'OKI'
5366: , name => 'OKI_TABLE_LOAD_FAILURE');
5367: fnd_message.set_token( token => 'TABLE_NAME'
5368: , value => 'OKI_SOLD_ITM_LINES');
5369: fnd_file.put_line( which => fnd_file.log
5370: , buff => fnd_message.get);
5371:
5372: -- Log the location within the procedure where the error occurred