18: -- Pre-Req :
19: -- Parameters:
20: -- IN
21: -- p_api_version_number IN NUMBER Required
22: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
23: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
24: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
25: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
26: --
19: -- Parameters:
20: -- IN
21: -- p_api_version_number IN NUMBER Required
22: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
23: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
24: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
25: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
26: --
27: -- OUT:
20: -- IN
21: -- p_api_version_number IN NUMBER Required
22: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
23: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
24: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
25: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
26: --
27: -- OUT:
28: -- x_return_status OUT VARCHAR2
36: --
37:
38: PROCEDURE Create_process_rule(
39: P_Api_Version_Number IN NUMBER,
40: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
41: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: P_Identity_Resource_Id IN NUMBER,
44: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE
37:
38: PROCEDURE Create_process_rule(
39: P_Api_Version_Number IN NUMBER,
40: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
41: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: P_Identity_Resource_Id IN NUMBER,
44: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE
45: := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
38: PROCEDURE Create_process_rule(
39: P_Api_Version_Number IN NUMBER,
40: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
41: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: P_Identity_Resource_Id IN NUMBER,
44: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE
45: := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
46: X_PROCESS_RULE_ID OUT NOCOPY NUMBER,
57: -- Pre-Req :
58: -- Parameters:
59: -- IN
60: -- p_api_version_number IN NUMBER Required
61: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
62: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
64: -- p_identity_resource_id IN NUMBER Optional Default = NULL
65: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
58: -- Parameters:
59: -- IN
60: -- p_api_version_number IN NUMBER Required
61: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
62: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
64: -- p_identity_resource_id IN NUMBER Optional Default = NULL
65: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
66: --
59: -- IN
60: -- p_api_version_number IN NUMBER Required
61: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
62: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
63: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
64: -- p_identity_resource_id IN NUMBER Optional Default = NULL
65: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
66: --
67: -- OUT:
76: --
77: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
78: PROCEDURE Update_process_rule(
79: P_Api_Version_Number IN NUMBER,
80: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
81: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: P_Identity_Resource_Id IN NUMBER,
84: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
77: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
78: PROCEDURE Update_process_rule(
79: P_Api_Version_Number IN NUMBER,
80: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
81: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: P_Identity_Resource_Id IN NUMBER,
84: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
85: X_Return_Status OUT NOCOPY VARCHAR2,
78: PROCEDURE Update_process_rule(
79: P_Api_Version_Number IN NUMBER,
80: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
81: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
82: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83: P_Identity_Resource_Id IN NUMBER,
84: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
85: X_Return_Status OUT NOCOPY VARCHAR2,
86: X_Msg_Count OUT NOCOPY NUMBER,
95: -- Pre-Req :
96: -- Parameters:
97: -- IN
98: -- p_api_version_number IN NUMBER Required
99: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
100: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
101: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
102: -- p_identity_resource_id IN NUMBER Optional Default = NULL
103: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
96: -- Parameters:
97: -- IN
98: -- p_api_version_number IN NUMBER Required
99: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
100: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
101: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
102: -- p_identity_resource_id IN NUMBER Optional Default = NULL
103: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
104: --
97: -- IN
98: -- p_api_version_number IN NUMBER Required
99: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
100: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
101: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
102: -- p_identity_resource_id IN NUMBER Optional Default = NULL
103: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
104: --
105: -- OUT:
115: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
116: -- The Master delete procedure may not be needed depends on different business requirements.
117: PROCEDURE Delete_process_rule(
118: P_Api_Version_Number IN NUMBER,
119: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
120: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: P_Identity_Resource_Id IN NUMBER,
123: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
116: -- The Master delete procedure may not be needed depends on different business requirements.
117: PROCEDURE Delete_process_rule(
118: P_Api_Version_Number IN NUMBER,
119: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
120: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: P_Identity_Resource_Id IN NUMBER,
123: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
124: X_Return_Status OUT NOCOPY VARCHAR2,
117: PROCEDURE Delete_process_rule(
118: P_Api_Version_Number IN NUMBER,
119: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
120: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: P_Identity_Resource_Id IN NUMBER,
123: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
124: X_Return_Status OUT NOCOPY VARCHAR2,
125: X_Msg_Count OUT NOCOPY NUMBER,
134: -- Pre-Req :
135: -- Parameters:
136: -- IN
137: -- p_api_version_number IN NUMBER Required
138: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
139: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
140: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
141: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
142: --
135: -- Parameters:
136: -- IN
137: -- p_api_version_number IN NUMBER Required
138: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
139: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
140: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
141: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
142: --
143: -- OUT:
136: -- IN
137: -- p_api_version_number IN NUMBER Required
138: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
139: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
140: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
141: -- P_PROCESS_RULE_Rec IN RULES_REC_TYPE Required
142: --
143: -- OUT:
144: -- x_return_status OUT VARCHAR2
152: --
153:
154: PROCEDURE Copy_process_rule(
155: P_Api_Version_Number IN NUMBER,
156: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
157: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: P_Identity_Resource_Id IN NUMBER,
160: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE
153:
154: PROCEDURE Copy_process_rule(
155: P_Api_Version_Number IN NUMBER,
156: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
157: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: P_Identity_Resource_Id IN NUMBER,
160: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE
161: := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
154: PROCEDURE Copy_process_rule(
155: P_Api_Version_Number IN NUMBER,
156: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
157: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: P_Identity_Resource_Id IN NUMBER,
160: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE
161: := PV_RULE_RECTYPE_PUB.G_MISS_RULES_REC,
162: X_PROCESS_RULE_ID OUT NOCOPY NUMBER,
178: --
179: -- End of Comments
180:
181: PROCEDURE Validate_PROCESS_RULE_ID (
182: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
183: P_Validation_mode IN VARCHAR2,
184: P_PROCESS_RULE_ID IN NUMBER,
185: X_Return_Status OUT NOCOPY VARCHAR2,
186: X_Msg_Count OUT NOCOPY NUMBER,
199: --
200: -- End of Comments
201:
202: PROCEDURE Validate_OWNER_RESOURCE_ID (
203: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
204: P_Validation_mode IN VARCHAR2,
205: P_OWNER_RESOURCE_ID IN NUMBER,
206: X_Return_Status OUT NOCOPY VARCHAR2,
207: X_Msg_Count OUT NOCOPY NUMBER,
220: --
221: -- End of Comments
222:
223: PROCEDURE Validate_CURRENCY_CODE (
224: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
225: P_Validation_mode IN VARCHAR2,
226: P_CURRENCY_CODE IN VARCHAR2,
227: X_Return_Status OUT NOCOPY VARCHAR2,
228: X_Msg_Count OUT NOCOPY NUMBER,
241: -- 2. We can also validate table instead of record. There will be an option for user to choose.
242: -- End of Comments
243:
244: PROCEDURE Validate_RANK (
245: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
246: P_Validation_mode IN VARCHAR2,
247: P_Parent_Rule_ID IN NUMBER,
248: P_Child_Rule_ID IN NUMBER,
249: P_RANK IN NUMBER,
260: --
261: -- End of Comments
262:
263: PROCEDURE Validate_enddate(
264: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
265: P_Validation_mode IN VARCHAR2,
266: P_START_DATE IN DATE,
267: P_END_DATE IN DATE,
268: X_Return_Status OUT NOCOPY VARCHAR2,
270: X_Msg_Data OUT NOCOPY VARCHAR2
271: );
272:
273: PROCEDURE Validate_startdate(
274: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
275: P_Validation_mode IN VARCHAR2,
276: P_Parent_Rule_ID IN NUMBER,
277: P_START_DATE IN DATE,
278: X_Return_Status OUT NOCOPY VARCHAR2,
280: X_Msg_Data OUT NOCOPY VARCHAR2
281: );
282:
283: PROCEDURE Validate_status(
284: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
285: P_Validation_mode IN VARCHAR2,
286: P_Parent_Rule_ID IN NUMBER,
287: P_STATUS IN VARCHAR2,
288: X_Return_Status OUT NOCOPY VARCHAR2,
302: --
303: -- End of Comments
304:
305: PROCEDURE Validate_process_rule(
306: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
307: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: P_Validation_mode IN VARCHAR2,
309: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
310: X_Return_Status OUT NOCOPY VARCHAR2,
303: -- End of Comments
304:
305: PROCEDURE Validate_process_rule(
306: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
307: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: P_Validation_mode IN VARCHAR2,
309: P_PROCESS_RULE_Rec IN PV_RULE_RECTYPE_PUB.RULES_REC_TYPE,
310: X_Return_Status OUT NOCOPY VARCHAR2,
311: X_Msg_Count OUT NOCOPY NUMBER,