APPS.FV_FACTS_TRX_REGISTER dependencies on FV_FACTS_ATTRIBUTES

Line 808: l_balance_type_flag FV_FACTS_ATTRIBUTES.balance_type%TYPE;

804: l_name VARCHAR2(150);
805: l_valid_flag VARCHAR2(2);
806: l_feeder_flag VARCHAR2(1);
807: l_stage NUMBER(2);
808: l_balance_type_flag FV_FACTS_ATTRIBUTES.balance_type%TYPE;
809: l_sob NUMBER(15);
810: l_coa NUMBER(15);
811: l_period_num_low NUMBER(15);
812: l_period_num_high NUMBER(15);

Line 1617: FROM FV_FACTS_ATTRIBUTES

1613: -- Get the account or the parent account
1614: BEGIN
1615: SELECT 'X'
1616: INTO l_exists
1617: FROM FV_FACTS_ATTRIBUTES
1618: WHERE facts_acct_number = l_account_number
1619: AND set_of_books_id = g_set_of_books_id;
1620: -- AND EXISTS (SELECT 'X'
1621: -- FROM fv_facts_ussgl_accounts

Line 1624: -- Account Number exists in FV_FACTS_ATTRIBUTES table

1620: -- AND EXISTS (SELECT 'X'
1621: -- FROM fv_facts_ussgl_accounts
1622: -- WHERE ussgl_account = l_account_number);
1623:
1624: -- Account Number exists in FV_FACTS_ATTRIBUTES table
1625: -- and can be used to get FACTS attributes.
1626: -- l_sgl_acct_num := l_account_number;
1627:
1628: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4406: -- segment from FV_FACTS_ATTRIBUTES table and load them into global

4402: -- -------------------------------------------------------------------
4403: -- PROCEDURE LOAD_FACTS_ATTRIBUTES
4404: -- -------------------------------------------------------------------
4405: -- This procedure selects the attributes for the Account number
4406: -- segment from FV_FACTS_ATTRIBUTES table and load them into global
4407: -- variables for usage in the FACTS Main process. It also calculates
4408: -- one time pull up values for the account number that does not
4409: -- require drill down into GL transactions.
4410: -- ------------------------------------------------------------------

Line 4464: FROM FV_FACTS_ATTRIBUTES

4460: g_govt_non_govt_ind,
4461: g_exch_non_exch_ind,
4462: g_cust_non_cust_ind,
4463: g_budget_subfunction_ind
4464: FROM FV_FACTS_ATTRIBUTES
4465: WHERE Facts_Acct_Number = acct_num
4466: AND set_of_books_id = g_set_of_books_id;
4467: g_attributes_found :='Y';
4468: EXCEPTION

Line 4790: -- Look for parent in FV_FACTS_ATTRIBUTES table

4786: FROM fv_facts_ussgl_accounts
4787: WHERE ussgl_account = parent_flex_value);
4788:
4789: BEGIN
4790: -- Look for parent in FV_FACTS_ATTRIBUTES table
4791: SELECT 'X'
4792: INTO l_exists
4793: FROM fv_facts_attributes
4794: WHERE facts_acct_number = sgl_acct_num

Line 4793: FROM fv_facts_attributes

4789: BEGIN
4790: -- Look for parent in FV_FACTS_ATTRIBUTES table
4791: SELECT 'X'
4792: INTO l_exists
4793: FROM fv_facts_attributes
4794: WHERE facts_acct_number = sgl_acct_num
4795: AND set_of_books_id = g_set_of_books_id;
4796: -- Return the account Number
4797: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN