APPS.FV_FACTS1_PKG dependencies on FV_FACTS_ATTRIBUTES

Line 994: l_e_ne_ind Fv_Facts_Attributes.exch_non_exch%TYPE;

990:
991: l_exists VARCHAR2(1);
992: l_row_exists VARCHAR2(1);
993: l_g_ng_ind Fv_Facts_Report_T2.g_ng_indicator%TYPE;
994: l_e_ne_ind Fv_Facts_Attributes.exch_non_exch%TYPE;
995: l_c_nc_ind Fv_Facts_Attributes.cust_non_cust%TYPE;
996: l_c_nc Fv_Facts_Report_T2.cust_non_cust%TYPE;
997: l_budget_sub_ind Fv_Facts_Attributes.budget_subfunction%TYPE;
998: l_budget_sub Fv_Facts_Report_T2.budget_subfunction%TYPE;

Line 995: l_c_nc_ind Fv_Facts_Attributes.cust_non_cust%TYPE;

991: l_exists VARCHAR2(1);
992: l_row_exists VARCHAR2(1);
993: l_g_ng_ind Fv_Facts_Report_T2.g_ng_indicator%TYPE;
994: l_e_ne_ind Fv_Facts_Attributes.exch_non_exch%TYPE;
995: l_c_nc_ind Fv_Facts_Attributes.cust_non_cust%TYPE;
996: l_c_nc Fv_Facts_Report_T2.cust_non_cust%TYPE;
997: l_budget_sub_ind Fv_Facts_Attributes.budget_subfunction%TYPE;
998: l_budget_sub Fv_Facts_Report_T2.budget_subfunction%TYPE;
999:

Line 997: l_budget_sub_ind Fv_Facts_Attributes.budget_subfunction%TYPE;

993: l_g_ng_ind Fv_Facts_Report_T2.g_ng_indicator%TYPE;
994: l_e_ne_ind Fv_Facts_Attributes.exch_non_exch%TYPE;
995: l_c_nc_ind Fv_Facts_Attributes.cust_non_cust%TYPE;
996: l_c_nc Fv_Facts_Report_T2.cust_non_cust%TYPE;
997: l_budget_sub_ind Fv_Facts_Attributes.budget_subfunction%TYPE;
998: l_budget_sub Fv_Facts_Report_T2.budget_subfunction%TYPE;
999:
1000: BEGIN
1001:

Line 1022: -- Verify whether the account number exists in FV_FACTS_ATTRIBUTES table

1018: p_ene_exception := NULL;
1019:
1020: -- Validate the Account number and return the corresponding SGL
1021: -- number or parent for getting attributes.
1022: -- Verify whether the account number exists in FV_FACTS_ATTRIBUTES table
1023: -- Validate the USSGL Account Number
1024: gbl_error_code := 0;
1025:
1026: GET_USSGL_INFO(p_acct_num, l_ussgl_enabled, l_reporting_type);

Line 1051: FROM fv_facts_attributes

1047: BEGIN
1048:
1049: SELECT 'X', govt_non_govt, exch_non_exch, cust_non_cust, budget_subfunction
1050: INTO l_exists, l_g_ng_ind, l_e_ne_ind, l_c_nc_ind, l_budget_sub_ind
1051: FROM fv_facts_attributes
1052: WHERE facts_acct_number = p_acct_num
1053: AND set_of_books_id = gbl_set_of_books_id;
1054:
1055: p_govt_non_govt := l_g_ng_ind;

Line 1058: -- If Budget_Subfunction is Checked 'Y' in FV_FACTS_ATTRIBUTES

1054:
1055: p_govt_non_govt := l_g_ng_ind;
1056:
1057: -- Account Number Valid
1058: -- If Budget_Subfunction is Checked 'Y' in FV_FACTS_ATTRIBUTES
1059: -- but Budget_Subfunction is empty in FV_FUND_PARAMETERS then
1060: -- the account gets reported to exception report
1061:
1062: IF (l_budget_sub_ind = 'Y') THEN

Line 1152: FROM fv_facts_attributes

1148: --so checking facts_attributes for a/c itself') ;
1149: BEGIN
1150: SELECT 'X', govt_non_govt, exch_non_exch, cust_non_cust, budget_subfunction
1151: INTO l_exists, l_g_ng_ind, l_e_ne_ind, l_c_nc_ind, l_budget_sub_ind
1152: FROM fv_facts_attributes
1153: WHERE facts_acct_number = p_acct_num
1154: AND set_of_books_id = gbl_set_of_books_id;
1155:
1156: EXCEPTION

Line 1201: -- Parent is Valid USSGL Acct. Child exists on FV_FACTS_ATTRIBUTES

1197:
1198: IF l_exists IS NOT NULL THEN
1199: --fnd_file.put_line(fnd_file.log , 'USSGL exists and facts
1200: --attributes found for' || p_acct_num );
1201: -- Parent is Valid USSGL Acct. Child exists on FV_FACTS_ATTRIBUTES
1202: p_govt_non_govt := l_g_ng_ind;
1203:
1204: -- If Budget_Subfunction is Checked 'Y' in FV_FACTS_ATTRIBUTES
1205: -- but Budget_Subfunction is empty in FV_FUND_PARAMETERS then

Line 1204: -- If Budget_Subfunction is Checked 'Y' in FV_FACTS_ATTRIBUTES

1200: --attributes found for' || p_acct_num );
1201: -- Parent is Valid USSGL Acct. Child exists on FV_FACTS_ATTRIBUTES
1202: p_govt_non_govt := l_g_ng_ind;
1203:
1204: -- If Budget_Subfunction is Checked 'Y' in FV_FACTS_ATTRIBUTES
1205: -- but Budget_Subfunction is empty in FV_FUND_PARAMETERS then
1206: -- the account gets reported to exception report
1207: IF (l_budget_sub_ind = 'Y') THEN
1208: SELECT 'X', budget_subfunction

Line 1272: FROM fv_facts_attributes

1268: --USSGL exists but no facts attributes found for the acct num.
1269: --So check facts attribuetes from its USSGL acct.
1270: SELECT 'X', govt_non_govt, exch_non_exch, cust_non_cust, budget_subfunction
1271: INTO l_exists, l_g_ng_ind, l_e_ne_ind, l_c_nc_ind, l_budget_sub_ind
1272: FROM fv_facts_attributes
1273: WHERE facts_acct_number = l_ussgl_acct_num
1274: AND set_of_books_id = gbl_set_of_books_id;
1275:
1276: --fnd_file.put_line(fnd_file.log , 'facts-attibutes found for' || p_acct_num );

Line 3230: -- Federal/Non-Federal accounts in FV_FACTS_ATTRIBUTES Table.

3226:
3227: End submit_exception_report;
3228: --------------------------------------------------------------------------------
3229: -- Purpose of this procedure is to process all Federal or
3230: -- Federal/Non-Federal accounts in FV_FACTS_ATTRIBUTES Table.
3231: --
3232: -- For each such account, find if its a child account. If yes, insert
3233: -- this account along with its parent and fed_nonfed attribute into
3234: -- FV_FACTS_FED_ACCOUNTS table.

Line 3268: FROM fv_facts_attributes

3264: message VARCHAR2(80);
3265:
3266: CURSOR facts_attributes_cur IS
3267: SELECT facts_acct_number, govt_non_govt
3268: FROM fv_facts_attributes
3269: WHERE set_of_books_id = p_sob_id --vg_sob_id
3270: AND govt_non_govt in ('F', 'Y');
3271:
3272: CURSOR fnd_flex_value_hierarchies_cur IS

Line 3308: -- Loop through records in FV_FACTS_ATTRIBUTES table with F/Y as Fed_NonFed Attribute

3304: FV_UTILITY.LOG_MESG('Accounting Segment: '||gbl_acc_segment_name);
3305: FV_UTILITY.LOG_MESG('Chart of Account ID: '||gbl_coa_id);
3306: FV_UTILITY.LOG_MESG('Account Value Set ID: '||gbl_acc_value_set_id);
3307:
3308: -- Loop through records in FV_FACTS_ATTRIBUTES table with F/Y as Fed_NonFed Attribute
3309: FOR facts_attributes_rec IN facts_attributes_cur
3310: LOOP
3311: vg_acct_number := NULL;
3312: vg_fed_nonfed := NULL;