1 PACKAGE PA_GL_AUTOALLOC_PKG AUTHID CURRENT_USER AS
2 /* $Header: PAXGLAAS.pls 120.1 2005/08/10 15:51:16 dlanka noship $ */
3
4 ----------------------------------------------------------------------------
5 /* Given a set id it determines if Project Allocation Rules use GL period or
6 PA period. If all the rules use PA Period type then return 'P' similarly if
7 all the rules use GL Period Type then return 'G'- if both types exist return
8 'B' - if the set does not have any Project Allocation Rules return 'N'*/
9
10 FUNCTION GET_PERIOD_TYPE ( p_allocation_set_id Number )
11 RETURN CHAR;
12
13 PRAGMA RESTRICT_REFERENCES (Get_Period_Type,WNDS,WNPS);
14 --------------------------------------------------------------------------
15 /* This function calls Get_Period_Type to determine which run period (pa/gl)
16 value is required. It further checks if that period is not null. It returns
17 TRUE on success, FALSE on failure. */
18
19 FUNCTION Valid_Run_Period ( p_allocation_set_id IN Number,
20 p_pa_period IN Varchar2
21 default Null,
22 p_gl_period IN Varchar2
23 default Null)
24 RETURN BOOLEAN;
25
26 PRAGMA RESTRICT_REFERENCES (Valid_Run_Period,WNDS,WNPS);
27 -------------------------------------------------------------------------------
28 /* The function does two things
29 1.Identify which period to be passed as parameter to a process.
30 2. Submits the Generate Allocation Transactions Request.
31 Return Value:
32 Request Id.
33 */
34
35 FUNCTION SUBMIT_ALLOC_REQUEST( p_rule_id IN Number,
36 p_expnd_item_date IN Date,
37 p_pa_period IN Varchar2,
38 p_gl_period IN Varchar2
39 )
40 Return Number;
41 -------------------------------------------------------------------------------
42 /** This procedure is called from GL package GL_PA_AUTOALLOC_PKG.
43 It sets status of a concurrent request called from PA step down allocation.
44 This status is displayed in View Status form part of Autoallocation **/
45
46 Procedure get_pa_step_status (
47 p_request_Id In Number
48 ,p_step_number In Number
49 ,p_mode In Varchar2
50 ,l_status Out NOCOPY Varchar2);
51
52 ------------------------------------------------------------------------------
53 END PA_GL_AUTOALLOC_PKG;