APPS.HZ_PURGE dependencies on FND_INSTALLATION

Line 333: --l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);

329: end if;
330:
331: log('NEWLINE',conc_prg);
332: log('--Program to identify the purge candidates',conc_prg);
333: --l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);
334: open time_stmp;
335: fetch time_stmp into time_stamp;
336: close time_stmp;
337:

Line 864: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);

860:
861: /* update the status of purged parties in table 'HZ_PURGE_BATCHES to 'PURGE_COMPLETED' */
862: update hz_purge_batches set status='PURGE_COMPLETE',purge_date=sysdate where batch_id=batchid;
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');

Line 1228: /*l_bool := fnd_installation.GET_APP_INFO(p_app_name,l_status,l_tmp,l_schema);

1224: l_schema VARCHAR2(255);
1225: l_tmp VARCHAR2(2000);
1226:
1227: BEGIN
1228: /*l_bool := fnd_installation.GET_APP_INFO(p_app_name,l_status,l_tmp,l_schema);
1229: OPEN data_type(l_schema);
1230: FETCH data_type INTO l_data_type;
1231: CLOSE data_type;
1232: if (l_data_type is null) then

Line 1361: l_bool := fnd_installation.GET_APP_INFO(app_name,l_status,l_tmp,l_schema);

1357: close indexed_views;
1358: if(isView='Y') then
1359: check_flag := 'Y';
1360: else
1361: l_bool := fnd_installation.GET_APP_INFO(app_name,l_status,l_tmp,l_schema);
1362: open column_position(entity_name, column_name, l_schema);
1363: fetch column_position into col_pos;
1364: close column_position;
1365: