1 PACKAGE MSC_SECRULE_PKG AUTHID CURRENT_USER AS
2 -- $Header: MSCXVSPS.pls 120.1 2005/06/20 04:21:25 appldev ship $
3
4 ORDER_TYPE_ZERO CONSTANT NUMBER := 0;
5
6
7
8
9 Procedure INSERT_SEC_RULE
10 ( p_order_type IN Number,
11 p_item_name IN Varchar2,
12 p_customer_name IN Varchar2,
13 p_supplier_name IN Varchar2,
14 p_customer_site_name IN Varchar2,
15 p_supplier_site_name IN Varchar2,
16 p_org_name IN Varchar2,
17 p_grantee_type IN Varchar2,
18 p_grantee_key IN Varchar2,
19 p_start_date IN date,
20 p_end_date IN date,
21 p_privilege IN Varchar2,
22 p_order_number IN Varchar2,
23 p_company_name IN Varchar2,
24 p_return_code OUT NOCOPY Number,
25 p_err_msg OUT NOCOPY Varchar2);
26
27 Procedure EDIT_SEC_RULE
28 ( p_order_type IN Number,
29 p_item_name IN Varchar2,
30 p_customer_name IN Varchar2,
31 p_supplier_name IN Varchar2,
32 p_customer_site_name IN Varchar2,
33 p_supplier_site_name IN Varchar2,
34 p_org_name IN Varchar2,
35 p_grantee_type IN Varchar2,
36 p_grantee_key IN Varchar2,
37 p_start_date IN date,
38 p_end_date IN date,
39 p_privilege IN Varchar2,
40 p_order_number IN Varchar2,
41 p_company_name IN Varchar2,
42 p_rule_id IN Number,
43 p_return_code OUT NOCOPY Number,
44 p_err_msg OUT NOCOPY Varchar2);
45
46
47 /*Procedure VALIDATE_ORDER_TYPE
48 ( p_order_type IN Varchar2,
49 l_lookup_code OUT Number,
50 p_return_code IN OUT Number,
51 p_err_msg IN OUT Varchar2);
52 */
53
54 Procedure VALIDATE_COMPANY_NAME
55 ( p_company_name IN Varchar2,
56 l_company_id OUT NOCOPY Number,
57 p_return_code IN OUT NOCOPY Number,
58 p_err_msg IN OUT NOCOPY Varchar2);
59
60 Procedure VALIDATE_ITEM_NAME
61 ( p_item_name IN Varchar2,
62 p_company_name IN Varchar2,
63 l_item_id OUT NOCOPY Number,
64 p_return_code IN OUT NOCOPY Number,
65 p_err_msg IN OUT NOCOPY Varchar2);
66
67 Procedure VALIDATE_CUSTOMER_NAME
68 ( p_customer_name IN Varchar2,
69 l_company_id IN Number,
70 l_customer_id OUT NOCOPY Number,
71 l_customer_flag IN OUT NOCOPY boolean,
72 p_return_code IN OUT NOCOPY Number,
73 p_err_msg IN OUT NOCOPY Varchar2);
74
75 Procedure VALIDATE_SUPPLIER_NAME
76 ( p_supplier_name IN Varchar2,
77 l_company_id IN Number,
78 l_supplier_id OUT NOCOPY Number,
79 l_supplier_flag IN OUT NOCOPY boolean,
80 p_return_code IN OUT NOCOPY Number,
81 p_err_msg IN OUT NOCOPY Varchar2);
82
83 Procedure VALIDATE_CUSTOMER_SITE_NAME
84 ( p_customer_site_name IN Varchar2,
85 l_company_id IN Number,
86 l_customer_id IN Number,
87 l_customer_site_id OUT NOCOPY Number,
88 l_customer_flag IN OUT NOCOPY boolean,
89 p_return_code IN OUT NOCOPY Number,
90 p_err_msg IN OUT NOCOPY Varchar2);
91
92 Procedure VALIDATE_SUPPLIER_SITE_NAME
93 ( p_supplier_site_name IN Varchar2,
94 l_company_id IN Number,
95 l_supplier_id IN Number,
96 l_supplier_site_id OUT NOCOPY Number,
97 l_supplier_flag IN OUT NOCOPY boolean,
98 p_return_code IN OUT NOCOPY Number,
99 p_err_msg IN OUT NOCOPY Varchar2);
100
101 Procedure VALIDATE_ORG_NAME
102 ( p_org_name IN Varchar2,
103 l_company_id IN Number,
104 l_org_id OUT NOCOPY Number,
105 p_return_code IN OUT NOCOPY Number,
106 p_err_msg IN OUT NOCOPY Varchar2);
107
108 Procedure VALIDATE_GRANTEE_KEY
109 ( p_grantee_type IN Varchar2,
110 p_grantee_key IN Varchar2,
111 l_grantee_key OUT NOCOPY Number,
112 p_return_code IN OUT NOCOPY Number,
113 p_err_msg IN OUT NOCOPY Varchar2);
114
115
116 END MSC_SECRULE_PKG;
117