APPS.GL_DATE_PERIOD_MAP_PKG dependencies on GL_DATE_PERIOD_MAP

Line 1: PACKAGE BODY gl_date_period_map_pkg AS

1: PACKAGE BODY gl_date_period_map_pkg AS
2: /* $Header: gliprmpb.pls 120.3.12010000.2 2010/04/30 13:36:47 sommukhe ship $ */
3: --
4: -- PRIVATE FUNCTIONS
5: --

Line 22: -- do we already have this year in GL_DATE_PERIOD_MAP?

18: dummy VARCHAR2(100);
19: new_year_flag VARCHAR2(1);
20: new_entered_year VARCHAR2(30);
21: BEGIN
22: -- do we already have this year in GL_DATE_PERIOD_MAP?
23: SELECT '1' INTO dummy FROM sys.dual
24: WHERE EXISTS
25: (SELECT 'Existing Year'
26: FROM gl_date_period_map

Line 26: FROM gl_date_period_map

22: -- do we already have this year in GL_DATE_PERIOD_MAP?
23: SELECT '1' INTO dummy FROM sys.dual
24: WHERE EXISTS
25: (SELECT 'Existing Year'
26: FROM gl_date_period_map
27: WHERE
28: period_set_name = x_period_set_name
29: AND period_type = x_period_type
30: AND accounting_date BETWEEN

Line 40: -- year into the GL_DATE_PERIOD_MAP table

36: EXCEPTION
37: WHEN NO_DATA_FOUND THEN
38: -- NO, this is a new year
39: -- Insert placeholder records (with period_name = NOT ASSIGNED) for the new
40: -- year into the GL_DATE_PERIOD_MAP table
41: new_entered_year := x_entered_year;
42: INSERT INTO gl_date_period_map
43: (
44: period_set_name,

Line 42: INSERT INTO gl_date_period_map

38: -- NO, this is a new year
39: -- Insert placeholder records (with period_name = NOT ASSIGNED) for the new
40: -- year into the GL_DATE_PERIOD_MAP table
41: new_entered_year := x_entered_year;
42: INSERT INTO gl_date_period_map
43: (
44: period_set_name,
45: period_type,
46: accounting_date,

Line 74: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_date_period_map%ROWTYPE) IS

70:
71: END;
72:
73:
74: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_date_period_map%ROWTYPE) IS
75: BEGIN
76: SELECT *
77: INTO recinfo
78: FROM gl_date_period_map

Line 78: FROM gl_date_period_map

74: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_date_period_map%ROWTYPE) IS
75: BEGIN
76: SELECT *
77: INTO recinfo
78: FROM gl_date_period_map
79: WHERE period_set_name = recinfo.period_set_name
80: AND period_type = recinfo.period_type
81: AND accounting_date = recinfo.accounting_date;
82:

Line 141: -- Update period_name column in GL_DATE_PERIOD_MAP table

137: );
138: END IF;
139:
140:
141: -- Update period_name column in GL_DATE_PERIOD_MAP table
142: -- (only non-adjusting periods)
143: IF (x_adjust_period_flag = 'N') THEN
144: IF (x_operation = 'INSERT') THEN
145: -- For new periods being inserted:

Line 146: UPDATE gl_date_period_map

142: -- (only non-adjusting periods)
143: IF (x_adjust_period_flag = 'N') THEN
144: IF (x_operation = 'INSERT') THEN
145: -- For new periods being inserted:
146: UPDATE gl_date_period_map
147: SET period_name = x_period_name
148: WHERE
149: accounting_date between
150: x_start_date

Line 158: UPDATE gl_date_period_map

154:
155: ELSIF(x_operation = 'DELETE') THEN
156:
157: -- For existing periods being updated:
158: UPDATE gl_date_period_map
159: SET period_name = 'NOT ASSIGNED'
160: WHERE
161: ( accounting_date between x_start_date AND x_end_date
162: OR period_name = x_period_name)

Line 168: UPDATE gl_date_period_map

164: AND period_type = x_period_type;
165: ELSE
166:
167: -- For existing periods being updated:
168: UPDATE gl_date_period_map
169: SET period_name = DECODE(LEAST(accounting_date, x_start_date-1),
170: accounting_date, 'NOT ASSIGNED',
171: DECODE(GREATEST(accounting_date, x_end_date+1),
172: accounting_date, 'NOT ASSIGNED',

Line 186: 'gl_date_period_map_pkg.maintain_date_period_map');

182: EXCEPTION
183: WHEN OTHERS THEN
184: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
185: fnd_message.set_token('PROCEDURE',
186: 'gl_date_period_map_pkg.maintain_date_period_map');
187: RAISE;
188:
189: END maintain_date_period_map;
190:

Line 199: recinfo gl_date_period_map%ROWTYPE;

195: x_period_type VARCHAR2,
196: x_accounting_date DATE,
197: x_period_name IN OUT NOCOPY VARCHAR2) IS
198:
199: recinfo gl_date_period_map%ROWTYPE;
200:
201: BEGIN
202: recinfo.period_set_name := x_period_set_name;
203: recinfo.period_type := x_period_type;