eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CSC_PROFILE_ENGINE_PKG dependencies on CSC_PROF_CHECK_RESULTS

Line 421: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS NOLOGGING';

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(*)
425: INTO v_chk_count

Line 426: FROM csc_prof_check_results;

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(*)
425: INTO v_chk_count
426: FROM csc_prof_check_results;
427:
428: SELECT count(*)
429: INTO v_batch_count
430: FROM CSC_PROF_BATCH_RESULTS2_T;

Line 433: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';

429: INTO v_batch_count
430: FROM CSC_PROF_BATCH_RESULTS2_T;
431:
432: IF v_chk_count = 0 AND v_batch_count <> 0 THEN
433: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
434: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
435: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
436: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
437: INTO csc_prof_check_results

Line 434: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';

430: FROM CSC_PROF_BATCH_RESULTS2_T;
431:
432: IF v_chk_count = 0 AND v_batch_count <> 0 THEN
433: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
434: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
435: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
436: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
437: INTO csc_prof_check_results
438: (check_results_id,

Line 435: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';

431:
432: IF v_chk_count = 0 AND v_batch_count <> 0 THEN
433: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
434: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
435: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
436: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
437: INTO csc_prof_check_results
438: (check_results_id,
439: check_id,

Line 436: INSERT /+ PARALLEL (csc_prof_check_results, 12) /

432: IF v_chk_count = 0 AND v_batch_count <> 0 THEN
433: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
434: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
435: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
436: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
437: INTO csc_prof_check_results
438: (check_results_id,
439: check_id,
440: party_id,

Line 437: INTO csc_prof_check_results

433: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
434: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
435: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
436: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
437: INTO csc_prof_check_results
438: (check_results_id,
439: check_id,
440: party_id,
441: cust_account_id,

Line 473: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';

469: rating_code,
470: color_code
471: FROM CSC_PROF_BATCH_RESULTS2_T;
472: COMMIT;
473: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
474: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
475: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
476: END IF;
477: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;

Line 474: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';

470: color_code
471: FROM CSC_PROF_BATCH_RESULTS2_T;
472: COMMIT;
473: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
474: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
475: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
476: END IF;
477: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
478: IF g_dashboard_for_contact IS NULL THEN

Line 475: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';

471: FROM CSC_PROF_BATCH_RESULTS2_T;
472: COMMIT;
473: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
474: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
475: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
476: END IF;
477: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
478: IF g_dashboard_for_contact IS NULL THEN
479: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT',g_dashboard_for_contact);

Line 759: ' SELECT csc_prof_check_results_s.nextval, '

755: insert_stmnt_final := 'INSERT /*+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) */ INTO CSC_PROF_BATCH_RESULTS2_T ' ||
756: '(check_results_id, check_id, party_id, cust_account_id, party_site_id,value, currency_code, grade, '|| -- Inlcuded 'party_site_id' for ER#8473903
757: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
758: ' results_threshold_flag, rating_code, color_code)' ||
759: ' SELECT csc_prof_check_results_s.nextval, '
760: || chk_id || ', party_id, account_id,party_site_id, ' -- Inlcuded 'party_site_id' by spamujul for ER#8473903
761: || c_fmt_mask ||', '
762: || c_curr_code || ', '
763: || c_grade

Line 777: ' SELECT csc_prof_check_results_s.nextval, '

773: -- added party_site_id in the below line for ER#8473903
774: '(check_results_id, check_id, party_id, cust_account_id,party_site_id, value, currency_code, grade, '|| -- Inlcuded 'party_site_id' for ER#8473903
775: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
776: ' results_threshold_flag, rating_code, color_code)' ||
777: ' SELECT csc_prof_check_results_s.nextval, '
778: -- || chk_id || ', party_id, account_id, '
779: -- added party_site_id in the below line for ER#8473903
780: || chk_id || ', party_id, account_id,party_site_id, ' -- Inlcuded 'party_site_id' by spamujul for ER#8473903
781: || c_fmt_mask ||', '

Line 795: ' SELECT csc_prof_check_results_s.nextval, '

791: insert_stmnt_final := 'INSERT /*+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) */ INTO CSC_PROF_BATCH_RESULTS2_T ' ||
792: '(check_results_id, check_id, party_id, cust_account_id, party_site_id,value, currency_code, grade, '|| -- Inlcuded 'party_site_id' for ER#8473903
793: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
794: ' results_threshold_flag, rating_code, color_code)' ||
795: ' SELECT csc_prof_check_results_s.nextval, '
796: || chk_id || ', party_id, account_id,party_site_id ,'
797: || c_fmt_mask ||', '
798: || c_curr_code || ', '
799: || c_grade

Line 851: FROM csc_prof_check_results a

847: last_update_login,
848: results_threshold_flag,
849: rating_code,
850: color_code
851: FROM csc_prof_check_results a
852: WHERE NOT EXISTS (SELECT null FROM csc_prof_checks_b b
853: WHERE a.check_id = b.check_id
854: AND b.select_type = 'B');
855: */

Line 858: EXECUTE IMMEDIATE 'TRUNCATE TABLE '|| v_schema_name ||'.csc_prof_check_results';

854: AND b.select_type = 'B');
855: */
856: COMMIT;
857:
858: EXECUTE IMMEDIATE 'TRUNCATE TABLE '|| v_schema_name ||'.csc_prof_check_results';
859:
860:
861: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
862: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';

Line 861: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';

857:
858: EXECUTE IMMEDIATE 'TRUNCATE TABLE '|| v_schema_name ||'.csc_prof_check_results';
859:
860:
861: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
862: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
863: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
864:
865: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */

Line 862: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';

858: EXECUTE IMMEDIATE 'TRUNCATE TABLE '|| v_schema_name ||'.csc_prof_check_results';
859:
860:
861: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
862: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
863: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
864:
865: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
866: INTO csc_prof_check_results

Line 863: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';

859:
860:
861: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
862: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
863: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
864:
865: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
866: INTO csc_prof_check_results
867: (check_results_id,

Line 865: INSERT /+ PARALLEL (csc_prof_check_results, 12) /

861: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
862: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
863: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
864:
865: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
866: INTO csc_prof_check_results
867: (check_results_id,
868: check_id,
869: party_id,

Line 866: INTO csc_prof_check_results

862: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
863: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
864:
865: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
866: INTO csc_prof_check_results
867: (check_results_id,
868: check_id,
869: party_id,
870: cust_account_id,

Line 905: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';

901: FROM CSC_PROF_BATCH_RESULTS2_T;
902:
903: COMMIT;
904:
905: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
906: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
907: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
908:
909: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;

Line 906: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';

902:
903: COMMIT;
904:
905: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
906: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
907: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
908:
909: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
910:

Line 907: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';

903: COMMIT;
904:
905: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
906: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
907: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
908:
909: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
910:
911: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL DML';

Line 912: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';

908:
909: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
910:
911: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL DML';
912: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';
913:
914: EXCEPTION
915: when Tablesegment_full then
916: CSC_Profile_Engine_PKG.Handle_Exception;

Line 3676: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS NOLOGGING';

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';
3679:
3680: SELECT count(*) INTO v_chk_count FROM csc_prof_check_results;

Line 3680: SELECT count(*) INTO v_chk_count FROM csc_prof_check_results;

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';
3679:
3680: SELECT count(*) INTO v_chk_count FROM csc_prof_check_results;
3681: SELECT count(*) INTO v_batch_count FROM CSC_PROF_BATCH_RESULTS2_T;
3682: IF v_chk_count = 0 AND v_batch_count <> 0 THEN
3683: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
3684: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';

Line 3683: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';

3679:
3680: SELECT count(*) INTO v_chk_count FROM csc_prof_check_results;
3681: SELECT count(*) INTO v_batch_count FROM CSC_PROF_BATCH_RESULTS2_T;
3682: IF v_chk_count = 0 AND v_batch_count <> 0 THEN
3683: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
3684: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
3685: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
3686: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
3687: INTO csc_prof_check_results

Line 3684: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';

3680: SELECT count(*) INTO v_chk_count FROM csc_prof_check_results;
3681: SELECT count(*) INTO v_batch_count FROM CSC_PROF_BATCH_RESULTS2_T;
3682: IF v_chk_count = 0 AND v_batch_count <> 0 THEN
3683: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
3684: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
3685: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
3686: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
3687: INTO csc_prof_check_results
3688: (check_results_id,

Line 3685: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';

3681: SELECT count(*) INTO v_batch_count FROM CSC_PROF_BATCH_RESULTS2_T;
3682: IF v_chk_count = 0 AND v_batch_count <> 0 THEN
3683: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
3684: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
3685: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
3686: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
3687: INTO csc_prof_check_results
3688: (check_results_id,
3689: check_id,

Line 3686: INSERT /+ PARALLEL (csc_prof_check_results, 12) /

3682: IF v_chk_count = 0 AND v_batch_count <> 0 THEN
3683: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
3684: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
3685: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
3686: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
3687: INTO csc_prof_check_results
3688: (check_results_id,
3689: check_id,
3690: party_id,

Line 3687: INTO csc_prof_check_results

3683: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
3684: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
3685: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
3686: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
3687: INTO csc_prof_check_results
3688: (check_results_id,
3689: check_id,
3690: party_id,
3691: cust_account_id,

Line 3724: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';

3720: rating_code,
3721: color_code
3722: FROM CSC_PROF_BATCH_RESULTS2_T;
3723: COMMIT;
3724: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
3725: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
3726: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
3727: END IF;
3728: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;

Line 3725: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';

3721: color_code
3722: FROM CSC_PROF_BATCH_RESULTS2_T;
3723: COMMIT;
3724: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
3725: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
3726: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
3727: END IF;
3728: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
3729: IF g_dashboard_for_contact IS NULL THEN

Line 3726: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';

3722: FROM CSC_PROF_BATCH_RESULTS2_T;
3723: COMMIT;
3724: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
3725: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
3726: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
3727: END IF;
3728: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
3729: IF g_dashboard_for_contact IS NULL THEN
3730: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT', g_dashboard_for_contact);

Line 3964: ' SELECT csc_prof_check_results_s.nextval, '

3960: -- added party_site_id in the below line for ER#8473903
3961: '(check_results_id, check_id, party_id, cust_account_id,party_site_id, value, currency_code, grade, '||
3962: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
3963: ' results_threshold_flag, rating_code, color_code)' ||
3964: ' SELECT csc_prof_check_results_s.nextval, '
3965: -- || chk_id || ', party_id, account_id, '
3966: -- added party_site_id in the below line for ER#8473903
3967: || chk_id || ', party_id, account_id,party_site_id, '
3968: || c_fmt_mask ||', '

Line 3984: ' SELECT csc_prof_check_results_s.nextval, '

3980: -- added party_site_id in the below line for ER#8473903
3981: '(check_results_id, check_id, party_id, cust_account_id,party_site_id, value, currency_code, grade, '||
3982: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
3983: ' results_threshold_flag, rating_code, color_code)' ||
3984: ' SELECT csc_prof_check_results_s.nextval, '
3985: -- || chk_id || ', party_id, account_id, '
3986: -- added party_site_id in the below line for ER#8473903
3987: || chk_id || ', party_id, account_id,party_site_id, '
3988: || c_fmt_mask ||', '

Line 4004: ' SELECT csc_prof_check_results_s.nextval, '

4000: -- added party_site_id in the below line for ER#8473903
4001: '(check_results_id, check_id, party_id, cust_account_id,party_site_id, value, currency_code, grade, '||
4002: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
4003: ' results_threshold_flag, rating_code, color_code)' ||
4004: ' SELECT csc_prof_check_results_s.nextval, '
4005: -- || chk_id || ', party_id, account_id, '
4006: -- added party_site_id in the below line for ER#8473903
4007: || chk_id || ', party_id, account_id,party_site_id, '
4008: || c_fmt_mask ||', '

Line 4062: FROM csc_prof_check_results

4058: last_update_login,
4059: results_threshold_flag,
4060: rating_code,
4061: color_code
4062: FROM csc_prof_check_results
4063: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks
4064: MINUS
4065: SELECT check_id FROM csc_prof_group_checks a
4066: WHERE group_id = p_group_id

Line 4070: EXECUTE IMMEDIATE 'TRUNCATE TABLE '|| v_schema_name ||'.csc_prof_check_results';

4066: WHERE group_id = p_group_id
4067: AND EXISTS (SELECT 1 FROM csc_prof_checks_b b
4068: WHERE a.check_id = b.check_id AND b.select_type = 'B'));
4069: COMMIT;
4070: EXECUTE IMMEDIATE 'TRUNCATE TABLE '|| v_schema_name ||'.csc_prof_check_results';
4071:
4072: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
4073: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
4074: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';

Line 4072: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';

4068: WHERE a.check_id = b.check_id AND b.select_type = 'B'));
4069: COMMIT;
4070: EXECUTE IMMEDIATE 'TRUNCATE TABLE '|| v_schema_name ||'.csc_prof_check_results';
4071:
4072: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
4073: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
4074: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
4075:
4076: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */

Line 4073: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';

4069: COMMIT;
4070: EXECUTE IMMEDIATE 'TRUNCATE TABLE '|| v_schema_name ||'.csc_prof_check_results';
4071:
4072: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
4073: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
4074: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
4075:
4076: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
4077: INTO csc_prof_check_results

Line 4074: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';

4070: EXECUTE IMMEDIATE 'TRUNCATE TABLE '|| v_schema_name ||'.csc_prof_check_results';
4071:
4072: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
4073: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
4074: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
4075:
4076: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
4077: INTO csc_prof_check_results
4078: (check_results_id,

Line 4076: INSERT /+ PARALLEL (csc_prof_check_results, 12) /

4072: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
4073: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
4074: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
4075:
4076: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
4077: INTO csc_prof_check_results
4078: (check_results_id,
4079: check_id,
4080: party_id,

Line 4077: INTO csc_prof_check_results

4073: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
4074: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
4075:
4076: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
4077: INTO csc_prof_check_results
4078: (check_results_id,
4079: check_id,
4080: party_id,
4081: cust_account_id,

Line 4116: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';

4112:
4113: COMMIT;
4114:
4115:
4116: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
4117: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
4118: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
4119:
4120: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;

Line 4117: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';

4113: COMMIT;
4114:
4115:
4116: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
4117: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
4118: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
4119:
4120: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
4121: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;

Line 4118: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';

4114:
4115:
4116: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
4117: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
4118: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
4119:
4120: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
4121: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;
4122:

Line 4124: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';

4120: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
4121: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;
4122:
4123: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL DML';
4124: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';
4125:
4126: EXCEPTION
4127: WHEN Tablesegment_full then
4128: CSC_Profile_Engine_PKG.Handle_Exception;

Line 5126: -- CSC_PROF_CHECK_RESULTS table. Also store the grade if ranges are

5122: END Evaluate_Checks4_Rule;
5123: --
5124: -- Evaluate_One_Check
5125: -- Evaluate the given profile check and store the result in the
5126: -- CSC_PROF_CHECK_RESULTS table. Also store the grade if ranges are
5127: -- specified.
5128: -- IN
5129: -- chk_id - profile check identifier
5130: -- cust_id - customer identifier for which check is evaluated

Line 5224: From csc_prof_check_results

5220: /*
5221: -- for party level
5222: Cursor party_check_crs IS
5223: Select count(*)
5224: From csc_prof_check_results
5225: Where check_id = p_chk_id
5226: And party_id = p_party_id
5227: And cust_account_id IS NULL;
5228:

Line 5232: From csc_prof_check_results

5228:
5229: -- for account level
5230: Cursor account_check_crs IS
5231: Select count(*)
5232: From csc_prof_check_results
5233: Where check_id = p_chk_id
5234: And party_id = p_party_id
5235: And cust_account_id = p_acct_id;
5236: */

Line 5507: from csc_prof_check_results

5503: IF p_acct_id IS NULL THEN
5504: IF p_truncate_flag = 'N' THEN
5505: begin
5506: select 1 into v_party_count
5507: from csc_prof_check_results
5508: where check_id = p_chk_id
5509: and party_id = p_party_id
5510: and cust_account_id is null
5511: and party_site_id is null -- Added by spamujul for ER#8473903

Line 5583: select 1 into v_account_count from csc_prof_check_results

5579: END IF;
5580: ELSE
5581: IF p_truncate_flag = 'N' THEN
5582: begin
5583: select 1 into v_account_count from csc_prof_check_results
5584: where check_id = p_chk_id
5585: and party_id = p_party_id
5586: and party_site_id is null -- Added by spamujul for ER#8473903
5587: and CUST_ACCOUNT_ID =p_acct_id; -- Bug 5255227 Fix

Line 5669: from csc_prof_check_results

5665: Begin
5666: IF p_truncate_flag = 'N' THEN
5667: begin
5668: select 1 into v_psite_count
5669: from csc_prof_check_results
5670: where check_id = p_chk_id
5671: and party_id = p_party_id
5672: and cust_account_id is null
5673: and party_site_id =p_psite_id;

Line 9211: -- Insert or Update Records into Csc_Prof_Check_Results Table

9207:
9208: END Insert_Update_Block_Results;
9209:
9210: --
9211: -- Insert or Update Records into Csc_Prof_Check_Results Table
9212: -- IN
9213: -- p_count - the number of records to be inserted or updated
9214: -- p_for_party - flag to check if the insert or update is for party or account
9215: -- p_for_insert - flag to check if for insert or update.

Line 9237: -- Insert Records into Csc_Prof_Check_Results Table

9233: IF p_for_psite ='N' THEN -- Added by spamujul for ER#8473903
9234: IF p_for_party = 'Y' THEN
9235: -- PARTY level insert or update of records
9236: IF p_for_insert = 'Y' THEN
9237: -- Insert Records into Csc_Prof_Check_Results Table
9238: FORALL i IN 1..p_count
9239: INSERT
9240: INTO Csc_Prof_Check_Results
9241: (

Line 9240: INTO Csc_Prof_Check_Results

9236: IF p_for_insert = 'Y' THEN
9237: -- Insert Records into Csc_Prof_Check_Results Table
9238: FORALL i IN 1..p_count
9239: INSERT
9240: INTO Csc_Prof_Check_Results
9241: (
9242: check_results_id ,
9243: check_id ,
9244: party_id ,

Line 9261: csc_prof_check_results_s.nextval ,

9257: last_update_login
9258: )
9259: VALUES
9260: (
9261: csc_prof_check_results_s.nextval ,
9262: ip_check_id(i) ,
9263: ip_party_id(i) ,
9264: ip_account_id(i) ,
9265: ip_psite_id(i), -- Added by spamujul for ER#8473903

Line 9291: UPDATE Csc_Prof_Check_Results

9287: ip_color_code.DELETE;
9288: ip_results.DELETE;
9289: ELSE
9290: FORALL i IN 1..p_count
9291: UPDATE Csc_Prof_Check_Results
9292: SET value = up_value(i) ,
9293: results_threshold_flag = up_results(i) ,
9294: currency_code = up_currency(i) ,
9295: grade = up_grade(i) ,

Line 9321: -- Insert Records into Csc_Prof_Check_Results Table

9317: END IF;
9318: ELSE
9319: -- ACCOUNT level insert or update of records
9320: IF p_for_insert = 'Y' THEN
9321: -- Insert Records into Csc_Prof_Check_Results Table
9322: FORALL i IN 1..p_count
9323: INSERT
9324: INTO Csc_Prof_Check_Results
9325: (

Line 9324: INTO Csc_Prof_Check_Results

9320: IF p_for_insert = 'Y' THEN
9321: -- Insert Records into Csc_Prof_Check_Results Table
9322: FORALL i IN 1..p_count
9323: INSERT
9324: INTO Csc_Prof_Check_Results
9325: (
9326: check_results_id ,
9327: check_id ,
9328: party_id ,

Line 9345: csc_prof_check_results_s.nextval ,

9341: last_update_login
9342: )
9343: VALUES
9344: (
9345: csc_prof_check_results_s.nextval ,
9346: ia_check_id(i) ,
9347: ia_party_id(i) ,
9348: ia_account_id(i) ,
9349: ia_psite_id(i) , -- Added by spamujul for ER#8473903

Line 9375: UPDATE Csc_Prof_Check_Results

9371: ia_color_code.DELETE;
9372: ia_results.DELETE;
9373: ELSE
9374: FORALL i IN 1..p_count
9375: UPDATE Csc_Prof_Check_Results
9376: SET value = ua_value(i) ,
9377: results_threshold_flag = ua_results(i) ,
9378: currency_code = ua_currency(i) ,
9379: grade = ua_grade(i) ,

Line 9408: INTO Csc_Prof_Check_Results

9404: ELSE
9405: IF p_for_insert = 'Y' THEN
9406: FORALL i IN 1..p_count
9407: INSERT
9408: INTO Csc_Prof_Check_Results
9409: (
9410: check_results_id ,
9411: check_id ,
9412: party_id ,

Line 9429: csc_prof_check_results_s.nextval ,

9425: last_update_login
9426: )
9427: VALUES
9428: (
9429: csc_prof_check_results_s.nextval ,
9430: is_check_id(i) ,
9431: is_party_id(i) ,
9432: is_account_id(i) ,
9433: is_psite_id(i) ,

Line 9459: UPDATE Csc_Prof_Check_Results

9455: is_color_code.DELETE;
9456: is_results.DELETE;
9457: ELSE
9458: FORALL i IN 1..p_count
9459: UPDATE Csc_Prof_Check_Results
9460: SET value = us_value(i) ,
9461: results_threshold_flag = us_results(i) ,
9462: currency_code = us_currency(i) ,
9463: grade = us_grade(i) ,

Line 10710: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';

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';
10714: END Handle_Exception;

Line 10711: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';

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';
10714: END Handle_Exception;
10715:

Line 10712: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';

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';
10714: END Handle_Exception;
10715:
10716: /******************************

Line 10713: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';

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';
10714: END Handle_Exception;
10715:
10716: /******************************
10717: * End Utilities Definition *