eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_PERIOD_TYPES_PKG dependencies on GL_PERIOD_TYPES

Line 1: PACKAGE BODY gl_period_types_pkg AS

1: PACKAGE BODY gl_period_types_pkg AS
2: /* $Header: gliprptb.pls 120.9 2005/05/05 01:18:12 kvora ship $ */
3:
4: --
5: -- PRIVATE FUNCTIONS

Line 18: -- gl_period_types_pkg.select_row(recinfo)

14: -- 11-02-93 D. J. Ogg Created
15: -- Arguments
16: -- recinfo Various information about the row
17: -- Example
18: -- gl_period_types_pkg.select_row(recinfo)
19: -- Notes
20: --
21: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_period_types%ROWTYPE) IS
22: BEGIN

Line 21: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_period_types%ROWTYPE) IS

17: -- Example
18: -- gl_period_types_pkg.select_row(recinfo)
19: -- Notes
20: --
21: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_period_types%ROWTYPE) IS
22: BEGIN
23: SELECT *
24: INTO recinfo
25: FROM gl_period_types

Line 25: FROM gl_period_types

21: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_period_types%ROWTYPE) IS
22: BEGIN
23: SELECT *
24: INTO recinfo
25: FROM gl_period_types
26: WHERE period_type = recinfo.period_type;
27: END SELECT_ROW;
28:
29:

Line 40: recinfo gl_period_types%ROWTYPE;

36: x_user_period_type IN OUT NOCOPY VARCHAR2,
37: x_year_type_in_name IN OUT NOCOPY VARCHAR2,
38: x_number_per_fiscal_year IN OUT NOCOPY NUMBER) IS
39:
40: recinfo gl_period_types%ROWTYPE;
41:
42: BEGIN
43: recinfo.period_type := x_period_type;
44:

Line 56: FROM GL_PERIOD_TYPES pt

52: PROCEDURE Check_Unique_User_Type(x_user_period_type VARCHAR2,
53: x_rowid VARCHAR2) IS
54: CURSOR check_dups is
55: SELECT 1
56: FROM GL_PERIOD_TYPES pt
57: WHERE pt.user_period_type =
58: check_unique_user_type.x_user_period_type
59: AND ( x_rowid is NULL
60: OR pt.rowid <> x_rowid );

Line 87: FROM GL_PERIOD_TYPES pt

83: PROCEDURE Check_Unique_Type(x_period_type VARCHAR2,
84: x_rowid VARCHAR2) IS
85: CURSOR chk_dups is
86: SELECT 1
87: FROM GL_PERIOD_TYPES pt
88: WHERE pt.period_type =
89: check_unique_type.x_period_type
90: AND ( x_rowid is NULL
91: OR pt.rowid <> x_rowid );

Line 102: fnd_message.set_token('TAB_S', 'GL_PERIOD_TYPES_S');

98:
99: IF chk_dups%FOUND THEN
100: CLOSE chk_dups;
101: fnd_message.set_name('SQLGL', 'GL_DUP_UNIQUE_ID');
102: fnd_message.set_token('TAB_S', 'GL_PERIOD_TYPES_S');
103: app_exception.raise_exception;
104: END IF;
105:
106: CLOSE chk_dups;

Line 118: select GL_PERIOD_TYPES_S.NEXTVAL

114:
115: PROCEDURE Get_New_Id(x_period_type IN OUT NOCOPY VARCHAR2) IS
116:
117: BEGIN
118: select GL_PERIOD_TYPES_S.NEXTVAL
119: into x_period_type
120: from dual;
121:
122: IF (x_period_type is NULL) THEN

Line 124: fnd_message.set_token('TAB_S', 'GL_PERIOD_TYPES_S');

120: from dual;
121:
122: IF (x_period_type is NULL) THEN
123: fnd_message.set_name('SQLGL', 'GL_SEQUENCE_NOT_FOUND');
124: fnd_message.set_token('TAB_S', 'GL_PERIOD_TYPES_S');
125: app_exception.raise_exception;
126: END IF;
127: EXCEPTION
128: WHEN app_exception.application_exception THEN RAISE;

Line 153: update gl_period_types

149: end if;
150:
151: /* Update only if force_edits is 'Y' or it is seed data */
152: if ((x_force_edits = 'Y') OR (x_owner = 'SEED')) then
153: update gl_period_types
154: set
155: user_period_type = x_user_period_type,
156: description = x_description,
157: last_update_date = sysdate,

Line 214: from gl_period_types

210: number_per_fiscal_year to update. */
211:
212: select creation_date,rowid,number_per_fiscal_year
213: into v_creation_date, v_rowid, v_num_per_fiscal_yr
214: from gl_period_types
215: where period_type = x_period_type;
216:
217: if ((x_force_edits = 'Y') OR (x_owner = 'SEED')) THEN
218: -- update row if present

Line 219: gl_period_types_pkg.UPDATE_ROW(

215: where period_type = x_period_type;
216:
217: if ((x_force_edits = 'Y') OR (x_owner = 'SEED')) THEN
218: -- update row if present
219: gl_period_types_pkg.UPDATE_ROW(
220: x_row_id => v_rowid,
221: x_period_type => x_period_type,
222: x_number_per_fiscal_year => v_num_per_fiscal_yr,
223: x_year_type_in_name => x_year_type_in_name,

Line 241: gl_period_types_pkg.INSERT_ROW(

237: end if;
238:
239: exception
240: when NO_DATA_FOUND then
241: gl_period_types_pkg.INSERT_ROW(
242: x_row_id => v_rowid,
243: x_period_type => x_period_type,
244: x_number_per_fiscal_year => x_number_per_fiscal_year,
245: x_year_type_in_name => x_year_type_in_name,

Line 285: Update gl_period_types

281: x_last_update_login in number ,
282: x_creation_date in date
283: ) AS
284: BEGIN
285: Update gl_period_types
286: set period_type = x_period_type,
287: number_per_fiscal_year = x_number_per_fiscal_year,
288: year_type_in_name = x_year_type_in_name,
289: user_period_type = x_user_period_type,

Line 331: from gl_period_types

327: )AS
328:
329: cursor period_type_row is
330: select rowid
331: from gl_period_types
332: where period_type = x_period_type;
333: BEGIN
334: if (x_period_type is NULL) then
335: raise no_data_found;

Line 338: INSERT INTO GL_PERIOD_TYPES(

334: if (x_period_type is NULL) then
335: raise no_data_found;
336: end if;
337:
338: INSERT INTO GL_PERIOD_TYPES(
339: period_type,
340: number_per_fiscal_year ,
341: year_type_in_name ,
342: user_period_type,

Line 361: gl_period_types_s.nextval,

357: x_period_type,
358: x_number_per_fiscal_year ,
359: x_year_type_in_name ,
360: x_user_period_type ,
361: gl_period_types_s.nextval,
362: x_description ,
363: x_attribute1,
364: x_attribute2,
365: x_attribute3,

Line 377: from gl_period_types B

373: x_created_by
374: from dual
375: where not exists
376: ( select null
377: from gl_period_types B
378: where B.period_type = x_period_type );
379:
380:
381: open period_type_row;

Line 406: from gl_period_types

402: l_year_type_in_name Varchar2(1);
403:
404: Cursor c1 is select number_per_fiscal_year,
405: year_type_in_name
406: from gl_period_types
407: where period_type = mPeriodType;
408: Begin
409: mReturnValue := 0;
410: open c1;

Line 422: END gl_period_types_pkg;

418: end if;
419:
420: End checkUpdate;
421:
422: END gl_period_types_pkg;