1 PACKAGE FEM_BUSINESS_RULE_PVT AS
2 /* $Header: FEMVBUSS.pls 120.4.12010000.1 2008/07/24 11:02:06 appldev ship $ */
3
4 --------------------------------------------------------------------------------
5 -- PUBLIC CONSTANTS
6 --------------------------------------------------------------------------------
7
8 -- Copy Type Code Constants
9 G_DUPLICATE constant varchar2(30) := 'DUPLICATE';
10 G_BACKUP constant varchar2(30) := 'BACKUP';
11 G_REVERT constant varchar2(30) := 'REVERT';
12
13 -- FEMAPPR Item Attributes for all approvals. Included to remove PL/SQL
14 -- compilation dependencies
15 G_APPROVAL_TYPE constant varchar2(30) := 'APPROVAL';
16 G_DELETE_TYPE constant varchar2(30) := 'DELETE';
17 G_REQUEST_ID constant varchar2(30) := 'REQUEST_ID';
18 G_REQUEST_ITEM_CODE constant varchar2(30) := 'REQUEST_ITEM_CODE';
19 G_REQUEST_TYPE_CODE constant varchar2(30) := 'REQUEST_TYPE_CODE';
20 G_APPROVER_USER_ID constant varchar2(30) := 'APPROVER_USER_ID';
21
22 -- FEMAPPR Item Attributes Specific for Business Rules
23 G_FOLDER_NAME constant varchar2(30) := 'FOLDER_NAME';
24 G_OBJECT_TYPE_CODE constant varchar2(30) := 'OBJECT_TYPE_CODE';
25 G_OBJECT_TYPE constant varchar2(30) := 'OBJECT_TYPE';
26 G_OBJECT_NAME constant varchar2(30) := 'OBJECT_NAME';
27 G_OBJECT_DEFINITION_ID constant varchar2(30) := 'OBJECT_DEFINITION_ID';
28 G_OBJECT_DEFINITION_NAME constant varchar2(30) := 'OBJECT_DEFINITION_NAME';
29 G_URL_SUBMITTED constant varchar2(30) := 'URL_SUBMITTED';
30 G_URL_ORIGINAL constant varchar2(30) := 'URL_ORIGINAL';
31 G_URL_APPROVED constant varchar2(30) := 'URL_APPROVED';
32 G_URL_REJECTED constant varchar2(30) := 'URL_REJECTED';
33
34 -- FEM_APPROVAL_STATUS_DSC
35 G_APPROVED_STATUS constant varchar2(30) := 'APPROVED';
36 G_NOT_APPROVED_STATUS constant varchar2(30) := 'NOT_APPROVED';
37 G_NEW_STATUS constant varchar2(30) := 'NEW';
38 G_SUBMIT_APPROVAL_STATUS constant varchar2(30) := 'SUBMIT_APPROVAL';
39 G_SUBMIT_DELETE_STATUS constant varchar2(30) := 'SUBMIT_DELETE';
40 G_NOT_APPLICABLE_STATUS constant varchar2(30) := 'NOT_APPLICABLE';
41
42 -- OLD_APPROVED_COPY_FLAG
43 G_CURRENT_COPY constant varchar2(1) := 'N';
44 G_OLD_APPROVED_COPY constant varchar2(1) := 'Y';
45
46 -- PROCESS TYPE (For calling FEM_PL_PKG can_delete API's)
47 G_DEFAULT constant number := 0;
48 G_WORKFLOW constant number := 1;
49
50 G_YES constant varchar2(1) := 'Y';
51 G_NO constant varchar2(1) := 'N';
52
53 t_url varchar(2000);
54 G_URL_FUNCTION constant varchar2(100) := 'JSP:/OA_HTML/OA.jsp?OAFunc=';
55 G_URL_OBJ_DEF_ID constant varchar2(30) := '&ObjDefId=';
56 G_URL_FOLDER_ID constant varchar2(30) := '&FolderId=';
57 G_URL_PAGE_MODE_VIEW constant varchar2(30) := '&PageMode=VIEW';
58
59 --------------------------------------------------------------------------------
60 -- PUBLIC SPECIFICATIONS
61 --------------------------------------------------------------------------------
62
63 --
64 -- PROCEDURE
65 -- DeleteObjectDefinition
66 --
67 -- DESCRIPTION
68 -- Deletes a Business Rule Definition and all its detail records.
69 --
70 -- IN
71 -- p_api_version - API Version
72 -- p_init_msg_list - Initialize Message List Flag (Boolean)
73 -- p_commit - Commit Work Flag (Boolean)
74 -- p_object_type_code - Object Type Code
75 -- p_obj_def_id - Object Definition ID
76 -- p_process_type - Process Type (optional)
77 -- 0 = DEFAULT
78 -- 1 = WORKFLOW
79 --
80 -- OUT
81 -- x_return_status - Return Status of API Call
82 -- x_msg_count - Total Count of Error Messages in API Call
83 -- x_msg_data - Error Message in API Call
84 --
85 --------------------------------------------------------------------------------
86 PROCEDURE DeleteObjectDefinition (
87 p_api_version in number := 1.0
88 ,p_init_msg_list in varchar2 := FND_API.G_FALSE
89 ,p_commit in varchar2 := FND_API.G_FALSE
90 ,x_return_status out nocopy varchar2
91 ,x_msg_count out nocopy number
92 ,x_msg_data out nocopy varchar2
93 ,p_object_type_code in varchar2
94 ,p_obj_def_id in number
95 ,p_process_type in number := G_DEFAULT
96 );
97
98 --
99 -- PROCEDURE
100 -- DeleteObjectDefinition
101 --
102 -- DESCRIPTION
103 -- Deletes a Business Rule Definition and all its detail records.
104 --
105 -- IN
106 -- p_api_version - API Version
107 -- p_init_msg_list - Initialize Message List Flag (Boolean)
108 -- p_commit - Commit Work Flag (Boolean)
109 -- p_object_type_code - Object Type Code
110 -- p_obj_def_id - Object Definition Id
111 -- p_process_type - Process Type (optional)
112 -- 0 = DEFAULT
113 -- 1 = WORKFLOW
114 --
115 -- OUT
116 -- x_return_status - Return Status of API Call
117 -- x_msg_count - Total Count of Error Messages in API Call
118 -- x_msg_data - Error Message in API Call
119 -- x_delete_request_id - Delete Request Id
120 --
121 --------------------------------------------------------------------------------
122 PROCEDURE DeleteObjectDefinition (
123 p_api_version in number := 1.0
124 ,p_init_msg_list in varchar2 := FND_API.G_FALSE
125 ,p_commit in varchar2 := FND_API.G_FALSE
126 ,x_return_status out nocopy varchar2
127 ,x_msg_count out nocopy number
128 ,x_msg_data out nocopy varchar2
129 ,p_object_type_code in varchar2
130 ,p_obj_def_id in number
131 ,p_process_type in number := G_DEFAULT
132 ,x_delete_request_id out nocopy number
133 );
134
135 --
136 -- PROCEDURE
137 -- DuplicateObjectDefinition
138 --
139 -- DESCRIPTION
140 -- Duplicates all the detail records of a Business Rule Definition (source)
141 -- into another empty Business Rule Definition (target).
142 -- NOTE: It does not copy the Business Rule Definition record in
143 -- FEM_OBJECT_DEFINITION_VL. That record must already exist.
144 --
145 -- IN
146 -- p_api_version - API Version
147 -- p_init_msg_list - Initialize Message List Flag (Boolean)
148 -- p_commit - Commit Work Flag (Boolean)
149 -- p_object_type_code - Object Type Code
150 -- p_source_obj_def_id - Source Object Definition ID
151 -- p_target_obj_def_id - Target Object Definition ID
152 --
153 -- OUT
154 -- x_return_status - Return Status of API Call
155 -- x_msg_count - Total Count of Error Messages in API Call
156 -- x_msg_data - Error Message in API Call
157 --
158 --------------------------------------------------------------------------------
159 PROCEDURE DuplicateObjectDefinition (
160 p_api_version in number := 1.0
161 ,p_init_msg_list in varchar2 := FND_API.G_FALSE
162 ,p_commit in varchar2 := FND_API.G_FALSE
163 ,x_return_status out nocopy varchar2
164 ,x_msg_count out nocopy number
165 ,x_msg_data out nocopy varchar2
166 ,p_object_type_code in varchar2
167 ,p_source_obj_def_id in number
168 ,p_target_obj_def_id in number
169 );
170
171 --
172 -- PROCEDURE
173 -- BackupObjectDefinition
174 --
175 -- DESCRIPTION
176 -- Creates a backup of a Business Rule Definition and all its detail records.
177 -- Returns the old approved copy object definition id.
178 --
179 -- IN
180 -- p_api_version - API Version
181 -- p_init_msg_list - Initialize Message List Flag (Boolean)
182 -- p_commit - Commit Work Flag (Boolean)
183 -- p_object_type_code - Object Type Code
184 -- p_obj_def_id - Object Definition ID
185 --
186 -- OUT
187 -- x_return_status - Return Status of API Call
188 -- x_msg_count - Total Count of Error Messages in API Call
189 -- x_msg_data - Error Message in API Call
190 -- x_old_approved_obj_def_id - Old Approved Copy Object Definition ID
191 --
192 --------------------------------------------------------------------------------
193 PROCEDURE BackupObjectDefinition (
194 p_api_version in number := 1.0
195 ,p_init_msg_list in varchar2 := FND_API.G_FALSE
196 ,p_commit in varchar2 := FND_API.G_FALSE
197 ,x_return_status out nocopy varchar2
198 ,x_msg_count out nocopy number
199 ,x_msg_data out nocopy varchar2
200 ,p_object_type_code in varchar2
201 ,p_obj_def_id in number
202 ,x_old_approved_obj_def_id out nocopy number
203 );
204
205 --
206 -- PROCEDURE
207 -- RevertObjectDefinition
208 --
209 -- DESCRIPTION
210 -- Reverts a Business Rule Definition and all its detail records from its
211 -- backup copy.
212 --
213 -- IN
214 -- p_api_version - API Version
215 -- p_init_msg_list - Initialize Message List Flag (Boolean)
216 -- p_commit - Commit Work Flag (Boolean)
217 -- p_object_type_code - Object Type Code
218 -- p_obj_def_id - Object Definition ID
219 --
220 -- OUT
221 -- x_return_status - Return Status of API Call
222 -- x_msg_count - Total Count of Error Messages in API Call
223 -- x_msg_data - Error Message in API Call
224 --
225 --------------------------------------------------------------------------------
226 PROCEDURE RevertObjectDefinition (
227 p_api_version in number := 1.0
228 ,p_init_msg_list in varchar2 := FND_API.G_FALSE
229 ,p_commit in varchar2 := FND_API.G_FALSE
230 ,x_return_status out nocopy varchar2
231 ,x_msg_count out nocopy number
232 ,x_msg_data out nocopy varchar2
233 ,p_object_type_code in varchar2
234 ,p_obj_def_id in number
235 );
236
237 --
238 -- PROCEDURE
239 -- DeleteObject
240 --
241 -- DESCRIPTION
242 -- Deletes an entire Business Rule, including all its Definitions and
243 -- detail records.
244 --
245 -- IN
246 -- p_api_version - API Version
247 -- p_init_msg_list - Initialize Message List Flag (Boolean)
248 -- p_commit - Commit Work Flag (Boolean)
249 -- p_object_type_code - Object Type Code
250 -- p_obj_def_id - Object Definition ID
251 -- p_process_type - Process Type (optional)
252 -- 0 = DEFAULT
253 -- 1 = WORKFLOW
254 --
255 -- OUT
256 -- x_return_status - Return Status of API Call
257 -- x_msg_count - Total Count of Error Messages in API Call
258 -- x_msg_data - Error Message in API Call
259 --
260 --------------------------------------------------------------------------------
261 PROCEDURE DeleteObject (
262 p_api_version in number
263 ,p_init_msg_list in varchar2 := FND_API.G_FALSE
264 ,p_commit in varchar2 := FND_API.G_FALSE
265 ,x_return_status out nocopy varchar2
266 ,x_msg_count out nocopy number
267 ,x_msg_data out nocopy varchar2
268 ,p_object_type_code in varchar2
269 ,p_obj_id in number
270 ,p_process_type in number := G_DEFAULT
271 );
272
273 --
274 -- PROCEDURE
275 -- DuplicateObject
276 --
277 -- DESCRIPTION
278 -- Duplicates an entire Object (source), including the Object Definition,
279 -- Object Dependencies and all its detail records, into a new Object (target).
280 --
281 -- NOTES:
282 -- 1) If a null value is passed for Target Object Id and/or Target Object
283 -- Definition Id, a new value will be obtained from their respective
284 -- sequences.
285 -- 2) If any of the optional parameters are omitted when calling this API,
286 -- the corresponding values will be copied from the source record.
287 --
288 -- IN
289 -- p_api_version - API Version
290 -- p_init_msg_list - Initialize Message List Flag (Boolean)
291 -- p_commit - Commit Work Flag (Boolean)
292 -- p_object_type_code - Object Type Code
293 -- p_source_obj_id - Source Object Id
294 -- p_source_obj_def_id - Source Object Definition Id
295 -- p_target_obj_name - Target Object Name
296 -- p_target_obj_desc - Target Object Description (optional)
297 -- p_target_obj_def_name - Target Object Definition Name
298 -- p_target_obj_def_desc - Target Object Definition Description (optional)
299 -- p_target_start_date - Target Effective Start Date (optional)
300 -- p_target_end_date - Target Effective End Date (optional)
301 -- p_target_approval_status_code - Target Approval Status Code (optional)
302 -- p_target_approved_by - Target Approved By (optional)
303 -- p_target_approval_date - Target Approval Date (optional)
304 -- p_created_by - Created By (optional)
305 -- p_creation_date - Creation Date (optional)
306 --
307 -- IN OUT
308 -- x_target_obj_id - Target Object Id (optional)
309 -- x_target_obj_def_id - Target Object Definition Id (optional)
310 --
311 -- OUT
312 -- x_return_status - Return Status of API Call
313 -- x_msg_count - Total Count of Error Messages in API Call
314 -- x_msg_data - Error Message in API Call
315 --
316 --------------------------------------------------------------------------------
317 PROCEDURE DuplicateObject (
321 ,x_return_status out nocopy varchar2
318 p_api_version in number
319 ,p_init_msg_list in varchar2 := FND_API.G_FALSE
320 ,p_commit in varchar2 := FND_API.G_FALSE
322 ,x_msg_count out nocopy number
323 ,x_msg_data out nocopy varchar2
324 ,p_object_type_code in varchar2
325 ,p_source_obj_id in number
326 ,p_source_obj_def_id in number
327 ,x_target_obj_id in out nocopy number
328 ,p_target_obj_name in varchar2
329 ,p_target_obj_desc in varchar2 := FND_API.G_MISS_CHAR
330 ,x_target_obj_def_id in out nocopy number
331 ,p_target_obj_def_name in varchar2 := FND_API.G_MISS_CHAR
332 ,p_target_obj_def_desc in varchar2 := FND_API.G_MISS_CHAR
333 ,p_target_start_date in date := FND_API.G_MISS_DATE
334 ,p_target_end_date in date := FND_API.G_MISS_DATE
335 ,p_target_approval_status_code in varchar2 := FND_API.G_MISS_CHAR
336 ,p_target_approved_by in number := FND_API.G_MISS_NUM
337 ,p_target_approval_date in date := FND_API.G_MISS_DATE
338 ,p_created_by in number := FND_API.G_MISS_NUM
339 ,p_creation_date in date := FND_API.G_MISS_DATE
340 );
341
342 --
343 -- PROCEDURE
344 -- DuplicateObjectDetails
345 --
346 -- DESCRIPTION
347 -- Duplicates only the detail records of a Business Rule (source) into
348 -- another empty Business Rule (target). It does not duplicate any of the
349 -- Business Rule Definition records.
350 -- NOTE: It does not copy the Business Rule record in
351 -- FEM_OBJECT_CATALOG_VL. That record must already exist.
352 --
353 -- IN
354 -- p_api_version - API Version
355 -- p_init_msg_list - Initialize Message List Flag (Boolean)
356 -- p_commit - Commit Work Flag (Boolean)
357 -- p_object_type_code - Object Type Code
358 -- p_source_obj_id - Source Object ID
359 -- p_target_obj_id - Target Object ID
360 --
361 -- OUT
362 -- x_return_status - Return Status of API Call
363 -- x_msg_count - Total Count of Error Messages in API Call
364 -- x_msg_data - Error Message in API Call
365 --
366 --------------------------------------------------------------------------------
367 PROCEDURE DuplicateObjectDetails (
368 p_api_version in number := 1.0
369 ,p_init_msg_list in varchar2 := FND_API.G_FALSE
370 ,p_commit in varchar2 := FND_API.G_FALSE
371 ,x_return_status out nocopy varchar2
372 ,x_msg_count out nocopy number
373 ,x_msg_data out nocopy varchar2
374 ,p_object_type_code in varchar2
375 ,p_source_obj_id in number
376 ,p_target_obj_id in number
377 );
378
379 --
380 -- PROCEDURE
381 -- CheckOverlapObjDefs
382 --
383 -- DESCRIPTION
384 -- Checks if the specified effective dates will overlap with existing
385 -- object definitions under the same parent object. If this check is for
386 -- updating the effective dates of an existing object definition, this
387 -- object definition must be excluded from the overlap check.
388 --
389 -- IN
390 -- p_api_version - API Version
391 -- p_init_msg_list - Initialize Message List Flag (Boolean)
392 -- p_obj_id - Object ID
393 -- p_exclude obj_def_id - Object Definition ID to exclude from check
394 -- p_effective_start_date - The new effective start date
395 -- p_effective_end_date - The new effective end date
396 --
397 -- OUT
398 -- x_return_status - Return Status of API Call
399 -- x_msg_count - Total Count of Error Messages in API Call
400 -- x_msg_data - Error Message in API Call
401 --
402 --------------------------------------------------------------------------------
403 PROCEDURE CheckOverlapObjDefs(
404 p_api_version in number := 1.0
405 ,p_init_msg_list in varchar2 := FND_API.G_FALSE
406 ,x_return_status out nocopy varchar2
407 ,x_msg_count out nocopy number
408 ,x_msg_data out nocopy varchar2
409 ,p_obj_id in number
410 ,p_exclude_obj_def_id in number
411 ,p_effective_start_date in date
412 ,p_effective_end_date in date
413 );
414
415 --
416 -- FUNCTION
417 -- GetDefaultStartDate
418 --
419 -- DESCRIPTION
420 -- Returns the default start date stored in the profile options table. If
421 -- none is specified, use the defaulted value.
422 --
423 -- RETURN
424 -- x_default_start_date - Default Effective Start Date
425 --
426 FUNCTION GetDefaultStartDate
427 RETURN date;
428
429 --
430 -- FUNCTION
431 -- GetDefaultEndDate
432 --
433 -- DESCRIPTION
434 -- Returns the default end date stored in the profile options table. If
435 -- none is specified, use the defaulted value.
436 --
437 -- RETURN
438 -- x_default_end_date - Default Effective End Date
439 --
440 FUNCTION GetDefaultEndDate
441 RETURN date;
442
443 --
444 -- PROCEDURE
445 -- CheckObjectName
446 --
450 --
447 -- DESCRIPTION
448 -- Checks that a new or updated Object does not have the same name as other
449 -- existing Object records.
451 -- IN
452 -- p_api_version - API Version
453 -- p_init_msg_list - Initialize Message List Flag (Boolean)
454 -- p_obj_name - Object Name
455 -- p_obj_id - Object ID (optional)
456 --
457 -- OUT
458 -- x_return_status - Return Status of API Call
459 -- x_msg_count - Total Count of Error Messages in API Call
460 -- x_msg_data - Error Message in API Call
461 --
462 --------------------------------------------------------------------------------
463 PROCEDURE CheckObjectName (
464 p_api_version in number
465 ,p_init_msg_list in varchar2 := FND_API.G_FALSE
466 ,x_return_status out nocopy varchar2
467 ,x_msg_count out nocopy number
468 ,x_msg_data out nocopy varchar2
469 ,p_obj_name in varchar2
470 ,p_obj_id in number
471 );
472
473 --
474 -- PROCEDURE
475 -- CheckObjectDefinitionName
476 --
477 -- DESCRIPTION
478 -- Checks that a new or updated Object Definition does not have the same
479 -- name as other existing Object Definition records that all belong to the
480 -- same Object.
481 --
482 -- IN
483 -- p_api_version - API version
484 -- p_init_msg_list - Initialize Message List (boolean)
485 -- p_obj_def_name - Object Definition Name
486 -- p_obj_id - Object ID
487 -- p_obj_def_id - Object Definition ID (optional)
488 --
489 -- OUT
490 -- x_return_status - Return Status of API Call
491 -- x_msg_count - Total Count of Error Messages in API Call
492 -- x_msg_data - Error Message in API Call
493 --
494 --------------------------------------------------------------------------------
495 PROCEDURE CheckObjectDefinitionName (
496 p_api_version in number
497 ,p_init_msg_list in varchar2 := FND_API.G_FALSE
498 ,x_return_status out nocopy varchar2
499 ,x_msg_count out nocopy number
500 ,x_msg_data out nocopy varchar2
501 ,p_obj_def_name in varchar2
502 ,p_obj_id in number
503 ,p_obj_def_id in number
504 );
505
506 --
507 -- FUNCTION
508 -- ObjDefDataEditLockExists
509 --
510 -- DESCRIPTION
511 -- Check if data lock exists for the object definition
512 --
513 -- IN
514 -- p_obj_def_id - Object Definition ID
515 --
516 -- OUT
517 -- l_lock_exists - Lock Exists (T - True, F - False)
518 --
519 --------------------------------------------------------------------------------
520 FUNCTION ObjDefDataEditLockExists (
521 p_obj_def_id in number
522 ) RETURN varchar2;
523
524 --
525 -- FUNCTION
526 -- GetObjectId
527 --
528 -- DESCRIPTION
529 -- Getter for obtaining the object ID of the specified object definition ID.
530 --
531 -- IN
532 -- p_obj_def_id - Object Defintion ID
533 --
534 -- RETURNS
535 -- obj_id - Object ID
536 --
537 FUNCTION GetObjectId (
538 p_obj_def_id in number
539 )
540 RETURN number;
541
542 --
543 -- FUNCTION
544 -- GetNewObjId
545 --
546 -- DESCRIPTION
547 -- Getter for the FEM_OBJECT_CATALOG_ID_SEQ database sequence.
551 --
548 --
549 -- RETURNS
550 -- obj_id - Object Definition ID
552 FUNCTION GetNewObjId
553 RETURN number;
554
555 --
556 -- FUNCTION
557 -- GetNewObjDefId
558 --
559 -- DESCRIPTION
560 -- Getter for the FEM_OBJECT_DEFINITION_ID_SEQ database sequence.
561 --
562 -- RETURNS
563 -- obj_def_id - Object Definition ID
564 --
565 FUNCTION GetNewObjDefId
566 RETURN number;
567
568 --
569 -- FUNCTION
570 -- GetRulesetIsetupImpExpFlag
571 --
572 -- DESCRIPTION
573 -- Getter for obtaining the iSetup import/export flag for the
574 -- specified rule set object definition.
575 --
576 -- IN
577 -- p_obj_def_id - Rule Set Object Definition ID
578 --
579 -- RETURNS
580 -- isetup_import_export_flag - iSetup Import/Export Flag
581 --
582 --------------------------------------------------------------------------------
583 FUNCTION GetRulesetIsetupImpExpFlag (
584 p_ruleset_obj_def_id in number
585 )
586 RETURN varchar2;
587
588 --
589 -- PROCEDURE
590 -- SetSubmittedState
591 --
592 -- DESCRIPTION
593 -- Sets all the business rule definitions in a workflow request to the
594 -- submitted state.
595 --
596 -- IN
597 -- p_item_type - The workflow item type (FEMAPPR)
598 -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
599 --
600 -- USED BY
601 -- FEM_FEMAPPR_ITEM_TYPE SetSubmittedState()
602 --
603 PROCEDURE SetSubmittedState(
604 p_item_type in varchar2
605 ,p_item_key in varchar2
606 );
607
608 --
609 -- PROCEDURE
610 -- SetApprovedState
611 --
612 -- DESCRIPTION
613 -- Sets all the business rule definitions in a workflow request to the
614 -- approved state.
615 --
616 -- IN
617 -- p_item_type - The workflow item type (FEMAPPR)
618 -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
619 --
620 -- USED BY
621 -- FEM_FEMAPPR_ITEM_TYPE SetApprovedState()
622 --
623 PROCEDURE SetApprovedState(
624 p_item_type in varchar2
625 ,p_item_key in varchar2
626 );
627
628 --
629 -- PROCEDURE
630 -- SetRejectedState
631 --
632 -- DESCRIPTION
633 -- Sets all the business rule definitions in a workflow request to the
634 -- rejected state.
635 --
636 -- IN
637 -- p_item_type - The workflow item type (FEMAPPR)
638 -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
639 --
640 -- USED BY
641 -- FEM_FEMAPPR_ITEM_TYPE SetRejectedState()
642 --
643 PROCEDURE SetRejectedState(
644 p_item_type in varchar2
645 ,p_item_key in varchar2
646 );
647
648 --
649 -- FUNCTION
650 -- CheckApprovalItems
651 --
652 -- DESCRIPTION
653 -- Checks to see if a workflow request contains any business rule
654 -- definitions.
655 --
656 -- IN
657 -- p_item_type - The workflow item type (FEMAPPR)
658 -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
659 --
660 -- RETURNS
661 -- approval_items_exist - Approval Items Exist Flag (YES, NO)
662 --
663 -- USED BY
664 -- FEM_FEMAPPR_ITEM_TYPE CheckApprovalItems()
665 --
666
667 FUNCTION CheckApprovalItems(
668 p_item_type in varchar2
669 ,p_item_key in varchar2
670 )
671 RETURN varchar2;
672
673 --
674 -- PROCEDURE
675 -- InitApprovalItems
676 --
677 -- DESCRIPTION
678 -- Initializes the workflow item attributes with information from the
679 -- object definitions in a workflow request
680 --
681 -- IN
682 -- p_item_type - The workflow item type (FEMAPPR)
683 -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
684 --
685 -- USED BY
686 -- FEM_FEMAPPR_ITEM_TYPE InitApprovalItems()
687 --
688 PROCEDURE InitApprovalItems(
689 p_item_type in varchar2
690 ,p_item_key in varchar2
691 );
692
693 --
694 -- PROCEDURE
695 -- PurgeApprovalRequest
696 --
697 -- DESCRIPTION
698 -- Deletes all the appropriate approval request records from the
699 -- FEM_WF_REQ_OBJECT_DEFS table.
700 --
701 -- IN
702 -- p_item_type - The workflow item type (FEMAPPR)
703 -- p_item_key - The workflow request id (FEM_WF_REQUEST_ID_SEQ)
704 --
705 -- USED BY
706 -- FEM_FEMAPPR_ITEM_TYPE PurgeApprovalRequest()
707 --
708 --------------------------------------------------------------------------------
709 PROCEDURE PurgeApprovalRequest (
710 p_item_type in varchar2
711 ,p_item_key in varchar2
712 );
713
714
715 END FEM_BUSINESS_RULE_PVT;