1 PACKAGE Oe_PC_Constraints_Admin_Pub AUTHID CURRENT_USER as
2 /* $Header: OEXPPCAS.pls 120.0 2005/06/01 02:33:05 appldev noship $ */
3
4 -- Start of Comments
5 -- API name Generate_Constraint_API
6 -- Type Public
7 -- Function
8 --
9 -- Pre-reqs
10 --
11 -- Parameters
12 --
13 -- Version Current version = 1.0
14 -- Initial version = 1.0
15 --
16 -- Notes
17 --
18 -- End of Comments
19
20 ---------------------------------------
21 PROCEDURE Generate_Constraint_API
22 (
23 p_api_version_number in number,
24 p_application_id in number,
25 p_entity_short_name in varchar2,
26 x_script_file_name out NOCOPY /* file.sql.39 change */ varchar2,
27 x_return_status out NOCOPY /* file.sql.39 change */ varchar2,
28 x_msg_count out NOCOPY /* file.sql.39 change */ number,
29 x_msg_data out NOCOPY /* file.sql.39 change */ varchar2
30 );
31 -----------------------------------------------------
32
33
34 -- FUNCTION Get_Authorized_WF_Roles:
35 -- Returns the list of WF Roles that are NOT constrained
36 -- by the conditions for a given constraint (p_constraint_id).
37
38 -- NOTE: This does not mean that these roles can perform the
39 -- constrained operation. There may be other constraints for
40 -- the same operation on this entity that are applicable to this role.
41
42 -----------------------------------------------------
43 FUNCTION Get_Authorized_WF_Roles
44 (
45 p_constraint_id IN NUMBER
46 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
47 )
48 RETURN OE_PC_GLOBALS.Authorized_WF_Roles_TBL;
49 -----------------------------------------------------
50
51 -- PROCEDURE Add_Constraint_Message
52 -- For a constraint violation on a given object and for a given constraint
53 -- condition (constraint_id AND group_number), this procedure constructs
54 -- the message tokens for the name of the attribute, object and the
55 -- reason. Then adds the message to the OE message stack.
56 ---------------------------------------
57 PROCEDURE Add_Constraint_Message
58 ( p_application_id IN NUMBER
59 ,p_database_object_name IN VARCHAR2
60 ,p_column_name IN VARCHAR2
61 ,p_operation IN VARCHAR2
62 ,p_constraint_id IN NUMBER
63 ,p_on_operation_action IN NUMBER
64 ,p_group_number IN NUMBER
65 );
66 -----------------------------------------------------
67
68 END Oe_PC_Constraints_Admin_Pub;