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_K_SALESREPS

Line 334: ELSIF p_object_name = 'OKI_K_SALESREPS' THEN

330: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
331: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
332: EXECUTE IMMEDIATE l_sql_string;
333: */
334: ELSIF p_object_name = 'OKI_K_SALESREPS' THEN
335: l_sql_string := 'CREATE INDEX OKI.OKI_K_SALESREPS_N1 ON';
336: l_sql_string := l_sql_string||' OKI.OKI_K_SALESREPS(CONTRACT_ID)'||' PARALLEL ';
337: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
338: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;

Line 335: l_sql_string := 'CREATE INDEX OKI.OKI_K_SALESREPS_N1 ON';

331: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
332: EXECUTE IMMEDIATE l_sql_string;
333: */
334: ELSIF p_object_name = 'OKI_K_SALESREPS' THEN
335: l_sql_string := 'CREATE INDEX OKI.OKI_K_SALESREPS_N1 ON';
336: l_sql_string := l_sql_string||' OKI.OKI_K_SALESREPS(CONTRACT_ID)'||' PARALLEL ';
337: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
338: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
339: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 336: l_sql_string := l_sql_string||' OKI.OKI_K_SALESREPS(CONTRACT_ID)'||' PARALLEL ';

332: EXECUTE IMMEDIATE l_sql_string;
333: */
334: ELSIF p_object_name = 'OKI_K_SALESREPS' THEN
335: l_sql_string := 'CREATE INDEX OKI.OKI_K_SALESREPS_N1 ON';
336: l_sql_string := l_sql_string||' OKI.OKI_K_SALESREPS(CONTRACT_ID)'||' PARALLEL ';
337: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
338: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
339: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
340: EXECUTE IMMEDIATE l_sql_string;

Line 346: l_sql_string := 'CREATE INDEX OKI.OKI_K_SALESREPS_N2 ON';

342: /* 11510 Changes
343: Commenting out creation of index as salesrep name is not be used from
344: this table.
345:
346: l_sql_string := 'CREATE INDEX OKI.OKI_K_SALESREPS_N2 ON';
347: l_sql_string := l_sql_string||' OKI.OKI_K_SALESREPS(SALESREP_NAME)'||' PARALLEL ';
348: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
349: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
350: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 347: l_sql_string := l_sql_string||' OKI.OKI_K_SALESREPS(SALESREP_NAME)'||' PARALLEL ';

343: Commenting out creation of index as salesrep name is not be used from
344: this table.
345:
346: l_sql_string := 'CREATE INDEX OKI.OKI_K_SALESREPS_N2 ON';
347: l_sql_string := l_sql_string||' OKI.OKI_K_SALESREPS(SALESREP_NAME)'||' PARALLEL ';
348: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
349: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
350: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
351: EXECUTE IMMEDIATE l_sql_string;

Line 353: l_sql_string := 'CREATE INDEX OKI.OKI_K_SALESREPS_N3 ON';

349: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
350: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
351: EXECUTE IMMEDIATE l_sql_string;
352: */
353: l_sql_string := 'CREATE INDEX OKI.OKI_K_SALESREPS_N3 ON';
354: l_sql_string := l_sql_string||' OKI.OKI_K_SALESREPS(PARTY_ROLE_ID)'||' PARALLEL ';
355: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
356: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
357: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 354: l_sql_string := l_sql_string||' OKI.OKI_K_SALESREPS(PARTY_ROLE_ID)'||' PARALLEL ';

350: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
351: EXECUTE IMMEDIATE l_sql_string;
352: */
353: l_sql_string := 'CREATE INDEX OKI.OKI_K_SALESREPS_N3 ON';
354: l_sql_string := l_sql_string||' OKI.OKI_K_SALESREPS(PARTY_ROLE_ID)'||' PARALLEL ';
355: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
356: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
357: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
358: EXECUTE IMMEDIATE l_sql_string;

Line 359: l_sql_string := 'CREATE UNIQUE INDEX OKI.OKI_K_SALESREPS_U1 ON';

355: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
356: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
357: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
358: EXECUTE IMMEDIATE l_sql_string;
359: l_sql_string := 'CREATE UNIQUE INDEX OKI.OKI_K_SALESREPS_U1 ON';
360: l_sql_string := l_sql_string||' OKI.OKI_K_SALESREPS(PARTY_CONTACT_ID)'||' PARALLEL ';
361: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
362: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
363: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';

Line 360: l_sql_string := l_sql_string||' OKI.OKI_K_SALESREPS(PARTY_CONTACT_ID)'||' PARALLEL ';

356: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
357: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
358: EXECUTE IMMEDIATE l_sql_string;
359: l_sql_string := 'CREATE UNIQUE INDEX OKI.OKI_K_SALESREPS_U1 ON';
360: l_sql_string := l_sql_string||' OKI.OKI_K_SALESREPS(PARTY_CONTACT_ID)'||' PARALLEL ';
361: l_sql_string := l_sql_string||' TABLESPACE '||l_index_info.tablespace_name;
362: l_sql_string := l_sql_string||' STORAGE(INITIAL '||l_index_info.initial_extent;
363: l_sql_string := l_sql_string||' NEXT '||l_index_info.next_extent||')';
364: EXECUTE IMMEDIATE l_sql_string;

Line 784: l_table_name := 'OKI_K_SALESREPS' ;

780: -- Truncate failed, exit immediately.
781: RAISE l_excp_exit_immediate ;
782: END IF ;
783: */
784: l_table_name := 'OKI_K_SALESREPS' ;
785: l_loc := 'Calling truncate_table with ' || l_table_owner || '.' || l_table_name ;
786: truncate_table( p_table_owner => l_table_owner
787: , p_table_name => l_table_name
788: , x_errbuf => x_errbuf

Line 868: l_table_name := 'OKI_K_SALESREPS' ;

864: RAISE l_excp_exit_immediate ;
865: END IF ;
866: */
867:
868: l_table_name := 'OKI_K_SALESREPS' ;
869: l_loc := 'Updating OKI_REFRESHS for || l_table_name' ;
870: -- update oki_refreshes
871: update_oki_refresh( p_object_name => l_table_name
872: , p_job_run_id => l_job_run_id

Line 4677: -- oki_k_salesreps. Therefore, the logic to populate this column is

4673: -- 11510 Changes to refresh/fast_k_salesrep
4674: -- 1. Table oki_role_maps is obsoleted, so the procedure hard codes the
4675: -- value for contact role code depending upon the contract subclass.
4676: -- 2. Column salesrep_name is not populated in the table
4677: -- oki_k_salesreps. Therefore, the logic to populate this column is
4678: -- removed from the procedure.
4679: procedure refresh_k_salesreps(errbuf OUT NOCOPY VARCHAR2
4680: ,retcode OUT NOCOPY VARCHAR2) IS
4681:

Line 4700: OPEN index_info_csr('OKI_K_SALESREPS','OKI_K_SALESREPS_U1','OKI');

4696: BEGIN
4697: retcode := '0';
4698:
4699: -- get representative index storage parms for later use
4700: OPEN index_info_csr('OKI_K_SALESREPS','OKI_K_SALESREPS_U1','OKI');
4701: FETCH index_info_csr INTO l_ind_rec;
4702: CLOSE index_info_csr;
4703: l_errpos := 1;
4704:

Line 4706: OPEN index_name_csr('OKI_K_SALESREPS');

4702: CLOSE index_info_csr;
4703: l_errpos := 1;
4704:
4705: -- drop indexes
4706: OPEN index_name_csr('OKI_K_SALESREPS');
4707: FETCH index_name_csr BULK COLLECT INTO l_index_tab;
4708: CLOSE index_name_csr;
4709: l_errpos := 2;
4710:

Line 4729: l_sql_string := 'TRUNCATE TABLE OKI.OKI_K_SALESREPS';

4725: END IF;
4726: l_errpos := 3;
4727:
4728: -- truncate table
4729: l_sql_string := 'TRUNCATE TABLE OKI.OKI_K_SALESREPS';
4730: EXECUTE IMMEDIATE l_sql_string;
4731: l_errpos := 4;
4732:
4733: l_sql_string := 'ALTER SESSION ENABLE PARALLEL DML';

Line 4743: INSERT /+ append / INTO OKI_K_SALESREPS

4739: l_sql_string := 'alter session set sort_area_size=100000000';
4740: EXECUTE IMMEDIATE l_sql_string;
4741:
4742: -- insert data
4743: INSERT /*+ append */ INTO OKI_K_SALESREPS
4744: (
4745: PARTY_CONTACT_ID,
4746: CONTRACT_ID,
4747: PARTY_ROLE_ID,

Line 4806: create_indicies(p_object_name => 'OKI_K_SALESREPS'

4802: COMMIT;
4803: l_errpos := 6;
4804:
4805: -- recreate indexes
4806: create_indicies(p_object_name => 'OKI_K_SALESREPS'
4807: ,p_parm_rec => l_ind_rec);
4808: l_errpos := 7;
4809:
4810: OPEN g_latest_job_run_id_csr ;

Line 4819: update_oki_refresh( p_object_name => 'OKI_K_SALESREPS'

4815: l_job_run_id := rec_g_latest_job_run_id_csr.job_run_id ;
4816: CLOSE g_latest_job_run_id_csr ;
4817:
4818: -- update oki_refreshes
4819: update_oki_refresh( p_object_name => 'OKI_K_SALESREPS'
4820: , p_job_run_id => l_job_run_id
4821: , x_retcode => retcode ) ;
4822: if retcode = 2 THEN
4823: raise l_no_update_refresh;

Line 4830: ,tabname => 'OKI_K_SALESREPS',percent=> 10);

4826: l_errpos := 9;
4827:
4828: -- analyze table
4829: fnd_stats.gather_table_stats(ownname => 'OKI'
4830: ,tabname => 'OKI_K_SALESREPS',percent=> 10);
4831:
4832: fnd_message.set_name(application => 'OKI'
4833: ,name => 'OKI_TABLE_LOAD_SUCCESS');
4834: fnd_message.set_token(token => 'TABLE_NAME'

Line 4835: ,value => 'OKI_K_SALESREPS');

4831:
4832: fnd_message.set_name(application => 'OKI'
4833: ,name => 'OKI_TABLE_LOAD_SUCCESS');
4834: fnd_message.set_token(token => 'TABLE_NAME'
4835: ,value => 'OKI_K_SALESREPS');
4836: fnd_file.put_line(which => fnd_file.log
4837: ,buff => fnd_message.get);
4838:
4839: EXCEPTION

Line 4847: , value => 'OKI_K_SALESREPS');

4843:
4844: fnd_message.set_name( application => 'OKI'
4845: , name => 'OKI_TABLE_LOAD_FAILURE');
4846: fnd_message.set_token( token => 'TABLE_NAME'
4847: , value => 'OKI_K_SALESREPS');
4848: fnd_file.put_line( which => fnd_file.log
4849: , buff => fnd_message.get);
4850:
4851: fnd_message.set_name( application => 'OKI'

Line 4860: ,value => 'OKI_K_SALESREPS');

4856: when l_no_update_refresh then
4857: fnd_message.set_name(application => 'OKI'
4858: ,name => 'OKI_TABLE_LOAD_FAILURE');
4859: fnd_message.set_token(token => 'TABLE_NAME'
4860: ,value => 'OKI_K_SALESREPS');
4861: fnd_file.put_line(which => fnd_file.log
4862: ,buff => fnd_message.get);
4863:
4864: fnd_file.put_line(which => fnd_file.log

Line 4874: , value => 'OKI_K_SALESREPS');

4870: retcode := '2';
4871: fnd_message.set_name( application => 'OKI'
4872: , name => 'OKI_TABLE_LOAD_FAILURE');
4873: fnd_message.set_token( token => 'TABLE_NAME'
4874: , value => 'OKI_K_SALESREPS');
4875: fnd_file.put_line( which => fnd_file.log
4876: , buff => fnd_message.get);
4877: fnd_file.put_line( which => fnd_file.log
4878: , buff => l_sqlcode||' '||l_sqlerrm);

Line 4880: create_indicies( p_object_name => 'OKI_K_SALESREPS'

4876: , buff => fnd_message.get);
4877: fnd_file.put_line( which => fnd_file.log
4878: , buff => l_sqlcode||' '||l_sqlerrm);
4879: IF l_errpos < 6 THEN
4880: create_indicies( p_object_name => 'OKI_K_SALESREPS'
4881: , p_parm_rec => l_ind_rec);
4882: ELSIF l_errpos = 6 THEN
4883: -- truncate table
4884: l_sql_string := 'TRUNCATE TABLE OKI.OKI_K_SALESREPS';

Line 4884: l_sql_string := 'TRUNCATE TABLE OKI.OKI_K_SALESREPS';

4880: create_indicies( p_object_name => 'OKI_K_SALESREPS'
4881: , p_parm_rec => l_ind_rec);
4882: ELSIF l_errpos = 6 THEN
4883: -- truncate table
4884: l_sql_string := 'TRUNCATE TABLE OKI.OKI_K_SALESREPS';
4885: EXECUTE IMMEDIATE l_sql_string;
4886: END IF;
4887: END refresh_k_salesreps;
4888: ---------------------------------------------------------------------

Line 4920: l_table_name := 'OKI_K_SALESREPS';

4916: l_salesperson_code okc_contacts.cro_code%TYPE; -- 11510 Changes
4917:
4918: BEGIN
4919: l_retcode := '0';
4920: l_table_name := 'OKI_K_SALESREPS';
4921:
4922: l_loc := 'Calling process_refresh_check.' ;
4923: process_refresh_check(
4924: p_object_name => l_table_name

Line 4963: DELETE FROM oki_k_salesreps ksr

4959: RAISE l_excp_exit_immediate ;
4960: END IF ;
4961:
4962: l_loc := 'Deleting from ' || l_table_name ;
4963: DELETE FROM oki_k_salesreps ksr
4964: WHERE contract_id in ( SELECT jrd.chr_id
4965: FROM oki_job_run_dtl jrd
4966: WHERE jrd.job_run_id = l_job_run_id ) ;
4967:

Line 4970: INSERT INTO OKI_K_SALESREPS(

4966: WHERE jrd.job_run_id = l_job_run_id ) ;
4967:
4968: l_loc := 'Inserting into ' || l_table_name ;
4969: -- insert data
4970: INSERT INTO OKI_K_SALESREPS(
4971: PARTY_CONTACT_ID
4972: , CONTRACT_ID
4973: , PARTY_ROLE_ID
4974: , CONTACT_ROLE_CODE