[Home] [Help]
PACKAGE: APPS.GL_JE_BATCHES_POST_PKG
Source
1 PACKAGE GL_JE_BATCHES_POST_PKG as
2 /* $Header: glijebps.pls 120.4 2005/05/05 00:38:48 kvora ship $ */
3
4
5 -- PUBLIC VARIABLES
6 access_set_id NUMBER;
7
8 --
9 -- Procedure
10 -- set_access_set_id
11 -- Purpose
12 -- Sets the access_set_id
13 -- Arguments
14 -- access_set_id
15 -- Example
16 -- gl_je_batches_post_pkg.set_access_set_id(221);
17 -- Notes
18 --
19 PROCEDURE set_access_set_id(X_access_set_id NUMBER);
20
21 --
22 -- Procedure
23 -- get_access_set_id
24 -- Purpose
25 -- Gets the package (global) variable
26 -- History: 09-21-96 Rashmi Goyal Created
27 -- Example
28 -- l_access_set_id := gl_je_batches_post_pkg.get_access_set_id;
29 -- Notes
30 --
31 FUNCTION get_access_set_id RETURN NUMBER;
32 PRAGMA RESTRICT_REFERENCES(get_access_set_id,WNDS,WNPS);
33
34 --
35 -- Procedure
36 -- get_unique_id
37 -- Purpose
38 -- Gets a unique posting_run_id
39 -- Arguments
40 -- * None *
41 -- Example
42 -- :WORLD.posting_run_id := gl_je_batches_post_pkg.get_unique_id;
43 -- Notes
44 --
45 FUNCTION get_unique_id RETURN NUMBER;
46
47 --
48 -- Procedure
49 -- check_budget_status
50 -- Purpose
51 -- Checks whether budget batch contains journals with budget that
52 -- is frozen or in unopened budget year
53 -- Returns:
54 -- BF With frozen budget
55 -- BU With unopened budget year
56 -- OK Neither
57 -- Arguments
58 -- je_batch_id JE batch id
59 -- period_year Period year of batch
60 -- Example
61 -- status := gl_je_batches_post_pkg.check_budget_status(
62 -- :BATCHES.je_batch_id, :BATCHES.period_year );
63 -- Notes
64 --
65 FUNCTION check_budget_status( X_je_batch_id NUMBER,
66 X_period_year NUMBER ) RETURN VARCHAR2;
67
68 --
69 -- Procedure
70 -- check_unbal_monetary_headers
71 -- Purpose
72 -- Checks if there are any unbalanced monetary headers in the
73 -- specified batch.
74 -- It is okay to have STAT headers that are not balanced.
75 -- Returns:
76 -- TRUE Batch is unbalanced
77 -- FALSE Batch is balanced
78 -- Arguments
79 -- je_batch_id JE batch id
80 -- Example
81 -- status := gl_je_batches_post_pkg.check_unbal_monetary_headers(
82 -- :BATCHES.je_batch_id );
83 -- Notes
84 -- For bug #394393:
85 -- This function replaces the function gl_je_batches_pkg.all_stat_headers
86 -- to check for an out of balance condition.
87
88 FUNCTION check_unbal_monetary_headers( X_je_batch_id NUMBER ) RETURN BOOLEAN;
89
90 --
91 -- Procedure
92 -- check_untax_monetary_headers
93 -- Purpose
94 -- Checks if there are any untaxed monetary headers in the specified batch.
95 -- It is okay to have STAT headers that are not taxed.
96 -- Returns:
97 -- TRUE Batch is untaxed ( tax_status_code = 'R' in any headers )
98 -- FALSE Batch is taxed
99 -- Arguments
100 -- je_batch_id JE batch id
101 -- Example
102 -- status := gl_je_batches_post_pkg.check_untax_monetary_headers(
103 -- :BATCHES.je_batch_id );
104 -- Notes
105 FUNCTION check_untax_monetary_headers( X_je_batch_id NUMBER ) RETURN BOOLEAN;
106
107
108 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
109 X_Je_Batch_Id NUMBER,
110 X_Chart_Of_Accounts_Id NUMBER,
111 X_Name VARCHAR2,
112 X_Status VARCHAR2,
113 X_Status_Verified VARCHAR2,
114 X_Actual_Flag VARCHAR2,
115 X_Budgetary_Control_Status VARCHAR2,
116 X_Default_Period_Name VARCHAR2,
117 X_Control_Total NUMBER,
118 X_Running_Total_Dr NUMBER,
119 X_Running_Total_Cr NUMBER,
120 X_Posting_Run_Id NUMBER,
121 X_Request_Id NUMBER
122 );
123
124 PROCEDURE Update_Row(X_Rowid VARCHAR2,
125 X_Je_Batch_Id NUMBER,
126 X_Last_Update_Date DATE,
127 X_Last_Updated_By NUMBER,
128 X_Chart_Of_Accounts_Id NUMBER,
129 X_Name VARCHAR2,
130 X_Status VARCHAR2,
131 X_Status_Verified VARCHAR2,
132 X_Actual_Flag VARCHAR2,
133 X_Budgetary_Control_Status VARCHAR2,
134 X_Last_Update_Login NUMBER,
135 X_Default_Period_Name VARCHAR2,
136 X_Control_Total NUMBER,
137 X_Running_Total_Dr NUMBER,
138 X_Running_Total_Cr NUMBER,
139 X_Posting_Run_Id NUMBER,
140 X_Request_Id NUMBER
141 );
142
143
144 END GL_JE_BATCHES_POST_PKG;