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_RESULTS1_T

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

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

Line 527: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;

523: v_party_in_sql := 0;
524: v_acct_in_sql := 0;
525: End if;
526:
527: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;
528: insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || batch_sql_stmnt;
529: EXECUTE IMMEDIATE (insert_stmnt);
530:
531: IF v_acct_in_sql <> 0 AND v_check_level = 'PARTY' THEN

Line 528: insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || batch_sql_stmnt;

524: v_acct_in_sql := 0;
525: End if;
526:
527: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;
528: insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || batch_sql_stmnt;
529: EXECUTE IMMEDIATE (insert_stmnt);
530:
531: IF v_acct_in_sql <> 0 AND v_check_level = 'PARTY' THEN
532:

Line 557: insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || v_select_sum ;

553: csc_core_utils_pvt.validate_sql_stmnt( p_sql_stmnt => v_select_sum,
554: x_return_status => return_status);
555:
556: IF return_status = 'S' THEN
557: insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || v_select_sum ;
558: EXECUTE IMMEDIATE (insert_stmnt_sum);
559: ELSE
560: RAISE SUMMATION_ERROR;
561: fnd_file.put_line(fnd_file.log, 'Summation SQL failed for check_id' || chk_id);

Line 567: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)

563:
564: END IF;
565:
566: IF v_check_level = 'PARTY' THEN
567: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
568: SELECT party_id, NULL, NULL
569: FROM hz_parties hz
570: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
571: AND hz.status = 'A'

Line 570: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)

566: IF v_check_level = 'PARTY' THEN
567: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
568: SELECT party_id, NULL, NULL
569: FROM hz_parties hz
570: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
571: AND hz.status = 'A'
572: AND hz.party_type IN ('PERSON', 'ORGANIZATION');
573: ELSIF v_check_level = 'CONTACT' THEN
574: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)

Line 574: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)

570: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
571: AND hz.status = 'A'
572: AND hz.party_type IN ('PERSON', 'ORGANIZATION');
573: ELSIF v_check_level = 'CONTACT' THEN
574: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
575: SELECT party_id, NULL, NULL
576: FROM hz_parties hz
577: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
578: AND hz.status = 'A'

Line 577: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)

573: ELSIF v_check_level = 'CONTACT' THEN
574: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
575: SELECT party_id, NULL, NULL
576: FROM hz_parties hz
577: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
578: AND hz.status = 'A'
579: AND hz.party_type = 'PARTY_RELATIONSHIP';
580: ELSIF v_check_level = 'ACCOUNT' THEN
581: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)

Line 581: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)

577: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
578: AND hz.status = 'A'
579: AND hz.party_type = 'PARTY_RELATIONSHIP';
580: ELSIF v_check_level = 'ACCOUNT' THEN
581: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
582: SELECT party_id, cust_account_id, NULL
583: FROM hz_cust_accounts hz
584: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.account_id = hz.cust_account_id)
585: AND hz.status = 'A';

Line 584: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.account_id = hz.cust_account_id)

580: ELSIF v_check_level = 'ACCOUNT' THEN
581: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
582: SELECT party_id, cust_account_id, NULL
583: FROM hz_cust_accounts hz
584: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.account_id = hz.cust_account_id)
585: AND hz.status = 'A';
586: ELSIF v_check_level = 'EMPLOYEE' THEN
587: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
588: SELECT person_id, NULL, NULL

Line 587: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)

583: FROM hz_cust_accounts hz
584: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.account_id = hz.cust_account_id)
585: AND hz.status = 'A';
586: ELSIF v_check_level = 'EMPLOYEE' THEN
587: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
588: SELECT person_id, NULL, NULL
589: FROM per_workforce_current_x hz
590: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.person_id) ;
591:

Line 590: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.person_id) ;

586: ELSIF v_check_level = 'EMPLOYEE' THEN
587: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
588: SELECT person_id, NULL, NULL
589: FROM per_workforce_current_x hz
590: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.person_id) ;
591:
592: END IF;
593:
594: OPEN val_csr3;

Line 666: ||' FROM CSC_PROF_BATCH_RESULTS1_T where nvl(account_id, -999999) <> -999999';

662: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
663: || c_threshold ||', '
664: || c_rating || ', '
665: || c_color
666: ||' FROM CSC_PROF_BATCH_RESULTS1_T where nvl(account_id, -999999) <> -999999';
667: ELSE
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, '||

Line 681: ||' FROM CSC_PROF_BATCH_RESULTS1_T where account_id IS NULL';

677: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
678: || c_threshold ||', '
679: || c_rating || ', '
680: || c_color
681: ||' FROM CSC_PROF_BATCH_RESULTS1_T where account_id IS NULL';
682: END IF;
683:
684: EXECUTE IMMEDIATE (insert_stmnt_final);
685: COMMIT;

Line 2602: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_BATCH_RESULTS1_T NOLOGGING';

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

Line 2709: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;

2705: v_party_in_sql := 0;
2706: v_acct_in_sql := 0;
2707: END IF;
2708:
2709: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;
2710:
2711: insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || batch_sql_stmnt;
2712: EXECUTE IMMEDIATE (insert_stmnt);
2713:

Line 2711: insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || batch_sql_stmnt;

2707: END IF;
2708:
2709: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;
2710:
2711: insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || batch_sql_stmnt;
2712: EXECUTE IMMEDIATE (insert_stmnt);
2713:
2714: IF v_acct_in_sql <> 0 AND v_check_level = 'PARTY' THEN
2715:

Line 2740: insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || v_select_sum ;

2736: csc_core_utils_pvt.validate_sql_stmnt( p_sql_stmnt => v_select_sum,
2737: x_return_status => return_status);
2738:
2739: IF return_status = 'S' THEN
2740: insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || v_select_sum ;
2741: EXECUTE IMMEDIATE (insert_stmnt_sum);
2742: ELSE
2743: RAISE SUMMATION_ERROR;
2744: fnd_file.put_line(fnd_file.log, 'Summation SQL failed for check_id' || chk_id);

Line 2750: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)

2746:
2747: END IF;
2748:
2749: IF v_check_level = 'PARTY' THEN
2750: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
2751: SELECT party_id, NULL, NULL
2752: FROM hz_parties hz
2753: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
2754: AND hz.status = 'A'

Line 2753: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)

2749: IF v_check_level = 'PARTY' THEN
2750: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
2751: SELECT party_id, NULL, NULL
2752: FROM hz_parties hz
2753: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
2754: AND hz.status = 'A'
2755: AND hz.party_type IN ('PERSON', 'ORGANIZATION');
2756: ELSIF v_check_level = 'CONTACT' THEN
2757: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)

Line 2757: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)

2753: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
2754: AND hz.status = 'A'
2755: AND hz.party_type IN ('PERSON', 'ORGANIZATION');
2756: ELSIF v_check_level = 'CONTACT' THEN
2757: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
2758: SELECT party_id, NULL, NULL
2759: FROM hz_parties hz
2760: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
2761: AND hz.status = 'A'

Line 2760: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)

2756: ELSIF v_check_level = 'CONTACT' THEN
2757: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
2758: SELECT party_id, NULL, NULL
2759: FROM hz_parties hz
2760: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
2761: AND hz.status = 'A'
2762: AND hz.party_type = 'PARTY_RELATIONSHIP';
2763: ELSIF v_check_level = 'ACCOUNT' THEN
2764: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)

Line 2764: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)

2760: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
2761: AND hz.status = 'A'
2762: AND hz.party_type = 'PARTY_RELATIONSHIP';
2763: ELSIF v_check_level = 'ACCOUNT' THEN
2764: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
2765: SELECT party_id, cust_account_id, NULL
2766: FROM hz_cust_accounts hz
2767: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.account_id = hz.cust_account_id)
2768: AND hz.status = 'A';

Line 2767: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.account_id = hz.cust_account_id)

2763: ELSIF v_check_level = 'ACCOUNT' THEN
2764: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
2765: SELECT party_id, cust_account_id, NULL
2766: FROM hz_cust_accounts hz
2767: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.account_id = hz.cust_account_id)
2768: AND hz.status = 'A';
2769: ELSIF v_check_level = 'EMPLOYEE' THEN
2770: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
2771: SELECT person_id, NULL, NULL

Line 2770: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)

2766: FROM hz_cust_accounts hz
2767: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.account_id = hz.cust_account_id)
2768: AND hz.status = 'A';
2769: ELSIF v_check_level = 'EMPLOYEE' THEN
2770: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
2771: SELECT person_id, NULL, NULL
2772: FROM per_workforce_current_x hz
2773: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.person_id) ;
2774:

Line 2773: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.person_id) ;

2769: ELSIF v_check_level = 'EMPLOYEE' THEN
2770: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
2771: SELECT person_id, NULL, NULL
2772: FROM per_workforce_current_x hz
2773: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.person_id) ;
2774:
2775: END IF;
2776:
2777: OPEN val_csr3;

Line 2848: ||' FROM CSC_PROF_BATCH_RESULTS1_T where nvl(account_id, -999999) <> -999999';

2844: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
2845: || c_threshold ||', '
2846: || c_rating || ', '
2847: || c_color
2848: ||' FROM CSC_PROF_BATCH_RESULTS1_T where nvl(account_id, -999999) <> -999999';
2849: ELSE
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, '||

Line 2863: ||' FROM CSC_PROF_BATCH_RESULTS1_T where account_id IS NULL';

2859: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
2860: || c_threshold ||', '
2861: || c_rating || ', '
2862: || c_color
2863: ||' FROM CSC_PROF_BATCH_RESULTS1_T where account_id IS NULL';
2864: END IF;
2865:
2866: EXECUTE IMMEDIATE (insert_stmnt_final);
2867: COMMIT;

Line 2926: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;

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