APPS.CSC_PROFILE_ENGINE_PKG dependencies on FND_INSTALLATION

Line 420: v_get_appl := FND_INSTALLATION.GET_APP_INFO('CSC', v_schema_status, v_industry, v_schema_name);

416: BEGIN
417: COMMIT;
418: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
419: EXECUTE IMMEDIATE 'ALTER SESSION SET SKIP_UNUSABLE_INDEXES=TRUE';
420: v_get_appl := FND_INSTALLATION.GET_APP_INFO('CSC', v_schema_status, v_industry, v_schema_name);
421: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS NOLOGGING';
422: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_BATCH_RESULTS2_T NOLOGGING';
423: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_BATCH_RESULTS1_T NOLOGGING';
424: SELECT count(*)

Line 3674: v_get_appl := FND_INSTALLATION.GET_APP_INFO('CSC', v_schema_status, v_industry, v_schema_name);

3670: COMMIT;
3671: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
3672: EXECUTE IMMEDIATE 'ALTER SESSION SET SKIP_UNUSABLE_INDEXES=TRUE';
3673:
3674: v_get_appl := FND_INSTALLATION.GET_APP_INFO('CSC', v_schema_status, v_industry, v_schema_name);
3675:
3676: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS NOLOGGING';
3677: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_BATCH_RESULTS2_T NOLOGGING';
3678: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_BATCH_RESULTS1_T NOLOGGING';

Line 10709: v_get_appl := FND_INSTALLATION.GET_APP_INFO('CSC', v_schema_status, v_industry, v_schema_name);

10705: v_industry VARCHAR2(1);
10706: v_schema_name VARCHAR2(30);
10707: v_get_appl BOOLEAN;
10708: BEGIN
10709: v_get_appl := FND_INSTALLATION.GET_APP_INFO('CSC', v_schema_status, v_industry, v_schema_name);
10710: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
10711: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
10712: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
10713: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';