1 PACKAGE CN_GET_COMM_SUMM_DATA AUTHID CURRENT_USER AS
2 /*$Header: cnvcomms.pls 115.1 2001/01/15 18:45:45 pkm ship $*/
3
4 TYPE comm_summ_rec_type IS RECORD
5 (srp_plan_assign_id NUMBER,
6 name VARCHAR2(240),
7 emp_num VARCHAR2(30),
8 cost_center VARCHAR2(30),
9 charge_to_cost_center VARCHAR2(30),
10 analyst_name VARCHAR2(240),
11 role_name VARCHAR2(30),
12 plan_name VARCHAR2(30),
13
14 begin_balance NUMBER := 0,
15 draw NUMBER := 0,
16 net_due NUMBER := 0);
17
18 TYPE comm_summ_tbl_type IS TABLE OF comm_summ_rec_type
19 INDEX BY binary_integer;
20
21 TYPE pe_info_rec_type IS RECORD
22 (quota_group_code VARCHAR2(30),
23 annual_quota NUMBER := 0,
24 pct_annual_quota NUMBER := 0,
25 target NUMBER := 0,
26 credit NUMBER := 0,
27 earnings NUMBER := 0);
28
29 TYPE pe_info_tbl_type IS TABLE OF pe_info_rec_type
30 INDEX BY binary_integer;
31
32 PROCEDURE Get_Quota_Summary
33 (p_first IN NUMBER,
34 p_last IN NUMBER,
35 p_period_id IN NUMBER,
36 p_user_id IN NUMBER,
37 p_credit_type_id IN NUMBER,
38 x_total_rows OUT NUMBER,
39 x_result_tbl OUT comm_summ_tbl_type);
40
41 PROCEDURE Get_Pe_Info
42 (p_srp_plan_assign_id IN NUMBER,
43 p_period_id IN NUMBER,
44 p_credit_type_id IN NUMBER,
45 x_ytd_pe_info OUT pe_info_tbl_type,
46 x_ptd_pe_info OUT pe_info_tbl_type,
47 x_ytd_total_earnings OUT NUMBER,
48 x_ptd_total_earnings OUT NUMBER);
49
50 PROCEDURE Get_Group_Codes
51 (x_result_tbl OUT pe_info_tbl_type);
52
53 END CN_GET_COMM_SUMM_DATA;