863:
864: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);
865:
866: begin
867: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_parties_t1');
868: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_party_sites_t1');
869: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_contact_t1');
870: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_cpt_t1');
871: exception
864: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);
865:
866: begin
867: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_parties_t1');
868: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_party_sites_t1');
869: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_contact_t1');
870: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_cpt_t1');
871: exception
872: when others then
865:
866: begin
867: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_parties_t1');
868: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_party_sites_t1');
869: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_contact_t1');
870: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_cpt_t1');
871: exception
872: when others then
873: null;
866: begin
867: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_parties_t1');
868: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_party_sites_t1');
869: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_contact_t1');
870: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_cpt_t1');
871: exception
872: when others then
873: null;
874: end;