851:
852: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);
853:
854: begin
855: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_parties_t1');
856: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_party_sites_t1');
857: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_contact_t1');
858: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_cpt_t1');
859: exception
852: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);
853:
854: begin
855: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_parties_t1');
856: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_party_sites_t1');
857: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_contact_t1');
858: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_cpt_t1');
859: exception
860: when others then
853:
854: begin
855: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_parties_t1');
856: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_party_sites_t1');
857: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_contact_t1');
858: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_cpt_t1');
859: exception
860: when others then
861: null;
854: begin
855: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_parties_t1');
856: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_party_sites_t1');
857: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_contact_t1');
858: ad_ctx_ddl.sync_index(l_schema||'.hz_stage_cpt_t1');
859: exception
860: when others then
861: null;
862: end;