APPS.FV_FACTS1_GL_PKG dependencies on FV_FACTS1_FED_ACCOUNTS

Line 121: FROM fv_facts1_fed_accounts

117: AND ledger_id = p_sob_id
118: AND period_name = p_period_name;
119: SELECT COUNT(*)
120: INTO l_no_fed_account
121: FROM fv_facts1_fed_accounts
122: WHERE set_of_books_id = p_sob_id
123: AND fiscal_year = l_period_year;
124: IF l_no_fed_account = 0 THEN
125: p_err_buff := 'Please run the FACTS-1 Federal Accounts Creation process for this SOB

Line 355: -- the period being run, for all accounts existing in fv_facts1_fed_accounts and

351: FV_UTILITY.LOG_MESG('When others error in module: log: '||sqlerrm);
352: END log;
353: --------------------------------------------------------------------------------
354: -- Select all journal lines from gl_je_lines from the beginning of the year upto
355: -- the period being run, for all accounts existing in fv_facts1_fed_accounts and
356: -- all journal lines not existing in fv_facts1_line_balances.
357: -- Retreives party info like party type, eliminations dept, etc and insert into
358: -- fv_facts1_line_balances.
359: --------------------------------------------------------------------------------

Line 425: TABLE OF fv_facts1_fed_accounts.fed_non_fed%TYPE;

421: IS
422: TABLE OF fv_facts1_line_balances.account_number%TYPE;
423: TYPE fed_nonfed_t
424: IS
425: TABLE OF fv_facts1_fed_accounts.fed_non_fed%TYPE;
426: TYPE g_ng_indicator_t
427: IS
428: TABLE OF fv_facts1_line_balances.g_ng_indicator%TYPE;
429: TYPE record_category_t

Line 568: fv_facts1_fed_accounts fff,

564: NVL(gjh.je_from_sla_flag, ''N''),
565: gjh.je_batch_id ';
566: IF gbl_called_from_main = 'Y' THEN
567: l_select_stmt := 'SELECT ' || l_select_stmt || ' FROM
568: fv_facts1_fed_accounts fff,
569: gl_code_combinations glcc,
570: ( SELECT period_num, period_name
571: FROM gl_period_statuses
572: WHERE application_id = 101

Line 607: fff FV_FACTS1_FED_ACCOUNTS_U1) */ ' ||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
610: , gl_je_lines gjl
611: , (SELECT period_num

Line 619: , fv_facts1_fed_accounts fff

615: AND ledger_id = :gbl_sob_id
616: AND period_num BETWEEN :gbl_period_num_low AND :gbl_period_num_high
617: AND period_year = :gbl_period_year) gps
618: , gl_code_combinations glcc
619: , fv_facts1_fed_accounts fff
620: WHERE gjh.period_name = gps.period_name
621: AND gjl.ledger_id = :gbl_sob_id
622: AND gjl.je_header_id = ftt.je_header_id
623: AND gjh.currency_code <> ''STAT''

Line 1700: fv_utility.log_mesg('Updating fv_facts1_fed_accounts ' );

1696: WHERE set_of_books_id = gbl_sob_id
1697: AND fiscal_year = gbl_period_year
1698: AND table_indicator = 'N';
1699: --Update the fv_facts1_fed_account as processed as of date.
1700: fv_utility.log_mesg('Updating fv_facts1_fed_accounts ' );
1701: UPDATE fv_facts1_fed_accounts
1702: SET jc_flag = 'Y'
1703: WHERE set_of_books_id = gbl_sob_id
1704: AND fiscal_year = gbl_period_year;

Line 1701: UPDATE fv_facts1_fed_accounts

1697: AND fiscal_year = gbl_period_year
1698: AND table_indicator = 'N';
1699: --Update the fv_facts1_fed_account as processed as of date.
1700: fv_utility.log_mesg('Updating fv_facts1_fed_accounts ' );
1701: UPDATE fv_facts1_fed_accounts
1702: SET jc_flag = 'Y'
1703: WHERE set_of_books_id = gbl_sob_id
1704: AND fiscal_year = gbl_period_year;
1705: EXCEPTION