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_BATCH_RESULTS1_T

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

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;
427:

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

567: v_party_in_sql := 0;
568: v_acct_in_sql := 0;
569: v_psite_in_sql := 0; -- Added by spamujul for ER#8473903
570: End if;
571: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;
572:
573: --insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || batch_sql_stmnt; -- Commented the following code by spamujul for ER#8473903
574: -- Added the following code by spamujul for ER#8473903
575: insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE) ' || batch_sql_stmnt;

Line 573: --insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || batch_sql_stmnt; -- Commented the following code by spamujul for ER#8473903

569: v_psite_in_sql := 0; -- Added by spamujul for ER#8473903
570: End if;
571: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;
572:
573: --insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || batch_sql_stmnt; -- Commented the following code by spamujul for ER#8473903
574: -- Added the following code by spamujul for ER#8473903
575: insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE) ' || batch_sql_stmnt;
576: EXECUTE IMMEDIATE (insert_stmnt);
577: IF v_acct_in_sql <> 0 AND v_check_level = 'PARTY' THEN

Line 575: insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE) ' || batch_sql_stmnt;

571: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;
572:
573: --insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || batch_sql_stmnt; -- Commented the following code by spamujul for ER#8473903
574: -- Added the following code by spamujul for ER#8473903
575: insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE) ' || batch_sql_stmnt;
576: EXECUTE IMMEDIATE (insert_stmnt);
577: IF v_acct_in_sql <> 0 AND v_check_level = 'PARTY' THEN
578: v_select_pos := NULL;
579: v_select_length := NULL;

Line 599: -- insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || v_select_sum ; -- Commented the following code by spamujul for ER#8473903

595: -- validate the sql statement
596: csc_core_utils_pvt.validate_sql_stmnt( p_sql_stmnt => v_select_sum,
597: x_return_status => return_status);
598: IF return_status = 'S' THEN
599: -- insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || v_select_sum ; -- Commented the following code by spamujul for ER#8473903
600: -- Added the following code by spamujul for ER#8473903
601: insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE) ' || v_select_sum ;
602: EXECUTE IMMEDIATE (insert_stmnt_sum);
603: ELSE

Line 601: insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE) ' || v_select_sum ;

597: x_return_status => return_status);
598: IF return_status = 'S' THEN
599: -- insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || v_select_sum ; -- Commented the following code by spamujul for ER#8473903
600: -- Added the following code by spamujul for ER#8473903
601: insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE) ' || v_select_sum ;
602: EXECUTE IMMEDIATE (insert_stmnt_sum);
603: ELSE
604: RAISE SUMMATION_ERROR;
605: fnd_file.put_line(fnd_file.log, 'Summation SQL failed for check_id' || chk_id);

Line 609: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,

605: fnd_file.put_line(fnd_file.log, 'Summation SQL failed for check_id' || chk_id);
606: END IF;
607: END IF;
608: IF v_check_level = 'PARTY' THEN
609: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,
610: ACCOUNT_ID,
611: PARTY_SITE_ID,-- Added by spamujul for ER#8473903
612: VALUE)
613: SELECT party_id,

Line 618: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c

614: NULL,
615: NULL, -- Added by spamujul for ER#8473903
616: NULL
617: FROM hz_parties hz
618: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c
619: WHERE c.party_id = hz.party_id
620: AND C.PARTY_SITE_ID IS NULL -- Added by spamujul for ER#8473903
621: )
622: AND hz.status = 'A'

Line 626: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,

622: AND hz.status = 'A'
623: AND hz.party_type IN ('PERSON', 'ORGANIZATION')
624: ;
625: ELSIF v_check_level = 'CONTACT' THEN
626: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,
627: ACCOUNT_ID,
628: PARTY_SITE_ID,-- Added by spamujul for ER#8473903
629: VALUE)
630: SELECT party_id,

Line 635: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c

631: NULL,
632: NULL, -- Added 'NULL' for party_site_id by spamujul for ER#8473903
633: NULL
634: FROM hz_parties hz
635: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c
636: WHERE c.party_id = hz.party_id
637: AND C.PARTY_SITE_ID IS NULL -- Added by spamujul for ER#8473903
638: )
639: AND hz.status = 'A'

Line 642: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,

638: )
639: AND hz.status = 'A'
640: AND hz.party_type = 'PARTY_RELATIONSHIP' ;
641: ELSIF v_check_level = 'ACCOUNT' THEN
642: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,
643: ACCOUNT_ID,
644: PARTY_SITE_ID,-- Added by spamujul for ER#8473903
645: VALUE
646: )

Line 653: FROM CSC_PROF_BATCH_RESULTS1_T c

649: NULL, -- Added 'NULL' for party_site_id by spamujul for ER#8473903
650: NULL
651: FROM hz_cust_accounts hz
652: WHERE NOT EXISTS (SELECT 1
653: FROM CSC_PROF_BATCH_RESULTS1_T c
654: WHERE c.account_id = hz.cust_account_id
655: AND C.PARTY_SITE_ID IS NULL -- Added by spamujul for ER#8473903
656: )
657: AND hz.status = 'A'

Line 660: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,

656: )
657: AND hz.status = 'A'
658: ;
659: ELSIF v_check_level = 'EMPLOYEE' THEN
660: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,
661: ACCOUNT_ID,
662: PARTY_SITE_ID,-- Added by spamujul for ER#8473903
663: VALUE)
664: SELECT person_id,

Line 670: FROM CSC_PROF_BATCH_RESULTS1_T c

666: NULL , -- Added 'NULL' for party_site_id by spamujul for ER#8473903
667: NULL
668: FROM per_workforce_current_x hz
669: WHERE NOT EXISTS (SELECT 1
670: FROM CSC_PROF_BATCH_RESULTS1_T c
671: WHERE c.party_id = hz.person_id
672: AND C.PARTY_SITE_ID IS NULL -- Added by spamujul for ER#8473903
673: ) ;
674:

Line 677: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,

673: ) ;
674:
675: -- Begin fix by spamujul for ER#8473903
676: ELSIF v_check_level = 'SITE' THEN
677: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,
678: ACCOUNT_ID,
679: PARTY_SITE_ID,
680: VALUE)
681: SELECT hz.party_id,

Line 686: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c

682: NULL,
683: hz.party_site_id ,
684: NULL
685: FROM hz_party_sites hz
686: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c
687: WHERE c.party_id = hz.party_id
688: and c.party_site_id = hz.party_site_id)
689: AND hz.status = 'A'
690: AND nvl(hz.created_by_module,'XXX') <> 'SR_ONETIME';

Line 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

764: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
765: || c_threshold ||', '
766: || c_rating || ', '
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, '||

Line 788: ||' FROM CSC_PROF_BATCH_RESULTS1_T where nvl(party_site_id, -999999) <> -999999 and account_id IS NULL';

784: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
785: || c_threshold ||', '
786: || c_rating || ', '
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

Line 804: ||' FROM CSC_PROF_BATCH_RESULTS1_T where account_id IS NULL and PARTY_SITE_ID IS NULL'; -- Inlcuded 'party_site_id' IS NULL FOR ER#8473903';

800: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
801: || c_threshold ||', '
802: || c_rating || ', '
803: || c_color
804: ||' FROM CSC_PROF_BATCH_RESULTS1_T where account_id IS NULL and PARTY_SITE_ID IS NULL'; -- Inlcuded 'party_site_id' IS NULL FOR ER#8473903';
805: END IF;
806: EXECUTE IMMEDIATE (insert_stmnt_final);
807: COMMIT;
808: ELSE

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

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;
3682: IF v_chk_count = 0 AND v_batch_count <> 0 THEN

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

3817: v_party_in_sql := 0;
3818: v_acct_in_sql := 0;
3819: v_psite_in_sql := 0; -- Added by spamujul for ER#8473903
3820: END IF;
3821: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;
3822: -- insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || batch_sql_stmnt; -- Commnted the following code by spamujul for ER#8473903
3823: insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE) ' || batch_sql_stmnt; -- Added by spamujul for ER#8473903
3824: EXECUTE IMMEDIATE (insert_stmnt);
3825: IF v_acct_in_sql <> 0 AND v_check_level = 'PARTY' THEN

Line 3822: -- insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || batch_sql_stmnt; -- Commnted the following code by spamujul for ER#8473903

3818: v_acct_in_sql := 0;
3819: v_psite_in_sql := 0; -- Added by spamujul for ER#8473903
3820: END IF;
3821: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;
3822: -- insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || batch_sql_stmnt; -- Commnted the following code by spamujul for ER#8473903
3823: insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE) ' || batch_sql_stmnt; -- Added by spamujul for ER#8473903
3824: EXECUTE IMMEDIATE (insert_stmnt);
3825: IF v_acct_in_sql <> 0 AND v_check_level = 'PARTY' THEN
3826: v_select_pos := NULL;

Line 3823: insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE) ' || batch_sql_stmnt; -- Added by spamujul for ER#8473903

3819: v_psite_in_sql := 0; -- Added by spamujul for ER#8473903
3820: END IF;
3821: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;
3822: -- insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || batch_sql_stmnt; -- Commnted the following code by spamujul for ER#8473903
3823: insert_stmnt := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE) ' || batch_sql_stmnt; -- Added by spamujul for ER#8473903
3824: EXECUTE IMMEDIATE (insert_stmnt);
3825: IF v_acct_in_sql <> 0 AND v_check_level = 'PARTY' THEN
3826: v_select_pos := NULL;
3827: v_select_length := NULL;

Line 3847: -- insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || v_select_sum ; -- Commented the following code by spamujul for ER#8473903

3843: -- validate the sql statement
3844: csc_core_utils_pvt.validate_sql_stmnt( p_sql_stmnt => v_select_sum,
3845: x_return_status => return_status);
3846: IF return_status = 'S' THEN
3847: -- insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || v_select_sum ; -- Commented the following code by spamujul for ER#8473903
3848: -- Added the following code by spamujul for ER#8473903
3849: insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE)' || v_select_sum ;
3850: EXECUTE IMMEDIATE (insert_stmnt_sum);
3851: ELSE

Line 3849: insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE)' || v_select_sum ;

3845: x_return_status => return_status);
3846: IF return_status = 'S' THEN
3847: -- insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || v_select_sum ; -- Commented the following code by spamujul for ER#8473903
3848: -- Added the following code by spamujul for ER#8473903
3849: insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE)' || v_select_sum ;
3850: EXECUTE IMMEDIATE (insert_stmnt_sum);
3851: ELSE
3852: RAISE SUMMATION_ERROR;
3853: fnd_file.put_line(fnd_file.log, 'Summation SQL failed for check_id' || chk_id);

Line 3857: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,

3853: fnd_file.put_line(fnd_file.log, 'Summation SQL failed for check_id' || chk_id);
3854: END IF;
3855: END IF;
3856: IF v_check_level = 'PARTY' THEN
3857: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,
3858: ACCOUNT_ID,
3859: PARTY_SITE_ID, --Included party_site_id for ER#8473903
3860: VALUE)
3861: SELECT party_id, NULL, NULL,NULL -- Included NULL for party_site_id for ER#8473903

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

3859: PARTY_SITE_ID, --Included party_site_id for ER#8473903
3860: VALUE)
3861: SELECT party_id, NULL, NULL,NULL -- Included NULL for party_site_id for ER#8473903
3862: FROM hz_parties hz
3863: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
3864: AND hz.status = 'A'
3865: AND hz.party_type IN ('PERSON', 'ORGANIZATION');
3866: ELSIF v_check_level = 'CONTACT' THEN
3867: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,

Line 3867: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,

3863: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
3864: AND hz.status = 'A'
3865: AND hz.party_type IN ('PERSON', 'ORGANIZATION');
3866: ELSIF v_check_level = 'CONTACT' THEN
3867: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,
3868: ACCOUNT_ID,
3869: PARTY_SITE_ID, --Included party_site_id for ER#8473903
3870: VALUE)
3871: SELECT party_id, NULL, NULL ,NULL -- Included NULL for party_site_id for ER#8473903

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

3869: PARTY_SITE_ID, --Included party_site_id for ER#8473903
3870: VALUE)
3871: SELECT party_id, NULL, NULL ,NULL -- Included NULL for party_site_id for ER#8473903
3872: FROM hz_parties hz
3873: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
3874: AND hz.status = 'A'
3875: AND hz.party_type = 'PARTY_RELATIONSHIP';
3876: ELSIF v_check_level = 'ACCOUNT' THEN
3877: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,

Line 3877: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,

3873: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id)
3874: AND hz.status = 'A'
3875: AND hz.party_type = 'PARTY_RELATIONSHIP';
3876: ELSIF v_check_level = 'ACCOUNT' THEN
3877: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,
3878: ACCOUNT_ID,
3879: PARTY_SITE_ID, --Included party_site_id for ER#8473903
3880: VALUE)
3881: SELECT party_id, cust_account_id, NULL ,NULL -- Included NULL for party_site_id for ER#8473903

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

3879: PARTY_SITE_ID, --Included party_site_id for ER#8473903
3880: VALUE)
3881: SELECT party_id, cust_account_id, NULL ,NULL -- Included NULL for party_site_id for ER#8473903
3882: FROM hz_cust_accounts hz
3883: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.account_id = hz.cust_account_id)
3884: AND hz.status = 'A';
3885: ELSIF v_check_level = 'EMPLOYEE' THEN
3886: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE) --Included party_site_id for ER#8473903
3887: SELECT person_id, NULL, NULL,NULL -- Included NULL for party_site_id for ER#8473903

Line 3886: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE) --Included party_site_id for ER#8473903

3882: FROM hz_cust_accounts hz
3883: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.account_id = hz.cust_account_id)
3884: AND hz.status = 'A';
3885: ELSIF v_check_level = 'EMPLOYEE' THEN
3886: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE) --Included party_site_id for ER#8473903
3887: SELECT person_id, NULL, NULL,NULL -- Included NULL for party_site_id for ER#8473903
3888: FROM per_workforce_current_x hz
3889: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.person_id) ;
3890: -- Begin fix by spamujul for ER#8473903

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

3885: ELSIF v_check_level = 'EMPLOYEE' THEN
3886: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE) --Included party_site_id for ER#8473903
3887: SELECT person_id, NULL, NULL,NULL -- Included NULL for party_site_id for ER#8473903
3888: FROM per_workforce_current_x hz
3889: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.person_id) ;
3890: -- Begin fix by spamujul for ER#8473903
3891: ELSIF v_check_level = 'SITE' THEN
3892: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,
3893: ACCOUNT_ID,

Line 3892: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,

3888: FROM per_workforce_current_x hz
3889: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.person_id) ;
3890: -- Begin fix by spamujul for ER#8473903
3891: ELSIF v_check_level = 'SITE' THEN
3892: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,
3893: ACCOUNT_ID,
3894: PARTY_SITE_ID, --Included party_site_id for ER#8473903
3895: VALUE)
3896: SELECT hz.party_id, NULL, hz.party_site_id ,NULL -- Included NULL for party_site_id for ER#8473903

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

3894: PARTY_SITE_ID, --Included party_site_id for ER#8473903
3895: VALUE)
3896: SELECT hz.party_id, NULL, hz.party_site_id ,NULL -- Included NULL for party_site_id for ER#8473903
3897: FROM hz_party_sites hz
3898: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.party_id = hz.party_id and c.party_site_id = hz.party_site_id)
3899: AND hz.status = 'A'
3900: AND nvl(hz.created_by_module,'XXX') <> 'SR_ONETIME';
3901: -- End fix by spamujul for ER#8473903
3902: END IF;

Line 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

3971: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
3972: || c_threshold ||', '
3973: || c_rating || ', '
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, '||

Line 3995: ||' FROM CSC_PROF_BATCH_RESULTS1_T where nvl(party_site_id, -999999) <> -999999 and account_id IS NULL';

3991: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
3992: || c_threshold ||', '
3993: || c_rating || ', '
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, '||

Line 4015: ||' FROM CSC_PROF_BATCH_RESULTS1_T where account_id IS NULL and party_site_id IS NULL'; -- Added 'AND PARTY_SITE_ID IS NULL' for ER#8473903

4011: || ', FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.USER_ID, Sysdate, FND_GLOBAL.CONC_LOGIN_ID, '
4012: || c_threshold ||', '
4013: || c_rating || ', '
4014: || c_color
4015: ||' FROM CSC_PROF_BATCH_RESULTS1_T where account_id IS NULL and party_site_id IS NULL'; -- Added 'AND PARTY_SITE_ID IS NULL' for ER#8473903
4016: END IF;
4017: EXECUTE IMMEDIATE (insert_stmnt_final);
4018: COMMIT;
4019: ELSE

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

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';
4125: