DBA Data[Home] [Help]

PACKAGE: APPS.FEM_BUSINESS_RULE_PVT

Source


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;