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.

APPS.CSC_PROFILE_ENGINE_PKG dependencies on CSC_PROF_CHECK_RESULTS

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

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

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

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';
423:
424: SELECT count(*) INTO v_chk_count FROM csc_prof_check_results;
425: SELECT count(*) INTO v_batch_count FROM CSC_PROF_BATCH_RESULTS2_T;
426:
427: IF v_chk_count = 0 AND v_batch_count <> 0 THEN
428:

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

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

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

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

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

428:
429:
430: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
431: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
432: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
433:
434: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
435: INTO csc_prof_check_results
436: (check_results_id, check_id, party_id, cust_account_id,

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

430: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
431: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
432: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
433:
434: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
435: INTO csc_prof_check_results
436: (check_results_id, check_id, party_id, cust_account_id,
437: value, currency_code, grade, created_by, creation_date,
438: last_updated_by, last_update_date, last_update_login,

Line 435: INTO csc_prof_check_results

431: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
432: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
433:
434: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
435: INTO csc_prof_check_results
436: (check_results_id, check_id, party_id, cust_account_id,
437: value, currency_code, grade, created_by, creation_date,
438: last_updated_by, last_update_date, last_update_login,
439: results_threshold_flag, rating_code, color_code

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

446: FROM CSC_PROF_BATCH_RESULTS2_T;
447:
448: COMMIT;
449:
450: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
451: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
452: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
453:
454: END IF;

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

447:
448: COMMIT;
449:
450: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
451: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
452: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
453:
454: END IF;
455: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;

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

448: COMMIT;
449:
450: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
451: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
452: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
453:
454: END IF;
455: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
456:

Line 657: ' SELECT csc_prof_check_results_s.nextval, '

653: insert_stmnt_final := 'INSERT /*+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) */ INTO CSC_PROF_BATCH_RESULTS2_T ' ||
654: '(check_results_id, check_id, party_id, cust_account_id, value, currency_code, grade, '||
655: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
656: ' results_threshold_flag, rating_code, color_code)' ||
657: ' SELECT csc_prof_check_results_s.nextval, '
658: || chk_id || ', party_id, account_id, '
659: || c_fmt_mask ||', '
660: || c_curr_code || ', '
661: || c_grade

Line 672: ' SELECT csc_prof_check_results_s.nextval, '

668: insert_stmnt_final := 'INSERT /*+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) */ INTO CSC_PROF_BATCH_RESULTS2_T ' ||
669: '(check_results_id, check_id, party_id, cust_account_id, value, currency_code, grade, '||
670: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
671: ' results_threshold_flag, rating_code, color_code)' ||
672: ' SELECT csc_prof_check_results_s.nextval, '
673: || chk_id || ', party_id, account_id, '
674: || c_fmt_mask ||', '
675: || c_curr_code || ', '
676: || c_grade

Line 706: FROM csc_prof_check_results a

702: check_results_id, check_id, party_id, cust_account_id,
703: value, currency_code, grade, created_by, creation_date,
704: last_updated_by, last_update_date, last_update_login,
705: results_threshold_flag, rating_code, color_code
706: FROM csc_prof_check_results a
707: WHERE NOT EXISTS (SELECT null FROM csc_prof_checks_b b
708: WHERE a.check_id = b.check_id
709: AND b.select_type = 'B');
710:

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

709: AND b.select_type = 'B');
710:
711: COMMIT;
712:
713: EXECUTE IMMEDIATE 'TRUNCATE TABLE '|| v_schema_name ||'.csc_prof_check_results';
714:
715:
716: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
717: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';

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

712:
713: EXECUTE IMMEDIATE 'TRUNCATE TABLE '|| v_schema_name ||'.csc_prof_check_results';
714:
715:
716: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
717: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
718: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
719:
720: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */

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

713: EXECUTE IMMEDIATE 'TRUNCATE TABLE '|| v_schema_name ||'.csc_prof_check_results';
714:
715:
716: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
717: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
718: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
719:
720: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
721: INTO csc_prof_check_results

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

714:
715:
716: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
717: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
718: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
719:
720: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
721: INTO csc_prof_check_results
722: (check_results_id, check_id, party_id, cust_account_id,

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

716: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
717: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
718: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
719:
720: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
721: INTO csc_prof_check_results
722: (check_results_id, check_id, party_id, cust_account_id,
723: value, currency_code, grade, created_by, creation_date,
724: last_updated_by, last_update_date, last_update_login,

Line 721: INTO csc_prof_check_results

717: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
718: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
719:
720: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
721: INTO csc_prof_check_results
722: (check_results_id, check_id, party_id, cust_account_id,
723: value, currency_code, grade, created_by, creation_date,
724: last_updated_by, last_update_date, last_update_login,
725: results_threshold_flag, rating_code, color_code

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

733:
734: COMMIT;
735:
736:
737: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
738: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
739: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
740:
741: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;

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

734: COMMIT;
735:
736:
737: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
738: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
739: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
740:
741: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
742:

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

735:
736:
737: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
738: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
739: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
740:
741: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
742:
743: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL DML';

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

740:
741: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
742:
743: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL DML';
744: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';
745:
746: EXCEPTION
747: when Tablesegment_full then
748: CSC_Profile_Engine_PKG.Handle_Exception;

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

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

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

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';
2603:
2604: SELECT count(*) INTO v_chk_count FROM csc_prof_check_results;
2605: SELECT count(*) INTO v_batch_count FROM CSC_PROF_BATCH_RESULTS2_T;
2606:
2607: IF v_chk_count = 0 AND v_batch_count <> 0 THEN
2608:

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

2606:
2607: IF v_chk_count = 0 AND v_batch_count <> 0 THEN
2608:
2609:
2610: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
2611: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
2612: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
2613:
2614: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */

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

2607: IF v_chk_count = 0 AND v_batch_count <> 0 THEN
2608:
2609:
2610: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
2611: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
2612: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
2613:
2614: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
2615: INTO csc_prof_check_results

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

2608:
2609:
2610: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
2611: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
2612: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
2613:
2614: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
2615: INTO csc_prof_check_results
2616: (check_results_id, check_id, party_id, cust_account_id,

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

2610: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
2611: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
2612: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
2613:
2614: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
2615: INTO csc_prof_check_results
2616: (check_results_id, check_id, party_id, cust_account_id,
2617: value, currency_code, grade, created_by, creation_date,
2618: last_updated_by, last_update_date, last_update_login,

Line 2615: INTO csc_prof_check_results

2611: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
2612: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
2613:
2614: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
2615: INTO csc_prof_check_results
2616: (check_results_id, check_id, party_id, cust_account_id,
2617: value, currency_code, grade, created_by, creation_date,
2618: last_updated_by, last_update_date, last_update_login,
2619: results_threshold_flag, rating_code, color_code

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

2627:
2628: COMMIT;
2629:
2630:
2631: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
2632: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
2633: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
2634:
2635: END IF;

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

2628: COMMIT;
2629:
2630:
2631: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
2632: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
2633: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
2634:
2635: END IF;
2636: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;

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

2629:
2630:
2631: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
2632: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
2633: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
2634:
2635: END IF;
2636: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
2637:

Line 2839: ' SELECT csc_prof_check_results_s.nextval, '

2835: insert_stmnt_final := 'INSERT /*+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) */ INTO CSC_PROF_BATCH_RESULTS2_T ' ||
2836: '(check_results_id, check_id, party_id, cust_account_id, value, currency_code, grade, '||
2837: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
2838: ' results_threshold_flag, rating_code, color_code)' ||
2839: ' SELECT csc_prof_check_results_s.nextval, '
2840: || chk_id || ', party_id, account_id, '
2841: || c_fmt_mask ||', '
2842: || c_curr_code || ', '
2843: || c_grade

Line 2854: ' SELECT csc_prof_check_results_s.nextval, '

2850: insert_stmnt_final := 'INSERT /*+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) */ INTO CSC_PROF_BATCH_RESULTS2_T ' ||
2851: '(check_results_id, check_id, party_id, cust_account_id, value, currency_code, grade, '||
2852: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
2853: ' results_threshold_flag, rating_code, color_code)' ||
2854: ' SELECT csc_prof_check_results_s.nextval, '
2855: || chk_id || ', party_id, account_id, '
2856: || c_fmt_mask ||', '
2857: || c_curr_code || ', '
2858: || c_grade

Line 2887: FROM csc_prof_check_results

2883: check_results_id, check_id, party_id, cust_account_id,
2884: value, currency_code, grade, created_by, creation_date,
2885: last_updated_by, last_update_date, last_update_login,
2886: results_threshold_flag, rating_code, color_code
2887: FROM csc_prof_check_results
2888: WHERE check_id IN (SELECT check_id FROM csc_prof_group_checks
2889: MINUS
2890: SELECT check_id FROM csc_prof_group_checks a
2891: WHERE group_id = p_group_id

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

2893: WHERE a.check_id = b.check_id AND b.select_type = 'B'));
2894:
2895: COMMIT;
2896:
2897: EXECUTE IMMEDIATE 'TRUNCATE TABLE '|| v_schema_name ||'.csc_prof_check_results';
2898:
2899:
2900: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
2901: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';

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

2896:
2897: EXECUTE IMMEDIATE 'TRUNCATE TABLE '|| v_schema_name ||'.csc_prof_check_results';
2898:
2899:
2900: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
2901: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
2902: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
2903:
2904: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */

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

2897: EXECUTE IMMEDIATE 'TRUNCATE TABLE '|| v_schema_name ||'.csc_prof_check_results';
2898:
2899:
2900: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
2901: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
2902: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
2903:
2904: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
2905: INTO csc_prof_check_results

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

2898:
2899:
2900: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
2901: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
2902: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
2903:
2904: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
2905: INTO csc_prof_check_results
2906: (check_results_id, check_id, party_id, cust_account_id,

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

2900: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 UNUSABLE';
2901: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
2902: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
2903:
2904: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
2905: INTO csc_prof_check_results
2906: (check_results_id, check_id, party_id, cust_account_id,
2907: value, currency_code, grade, created_by, creation_date,
2908: last_updated_by, last_update_date, last_update_login,

Line 2905: INTO csc_prof_check_results

2901: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 UNUSABLE';
2902: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';
2903:
2904: INSERT /*+ PARALLEL (csc_prof_check_results, 12) */
2905: INTO csc_prof_check_results
2906: (check_results_id, check_id, party_id, cust_account_id,
2907: value, currency_code, grade, created_by, creation_date,
2908: last_updated_by, last_update_date, last_update_login,
2909: results_threshold_flag, rating_code, color_code

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

2917:
2918: COMMIT;
2919:
2920:
2921: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
2922: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
2923: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
2924:
2925: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;

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

2918: COMMIT;
2919:
2920:
2921: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
2922: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
2923: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
2924:
2925: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
2926: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;

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

2919:
2920:
2921: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
2922: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
2923: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
2924:
2925: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
2926: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;
2927:

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

2925: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
2926: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;
2927:
2928: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL DML';
2929: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';
2930:
2931: EXCEPTION
2932: WHEN Tablesegment_full then
2933: CSC_Profile_Engine_PKG.Handle_Exception;

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

3643: END Evaluate_Checks4_Rule;
3644: --
3645: -- Evaluate_One_Check
3646: -- Evaluate the given profile check and store the result in the
3647: -- CSC_PROF_CHECK_RESULTS table. Also store the grade if ranges are
3648: -- specified.
3649: -- IN
3650: -- chk_id - profile check identifier
3651: -- cust_id - customer identifier for which check is evaluated

Line 3734: From csc_prof_check_results

3730: /*
3731: -- for party level
3732: Cursor party_check_crs IS
3733: Select count(*)
3734: From csc_prof_check_results
3735: Where check_id = p_chk_id
3736: And party_id = p_party_id
3737: And cust_account_id IS NULL;
3738:

Line 3742: From csc_prof_check_results

3738:
3739: -- for account level
3740: Cursor account_check_crs IS
3741: Select count(*)
3742: From csc_prof_check_results
3743: Where check_id = p_chk_id
3744: And party_id = p_party_id
3745: And cust_account_id = p_acct_id;
3746: */

Line 4017: from csc_prof_check_results

4013: IF p_acct_id IS NULL THEN
4014: IF p_truncate_flag = 'N' THEN
4015: begin
4016: select 1 into v_party_count
4017: from csc_prof_check_results
4018: where check_id = p_chk_id
4019: and party_id = p_party_id
4020: and cust_account_id is null;
4021: exception when no_data_found then

Line 4085: select 1 into v_account_count from csc_prof_check_results

4081:
4082: ELSE
4083: IF p_truncate_flag = 'N' THEN
4084: begin
4085: select 1 into v_account_count from csc_prof_check_results
4086: where check_id = p_chk_id
4087: and party_id = p_party_id
4088: and CUST_ACCOUNT_ID =p_acct_id; -- Bug 5255227 Fix
4089: exception when no_data_found then

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

6571:
6572: END Insert_Update_Block_Results;
6573:
6574: --
6575: -- Insert or Update Records into Csc_Prof_Check_Results Table
6576: -- IN
6577: -- p_count - the number of records to be inserted or updated
6578: -- p_for_party - flag to check if the insert or update is for party or account
6579: -- p_for_insert - flag to check if for insert or update.

Line 6602: -- Insert Records into Csc_Prof_Check_Results Table

6598:
6599: IF p_for_party = 'Y' THEN
6600: -- PARTY level insert or update of records
6601: IF p_for_insert = 'Y' THEN
6602: -- Insert Records into Csc_Prof_Check_Results Table
6603:
6604: FORALL i IN 1..p_count
6605: INSERT INTO Csc_Prof_Check_Results
6606: ( check_results_id

Line 6605: INSERT INTO Csc_Prof_Check_Results

6601: IF p_for_insert = 'Y' THEN
6602: -- Insert Records into Csc_Prof_Check_Results Table
6603:
6604: FORALL i IN 1..p_count
6605: INSERT INTO Csc_Prof_Check_Results
6606: ( check_results_id
6607: , check_id
6608: , party_id
6609: , cust_account_id

Line 6622: (csc_prof_check_results_s.nextval

6618: , last_updated_by
6619: , last_update_date
6620: , last_update_login)
6621: VALUES
6622: (csc_prof_check_results_s.nextval
6623: , ip_check_id(i)
6624: , ip_party_id(i)
6625: , ip_account_id(i)
6626: , ip_value(i)

Line 6650: UPDATE Csc_Prof_Check_Results

6646: ip_results.DELETE;
6647:
6648: ELSE
6649: FORALL i IN 1..p_count
6650: UPDATE Csc_Prof_Check_Results
6651: Set value = up_value(i)
6652: , results_threshold_flag = up_results(i)
6653: , currency_code = up_currency(i)
6654: , grade = up_grade(i)

Line 6678: -- Insert Records into Csc_Prof_Check_Results Table

6674: END IF;
6675: ELSE
6676: -- ACCOUNT level insert or update of records
6677: IF p_for_insert = 'Y' THEN
6678: -- Insert Records into Csc_Prof_Check_Results Table
6679:
6680: FORALL i IN 1..p_count
6681: INSERT INTO Csc_Prof_Check_Results
6682: ( check_results_id

Line 6681: INSERT INTO Csc_Prof_Check_Results

6677: IF p_for_insert = 'Y' THEN
6678: -- Insert Records into Csc_Prof_Check_Results Table
6679:
6680: FORALL i IN 1..p_count
6681: INSERT INTO Csc_Prof_Check_Results
6682: ( check_results_id
6683: , check_id
6684: , party_id
6685: , cust_account_id

Line 6698: (csc_prof_check_results_s.nextval

6694: , last_updated_by
6695: , last_update_date
6696: , last_update_login)
6697: VALUES
6698: (csc_prof_check_results_s.nextval
6699: , ia_check_id(i)
6700: , ia_party_id(i)
6701: , ia_account_id(i)
6702: , ia_value(i)

Line 6726: UPDATE Csc_Prof_Check_Results

6722: ia_results.DELETE;
6723:
6724: ELSE
6725: FORALL i IN 1..p_count
6726: UPDATE Csc_Prof_Check_Results
6727: Set value = ua_value(i)
6728: , results_threshold_flag = ua_results(i)
6729: , currency_code = ua_currency(i)
6730: , grade = ua_grade(i)

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

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';
7964: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
7965:
7966: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';

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

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';
7964: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
7965:
7966: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';
7967: END Handle_Exception;

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

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';
7964: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
7965:
7966: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';
7967: END Handle_Exception;
7968:

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

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';
7964: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
7965:
7966: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';
7967: END Handle_Exception;
7968:
7969:
7970: /******************************