APPS.GL_INTERFACE_PKG dependencies on GL_INTERFACE

Line 1: PACKAGE BODY gl_interface_pkg AS

1: PACKAGE BODY gl_interface_pkg AS
2: /* $Header: glijiinb.pls 120.10.12010000.1 2008/07/28 13:25:18 appldev ship $ */
3:
4: --
5: -- PRIVATE FUNCTIONS

Line 25: FROM GL_INTERFACE

21: X_Entered_Cr NUMBER
22: ) IS
23: CURSOR C IS
24: SELECT *
25: FROM GL_INTERFACE
26: WHERE rowid = X_Rowid
27: FOR UPDATE of User_Je_Source_Name NOWAIT;
28: Recinfo C%ROWTYPE;
29: BEGIN

Line 183: SELECT rowid FROM GL_INTERFACE

179: X_Date_Created DATE,
180: X_Created_By NUMBER
181: ) IS
182: CURSOR C (ccid IN NUMBER, unique_value IN VARCHAR2) IS
183: SELECT rowid FROM GL_INTERFACE
184: WHERE user_je_source_name = X_User_Je_Source_Name
185: AND group_id = X_Group_Id
186: AND ledger_id = X_Ledger_Id
187: AND status_description = unique_value

Line 194: INSERT INTO GL_INTERFACE(

190: AND period_name = X_Period_Name;
191: BEGIN
192:
193: -- Insert the From line
194: INSERT INTO GL_INTERFACE(
195: status,
196: ledger_id,
197: user_je_source_name,
198: user_je_category_name,

Line 242: INSERT INTO GL_INTERFACE(

238: end if;
239: CLOSE C;
240:
241: -- Insert the to line, switching the Cr and Dr
242: INSERT INTO GL_INTERFACE(
243: status,
244: ledger_id,
245: user_je_source_name,
246: user_je_category_name,

Line 291: UPDATE GL_INTERFACE

287: CLOSE C;
288:
289:
290: -- Change the from status description to the to rowid.
291: UPDATE GL_INTERFACE
292: SET status_description = X_To_RowId
293: WHERE user_je_source_name = X_User_Je_Source_Name
294: AND group_id = X_Group_Id
295: AND ledger_id = X_Ledger_Id

Line 327: GL_INTERFACE_PKG.Lock_Budget_Transfer_Row(

323: ) IS
324: BEGIN
325:
326: -- Lock the from row
327: GL_INTERFACE_PKG.Lock_Budget_Transfer_Row(
328: X_Rowid => X_From_RowId,
329: X_Status => X_Status,
330: X_Ledger_Id => X_Ledger_Id,
331: X_User_Je_Source_Name => X_User_Je_Source_Name,

Line 345: GL_INTERFACE_PKG.Lock_Budget_Transfer_Row(

341: X_Je_Batch_Name => X_Je_Batch_Name
342: );
343:
344: -- Lock the to row
345: GL_INTERFACE_PKG.Lock_Budget_Transfer_Row(
346: X_Rowid => X_To_RowId,
347: X_Status => X_Status,
348: X_Ledger_Id => X_Ledger_Id,
349: X_User_Je_Source_Name => X_User_Je_Source_Name,

Line 385: UPDATE GL_INTERFACE

381: X_To_Entered_Dr NUMBER,
382: X_To_Entered_Cr NUMBER
383: ) IS
384: BEGIN
385: UPDATE GL_INTERFACE
386: SET
387: status = X_Status,
388: ledger_id = X_Ledger_Id,
389: user_je_source_name = X_User_Je_Source_Name,

Line 418: DELETE FROM GL_INTERFACE

414:
415: PROCEDURE Delete_Budget_Transfer_Row(X_From_Rowid VARCHAR2,
416: X_To_Rowid VARCHAR2) IS
417: BEGIN
418: DELETE FROM GL_INTERFACE
419: WHERE rowid IN (X_From_Rowid, X_To_Rowid);
420:
421: if (SQL%NOTFOUND) then
422: RAISE NO_DATA_FOUND;

Line 431: DELETE gl_interface

427: x_user_je_source_name VARCHAR2,
428: x_group_id NUMBER DEFAULT NULL,
429: x_je_batch_id NUMBER DEFAULT NULL) IS
430: BEGIN
431: DELETE gl_interface
432: WHERE ledger_id = x_ledger_id
433: AND user_je_source_name = x_user_je_source_name
434: AND nvl(group_id,-1) = nvl(x_group_id, -1)
435: AND nvl(je_batch_id, -1) = nvl(x_je_batch_id, nvl(je_batch_id, -1));

Line 446: FROM gl_interface

442: CURSOR check_for_data IS
443: SELECT 'Has data'
444: FROM dual
445: WHERE EXISTS (SELECT 'Has data'
446: FROM gl_interface
447: WHERE ledger_id = x_ledger_id
448: AND user_je_source_name = x_user_je_source_name
449: AND group_id = x_group_id);
450: dummy VARCHAR2(100);

Line 1579: END gl_interface_pkg;

1575: null;
1576: END delete_row;
1577:
1578:
1579: END gl_interface_pkg;