APPS.GL_PERIOD_SETS_PKG dependencies on GL_PERIOD_SETS

Line 1: PACKAGE BODY gl_period_sets_pkg AS

1: PACKAGE BODY gl_period_sets_pkg AS
2: /* $Header: gliprseb.pls 120.10 2005/05/05 01:18:26 kvora ship $ */
3:
4: --
5: -- PUBLIC FUNCTIONS

Line 11: FROM GL_PERIOD_SETS gps

7:
8: PROCEDURE check_unique(calendar_name VARCHAR2, row_id VARCHAR2) IS
9: CURSOR chk_duplicates is
10: SELECT 'Duplicate'
11: FROM GL_PERIOD_SETS gps
12: WHERE gps.period_set_name = calendar_name
13: AND ( row_id is null
14: OR gps.rowid <> row_id);
15: dummy VARCHAR2(100);

Line 33: fnd_message.set_token('PROCEDURE', 'gl_period_sets_pkg.check_unique');

29: WHEN app_exceptions.application_exception THEN
30: RAISE;
31: WHEN OTHERS THEN
32: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
33: fnd_message.set_token('PROCEDURE', 'gl_period_sets_pkg.check_unique');
34: RAISE;
35: END check_unique;
36:
37:

Line 41: SELECT gl_period_sets_s.NEXTVAL

37:
38:
39: FUNCTION get_unique_id RETURN NUMBER IS
40: CURSOR get_new_id IS
41: SELECT gl_period_sets_s.NEXTVAL
42: FROM dual;
43: new_id number;
44: BEGIN
45: OPEN get_new_id;

Line 54: fnd_message.set_token('SEQUENCE', 'GL_PERIOD_SETS_S');

50: return(new_id);
51: ELSE
52: CLOSE get_new_id;
53: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
54: fnd_message.set_token('SEQUENCE', 'GL_PERIOD_SETS_S');
55: app_exception.raise_exception;
56: END IF;
57:
58: EXCEPTION

Line 63: fnd_message.set_token('PROCEDURE', 'gl_period_sets_pkg.get_unique_id');

59: WHEN app_exceptions.application_exception THEN
60: RAISE;
61: WHEN OTHERS THEN
62: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
63: fnd_message.set_token('PROCEDURE', 'gl_period_sets_pkg.get_unique_id');
64: RAISE;
65: END get_unique_id;
66:
67:

Line 85: FROM gl_period_sets

81: X_Attribute4 VARCHAR2,
82: X_Attribute5 VARCHAR2) IS
83: CURSOR period_sets_row IS
84: SELECT rowid
85: FROM gl_period_sets
86: WHERE period_set_name = X_Period_Set_Name;
87: BEGIN
88: IF ( X_Period_Set_Name is NULL ) THEN
89: RAISE NO_DATA_FOUND;

Line 92: INSERT INTO GL_PERIOD_SETS (

88: IF ( X_Period_Set_Name is NULL ) THEN
89: RAISE NO_DATA_FOUND;
90: END IF;
91:
92: INSERT INTO GL_PERIOD_SETS (
93: period_set_name,
94: security_flag,
95: description,
96: last_update_date,

Line 125: FROM gl_period_sets GPS

121: X_Attribute5
122: FROM DUAL
123: WHERE NOT EXISTS
124: ( SELECT NULL
125: FROM gl_period_sets GPS
126: WHERE GPS.period_set_name = X_Period_Set_Name);
127:
128: OPEN period_sets_row;
129: FETCH period_sets_row into X_Rowid;

Line 151: UPDATE gl_period_sets

147: X_Attribute3 VARCHAR2,
148: X_Attribute4 VARCHAR2,
149: X_Attribute5 VARCHAR2) IS
150: BEGIN
151: UPDATE gl_period_sets
152: SET period_set_name = X_Period_Set_Name,
153: security_flag = X_Security_Flag,
154: description = X_Description,
155: last_updated_by = X_Last_Updated_By,

Line 197: FROM gl_period_sets

193:
194: BEGIN
195: SELECT creation_date, rowid, security_flag
196: INTO v_creation_date, v_rowid, v_security_flag
197: FROM gl_period_sets
198: WHERE period_set_name = X_Period_Set_Name;
199:
200: IF ( X_Owner = 'SEED' ) THEN
201: gl_period_sets_pkg.Update_Row(

Line 201: gl_period_sets_pkg.Update_Row(

197: FROM gl_period_sets
198: WHERE period_set_name = X_Period_Set_Name;
199:
200: IF ( X_Owner = 'SEED' ) THEN
201: gl_period_sets_pkg.Update_Row(
202: X_Rowid => v_rowid,
203: X_Period_Set_Name => X_Period_Set_Name,
204: X_Security_Flag => v_security_flag,
205: X_Last_Updated_By => v_user_id,

Line 219: gl_period_sets_pkg.Insert_Row(

215: END IF;
216:
217: EXCEPTION
218: WHEN NO_DATA_FOUND THEN
219: gl_period_sets_pkg.Insert_Row(
220: X_Rowid => v_rowid,
221: X_Period_Set_Name => X_Period_Set_Name,
222: X_Security_Flag => 'N',
223: X_Creation_Date => sysdate,

Line 255: FROM gl_period_sets

251: X_Context VARCHAR2,
252: X_Security_Flag VARCHAR2) IS
253: CURSOR C IS
254: SELECT *
255: FROM gl_period_sets
256: WHERE rowid = X_Rowid
257: FOR UPDATE of period_set_name NOWAIT;
258: Recinfo C%ROWTYPE;
259: BEGIN

Line 340: END gl_period_sets_pkg;

336:
337: return req_id;
338: END submit_concurrent;
339:
340: END gl_period_sets_pkg;