DBA Data[Home] [Help]

APPS.GL_JE_LINES_RECON_PKG dependencies on GL_JE_LINES

Line 1: PACKAGE BODY GL_JE_LINES_RECON_PKG as

1: PACKAGE BODY GL_JE_LINES_RECON_PKG as
2: /* $Header: glirclnb.pls 120.9.12010000.2 2009/01/16 22:49:53 kdong ship $ */
3:
4: PROCEDURE insert_rows_for_batch(X_Je_Batch_Id NUMBER,
5: X_Last_Updated_By NUMBER,

Line 8: INSERT INTO gl_je_lines_recon

4: PROCEDURE insert_rows_for_batch(X_Je_Batch_Id NUMBER,
5: X_Last_Updated_By NUMBER,
6: X_Last_Update_Login NUMBER) IS
7: BEGIN
8: INSERT INTO gl_je_lines_recon
9: (je_header_id, je_line_num, ledger_id,
10: creation_date, created_by, last_update_date,
11: last_updated_by, last_update_login, jgzz_recon_ref)
12: SELECT jeh.je_header_id, jel.je_line_num, jeh.ledger_id,

Line 15: FROM gl_je_batches jeb, gl_je_headers jeh, gl_ledgers lgr, gl_je_lines jel,

11: last_updated_by, last_update_login, jgzz_recon_ref)
12: SELECT jeh.je_header_id, jel.je_line_num, jeh.ledger_id,
13: sysdate, X_Last_Updated_By, sysdate,
14: X_Last_Updated_By, X_Last_Update_Login, jeh.jgzz_recon_ref
15: FROM gl_je_batches jeb, gl_je_headers jeh, gl_ledgers lgr, gl_je_lines jel,
16: gl_code_combinations cc
17: WHERE jeb.je_batch_id = X_Je_Batch_Id
18: AND jeb.average_journal_flag = 'N'
19: AND jeh.je_batch_id = X_Je_Batch_Id

Line 35: INSERT INTO gl_je_lines_recon

31: PROCEDURE insert_rows_for_journal(X_Je_Header_Id NUMBER,
32: X_Last_Updated_By NUMBER,
33: X_Last_Update_Login NUMBER) IS
34: BEGIN
35: INSERT INTO gl_je_lines_recon
36: (je_header_id, je_line_num, ledger_id,
37: creation_date, created_by, last_update_date,
38: last_updated_by, last_update_login, jgzz_recon_ref)
39: SELECT jel.je_header_id, jel.je_line_num, jel.ledger_id,

Line 42: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,

38: last_updated_by, last_update_login, jgzz_recon_ref)
39: SELECT jel.je_header_id, jel.je_line_num, jel.ledger_id,
40: sysdate, X_Last_Updated_By, sysdate,
41: X_Last_Updated_By, X_Last_Update_Login, jeh.jgzz_recon_ref
42: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,
43: gl_code_combinations cc
44: WHERE jeh.je_header_id = X_Je_Header_Id
45: AND jeh.actual_flag = 'A'
46: AND jeh.je_source NOT IN ('Move/Merge', 'Move/Merge Reversal')

Line 63: INSERT INTO gl_je_lines_recon

59: X_Je_Line_Num NUMBER,
60: X_Last_Updated_By NUMBER,
61: X_Last_Update_Login NUMBER) IS
62: BEGIN
63: INSERT INTO gl_je_lines_recon
64: (je_header_id, je_line_num, ledger_id,
65: creation_date, created_by, last_update_date,
66: last_updated_by, last_update_login, jgzz_recon_ref)
67: SELECT jel.je_header_id, jel.je_line_num, jel.ledger_id,

Line 70: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,

66: last_updated_by, last_update_login, jgzz_recon_ref)
67: SELECT jel.je_header_id, jel.je_line_num, jel.ledger_id,
68: sysdate, X_Last_Updated_By, sysdate,
69: X_Last_Updated_By, X_Last_Update_Login, jeh.jgzz_recon_ref
70: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,
71: gl_code_combinations cc
72: WHERE jeh.je_header_id = X_Je_Header_Id
73: AND jeh.actual_flag = 'A'
74: AND jeh.je_source NOT IN ('Move/Merge', 'Move/Merge Reversal')

Line 99: CURSOR C IS SELECT rowid FROM GL_JE_LINES_RECON

95: X_Last_Update_Date DATE,
96: X_Last_Updated_By NUMBER,
97: X_Last_Update_Login NUMBER
98: ) IS
99: CURSOR C IS SELECT rowid FROM GL_JE_LINES_RECON
100: WHERE je_header_id = X_Je_Header_Id
101: AND je_line_num = X_Je_Line_Num;
102:
103: BEGIN

Line 105: INSERT INTO GL_JE_LINES_RECON (

101: AND je_line_num = X_Je_Line_Num;
102:
103: BEGIN
104:
105: INSERT INTO GL_JE_LINES_RECON (
106: je_header_id,
107: je_line_num,
108: ledger_id,
109: jgzz_recon_status,

Line 156: FROM GL_JE_LINES_RECON

152: X_Jgzz_Recon_Ref VARCHAR2
153: ) IS
154: CURSOR C IS
155: SELECT *
156: FROM GL_JE_LINES_RECON
157: WHERE rowid = X_Rowid
158: FOR UPDATE of Je_Header_Id NOWAIT;
159: Recinfo C%ROWTYPE;
160: BEGIN

Line 210: UPDATE GL_JE_LINES_RECON

206: X_Last_Updated_By NUMBER,
207: X_Last_Update_Login NUMBER
208: ) IS
209: BEGIN
210: UPDATE GL_JE_LINES_RECON
211: SET
212: je_header_id = X_Je_Header_Id,
213: je_line_num = X_Je_Line_Num,
214: ledger_id = X_Ledger_Id,

Line 234: DELETE FROM GL_JE_LINES_RECON

230: -- **********************************************************************
231:
232: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
233: BEGIN
234: DELETE FROM GL_JE_LINES_RECON
235: WHERE rowid = X_Rowid;
236:
237: if (SQL%NOTFOUND) then
238: Raise NO_DATA_FOUND;

Line 253: INSERT INTO gl_je_lines_recon

249: RETURN NUMBER
250: IS
251: num_rows NUMBER;
252: BEGIN
253: INSERT INTO gl_je_lines_recon
254: (je_header_id, je_line_num, ledger_id,
255: creation_date, created_by, last_update_date,
256: last_updated_by, last_update_login, jgzz_recon_ref)
257: SELECT jel.je_header_id, jel.je_line_num, jel.ledger_id,

Line 260: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,

256: last_updated_by, last_update_login, jgzz_recon_ref)
257: SELECT jel.je_header_id, jel.je_line_num, jel.ledger_id,
258: sysdate, X_Last_Updated_By, sysdate,
259: X_Last_Updated_By, X_Last_Update_Login, jeh.jgzz_recon_ref
260: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,
261: gl_code_combinations cc
262: WHERE jeh.je_header_id = X_Je_Header_Id
263: AND jeh.actual_flag = 'A'
264: AND jeh.je_source NOT IN ('Move/Merge', 'Move/Merge Reversal')

Line 284: 'gl_je_lines_recon_pkg.insert_gen_line_recon_lines');

280: RAISE;
281: WHEN OTHERS THEN
282: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
283: fnd_message.set_token('PROCEDURE',
284: 'gl_je_lines_recon_pkg.insert_gen_line_recon_lines');
285: RAISE;
286: END insert_gen_line_recon_lines;
287:
288: -- **********************************************************************

Line 297: INSERT INTO gl_je_lines_recon

293: RETURN NUMBER
294: IS
295: num_rows NUMBER;
296: BEGIN
297: INSERT INTO gl_je_lines_recon
298: (je_header_id, je_line_num, ledger_id,
299: creation_date, created_by, last_update_date,
300: last_updated_by, last_update_login, jgzz_recon_ref)
301: SELECT jel.je_header_id, jel.je_line_num, jel.ledger_id,

Line 304: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,

300: last_updated_by, last_update_login, jgzz_recon_ref)
301: SELECT jel.je_header_id, jel.je_line_num, jel.ledger_id,
302: sysdate, X_Last_Updated_By, sysdate,
303: X_Last_Updated_By, X_Last_Update_Login, jeh.jgzz_recon_ref
304: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,
305: gl_code_combinations cc
306: WHERE jeb.posting_run_id = X_Prun_Id
307: AND jeb.status = 'I'
308: AND jeb.average_journal_flag = 'N'

Line 329: 'gl_je_lines_recon_pkg.insert_alc_recon_lines');

325: RAISE;
326: WHEN OTHERS THEN
327: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
328: fnd_message.set_token('PROCEDURE',
329: 'gl_je_lines_recon_pkg.insert_alc_recon_lines');
330: RAISE;
331: END insert_alc_recon_lines;
332:
333: -- **********************************************************************

Line 342: INSERT INTO gl_je_lines_recon

338: RETURN NUMBER
339: IS
340: num_rows NUMBER;
341: BEGIN
342: INSERT INTO gl_je_lines_recon
343: (je_header_id, je_line_num, ledger_id,
344: creation_date, created_by, last_update_date,
345: last_updated_by, last_update_login, jgzz_recon_ref)
346: SELECT sljel.je_header_id, sljel.je_line_num, sljel.ledger_id,

Line 350: gl_je_batches sljeb, gl_je_headers sljeh, gl_je_lines sljel,

346: SELECT sljel.je_header_id, sljel.je_line_num, sljel.ledger_id,
347: sysdate, X_Last_Updated_By, sysdate,
348: X_Last_Updated_By, X_Last_Update_Login, jeh.jgzz_recon_ref
349: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr,
350: gl_je_batches sljeb, gl_je_headers sljeh, gl_je_lines sljel,
351: gl_code_combinations cc
352: WHERE jeb.posting_run_id = X_Prun_Id
353: AND jeb.status = 'I'
354: AND jeh.je_batch_id = jeb.je_batch_id

Line 376: 'gl_je_lines_recon_pkg.insert_sl_recon_lines');

372: RAISE;
373: WHEN OTHERS THEN
374: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
375: fnd_message.set_token('PROCEDURE',
376: 'gl_je_lines_recon_pkg.insert_sl_recon_lines');
377: RAISE;
378: END insert_sl_recon_lines;
379:
380: -- **********************************************************************

Line 382: END GL_JE_LINES_RECON_PKG;

378: END insert_sl_recon_lines;
379:
380: -- **********************************************************************
381:
382: END GL_JE_LINES_RECON_PKG;