APPS.GL_ELIMINATION_SETS_PKG dependencies on GL_ELIMINATION_SETS

Line 1: PACKAGE BODY gl_elimination_sets_pkg As

1: PACKAGE BODY gl_elimination_sets_pkg As
2: /* $Header: gliesetb.pls 120.6 2005/05/05 01:07:26 kvora ship $ */
3:
4: ---
5: --- PRIVATE VARIABLES

Line 15: -- Returns nextval from gl_elimination_sets_s

11:
12: -- Function
13: -- get_unique_id
14: -- Purpose
15: -- Returns nextval from gl_elimination_sets_s
16: -- Parameters
17: -- None
18: -- History
19: -- 11-06-1998 W Wong Created

Line 26: SELECT gl_elimination_sets_s.NEXTVAL

22: --
23: FUNCTION get_unique_id RETURN NUMBER IS
24:
25: CURSOR get_new_id IS
26: SELECT gl_elimination_sets_s.NEXTVAL
27: FROM dual;
28: new_id number;
29:
30: BEGIN

Line 40: fnd_message.set_token('SEQUENCE', 'GL_ELIMINATION_SETS_S');

36: return(new_id);
37: ELSE
38: CLOSE get_new_id;
39: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
40: fnd_message.set_token('SEQUENCE', 'GL_ELIMINATION_SETS_S');
41: app_exception.raise_exception;
42: END IF;
43:
44: EXCEPTION

Line 53: 'gl_elimination_sets_pkg.get_unique_id');

49: WHEN OTHERS THEN
50: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
51: fnd_message.set_token(
52: 'PROCEDURE',
53: 'gl_elimination_sets_pkg.get_unique_id');
54: RAISE;
55: END get_unique_id;
56:
57: --

Line 129: FROM gl_elimination_sets

125: CURSOR name_count IS
126: SELECT 1
127: FROM DUAL
128: WHERE EXISTS (SELECT 1
129: FROM gl_elimination_sets
130: WHERE name = X_name
131: AND ledger_id = X_ledgerid
132: AND ((X_rowid IS NULL) OR (rowid <> X_rowid)));
133: BEGIN

Line 154: 'gl_elimination_sets_pkg.check_unique_name');

150: WHEN OTHERS THEN
151: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
152: fnd_message.set_token(
153: 'PROCEDURE',
154: 'gl_elimination_sets_pkg.check_unique_name');
155: RAISE;
156: END check_unique_name;
157:
158: --

Line 181: FROM gl_elimination_sets

177: CURSOR set_count IS
178: SELECT 1
179: FROM DUAL
180: WHERE EXISTS (SELECT 1
181: FROM gl_elimination_sets
182: WHERE elimination_set_id = X_setid
183: AND track_elimination_status_flag = 'Y'
184: AND last_executed_period IS NOT NULL);
185: BEGIN

Line 206: 'gl_elimination_sets_pkg.allow_delete_record');

202: WHEN OTHERS THEN
203: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
204: fnd_message.set_token(
205: 'PROCEDURE',
206: 'gl_elimination_sets_pkg.allow_delete_record');
207: RAISE;
208: END allow_delete_record;
209:
210: --

Line 214: -- Locks a row in GL_ELIMINATION_SETS table.

210: --
211: -- Procedure
212: -- lock_row
213: -- Purpose
214: -- Locks a row in GL_ELIMINATION_SETS table.
215: -- History
216: -- 10-SEP-03 P Sahay Created (For Definition Access Set Project)
217: -- Parameters
218: -- All the columns of GL_ELIMINATION_SETS table

Line 218: -- All the columns of GL_ELIMINATION_SETS table

214: -- Locks a row in GL_ELIMINATION_SETS table.
215: -- History
216: -- 10-SEP-03 P Sahay Created (For Definition Access Set Project)
217: -- Parameters
218: -- All the columns of GL_ELIMINATION_SETS table
219: -- (except WHO columns)
220: --
221: -- Notes
222: -- None

Line 278: FROM GL_ELIMINATION_SETS

274: attribute14,
275: attribute15,
276: context,
277: security_flag
278: FROM GL_ELIMINATION_SETS
279: WHERE ROWID = X_Rowid
280: FOR UPDATE OF elimination_set_id NOWAIT;
281: recinfo C%ROWTYPE;
282:

Line 392: End gl_elimination_sets_pkg;

388: END IF;
389:
390: END lock_row;
391:
392: End gl_elimination_sets_pkg;