[Home] [Help]
1264:
1265: log('Optimizing Intermedia indexes');
1266: log('Optimizing party index .. ', TRUE);
1267:
1268: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_index_owner);
1269: OPTIMIZE_INDEX(l_index_owner || '.hz_stage_parties_t1', 'FULL', l_prof_val, idx_retcode , idx_err);
1270: IF idx_retcode = 1 THEN
1271: RAISE FND_API.G_EXC_ERROR;
1272: END IF;
1857: l_index_owner VARCHAR2(255);
1858: l_tmp VARCHAR2(2000);
1859:
1860: BEGIN
1861: IF(fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_index_owner)) THEN
1862: IF (i_party) THEN
1863: SYNC_INDEX_REALTIME(l_index_owner || '.hz_stage_parties_t1',
1864: idx_retcode , idx_err);
1865: IF idx_retcode = 1 THEN
2740: -- GET THE INDEX OWNER INSTEAD OF HARDCODING IT
2741: -- THIS FND FUNCTION, WILL TAKE THE APPLICATION SHORT NAME AND RETURN THE ORACLE_SCHEMA FOR THE USER
2742: -- AND THIS IS ESSENTIALLY THE INDEX OWNER
2743:
2744: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);
2745:
2746: -- Propagating the changes done for Bug:4706376
2747: SELECT COUNT(*) INTO index_cnt FROM HZ_DQM_STAGE_LOG WHERE OPERATION='ALTER_INDEX';
2748:
2814:
2815: -- Sequentially Sync all indexes one by one
2816: -- set OUT variables and write any messages to logs appropriately
2817: -- Fix for bug 5048604. Moved the call to Parties Sync Index to be the last, instead of being first.
2818: IF ( fnd_installation.GET_APP_INFO('AR', l_status, l_tmp, l_index_owner ))
2819: THEN
2820: log ( 'index_owner is ' || l_index_owner );
2821: BEGIN
2822: idx_name := l_index_owner || '.hz_stage_party_sites_t1';
2901:
2902: FND_MSG_PUB.initialize;
2903:
2904:
2905: IF ( fnd_installation.GET_APP_INFO('AR', l_status, l_tmp, l_index_owner ))
2906: THEN
2907: log ( 'index_owner is ' || l_index_owner );
2908:
2909: -- Submit requests for the Parallel Sync Index Child concurrent program