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.CN_ACC_PERIODS_PVT dependencies on CN_PERIOD_STATUSES

Line 60: FROM cn_period_statuses cn,

56: 'O' closing_status_meaning,
57: cp.meaning processing_status,
58: p_freeze_flag,
59: cn.object_version_number
60: FROM cn_period_statuses cn,
61: cn_lookups cp
62: WHERE cp.lookup_type = 'PERIOD_PROCESSING_STATUS'
63: AND cp.lookup_code = nvl(cn.processing_status_code, 'CLEAN')
64: AND cn.period_set_id = l_period_set_id

Line 77: cn_period_statuses cn,

73: cp.meaning processing_status,
74: p_freeze_flag,
75: cn.object_version_number
76: FROM gl_period_statuses gl,
77: cn_period_statuses cn,
78: cn_lookups cp
79: WHERE gl.set_of_books_id = l_set_of_books_id
80: AND gl.application_id = 283
81: AND gl.adjustment_period_flag = 'N'

Line 89: (select 's' from cn_period_statuses cn1

85: AND cn.period_type_id(+) = l_period_type_id
86: AND cn.period_set_id(+) = l_period_set_id
87: AND gl.period_name = p_period_name
88: AND not exists
89: (select 's' from cn_period_statuses cn1
90: where gl.period_name = cn1.period_name
91: and cn1.period_set_id = l_period_set_id
92: and cn1.period_type_id = l_period_type_id);
93:

Line 167: update cn_period_statuses

163: end loop;
164: errbuf := l_msgs;
165: -- any other periods left PROCESSING should be FAILED
166:
167: update cn_period_statuses
168: set processing_status_code = 'FAILED'
169: where processing_status_code = 'PROCESSING'
170: and period_name = l_period_rec.period_name;
171: commit;

Line 207: -- Notes : 1) update period_status, insert period record into cn_period_statuses if the

203: -- x_msg_data OUT VARCHAR2(2000)
204: -- Version : Current version 1.0
205: -- Initial version 1.0
206: --
207: -- Notes : 1) update period_status, insert period record into cn_period_statuses if the
208: -- the corresponding record does not exist in cn_period_statuses
209: -- 2) update cn_repositories.status if it is the first time to touch accumulation periods
210: --
211: -- End of comments

Line 208: -- the corresponding record does not exist in cn_period_statuses

204: -- Version : Current version 1.0
205: -- Initial version 1.0
206: --
207: -- Notes : 1) update period_status, insert period record into cn_period_statuses if the
208: -- the corresponding record does not exist in cn_period_statuses
209: -- 2) update cn_repositories.status if it is the first time to touch accumulation periods
210: --
211: -- End of comments
212:

Line 236: l_object_version_number cn_period_statuses.object_version_number%TYPE;

232: l_period_type_id cn_period_types.period_type_id%TYPE;
233: l_period_type cn_period_types.period_type%TYPE;
234: l_quarter_num gl_period_statuses.quarter_num%TYPE;
235: l_period_num gl_period_statuses.period_num%TYPE;
236: l_object_version_number cn_period_statuses.object_version_number%TYPE;
237: l_closing_status gl_period_statuses.closing_status%TYPE;
238: l_closing_status_old gl_period_statuses.closing_status%TYPE;
239: l_proc_status_old cn_period_statuses.processing_status_code%TYPE;
240: l_freeze_flag_old cn_period_statuses.freeze_flag%TYPE;

Line 239: l_proc_status_old cn_period_statuses.processing_status_code%TYPE;

235: l_period_num gl_period_statuses.period_num%TYPE;
236: l_object_version_number cn_period_statuses.object_version_number%TYPE;
237: l_closing_status gl_period_statuses.closing_status%TYPE;
238: l_closing_status_old gl_period_statuses.closing_status%TYPE;
239: l_proc_status_old cn_period_statuses.processing_status_code%TYPE;
240: l_freeze_flag_old cn_period_statuses.freeze_flag%TYPE;
241: l_pre_status gl_period_statuses.closing_status%TYPE;
242: l_next_status gl_period_statuses.closing_status%TYPE;
243: l_update_flag VARCHAR2(1) := 'N';

Line 240: l_freeze_flag_old cn_period_statuses.freeze_flag%TYPE;

236: l_object_version_number cn_period_statuses.object_version_number%TYPE;
237: l_closing_status gl_period_statuses.closing_status%TYPE;
238: l_closing_status_old gl_period_statuses.closing_status%TYPE;
239: l_proc_status_old cn_period_statuses.processing_status_code%TYPE;
240: l_freeze_flag_old cn_period_statuses.freeze_flag%TYPE;
241: l_pre_status gl_period_statuses.closing_status%TYPE;
242: l_next_status gl_period_statuses.closing_status%TYPE;
243: l_update_flag VARCHAR2(1) := 'N';
244: -- Added as part of bug fix bug#2804029

Line 248: l_temp_start_date cn_period_statuses.start_date%TYPE;

244: -- Added as part of bug fix bug#2804029
245: l_period_status_count NUMBER := 0;
246: l_pre_gl_status_count NUMBER := 0;
247: l_next_gl_status_count NUMBER := 0;
248: l_temp_start_date cn_period_statuses.start_date%TYPE;
249: l_org_id cn_period_statuses.org_id%TYPE;
250:
251:
252: CURSOR repository_info IS

Line 249: l_org_id cn_period_statuses.org_id%TYPE;

245: l_period_status_count NUMBER := 0;
246: l_pre_gl_status_count NUMBER := 0;
247: l_next_gl_status_count NUMBER := 0;
248: l_temp_start_date cn_period_statuses.start_date%TYPE;
249: l_org_id cn_period_statuses.org_id%TYPE;
250:
251:
252: CURSOR repository_info IS
253: SELECT r.set_of_books_id,

Line 277: FROM gl_period_statuses gl, cn_period_statuses cn

273: gl.period_num,
274: cn.object_version_number,
275: gl.closing_status,
276: cn.freeze_flag
277: FROM gl_period_statuses gl, cn_period_statuses cn
278: WHERE gl.application_id = 283
279: AND gl.set_of_books_id = l_set_of_books_id
280: AND gl.period_name = p_period_name
281: AND gl.adjustment_period_flag = 'N'

Line 286: CURSOR cn_period_info(p_period_name cn_period_statuses.period_name%TYPE,

282: AND gl.period_name = cn.period_name(+)
283: AND cn.org_id(+) = p_org_id -- MOAC Change
284: FOR UPDATE OF gl.closing_status nowait;
285:
286: CURSOR cn_period_info(p_period_name cn_period_statuses.period_name%TYPE,
287: p_period_year cn_period_statuses.period_year%TYPE) IS
288: SELECT cn.period_status, processing_status_code
289: FROM cn_period_statuses cn
290: WHERE cn.period_name = p_period_name

Line 287: p_period_year cn_period_statuses.period_year%TYPE) IS

283: AND cn.org_id(+) = p_org_id -- MOAC Change
284: FOR UPDATE OF gl.closing_status nowait;
285:
286: CURSOR cn_period_info(p_period_name cn_period_statuses.period_name%TYPE,
287: p_period_year cn_period_statuses.period_year%TYPE) IS
288: SELECT cn.period_status, processing_status_code
289: FROM cn_period_statuses cn
290: WHERE cn.period_name = p_period_name
291: AND cn.period_year = p_period_year

Line 289: FROM cn_period_statuses cn

285:
286: CURSOR cn_period_info(p_period_name cn_period_statuses.period_name%TYPE,
287: p_period_year cn_period_statuses.period_year%TYPE) IS
288: SELECT cn.period_status, processing_status_code
289: FROM cn_period_statuses cn
290: WHERE cn.period_name = p_period_name
291: AND cn.period_year = p_period_year
292: AND cn.org_id = p_org_id -- MOAC Change
293: AND period_type_id = l_period_type_id

Line 317: (select 's' from cn_period_statuses cn1

313: AND gl.application_id = 283
314: AND gl.adjustment_period_flag = 'N'
315: AND start_date < p_start_date
316: and not exists
317: (select 's' from cn_period_statuses cn1
318: where gl.period_name = cn1.period_name
319: and cn1.period_set_id = l_period_set_id
320: and cn1.PERIOD_TYPE_id = l_period_type_id
321: and cn1.org_id = p_org_id) -- MOAC Change

Line 324: FROM cn_period_statuses cn

320: and cn1.PERIOD_TYPE_id = l_period_type_id
321: and cn1.org_id = p_org_id) -- MOAC Change
322: UNION
323: SELECT cn.period_status,start_date
324: FROM cn_period_statuses cn
325: WHERE cn.period_set_id = l_period_set_id
326: AND cn.period_type_id = l_period_type_id
327: AND cn.org_id = p_org_id -- MOAC Change
328: AND cn.start_date < p_start_date

Line 347: FROM cn_period_statuses cn

343: -- as part of bug fix bug#2804029
344:
345: CURSOR next_status(p_start_date DATE) IS
346: SELECT cn.period_status
347: FROM cn_period_statuses cn
348: WHERE cn.period_set_id = l_period_set_id
349: AND cn.PERIOD_TYPE_id = l_period_type_id
350: AND cn.org_id = p_org_id -- MOAC Change
351: AND cn.start_date > p_start_date

Line 554: -- create a matching CN_PERIOD_STATUSES record if necessary

550: sysdate,
551: fnd_global.login_id,
552: fnd_global.user_id);
553:
554: -- create a matching CN_PERIOD_STATUSES record if necessary
555: cn_periods_api.check_cn_period_record
556: (x_org_id => p_org_id, -- MOAC Change
557: x_period_name => p_acc_period_tbl(i).period_name,
558: x_closing_status => l_closing_status,

Line 573: -- commit here to force the update on cn_period_statuses.

569: END IF;
570: END LOOP;
571:
572: -- bug 1979768 : move all the srp table insert into a concurrent program
573: -- commit here to force the update on cn_period_statuses.
574: --commit;
575:
576: --this section is added for intimating the user that updates were not saved
577: --because the information was identical to what exists in the db.

Line 705: FROM cn_period_statuses cn,

701: gp.meaning closing_status_meaning,
702: cp.meaning processing_status,
703: cn.freeze_flag,
704: cn.object_version_number
705: FROM cn_period_statuses cn,
706: cn_lookups gp,
707: cn_lookups cp
708: WHERE
709: gp.lookup_type = 'PERIOD_CLOSING_STATUS'

Line 726: cn_period_statuses cn,

722: cp.meaning processing_status,
723: cn.freeze_flag,
724: cn.object_version_number
725: FROM gl_period_statuses gl,
726: cn_period_statuses cn,
727: cn_lookups gp,
728: cn_lookups cp
729: WHERE gl.set_of_books_id = l_set_of_books_id
730: AND gl.application_id = 283

Line 741: (select 's' from cn_period_statuses cn1

737: AND gl.period_year = nvl(p_year, l_current_year)
738: AND cn.period_type_id(+) = l_period_type_id
739: AND cn.period_set_id (+) = l_period_set_id
740: and not exists
741: (select 's' from cn_period_statuses cn1
742: where gl.period_name = cn1.period_name
743: and cn1.period_set_id = l_period_set_id
744: and cn1.period_type_id = l_period_type_id)
745: order by 2,3;