[Home] [Help]
1214:
1215: log('Optimizing Intermedia indexes');
1216: log('Optimizing party index .. ', TRUE);
1217:
1218: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_index_owner);
1219: OPTIMIZE_INDEX(l_index_owner || '.hz_stage_parties_t1', 'FULL', l_prof_val, idx_retcode , idx_err);
1220: IF idx_retcode = 1 THEN
1221: RAISE FND_API.G_EXC_ERROR;
1222: END IF;
1738: l_index_owner VARCHAR2(255);
1739: l_tmp VARCHAR2(2000);
1740:
1741: BEGIN
1742: IF(fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_index_owner)) THEN
1743: IF (i_party) THEN
1744: SYNC_INDEX_REALTIME(l_index_owner || '.hz_stage_parties_t1',
1745: idx_retcode , idx_err);
1746: IF idx_retcode = 1 THEN
2561: -- GET THE INDEX OWNER INSTEAD OF HARDCODING IT
2562: -- THIS FND FUNCTION, WILL TAKE THE APPLICATION SHORT NAME AND RETURN THE ORACLE_SCHEMA FOR THE USER
2563: -- AND THIS IS ESSENTIALLY THE INDEX OWNER
2564:
2565: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);
2566:
2567: -- Propagating the changes done for Bug:4706376
2568: SELECT COUNT(*) INTO index_cnt FROM HZ_DQM_STAGE_LOG WHERE OPERATION='ALTER_INDEX';
2569:
2635:
2636: -- Sequentially Sync all indexes one by one
2637: -- set OUT variables and write any messages to logs appropriately
2638: -- Fix for bug 5048604. Moved the call to Parties Sync Index to be the last, instead of being first.
2639: IF ( fnd_installation.GET_APP_INFO('AR', l_status, l_tmp, l_index_owner ))
2640: THEN
2641: log ( 'index_owner is ' || l_index_owner );
2642: BEGIN
2643: idx_name := l_index_owner || '.hz_stage_party_sites_t1';
2722:
2723: FND_MSG_PUB.initialize;
2724:
2725:
2726: IF ( fnd_installation.GET_APP_INFO('AR', l_status, l_tmp, l_index_owner ))
2727: THEN
2728: log ( 'index_owner is ' || l_index_owner );
2729:
2730: -- Submit requests for the Parallel Sync Index Child concurrent program