APPS.PER_WPM_SUMMARY_PKG dependencies on PER_WPM_APPRAISAL_SUMMARY

Line 554: INSERT INTO PER_WPM_APPRAISAL_SUMMARY

550: FETCH csr_directs_unrated INTO l_direct_unrated_count;
551: CLOSE csr_directs_unrated;
552:
553: --
554: INSERT INTO PER_WPM_APPRAISAL_SUMMARY
555: (
556: wpm_appraisal_summary_id ,
557: plan_id ,
558: appraisal_period_id ,

Line 645: PER_WPM_APPRAISAL_SUMMARY_S.nextval

641: norating_direct_count ,
642: norating_total_count )
643: VALUES
644: (
645: PER_WPM_APPRAISAL_SUMMARY_S.nextval
646: ,p_plan_id
647: ,g_appr_period_rec.appraisal_period_id
648: ,p_supervisor_id
649: ,p_supervisor_name

Line 778: DELETE PER_WPM_APPRAISAL_SUMMARY

774: CLOSE csr_appr_period_dtls;
775: RETURN;
776: END IF;
777: CLOSE csr_appr_period_dtls;
778: DELETE PER_WPM_APPRAISAL_SUMMARY
779: WHERE plan_id = p_plan_id
780: AND appraisal_period_id = g_appr_period_rec.appraisal_period_id;
781: COMMIT;
782: g_rating_levels.DELETE;

Line 798: INSERT INTO PER_WPM_APPRAISAL_SUMMARY

794: /*
795: create a row with supervisor_person_id as -1 to store the run_date into the
796: supervisor_name column in canonical format. level_1_id will store the request Id.
797: */
798: INSERT INTO PER_WPM_APPRAISAL_SUMMARY
799: (
800: wpm_appraisal_summary_id ,
801: plan_id ,
802: appraisal_period_id ,

Line 807: (PER_WPM_APPRAISAL_SUMMARY_S.nextval

803: supervisor_person_id ,
804: supervisor_name ,
805: level_1_id )
806: VALUES
807: (PER_WPM_APPRAISAL_SUMMARY_S.nextval
808: ,p_plan_id
809: ,g_appr_period_rec.appraisal_period_id
810: ,-1
811: ,fnd_date.date_to_canonical(sysdate)

Line 825: FROM per_wpm_appraisal_summary

821: ,p_appraisal_period_id IN NUMBER) RETURN DATE IS
822: CURSOR csr_get_date(p_plan_id NUMBER
823: ,p_period_id NUMBER) IS
824: SELECT NVL(fnd_date.canonical_to_date(supervisor_name),SYSDATE) -- supervisor_name is used to store the run date with id as -1.
825: FROM per_wpm_appraisal_summary
826: WHERE plan_id = p_plan_id
827: AND appraisal_period_id = p_period_id
828: AND supervisor_person_id = -1;
829: l_summary_date DATE;