1 PACKAGE PV_PROCESS_RULES_PUB as
2 /* $Header: pvrpprus.pls 120.0 2005/05/27 16:21:18 appldev noship $ */
3 -- Start of Comments
4 -- Package name : PV_PROCESS_RULES_PUB
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 -- *******************************************************
12 -- Start of Comments
13 -- *******************************************************
14 -- API Name: Create_process_rules
15 -- Type : Public
16 -- Pre-Req :
17 -- Parameters:
18 -- IN
19 -- p_api_version_number IN NUMBER Required
20 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
21 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
22 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
23 -- P_RULES_Rec IN RULES_REC_TYPE Required
24 --
25 -- OUT:
26 -- x_return_status OUT VARCHAR2
27 -- x_msg_count OUT NUMBER
28 -- x_msg_data OUT VARCHAR2
29 -- Version : Current version 2.0
30 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
31 -- and basic operation, developer must manually add parameters and business logic as necessary.
32 --
33 -- End of Comments
34 --
35 PROCEDURE Create_process_rules(
36 P_Api_Version_Number IN NUMBER,
37 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
38 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
39 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40 P_Identity_Resource_Id IN NUMBER,
41 P_RULES_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
42 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
43 X_process_rule_id OUT NOCOPY NUMBER,
44 X_Return_Status OUT NOCOPY VARCHAR2,
45 X_Msg_Count OUT NOCOPY NUMBER,
46 X_Msg_Data OUT NOCOPY VARCHAR2
47 );
48
49 -- *******************************************************
50 -- Start of Comments
51 -- *******************************************************
52 -- API Name: Update_process_rules
53 -- Type : Public
54 -- Pre-Req :
55 -- Parameters:
56 -- IN
57 -- p_api_version_number IN NUMBER Required
58 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
59 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
60 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
61 -- P_Identity_Resource_Id IN NUMBER Optional Default = NULL
62 -- P_RULES_Rec IN RULES_REC_TYPE Required
63 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
64 --
65 -- OUT:
66 -- x_return_status OUT VARCHAR2
67 -- x_msg_count OUT NUMBER
68 -- x_msg_data OUT VARCHAR2
69 -- Version : Current version 2.0
70 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
71 -- and basic operation, developer must manually add parameters and business logic as necessary.
72 --
73 -- End of Comments
74 --
75 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
76 PROCEDURE Update_process_rules(
77 P_Api_Version_Number IN NUMBER,
78 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
79 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
80 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81 P_Identity_Resource_Id IN NUMBER,
82 P_RULES_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
83 X_Return_Status OUT NOCOPY VARCHAR2,
84 X_Msg_Count OUT NOCOPY NUMBER,
85 X_Msg_Data OUT NOCOPY VARCHAR2
86 );
87
88 -- *******************************************************
89 -- Start of Comments
90 -- *******************************************************
91 -- API Name: Delete_process_rules
92 -- Type : Public
93 -- Pre-Req :
94 -- Parameters:
95 -- IN
96 -- p_api_version_number IN NUMBER Required
97 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
98 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
99 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
100 -- P_Identity_Resource_Id IN NUMBER Optional Default = NULL
101 -- P_RULES_Rec IN RULES_REC_TYPE Required
102 --
103 -- OUT:
104 -- x_return_status OUT VARCHAR2
105 -- x_msg_count OUT NUMBER
106 -- x_msg_data OUT VARCHAR2
107 -- Version : Current version 2.0
108 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
109 -- and basic operation, developer must manually add parameters and business logic as necessary.
110 --
111 -- End of Comments
112 --
113 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
114 -- The Master delete procedure may not be needed depends on different business requirements.
115 PROCEDURE Delete_process_rules(
116 P_Api_Version_Number IN NUMBER,
117 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
118 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
119 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120 P_Identity_Resource_Id IN NUMBER,
121 P_RULES_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
122 X_Return_Status OUT NOCOPY VARCHAR2,
123 X_Msg_Count OUT NOCOPY NUMBER,
124 X_Msg_Data OUT NOCOPY VARCHAR2
125 );
126
127 -- *******************************************************
128 -- Start of Comments
129 -- *******************************************************
130 -- API Name: Copy_process_rules
131 -- Type : Public
132 -- Pre-Req :
133 -- Parameters:
134 -- IN
135 -- p_api_version_number IN NUMBER Required
136 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
137 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
138 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
139 -- P_RULES_Rec IN RULES_REC_TYPE Required
140 --
141 -- OUT:
142 -- x_return_status OUT VARCHAR2
143 -- x_msg_count OUT NUMBER
144 -- x_msg_data OUT VARCHAR2
145 -- Version : Current version 2.0
146 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
147 -- and basic operation, developer must manually add parameters and business logic as necessary.
148 --
149 -- End of Comments
150 --
151 PROCEDURE Copy_process_rules(
152 P_Api_Version_Number IN NUMBER,
153 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
154 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
155 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156 P_Identity_Resource_Id IN NUMBER,
157 P_RULES_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
158 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
159 X_process_rule_id OUT NOCOPY NUMBER,
160 X_Return_Status OUT NOCOPY VARCHAR2,
161 X_Msg_Count OUT NOCOPY NUMBER,
162 X_Msg_Data OUT NOCOPY VARCHAR2
163 );
164
165
166
167 End PV_PROCESS_RULES_PUB;