1 PACKAGE PER_WPM_SUMMARY_PKG AUTHID CURRENT_USER AS
2 /* $Header: pewpmsum.pkh 120.1.12010000.4 2008/10/21 05:54:24 rvagvala ship $ */
3 --
4 PROCEDURE populate_plan_hierarchy_cp(errbuf OUT NOCOPY VARCHAR2
5 ,retcode OUT NOCOPY NUMBER
6 ,p_plan_id IN number
7 ,p_effective_date IN VARCHAR2);
8 PROCEDURE populate_plan_hierarchy(p_plan_id IN NUMBER
9 ,p_effective_date IN DATE);
10 PROCEDURE populate_appraisal_summary_cp(errbuf OUT NOCOPY VARCHAR2
11 ,retcode OUT NOCOPY NUMBER
12 ,p_plan_id IN NUMBER
13 ,p_appraisal_period_id IN NUMBER
14 ,p_effective_date IN VARCHAR2);
15 PROCEDURE populate_appraisal_summary(p_plan_id IN NUMBER
16 ,p_appraisal_period_id IN NUMBER
17 ,p_effective_date IN DATE);
18 --
19 FUNCTION get_summary_date(p_plan_id IN NUMBER
20 ,p_appraisal_period_id IN NUMBER) RETURN DATE;
21 --
22 PROCEDURE build_hierarchy_for_sc(p_plan_id IN NUMBER,
23 p_sc_id IN NUMBER DEFAULT NULL);
24 ---
25
26 PROCEDURE submit_refreshApprSummary_cp(p_plan_id IN NUMBER,
27 p_appraisal_period_id IN NUMBER,
28 p_request_id out NOCOPY number);
29 ---
30 END PER_WPM_SUMMARY_PKG;