1 package PA_PROJECT_VERIFY AUTHID CURRENT_USER AS
2 -- $Header: PAXPCO3S.pls 115.0 99/07/16 15:29:25 porting ship $
3
4 verify_rule_name pa_utils.Char30TabTyp;
5
6 verify_error_code pa_utils.Char30TabTyp;
7
8 verify_required_flag pa_utils.Char1TabTyp;
9
10 verify_action_msg pa_utils.Char240TabTyp;
11
12 verify_error_msg pa_utils.Char240TabTyp;
13
14 procedure verification ( x_project_type IN VARCHAR2, num_rows OUT NUMBER );
15
16
17 procedure manager (x_index IN NUMBER, x_rule_name IN VARCHAR2,
18 x_project_type IN VARCHAR2, x_description IN VARCHAR2, x_flag IN VARCHAR2);
19 PROCEDURE client (x_index IN NUMBER, x_rule_name IN VARCHAR2,
20 x_project_type IN VARCHAR2, x_description IN VARCHAR2, x_flag IN VARCHAR2);
21 PROCEDURE contact (x_index IN NUMBER, x_rule_name IN VARCHAR2,
22 x_project_type IN VARCHAR2, x_description IN VARCHAR2, x_flag IN VARCHAR2);
23 PROCEDURE cost_budget (x_index IN NUMBER, x_rule_name IN VARCHAR2,
24 x_project_type IN VARCHAR2, x_description IN VARCHAR2,x_flag IN VARCHAR2);
25 PROCEDURE revenue_budget (x_index IN NUMBER, x_rule_name IN VARCHAR2,
26 x_project_type IN VARCHAR2, x_description IN VARCHAR2,x_flag IN VARCHAR2);
27 PROCEDURE category (x_index IN NUMBER, x_rule_name IN VARCHAR2,
28 x_project_type IN VARCHAR2, x_description IN VARCHAR2,x_flag IN VARCHAR2);
29 PROCEDURE billing_event (x_index IN NUMBER, x_rule_name IN VARCHAR2,
30 x_project_type IN VARCHAR2, x_description IN VARCHAR2,x_flag IN VARCHAR2);
31
32 function get_rule_name(xrow IN NUMBER) return varchar2;
33 function get_error_msg(xrow IN NUMBER) return varchar2;
34 function get_action_msg(xrow IN NUMBER) return varchar2;
35 function get_required_flag(xrow IN NUMBER) return varchar2;
36
37 END;