[Home] [Help]
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;
234: l_quarter_num gl_period_statuses.quarter_num%TYPE;
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;
234: l_quarter_num gl_period_statuses.quarter_num%TYPE;
235: l_period_num gl_period_statuses.period_num%TYPE;
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'
264: AND r.period_set_id = ps.period_set_id
640: -- populate the accumulation periods screen
641: PROCEDURE get_acc_periods
642: (p_year IN NUMBER,
643: x_system_status OUT NOCOPY cn_lookups.meaning%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;
683: AND application_type = 'CN';
684:
685: CURSOR calendar IS
686: SELECT period_set_name
687: FROM cn_period_sets
688: WHERE period_set_id = l_period_set_id;
689:
690: CURSOR period_type IS
691: SELECT period_type