APPS.PER_WPM_SUMMARY_PKG dependencies on PER_WPM_APPRAISAL_SUMMARY

Line 928: INSERT INTO per_wpm_appraisal_summary

924:
925: CLOSE csr_directs_unrated;
926:
927: --
928: INSERT INTO per_wpm_appraisal_summary
929: (wpm_appraisal_summary_id,
930: plan_id,
931: appraisal_period_id,
932: supervisor_person_id,

Line 1017: VALUES (per_wpm_appraisal_summary_s.NEXTVAL,

1013: level_20_total_count,
1014: norating_direct_count,
1015: norating_total_count
1016: )
1017: VALUES (per_wpm_appraisal_summary_s.NEXTVAL,
1018: p_plan_id,
1019: g_appr_period_rec.appraisal_period_id,
1020: p_supervisor_id,
1021: p_supervisor_name,

Line 1176: DELETE per_wpm_appraisal_summary

1172: END IF;
1173:
1174: CLOSE csr_appr_period_dtls;
1175:
1176: DELETE per_wpm_appraisal_summary
1177: WHERE plan_id = p_plan_id
1178: AND appraisal_period_id = g_appr_period_rec.appraisal_period_id;
1179:
1180: COMMIT;

Line 1206: INSERT INTO per_wpm_appraisal_summary

1202: /*
1203: create a row with supervisor_person_id as -1 to store the run_date into the
1204: supervisor_name column in canonical format. level_1_id will store the request Id.
1205: */
1206: INSERT INTO per_wpm_appraisal_summary
1207: (wpm_appraisal_summary_id,
1208: plan_id,
1209: appraisal_period_id,
1210: supervisor_person_id,

Line 1214: VALUES (per_wpm_appraisal_summary_s.NEXTVAL,

1210: supervisor_person_id,
1211: supervisor_name,
1212: level_1_id
1213: )
1214: VALUES (per_wpm_appraisal_summary_s.NEXTVAL,
1215: p_plan_id,
1216: g_appr_period_rec.appraisal_period_id,
1217: -1,
1218: fnd_date.date_to_canonical (SYSDATE),

Line 1237: FROM per_wpm_appraisal_summary

1233: CURSOR csr_get_date (p_plan_id NUMBER, p_period_id NUMBER)
1234: IS
1235: SELECT NVL (fnd_date.canonical_to_date (supervisor_name), SYSDATE)
1236: -- supervisor_name is used to store the run date with id as -1.
1237: FROM per_wpm_appraisal_summary
1238: WHERE plan_id = p_plan_id AND appraisal_period_id = p_period_id
1239: AND supervisor_person_id = -1;
1240:
1241: l_summary_date DATE;