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_REPOSITORIES

Line 37: l_set_of_books_id cn_repositories.set_of_books_id%TYPE;

33: p_period_name IN VARCHAR2,
34: p_freeze_flag IN VARCHAR2) IS
35:
36: l_acc_period_tbl acc_period_tbl_type;
37: l_set_of_books_id cn_repositories.set_of_books_id%TYPE;
38: l_period_set_id cn_repositories.period_set_id%TYPE;
39: l_period_type_id cn_repositories.period_type_id%TYPE;
40:
41: CURSOR repository_info IS

Line 38: l_period_set_id cn_repositories.period_set_id%TYPE;

34: p_freeze_flag IN VARCHAR2) IS
35:
36: l_acc_period_tbl acc_period_tbl_type;
37: l_set_of_books_id cn_repositories.set_of_books_id%TYPE;
38: l_period_set_id cn_repositories.period_set_id%TYPE;
39: l_period_type_id cn_repositories.period_type_id%TYPE;
40:
41: CURSOR repository_info IS
42: SELECT set_of_books_id,

Line 39: l_period_type_id cn_repositories.period_type_id%TYPE;

35:
36: l_acc_period_tbl acc_period_tbl_type;
37: l_set_of_books_id cn_repositories.set_of_books_id%TYPE;
38: l_period_set_id cn_repositories.period_set_id%TYPE;
39: l_period_type_id cn_repositories.period_type_id%TYPE;
40:
41: CURSOR repository_info IS
42: SELECT set_of_books_id,
43: period_set_id,

Line 45: FROM cn_repositories

41: CURSOR repository_info IS
42: SELECT set_of_books_id,
43: period_set_id,
44: period_type_id
45: FROM cn_repositories
46: WHERE repository_id > 0
47: AND application_type = 'CN';
48:
49: -- copy of cursor in get_acc_periods proc

Line 209: -- 2) update cn_repositories.status if it is the first time to touch accumulation periods

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:
213: PROCEDURE Update_Acc_Periods

Line 228: l_set_of_books_id cn_repositories.set_of_books_id%TYPE;

224: l_api_name CONSTANT VARCHAR2(30) := 'Update_Acc_Periods';
225: l_api_version CONSTANT NUMBER := 1.0;
226: l_request_id NUMBER;
227:
228: l_set_of_books_id cn_repositories.set_of_books_id%TYPE;
229: l_repository_id cn_repositories.repository_id%TYPE;
230: l_calendar cn_period_sets.period_set_name%TYPE;
231: l_period_set_id cn_period_sets.period_set_id%TYPE;
232: l_period_type_id cn_period_types.period_type_id%TYPE;

Line 229: l_repository_id cn_repositories.repository_id%TYPE;

225: l_api_version CONSTANT NUMBER := 1.0;
226: l_request_id NUMBER;
227:
228: l_set_of_books_id cn_repositories.set_of_books_id%TYPE;
229: l_repository_id cn_repositories.repository_id%TYPE;
230: l_calendar cn_period_sets.period_set_name%TYPE;
231: l_period_set_id cn_period_sets.period_set_id%TYPE;
232: l_period_type_id cn_period_types.period_type_id%TYPE;
233: l_period_type cn_period_types.period_type%TYPE;

Line 259: FROM cn_repositories r,

255: ps.period_set_id,
256: ps.period_set_name,
257: pt.period_type,
258: pt.period_type_id
259: FROM cn_repositories r,
260: cn_period_sets ps,
261: cn_period_types pt
262: WHERE r.repository_id > 0
263: AND r.application_type = 'CN'

Line 373: UPDATE cn_repositories

369: -- Initialize API return status to success
370: x_return_status := FND_API.G_RET_STS_SUCCESS;
371:
372: -- API body
373: UPDATE cn_repositories
374: SET status = 'A'
375: WHERE repository_id > 0
376: AND application_type = 'CN'
377: AND org_id = p_org_id; -- MOAC Change

Line 648: l_set_of_books_id cn_repositories.set_of_books_id%TYPE;

644: x_calendar OUT NOCOPY cn_period_sets.period_set_name%TYPE,
645: x_period_type OUT NOCOPY cn_period_types.period_type%TYPE,
646: x_acc_period_tbl OUT NOCOPY acc_period_tbl_type)
647: IS
648: l_set_of_books_id cn_repositories.set_of_books_id%TYPE;
649: l_period_set_id cn_repositories.period_set_id%TYPE;
650: l_period_type_id cn_repositories.period_type_id%TYPE;
651: l_current_year gl_period_statuses.period_year%TYPE;
652:

Line 649: l_period_set_id cn_repositories.period_set_id%TYPE;

645: x_period_type OUT NOCOPY cn_period_types.period_type%TYPE,
646: x_acc_period_tbl OUT NOCOPY acc_period_tbl_type)
647: IS
648: l_set_of_books_id cn_repositories.set_of_books_id%TYPE;
649: l_period_set_id cn_repositories.period_set_id%TYPE;
650: l_period_type_id cn_repositories.period_type_id%TYPE;
651: l_current_year gl_period_statuses.period_year%TYPE;
652:
653: CURSOR current_year IS

Line 650: l_period_type_id cn_repositories.period_type_id%TYPE;

646: x_acc_period_tbl OUT NOCOPY acc_period_tbl_type)
647: IS
648: l_set_of_books_id cn_repositories.set_of_books_id%TYPE;
649: l_period_set_id cn_repositories.period_set_id%TYPE;
650: l_period_type_id cn_repositories.period_type_id%TYPE;
651: l_current_year gl_period_statuses.period_year%TYPE;
652:
653: CURSOR current_year IS
654: SELECT period_year

Line 660: FROM cn_repositories

656: WHERE trunc(sysdate) BETWEEN start_date AND end_date
657: AND application_id = 283
658: AND adjustment_period_flag = 'N'
659: AND set_of_books_id = (SELECT set_of_books_id
660: FROM cn_repositories
661: WHERE repository_id > 0
662: AND application_type = 'CN')
663: AND ROWNUM = 1;
664:

Line 671: FROM cn_repositories

667: FROM gl_period_statuses
668: WHERE application_id = 283
669: AND adjustment_period_flag = 'N'
670: AND set_of_books_id = (SELECT set_of_books_id
671: FROM cn_repositories
672: WHERE repository_id > 0
673: AND application_type = 'CN')
674: ;
675:

Line 681: FROM cn_repositories

677: SELECT status,
678: set_of_books_id,
679: period_set_id,
680: period_type_id
681: FROM cn_repositories
682: WHERE repository_id > 0
683: AND application_type = 'CN';
684:
685: CURSOR calendar IS