1 PACKAGE PO_DATES_S AUTHID CURRENT_USER AS
2 /* $Header: POXCODAS.pls 115.3 2004/05/26 00:34:51 spangulu ship $*/
3
4 /* bao - global variables*/
5 x_po_install_status VARCHAR2(2) := NULL;
6 x_inv_install_status VARCHAR2(2) := NULL;
7 x_sqlgl_install_status VARCHAR2(2) := NULL;
8 x_last_org_id NUMBER := NULL;
9 x_po_app_id NUMBER := NULL;
10 x_sqlgl_app_id NUMBER := NULL;
11 x_inv_app_id NUMBER := NULL;
12
13 /* Bug 3647086: Forward port; reverting faulty cache fix.
14 * We no longer need these global variables:
15 * x_last_txn_date, x_po_closing_status,
16 * x_inv_closing_status, x_other_closing_status
17 * Added global variable x_inv_app_id for clarity in body code.
18 * Added global variable x_sqlgl_install_status to use as cache.
19 */
20
21
22
23 /*===========================================================================
24 FUNCTION NAME: val_open_period()
25
26 DESCRIPTION: Checks the install status for Inventory and Purchasing.
27
28 Calls get_closing_status to validate that a date is in
29 an open GL, Inventory or Purchasing period (depending
30 on which application short name is passed in). Only
31 checks Inventory and Purchasing if they are installed.
32 Always checks GL.
33
34 PARAMETERS:
35
36 Parameter IN/OUT Datatype Description
37 ------------- ------- --------------- -------------------------------------
38 x_trx_date IN DATE Date to be validated
39 x_sob_id IN NUMBER, Set of Books ID
40 x_app_name IN VARCHAR2 Application short name:
41 GL = General Ledger
42 INV = Inventory
43 PO = Purchasing
44 x_org_id IN NUMBER Organization ID
45
46 RETURN VALUE: TRUE if date is in an open GL, Inventory or Purchasing
47 period or if Inventory or Purchasing is not installed.
48 FALSE if date is not in an open GL, Inventory or
49 Purchasing period.
50
51 DESIGN REFERENCES: RCVRCERC.dd
52 RCVTXECO.dd
53 RCVTXERE.dd
54 RCVTXERT.dd
55
56 ALGORITHM:
57
58 NOTES:
59
60 OPEN ISSUES:
61
62 CLOSED ISSUES:
63
64 CHANGE HISTORY:
65 ===========================================================================*/
66
67 FUNCTION val_open_period(x_trx_date IN DATE,
68 x_sob_id IN NUMBER,
69 x_app_name IN VARCHAR2,
70 x_org_id IN NUMBER)RETURN BOOLEAN;
71
72 /*===========================================================================
73 FUNCTION NAME: get_app_id()
74
75 DESCRIPTION: Determines the application id for the application
76 short name passed in.
77
78 Parameter IN/OUT Datatype Description
79 ------------- ------- --------------- -------------------------------------
80 x_app_name IN VARCHAR2 Application Short Name:
81 SQLGL = General Ledger
82 PO = Purchasing
83
84 RETURN VALUE: Application ID
85
86 DESIGN REFERENCES: RCVRCERC.dd
87 RCVTXECO.dd
88 RCVTXERE.dd
89 RCVTXERT.dd
90
91 ALGORITHM:
92
93 NOTES:
94
95 OPEN ISSUES:
96
97 CLOSED ISSUES:
98
99 CHANGE HISTORY:
100 ===========================================================================*/
101
102 FUNCTION get_app_id(x_app_name IN VARCHAR2)RETURN NUMBER;
103
104 /*===========================================================================
105 FUNCTION NAME: get_closing_status()
106
107 DESCRIPTION: Gets the closing status of the GL or Purchasing
108 period (depending on which application ID
109 is passed in) for a given date.
110
111 PARAMETERS:
112
113 Parameter IN/OUT Datatype Description
114 ------------- ------- --------------- -------------------------------------
115 x_trx_date IN DATE Date to be validated.
116 x_sob IN NUMBER Set of Books ID.
117 x_app_id IN NUMBER Application ID.
118
119 RETURN VALUE: C = closed
120 F = future
121 N = never opened
122 O = open
123 P = permanently closed
124
125
126 DESIGN REFERENCES: RCVRCERC.dd
127 RCVTXECO.dd
128 RCVTXERE.dd
129 RCVTXERT.dd
130
131 ALGORITHM:
132
133 NOTES:
134
135 OPEN ISSUES:
136
137 CLOSED ISSUES:
138
139 CHANGE HISTORY:
140 ===========================================================================*/
141
142 FUNCTION get_closing_status(x_trx_date IN DATE,
143 x_sob_id IN NUMBER,
144 x_app_id IN NUMBER)RETURN VARCHAR2;
145
146 /*===========================================================================
147 FUNCTION NAME: get_acct_period_status()
148
149 DESCRIPTION: Gets the closing status of the GL accounting period
150 for a given date.
151
152 PARAMETERS:
153
154 Parameter IN/OUT Datatype Description
155 ------------- ------- --------------- -------------------------------------
156 x_trx_date IN DATE Date to be validated.
157 x_sob IN NUMBER Set of Books ID.
158 x_app_id IN NUMBER Application ID.
159 x_org_id IN NUMBER Organization ID
160
161 RETURN VALUE: C = closed
162 F = future
163 N = never opened
164 O = open
165 P = permanently closed
166
167
168 DESIGN REFERENCES: RCVRCERC.dd
169 RCVTXECO.dd
170 RCVTXERE.dd
171 RCVTXERT.dd
172
173 ALGORITHM:
174
175 NOTES:
176
177 OPEN ISSUES:
178
179 CLOSED ISSUES:
180
181 CHANGE HISTORY:
182 ===========================================================================*/
183
184 FUNCTION get_acct_period_status(x_trx_date IN DATE,
185 x_sob_id IN NUMBER,
186 x_app_id IN NUMBER,
187 x_org_id IN NUMBER)RETURN VARCHAR2;
188
189 END PO_DATES_S;