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.12020000.2 2012/12/01 14:23:26 dthakker 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 188: SELECT rowid FROM GL_INTERFACE

184: X_Date_Created DATE,
185: X_Created_By NUMBER
186: ) IS
187: CURSOR C (ccid IN NUMBER, unique_value IN VARCHAR2) IS
188: SELECT rowid FROM GL_INTERFACE
189: WHERE user_je_source_name = X_User_Je_Source_Name
190: AND group_id = X_Group_Id
191: AND ledger_id = X_Ledger_Id
192: AND status_description = unique_value

Line 199: INSERT INTO GL_INTERFACE(

195: AND period_name = X_Period_Name;
196: BEGIN
197:
198: -- Insert the From line
199: INSERT INTO GL_INTERFACE(
200: status,
201: ledger_id,
202: user_je_source_name,
203: user_je_category_name,

Line 247: INSERT INTO GL_INTERFACE(

243: end if;
244: CLOSE C;
245:
246: -- Insert the to line, switching the Cr and Dr
247: INSERT INTO GL_INTERFACE(
248: status,
249: ledger_id,
250: user_je_source_name,
251: user_je_category_name,

Line 296: UPDATE GL_INTERFACE

292: CLOSE C;
293:
294:
295: -- Change the from status description to the to rowid.
296: UPDATE GL_INTERFACE
297: SET status_description = X_To_RowId
298: WHERE user_je_source_name = X_User_Je_Source_Name
299: AND group_id = X_Group_Id
300: AND ledger_id = X_Ledger_Id

Line 332: GL_INTERFACE_PKG.Lock_Budget_Transfer_Row(

328: ) IS
329: BEGIN
330:
331: -- Lock the from row
332: GL_INTERFACE_PKG.Lock_Budget_Transfer_Row(
333: X_Rowid => X_From_RowId,
334: X_Status => X_Status,
335: X_Ledger_Id => X_Ledger_Id,
336: X_User_Je_Source_Name => X_User_Je_Source_Name,

Line 350: GL_INTERFACE_PKG.Lock_Budget_Transfer_Row(

346: X_Je_Batch_Name => X_Je_Batch_Name
347: );
348:
349: -- Lock the to row
350: GL_INTERFACE_PKG.Lock_Budget_Transfer_Row(
351: X_Rowid => X_To_RowId,
352: X_Status => X_Status,
353: X_Ledger_Id => X_Ledger_Id,
354: X_User_Je_Source_Name => X_User_Je_Source_Name,

Line 390: UPDATE GL_INTERFACE

386: X_To_Entered_Dr NUMBER,
387: X_To_Entered_Cr NUMBER
388: ) IS
389: BEGIN
390: UPDATE GL_INTERFACE
391: SET
392: status = X_Status,
393: ledger_id = X_Ledger_Id,
394: user_je_source_name = X_User_Je_Source_Name,

Line 423: DELETE FROM GL_INTERFACE

419:
420: PROCEDURE Delete_Budget_Transfer_Row(X_From_Rowid VARCHAR2,
421: X_To_Rowid VARCHAR2) IS
422: BEGIN
423: DELETE FROM GL_INTERFACE
424: WHERE rowid IN (X_From_Rowid, X_To_Rowid);
425:
426: if (SQL%NOTFOUND) then
427: RAISE NO_DATA_FOUND;

Line 436: DELETE gl_interface

432: x_user_je_source_name VARCHAR2,
433: x_group_id NUMBER DEFAULT NULL,
434: x_je_batch_id NUMBER DEFAULT NULL) IS
435: BEGIN
436: DELETE gl_interface
437: WHERE ledger_id = x_ledger_id
438: AND user_je_source_name = x_user_je_source_name
439: AND nvl(group_id,-1) = nvl(x_group_id, -1)
440: AND nvl(je_batch_id, -1) = nvl(x_je_batch_id, nvl(je_batch_id, -1));

Line 451: FROM gl_interface

447: CURSOR check_for_data IS
448: SELECT 'Has data'
449: FROM dual
450: WHERE EXISTS (SELECT 'Has data'
451: FROM gl_interface
452: WHERE ledger_id = x_ledger_id
453: AND user_je_source_name = x_user_je_source_name
454: AND group_id = x_group_id);
455: dummy VARCHAR2(100);

Line 1584: END gl_interface_pkg;

1580: null;
1581: END delete_row;
1582:
1583:
1584: END gl_interface_pkg;