APPS.FV_FACTS1_GL_PKG dependencies on FV_FACTS1_HEADER_ID_GT

Line 503: FV_UTILITY.LOG_MESG('Inserting into fv_facts1_header_id_gt');

499: k BINARY_INTEGER := 1;
500: BEGIN
501: l_module_name := g_module_name || 'PROCESS_GL_LINES';
502: FV_UTILITY.LOG_MESG('In '||l_module_name);
503: FV_UTILITY.LOG_MESG('Inserting into fv_facts1_header_id_gt');
504: IF gbl_called_from_main = 'N' THEN
505: INSERT INTO fv_facts1_header_id_gt
506: (je_header_id,set_of_books_id
507: )

Line 505: INSERT INTO fv_facts1_header_id_gt

501: l_module_name := g_module_name || 'PROCESS_GL_LINES';
502: FV_UTILITY.LOG_MESG('In '||l_module_name);
503: FV_UTILITY.LOG_MESG('Inserting into fv_facts1_header_id_gt');
504: IF gbl_called_from_main = 'N' THEN
505: INSERT INTO fv_facts1_header_id_gt
506: (je_header_id,set_of_books_id
507: )
508: SELECT gjh.je_header_id ,
509: gjh.ledger_id

Line 533: Fnd_Stats.GATHER_TABLE_STATS(ownname=>'FV',tabname=>'FV_FACTS1_HEADER_ID_GT');

529: ) ;
530:
531: FV_UTILITY.LOG_MESG('Inserted ' || SQL%ROWCOUNT);
532: COMMIT;
533: Fnd_Stats.GATHER_TABLE_STATS(ownname=>'FV',tabname=>'FV_FACTS1_HEADER_ID_GT');
534: END IF;
535: l_select_stmt := ' gjl.code_combination_id,
536: gjh.ledger_id,
537: glcc.'||gbl_acc_segment|| ',

Line 605: FV_FACTS1_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,

601: fv_utility.log_mesg('Running in full mode');
602: fv_utility.log_mesg(l_select_stmt);
603: ELSE
604: l_select_stmt := 'SELECT /*+ ORDERED INDEX(gjh GL_JE_HEADERS_U1, ftt
605: FV_FACTS1_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,
606: glcc GL_CODE_COMBINATIONS_U1,
607: fff FV_FACTS1_FED_ACCOUNTS_U1) */ ' ||l_select_stmt ||
608: ' FROM fv_facts1_header_id_gt ftt
609: , gl_je_headers gjh

Line 608: ' FROM fv_facts1_header_id_gt ftt

604: l_select_stmt := 'SELECT /*+ ORDERED INDEX(gjh GL_JE_HEADERS_U1, ftt
605: FV_FACTS1_HEADER_ID_GT_U1, gjl GL_JE_LINES_U1,
606: glcc GL_CODE_COMBINATIONS_U1,
607: fff FV_FACTS1_FED_ACCOUNTS_U1) */ ' ||l_select_stmt ||
608: ' FROM fv_facts1_header_id_gt ftt
609: , gl_je_headers gjh
610: , gl_je_lines gjl
611: , (SELECT period_num
612: , period_name

Line 911: INTO fv_facts1_header_id_gt

907: END IF;
908: END LOOP;
909: FORALL i IN je_header_id_list_new.first .. je_header_id_list_new.last
910: INSERT
911: INTO fv_facts1_header_id_gt
912: (
913: je_header_id,
914: set_of_books_id
915: )

Line 1613: to_char( amount,''99,999,999,999,999,999.99'') ' || ' FROM fv_facts1_header_id_gt f ,

1609: substr(rpad(b.name, 40, '' ''),1,40) || '' '' ||
1610: substr(rpad(h.je_category, 15, '' ''),1,15) || '' '' ||
1611: substr(rpad(l.account_number, 9, '' ''),1,9) || '' '' ||
1612: substr(rpad(l.fund_value, 20, '' ''),1,20) || '' '' ||
1613: to_char( amount,''99,999,999,999,999,999.99'') ' || ' FROM fv_facts1_header_id_gt f ,
1614: gl_je_headers h,
1615: fv_facts1_line_balances l,
1616: gl_je_batches b
1617: where h.je_header_id = f.je_header_id

Line 1683: SELECT DISTINCT je_header_id,set_of_books_id FROM fv_facts1_header_id_gt;

1679: IF gbl_called_from_main = 'Y' THEN
1680: INSERT INTO fv_facts1_processed_je_hdrs
1681: (je_header_id,set_of_books_id
1682: )
1683: SELECT DISTINCT je_header_id,set_of_books_id FROM fv_facts1_header_id_gt;
1684: ELSE
1685: INSERT INTO fv_facts1_processed_je_hdrs
1686: (je_header_id,set_of_books_id
1687: )

Line 1688: SELECT je_header_id,set_of_books_id FROM fv_facts1_header_id_gt;

1684: ELSE
1685: INSERT INTO fv_facts1_processed_je_hdrs
1686: (je_header_id,set_of_books_id
1687: )
1688: SELECT je_header_id,set_of_books_id FROM fv_facts1_header_id_gt;
1689: END IF;
1690: fv_utility.log_mesg('Inserted ' || SQL%ROWCOUNT);
1691: fv_utility.log_mesg('Updating Facts1 run ' );
1692: UPDATE fv_facts1_run