1 PACKAGE PA_AUTOALLOC_UTLS AUTHID CURRENT_USER AS
2 /* $Header: PAXAAUTS.pls 115.0 99/07/16 15:16:02 porting ship $ */
3
4 ----------------------------------------------------------------------
5 /* Used_In_AutoAllocWF
6
7 Parameters - Run_ID
8 Return - Y : Used in auto allocation set
9 N : Not used in auto allocation set
10
11 Given a Run_ID, function determines if the Allocation Run is used
12 in a AutoAllocation Set.
13 */
14
15 FUNCTION USED_IN_AUTOALLOCWF ( p_allocation_run_id Number )
16 RETURN VARCHAR2;
17
18 PRAGMA RESTRICT_REFERENCES (USED_IN_AUTOALLOCWF,WNDS,WNPS);
19
20 ----------------------------------------------------------------------
21 /* In_Active_AutoAllocWF
22
23 Parameters - Run_ID
24 Return - Y : Used in active auto allocation set
25 N : Not used in auto allocation set
26
27 Given a Run_ID, the function first checks if the Allocation Run
28 is used in an active AutoAllocation Set. If not, then return 'N'.
29 If the first check returns a request_id that is the item_key of
30 GL Workflow then it checks from wf view if the top wf process is active.
31
32 */
33
34 FUNCTION IN_ACTIVE_AUTOALLOCWF ( p_allocation_run_id Number )
35 RETURN VARCHAR2;
36
37 PRAGMA RESTRICT_REFERENCES (IN_ACTIVE_AUTOALLOCWF,WNDS);
38
39 ----------------------------------------------------------------------
40
41 END;