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_BATCH_RESULTS2_T

Line 422: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_BATCH_RESULTS2_T NOLOGGING';

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
426: FROM csc_prof_check_results;

Line 430: FROM CSC_PROF_BATCH_RESULTS2_T;

426: FROM csc_prof_check_results;
427:
428: SELECT count(*)
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';

Line 471: FROM CSC_PROF_BATCH_RESULTS2_T;

467: last_update_login,
468: results_threshold_flag,
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';

Line 477: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;

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);
480: END IF;
481: /* R12 Employee HelpDesk Modifications */

Line 755: insert_stmnt_final := 'INSERT /+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) / INTO CSC_PROF_BATCH_RESULTS2_T ' ||

751: '''' || v_count || '''' || ')' ;
752:
753:
754: IF v_check_level = 'ACCOUNT' THEN
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, '

Line 771: insert_stmnt_final := 'INSERT /+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) / INTO CSC_PROF_BATCH_RESULTS2_T ' ||

767: || c_color
768: ||' FROM CSC_PROF_BATCH_RESULTS1_T where nvl(account_id, -999999) <> -999999 and PARTY_SITE_ID IS NULL'; -- Inlcuded 'party_site_id' IS NULL FOR ER#8473903
769: -- Begin fix by spamujul for ER# 8473903
770: ELSIF v_check_level = 'SITE' THEN
771: insert_stmnt_final := 'INSERT /*+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) */ INTO CSC_PROF_BATCH_RESULTS2_T ' ||
772: -- '(check_results_id, check_id, party_id, cust_account_id,value, currency_code, grade, '||
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, '||

Line 791: insert_stmnt_final := 'INSERT /+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) / INTO CSC_PROF_BATCH_RESULTS2_T ' ||

787: || c_color
788: ||' FROM CSC_PROF_BATCH_RESULTS1_T where nvl(party_site_id, -999999) <> -999999 and account_id IS NULL';
789: -- End fix by spamujul for ER#8473903
790: ELSE
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, '

Line 815: -- INSERT /+ PARALLEL (CSC_PROF_BATCH_RESULTS2_T, 12) /

811: END IF ; /* batch_sql_stmnt IS NOT NULL */
812: END LOOP;
813: CLOSE checks_csr;
814:
815: -- INSERT /*+ PARALLEL (CSC_PROF_BATCH_RESULTS2_T, 12) */
816: /* INTO CSC_PROF_BATCH_RESULTS2_T
817: (check_results_id,
818: check_id,
819: party_id,

Line 816: /* INTO CSC_PROF_BATCH_RESULTS2_T

812: END LOOP;
813: CLOSE checks_csr;
814:
815: -- INSERT /*+ PARALLEL (CSC_PROF_BATCH_RESULTS2_T, 12) */
816: /* INTO CSC_PROF_BATCH_RESULTS2_T
817: (check_results_id,
818: check_id,
819: party_id,
820: cust_account_id,

Line 901: FROM CSC_PROF_BATCH_RESULTS2_T;

897: last_update_login,
898: results_threshold_flag,
899: rating_code,
900: color_code
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';

Line 909: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;

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';
912: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';
913:

Line 3677: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_BATCH_RESULTS2_T NOLOGGING';

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;
3681: SELECT count(*) INTO v_batch_count FROM CSC_PROF_BATCH_RESULTS2_T;

Line 3681: SELECT count(*) INTO v_batch_count FROM CSC_PROF_BATCH_RESULTS2_T;

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';
3685: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 UNUSABLE';

Line 3722: FROM CSC_PROF_BATCH_RESULTS2_T;

3718: last_update_login,
3719: results_threshold_flag,
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';

Line 3728: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;

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);
3731: END IF;
3732: /* R12 Employee HelpDesk Modifications */

Line 3958: insert_stmnt_final := 'INSERT /+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) / INTO CSC_PROF_BATCH_RESULTS2_T ' ||

3954: '''' || 'COLOR' || '''' ||', ' ||
3955: '''' || v_count || '''' || ')' ;
3956:
3957: IF v_check_level = 'ACCOUNT' THEN
3958: insert_stmnt_final := 'INSERT /*+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) */ INTO CSC_PROF_BATCH_RESULTS2_T ' ||
3959: -- '(check_results_id, check_id, party_id, cust_account_id,value, currency_code, grade, '||
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, '||

Line 3978: insert_stmnt_final := 'INSERT /+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) / INTO CSC_PROF_BATCH_RESULTS2_T ' ||

3974: || c_color
3975: ||' FROM CSC_PROF_BATCH_RESULTS1_T where nvl(account_id, -999999) <> -999999 and party_site_id IS NULL'; -- Added 'AND PARTY_SITE_ID IS NULL' for ER#8473903
3976: -- Begin fix by spamujul for ER# 8473903
3977: ELSIF v_check_level = 'SITE' THEN
3978: insert_stmnt_final := 'INSERT /*+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) */ INTO CSC_PROF_BATCH_RESULTS2_T ' ||
3979: -- '(check_results_id, check_id, party_id, cust_account_id,value, currency_code, grade, '||
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, '||

Line 3998: insert_stmnt_final := 'INSERT /+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) / INTO CSC_PROF_BATCH_RESULTS2_T ' ||

3994: || c_color
3995: ||' FROM CSC_PROF_BATCH_RESULTS1_T where nvl(party_site_id, -999999) <> -999999 and account_id IS NULL';
3996: -- End fix by spamujul for ER#8473903
3997: ELSE
3998: insert_stmnt_final := 'INSERT /*+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) */ INTO CSC_PROF_BATCH_RESULTS2_T ' ||
3999: -- '(check_results_id, check_id, party_id, cust_account_id, value, currency_code, grade, '||
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, '||

Line 4026: INSERT /+ PARALLEL (CSC_PROF_BATCH_RESULTS2_T, 12) /

4022: END IF ; /* batch_sql_stmnt IS NOT NULL */
4023: END LOOP;
4024: CLOSE checks_csr;
4025:
4026: INSERT /*+ PARALLEL (CSC_PROF_BATCH_RESULTS2_T, 12) */
4027: INTO CSC_PROF_BATCH_RESULTS2_T
4028: (check_results_id,
4029: check_id,
4030: party_id,

Line 4027: INTO CSC_PROF_BATCH_RESULTS2_T

4023: END LOOP;
4024: CLOSE checks_csr;
4025:
4026: INSERT /*+ PARALLEL (CSC_PROF_BATCH_RESULTS2_T, 12) */
4027: INTO CSC_PROF_BATCH_RESULTS2_T
4028: (check_results_id,
4029: check_id,
4030: party_id,
4031: cust_account_id,

Line 4111: FROM CSC_PROF_BATCH_RESULTS2_T;

4107: last_update_date,
4108: last_update_login,
4109: results_threshold_flag,
4110: rating_code, color_code
4111: FROM CSC_PROF_BATCH_RESULTS2_T;
4112:
4113: COMMIT;
4114:
4115:

Line 4120: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;

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:
4123: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL DML';
4124: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';