[Home] [Help]
18: gbl_period_num_high gl_period_statuses.period_num%TYPE;
19: gbl_period_year gl_period_statuses.period_year%TYPE;
20: gbl_exception_rec_count NUMBER;
21: gbl_called_from_main VARCHAR2(1);
22: gbl_header_id gl_je_headers.je_header_id%type := 0;
23: gbl_trading_partner_att fv_be_trx_dtls.attribute1%TYPE;
24: gbl_manual_source_flag VARCHAR2(1) := 'N';
25:
26:
437:
438: TYPE t_ref_cur IS REF CURSOR ;
439: l_gl_lines_cur t_ref_cur ;
440:
441: TYPE je_header_id_t IS TABLE OF gl_je_headers.je_header_id%TYPE;
442: TYPE je_category_t IS TABLE OF gl_je_headers.je_category%TYPE;
443: TYPE je_source_t IS TABLE OF gl_je_headers.je_source%TYPE;
444: TYPE je_line_num_t IS TABLE OF gl_je_lines.je_line_num%TYPE;
445: TYPE sob_id_t IS TABLE OF gl_je_lines.ledger_id%TYPE;
438: TYPE t_ref_cur IS REF CURSOR ;
439: l_gl_lines_cur t_ref_cur ;
440:
441: TYPE je_header_id_t IS TABLE OF gl_je_headers.je_header_id%TYPE;
442: TYPE je_category_t IS TABLE OF gl_je_headers.je_category%TYPE;
443: TYPE je_source_t IS TABLE OF gl_je_headers.je_source%TYPE;
444: TYPE je_line_num_t IS TABLE OF gl_je_lines.je_line_num%TYPE;
445: TYPE sob_id_t IS TABLE OF gl_je_lines.ledger_id%TYPE;
446: TYPE ccid_t IS TABLE OF gl_je_lines.code_combination_id%TYPE;
439: l_gl_lines_cur t_ref_cur ;
440:
441: TYPE je_header_id_t IS TABLE OF gl_je_headers.je_header_id%TYPE;
442: TYPE je_category_t IS TABLE OF gl_je_headers.je_category%TYPE;
443: TYPE je_source_t IS TABLE OF gl_je_headers.je_source%TYPE;
444: TYPE je_line_num_t IS TABLE OF gl_je_lines.je_line_num%TYPE;
445: TYPE sob_id_t IS TABLE OF gl_je_lines.ledger_id%TYPE;
446: TYPE ccid_t IS TABLE OF gl_je_lines.code_combination_id%TYPE;
447: TYPE attribute_val_t IS TABLE OF gl_je_lines.attribute1%TYPE;
461: TYPE record_category_t IS TABLE OF fv_facts1_line_balances.record_category%TYPE;
462: TYPE varchar_1_t IS TABLE OF VARCHAR2(1);
463: TYPE period_num_t IS TABLE OF gl_period_statuses.period_num%TYPE;
464: TYPE je_from_sla_flag_t IS TABLE OF VARCHAR2(1);
465: TYPE je_batch_id_t IS TABLE OF gl_je_headers.je_batch_id%TYPE;
466:
467: je_header_id_list_new je_header_id_t;
468: je_header_id_list je_header_id_t;
469: je_category_list je_category_t;
546: WHERE application_id = 101
547: AND ledger_id = gbl_sob_id
548: AND period_num BETWEEN gbl_period_num_low AND gbl_period_num_high
549: AND period_year = gbl_period_year) gps,
550: gl_je_headers gjh
551: where gjh.period_name = gps.period_name
552: and gjh.ledger_id = gbl_sob_id
553: AND gjh.status = 'P'
554: AND gjh.actual_flag = 'A'
608: AND ledger_id = :gbl_sob_id
609: AND period_num BETWEEN :gbl_period_num_low AND :gbl_period_num_high
610: AND period_year = :gbl_period_year ) gps,
611: gl_je_lines gjl,
612: gl_je_headers gjh
613: WHERE fff.jc_flag = ''N''
614: AND fff.set_of_books_id = :gbl_sob_id
615: AND fff.fiscal_year = :gbl_period_year
616: AND glcc.'||gbl_acc_segment || ' = fff.account_number
634:
635: else
636:
637:
638: l_select_stmt := 'SELECT /*+ ORDERED INDEX(gjh GL_JE_HEADERS_U1, ftt
639: FV_FACTS1_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,
640: glcc GL_CODE_COMBINATIONS_U1,
641: fff FV_FACTS1_FED_ACCOUNTS_U1) */ ' ||l_select_stmt ||
642: ' FROM fv_facts1_header_id_gt ftt
639: FV_FACTS1_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,
640: glcc GL_CODE_COMBINATIONS_U1,
641: fff FV_FACTS1_FED_ACCOUNTS_U1) */ ' ||l_select_stmt ||
642: ' FROM fv_facts1_header_id_gt ftt
643: , gl_je_headers gjh
644: , gl_je_lines gjl
645: , (SELECT period_num
646: , period_name
647: FROM gl_period_statuses ps
1675: substr(rpad(l.account_number, 9, '' ''),1,9) || '' '' ||
1676: substr(rpad(l.fund_value, 20, '' ''),1,20) || '' '' ||
1677: to_char( amount,''99,999,999,999,999,999.99'') ' ||
1678: ' FROM fv_facts1_header_id_gt f ,
1679: gl_je_headers h,
1680: fv_facts1_line_balances l,
1681: gl_je_batches b
1682: where h.je_header_id = f.je_header_id
1683: and l.je_header_id = h.je_header_id