APPS.GL_AUTOREVERSE_OPTIONS_PKG dependencies on GL_AUTOREVERSE_OPTIONS

Line 1: PACKAGE BODY GL_AUTOREVERSE_OPTIONS_PKG as

1: PACKAGE BODY GL_AUTOREVERSE_OPTIONS_PKG as
2: /* $Header: glistarb.pls 120.7 2004/10/14 23:08:09 spala ship $ */
3:
4: --
5: -- PRIVATE FUNCTIONS

Line 42: FROM gl_autoreverse_options

38: ) IS
39:
40: CURSOR C IS
41: SELECT *
42: FROM gl_autoreverse_options
43: WHERE rowid = X_Rowid
44: FOR UPDATE of criteria_set_Id NOWAIT;
45:
46: Recinfo C%ROWTYPE;

Line 154: UPDATE gl_autoreverse_options

150: X_Context VARCHAR2
151:
152: ) IS
153: BEGIN
154: UPDATE gl_autoreverse_options
155: SET
156: criteria_set_id = X_criteria_set_Id,
157: je_category_name = X_Je_Category_Name,
158: method_code = X_Method_Code,

Line 198: FROM gl_autoreverse_options

194: x_last_updated_by NUMBER,
195: x_last_update_login NUMBER ) IS
196: CURSOR c_dup IS
197: SELECT 'Duplicate'
198: FROM gl_autoreverse_options
199: WHERE je_category_name = x_je_category_name ;
200: dummy VARCHAR2(100);
201:
202: BEGIN

Line 207: INSERT INTO gl_autoreverse_options (

203: OPEN c_dup;
204: FETCH c_dup INTO dummy;
205:
206: IF c_dup%NOTFOUND THEN
207: INSERT INTO gl_autoreverse_options (
208: criteria_set_id,
209: je_category_name,
210: method_code,
211: reversal_period_code,

Line 226: FROM GL_AUTOREVERSE_OPTIONS;

222: 'N',
223: sysdate, x_last_updated_by,
224: x_created_by, sysdate,
225: x_last_update_login
226: FROM GL_AUTOREVERSE_OPTIONS;
227:
228: END IF;
229:
230: CLOSE c_dup;

Line 251: INSERT INTO gl_autoreverse_options (

247: x_created_by NUMBER,
248: x_last_updated_by NUMBER,
249: x_last_update_login NUMBER ) IS
250: BEGIN
251: INSERT INTO gl_autoreverse_options (
252: criteria_set_id,
253: je_category_name,
254: method_code,
255: reversal_period_code,

Line 294: 'GL_AUTOREVERSE_OPTIONS_PKG.insert_ledger_reversal_cat');

290: EXCEPTION
291: WHEN OTHERS THEN
292: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
293: fnd_message.set_token('PROCEDURE',
294: 'GL_AUTOREVERSE_OPTIONS_PKG.insert_ledger_reversal_cat');
295: RAISE;
296:
297: END insert_criteria_reversal_cat;
298:

Line 299: END GL_AUTOREVERSE_OPTIONS_PKG;

295: RAISE;
296:
297: END insert_criteria_reversal_cat;
298:
299: END GL_AUTOREVERSE_OPTIONS_PKG;