DBA Data[Home] [Help]

APPS.CSC_PROFILE_ENGINE_PKG dependencies on FND_INSTALLATION

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

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

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

2594: COMMIT;
2595: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
2596: EXECUTE IMMEDIATE 'ALTER SESSION SET SKIP_UNUSABLE_INDEXES=TRUE';
2597:
2598: v_get_appl := FND_INSTALLATION.GET_APP_INFO('CSC', v_schema_status, v_industry, v_schema_name);
2599:
2600: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS NOLOGGING';
2601: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_BATCH_RESULTS2_T NOLOGGING';
2602: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_BATCH_RESULTS1_T NOLOGGING';

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

7955: v_industry VARCHAR2(1);
7956: v_schema_name VARCHAR2(30);
7957: v_get_appl BOOLEAN;
7958: BEGIN
7959: v_get_appl := FND_INSTALLATION.GET_APP_INFO('CSC', v_schema_status, v_industry, v_schema_name);
7960:
7961:
7962: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
7963: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';