[Home] [Help]
PACKAGE: APPS.GL_JE_LINES_RECON_PKG
Source
1 PACKAGE GL_JE_LINES_RECON_PKG as
2 /* $Header: glirclns.pls 120.4 2005/05/05 01:19:16 kvora ship $ */
3
4 --
5 -- Package
6 -- GL_JE_LINES_RECON_PKG
7 -- Purpose
8 -- To implement various data checking needed for the
9 -- gl_je_lines_recon table
10 -- History
11 -- 07-JUN-2004 D J Ogg Created.
12 --
13
14 --
15 -- Procedure
16 -- insert_rows_for_batch
17 -- Purpose
18 -- Inserts any missing reconciliation rows for a batch
19 -- History
20 -- 09-JUN-2004 D. J. Ogg Created
21 -- Arguments
22 -- X_Je_Batch_Id The batch id for which rows should be added
23 -- Example
24 -- gl_je_lines_recon_pkg.insert_rows_for_batch(500);
25 -- Notes
26 --
27 PROCEDURE insert_rows_for_batch(X_Je_Batch_Id NUMBER,
28 X_Last_Updated_By NUMBER,
29 X_Last_Update_Login NUMBER);
30
31 --
32 -- Procedure
33 -- insert_rows_for_journal
34 -- Purpose
35 -- Inserts any missing reconciliation rows for a journal
36 -- History
37 -- 09-JUN-2004 D. J. Ogg Created
38 -- Arguments
39 -- X_Je_Header_Id The header id for which rows should be added
40 -- Example
41 -- gl_je_lines_recon_pkg.insert_rows_for_journal(500);
42 -- Notes
43 --
44 PROCEDURE insert_rows_for_journal(X_Je_Header_Id NUMBER,
45 X_Last_Updated_By NUMBER,
46 X_Last_Update_Login NUMBER);
47
48 -- Procedure
49 -- insert_rows_for_line
50 -- Purpose
51 -- Inserts any missing reconciliation rows for a journal line
52 -- History
53 -- 09-JUN-2004 D. J. Ogg Created
54 -- Arguments
55 -- X_Je_Header_Id The header id for which rows should be added
56 -- Example
57 -- gl_je_lines_recon_pkg.insert_rows_for_line(500,1,1,2);
58 -- Notes
59 --
60 PROCEDURE insert_rows_for_line(X_Je_Header_Id NUMBER,
61 X_Je_Line_Num NUMBER,
62 X_Last_Updated_By NUMBER,
63 X_Last_Update_Login NUMBER);
64
65 PROCEDURE Insert_Row(X_RowId IN OUT NOCOPY VARCHAR2,
66 X_Je_Header_Id NUMBER,
67 X_Je_Line_Num NUMBER,
68 X_Ledger_Id NUMBER,
69 X_Jgzz_Recon_Status VARCHAR2,
70 X_Jgzz_Recon_Date DATE,
71 X_Jgzz_Recon_Id NUMBER,
72 X_Jgzz_Recon_Ref VARCHAR2,
73 X_Last_Update_Date DATE,
74 X_Last_Updated_By NUMBER,
75 X_Last_Update_Login NUMBER
76 );
77
78
79 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
80 X_Je_Header_Id NUMBER,
81 X_Je_Line_Num NUMBER,
82 X_Ledger_Id NUMBER,
83 X_Jgzz_Recon_Status VARCHAR2,
84 X_Jgzz_Recon_Date DATE,
85 X_Jgzz_Recon_Id NUMBER,
86 X_Jgzz_Recon_Ref VARCHAR2
87 );
88
89
90 PROCEDURE Update_Row(X_Rowid VARCHAR2,
91 X_Je_Header_Id NUMBER,
92 X_Je_Line_Num NUMBER,
93 X_Ledger_Id NUMBER,
94 X_Jgzz_Recon_Status VARCHAR2,
95 X_Jgzz_Recon_Date DATE,
96 X_Jgzz_Recon_Id NUMBER,
97 X_Jgzz_Recon_Ref VARCHAR2,
98 X_Last_Update_Date DATE,
99 X_Last_Updated_By NUMBER,
100 X_Last_Update_Login NUMBER
101 );
102
103
104 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
105
106
107 -- Procedure
108 -- insert_gen_line_recon_lines
109 -- Purpose
110 -- Insert reconciliation rows for the generated lines in a
111 -- primary journal being posted.
112 -- This routine is designed to be only called by Posting.
113 -- History
114 -- 14-FEB-2005 K Vora Created
115 -- Arguments
116 -- x_je_header_id The header to be used
117 -- x_from_je_line_num The line number from which to process
118 -- x_last_updated_by
119 -- x_last_update_login
120 -- Example
121 -- gl_je_lines_recon_pkg.insert_gen_line_recon_lines(123, 101, 1, 234);
122 -- Notes
123 --
124 FUNCTION insert_gen_line_recon_lines( X_Je_Header_Id NUMBER,
125 X_From_Je_Line_Num NUMBER,
126 X_Last_Updated_By NUMBER,
127 X_Last_Update_Login NUMBER )
128 RETURN NUMBER;
129
130
131 -- Procedure
132 -- insert_alc_recon_lines
133 -- Purpose
134 -- Insert reconciliation rows for the ALC journals in the
135 -- selected posting run.
136 -- This routine is designed to be only called by Posting.
137 -- History
138 -- 14-FEB-2005 K Vora Created
139 -- Arguments
140 -- x_prun_id The posting run id to be used
141 -- x_last_updated_by
142 -- x_last_update_login
143 -- Example
144 -- gl_je_lines_recon_pkg.insert_alc_recon_lines(123, 1, 234);
145 -- Notes
146 --
147 FUNCTION insert_alc_recon_lines( X_Prun_Id NUMBER,
148 X_Last_Updated_By NUMBER,
149 X_Last_Update_Login NUMBER )
150 RETURN NUMBER;
151
152
153 -- Procedure
154 -- insert_sl_recon_lines
155 -- Purpose
156 -- Insert reconciliation rows for the SL journals in the
157 -- selected posting run.
158 -- This routine is designed to be only called by Posting.
159 -- History
160 -- 14-FEB-2005 K Vora Created
161 -- Arguments
162 -- x_prun_id The posting run id to be used
163 -- x_last_updated_by
164 -- x_last_update_login
165 -- Example
166 -- gl_je_lines_recon_pkg.insert_sl_recon_lines(123, 1, 234);
167 -- Notes
168 --
169 FUNCTION insert_sl_recon_lines( X_Prun_Id NUMBER,
170 X_Last_Updated_By NUMBER,
171 X_Last_Update_Login NUMBER )
172 RETURN NUMBER;
173
174
175 END GL_JE_LINES_RECON_PKG;