1 PACKAGE GLXJEENT_PKG AUTHID CURRENT_USER as
2 /* $Header: glfjeens.pls 120.7 2004/07/14 21:53:54 djogg ship $ */
3
4 --
5 -- Package
6 -- GLXJEENT_PKG
7 -- Purpose
8 -- To implement various data checking needed for the
9 -- Enter Journals form
10 -- History
11 -- 06-FEB-95 D J Ogg Created
12 --
13
14 --
15 -- Procedure
16 -- cashe_data
17 -- Purpose
18 -- Gets all of the data needed for cashing by the form
19 -- History
20 -- 06-FEB-95 D. J. Ogg Created
21 -- Arguments
22 -- acc_id The current access set id
23 -- default_ledger_id The default ledger
24 -- form_mode The mode the form was brought up in
25 -- default_je_source Default source name
26 -- user_default_je_source Translation of default source name
27 -- journal_approval_flag Does the default source require
28 -- approval?
29 -- default_je_category Default category name
30 -- user_default_je_category Translation of default category name
31 -- default_rev_change_sign_flag Reversal option for default category
32 -- default_reversal_period Reversal period for default category
33 -- default_reversal_date Reversal date for default category
34 -- default_reversal_start_date Start Date of default reversal period
35 -- default_reversal_end_date Start Date of default reversal period
36 -- default_period_name Default period name for actuals
37 -- default_start_date Start date of period
38 -- default_end_date End date of period
39 -- default_eff_date Default effective date
40 -- default_period_year Year of period
41 -- default_period_num Number of period
42 -- default_conversion_type Default conversion type
43 -- user_default_conversion_type Translation of default conversion type
44 -- user_fixed_conversion_type Translation of EMU Fixed conv type
45 -- start_active_date First date in an open or future
46 -- enterable period
47 -- end_active_date Last date in an open or future
48 -- enterable period
49 -- Notes
50 --
51 PROCEDURE cache_data( acc_id NUMBER,
52 default_ledger_id NUMBER,
53 form_mode VARCHAR2,
54 default_je_source IN OUT NOCOPY VARCHAR2,
55 user_default_je_source IN OUT NOCOPY VARCHAR2,
56 journal_approval_flag IN OUT NOCOPY VARCHAR2,
57 default_je_category IN OUT NOCOPY VARCHAR2,
58 user_default_je_category IN OUT NOCOPY VARCHAR2,
59 default_rev_change_sign_flag IN OUT NOCOPY VARCHAR2,
60 default_reversal_period IN OUT NOCOPY VARCHAR2,
61 default_reversal_date IN OUT NOCOPY DATE,
62 default_reversal_start_date IN OUT NOCOPY DATE,
63 default_reversal_end_date IN OUT NOCOPY DATE,
64 default_period_name IN OUT NOCOPY VARCHAR2,
65 default_start_date IN OUT NOCOPY DATE,
66 default_end_date IN OUT NOCOPY DATE,
67 default_eff_date IN OUT NOCOPY DATE,
68 default_period_year IN OUT NOCOPY NUMBER,
69 default_period_num IN OUT NOCOPY NUMBER,
70 default_conversion_type IN OUT NOCOPY VARCHAR2,
71 user_default_conversion_type IN OUT NOCOPY VARCHAR2,
72 user_fixed_conversion_type IN OUT NOCOPY VARCHAR2,
73 start_active_date IN OUT NOCOPY DATE,
74 end_active_date IN OUT NOCOPY DATE);
75
76 --
77 -- Procedure
78 -- get_period
79 -- Purpose
80 -- Takes the accounting date and gets the period associated with it
81 -- History
82 -- 03-JUN-96 D. J. Ogg Created
83 -- Arguments
84 -- x_lgr_id The current ledger
85 -- x_accounting_date The accounting date to be used
86 -- x_period_name The period containing the date
87 -- x_start_date Start date of period
88 -- x_end_date End date of period
89 -- Notes
90 --
91 PROCEDURE get_period(x_lgr_id NUMBER,
92 x_accounting_date DATE,
93 x_period_name IN OUT NOCOPY VARCHAR2,
94 x_period_status IN OUT NOCOPY VARCHAR2,
95 x_start_date IN OUT NOCOPY DATE,
96 x_end_date IN OUT NOCOPY DATE);
97
98 --
99 -- Procedure
100 -- is_prior_period
101 -- Purpose
102 -- Takes a period and a ledger id or a batch id, and indicates
103 -- whether that period is a prior period (i.e. a period earlier than
104 -- the latest open) for that ledger or the ledgers in that batch
105 -- History
106 -- 13-NOV-01 D. J. Ogg Created
107 -- Arguments
108 -- x_period_name The period name
109 -- x_arg_type 'L' -- ledger id, 'B' -- batch id
110 -- x_arg_id Ledger or batch id
111 -- Notes
112 --
113 FUNCTION is_prior_period(x_period_name VARCHAR2,
114 x_arg_type VARCHAR2,
115 x_arg_id NUMBER) RETURN BOOLEAN;
116
117 --
118 -- Procedure
119 -- default_still_good
120 -- Purpose
121 -- Takes the default ledger, the current access set, a period,
122 -- and an average journal flag. Determines if the ledger is
123 -- still a good default given the access set, period, and the
124 -- average journal flag.
125 -- History
126 -- 04-FEB-02 D. J. Ogg Created
127 -- Arguments
128 -- x_ledger_id The default ledger
129 -- x_period_name The period name
130 -- x_average_journal_flag The average journal flag
131 -- Notes
132 --
133 FUNCTION default_still_good(x_access_set_id NUMBER,
134 x_ledger_id NUMBER,
135 x_period_name VARCHAR2,
136 x_average_journal_flag VARCHAR2
137 ) RETURN VARCHAR2;
138
139 --
140 -- Procedure
141 -- default_actual_period
142 -- Purpose
143 -- Determines the default period for an autocopied batch
144 -- History
145 -- 24-NOV-03 D. J. Ogg Created
146 -- Arguments
147 -- x_period_set_name Current calendar
148 -- x_period_type Current accounted period type
149 -- x_je_batch_id Autocopied batch
150 -- period_name Default period name
151 -- start_date Default start date
152 -- end_date Default end date
153 -- period_year Default period year
154 -- period_num Default period number
155 -- Notes
156 --
157 PROCEDURE default_actual_period(x_period_set_name VARCHAR2,
158 x_period_type VARCHAR2,
159 x_je_batch_id NUMBER,
160 period_name IN OUT NOCOPY VARCHAR2,
161 start_date IN OUT NOCOPY DATE,
162 end_date IN OUT NOCOPY DATE,
163 period_year IN OUT NOCOPY NUMBER,
164 period_num IN OUT NOCOPY NUMBER);
165
166 --
167 -- Procedure
168 -- set_find_window_state
169 -- Purpose
170 -- Saves the state of the find window. Uses autonomous_transactions
171 -- History
172 -- 07-MAY-03 D. J. Ogg Created
173 -- Arguments
174 -- w_state The current window state
175 -- Notes
176 --
177 PROCEDURE set_find_window_state(w_state VARCHAR2);
178
179 END GLXJEENT_PKG;