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 852: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);

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

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

1207: l_schema VARCHAR2(255);
1208: l_tmp VARCHAR2(2000);
1209:
1210: BEGIN
1211: /*l_bool := fnd_installation.GET_APP_INFO(p_app_name,l_status,l_tmp,l_schema);
1212: OPEN data_type(l_schema);
1213: FETCH data_type INTO l_data_type;
1214: CLOSE data_type;
1215: if (l_data_type is null) then

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

1340: close indexed_views;
1341: if(isView='Y') then
1342: check_flag := 'Y';
1343: else
1344: l_bool := fnd_installation.GET_APP_INFO(app_name,l_status,l_tmp,l_schema);
1345: open column_position(entity_name, column_name, l_schema);
1346: fetch column_position into col_pos;
1347: close column_position;
1348: