1 PACKAGE PA_PERIOD_PROCESS_PKG AUTHID CURRENT_USER as
2 -- $Header: PAGLPKGS.pls 120.1 2005/08/10 14:38:58 eyefimov noship $
3
4 Enable_New_GL_Date_Der VARCHAR2(1);
5
6 --
7 -- Function : Is_enabled
8 -- Purpose : This functions returns 'Y' if the profile option
9 -- PA_EN_NEW_GLDATE_DERIVATION is set as 'Y' otherwise 'N'.
10 -- Parameters : None.
11 --
12 FUNCTION Is_enabled RETURN VARCHAR2 ;
13
14 G_Application_Id NUMBER;
15
16 --
17 -- Function : Application_id
18 -- Purpose : This functions returns the application id based on profile
19 -- PA_EN_NEW_GLDATE_DERIVATION. If this profile is set as 'Y' then
20 -- it will returnn 8271. Else it will return 101.
21 -- Parameters : None.
22 --
23
24 FUNCTION Application_id RETURN NUMBER ;
25
26 --
27 -- Function : Use_Same_PA_GL_Period
28 -- Purpose : This functions returns 'Y' if the implementation option
29 -- Maintain Common PA and GL Periods is set as 'Y' otherwise 'N'.
30 -- Parameters : None.
31 --
32 -- Bug#2103722
33 -- Added parameter p_org_id.
34 --
35 FUNCTION Use_Same_PA_GL_Period(p_org_id IN pa_implementations_all.org_id%TYPE DEFAULT NULL) RETURN VARCHAR2 ;
36
37 --
38 -- Procedure : Update_PA_Period_Status
39 -- Purpose : This procedure will update the PA period status when the
40 -- Implementation option - Maintain Common PA and GL Periods
41 -- is set to Yes and the Profile - Enable Enhanced Period
42 -- Processing is set to Yes.
43 -- This API is called from the GL Periods Form - PAXPAGLP.fmb
44 -- Parameters : None.
45 --
46 PROCEDURE Update_PA_Period_Status ;
47
48 --Procedure : Check_Imp_Option_Controls
49 --Purpose : This procedure is called from the implementation form
50 -- when the user changes the option - Maintain Common PA
51 -- and GL Periods from N to Y.
52 -- The checks that are performed are as follows:
53 -- 1. See if the calendar and period_type for GL and PA
54 -- period are the same
55 -- 2. Check if the profile PA: Enable Enhanced Period Processing
56 -- is enabled.
57 -- 3. Check if the PA period status is in sync with the GL period
58 -- status
59 PROCEDURE Check_Imp_Option_Controls(p_period_set_name in varchar2,
60 p_pa_period_type in varchar2,
61 p_sob_id in number,
62 p_org_id in number,
63 x_return_status out nocopy varchar2,
64 x_error_message_code out nocopy varchar2);
65
66
67 END PA_PERIOD_PROCESS_PKG;