APPS.FV_FACTS1_PKG dependencies on FV_FACTS_ATTRIBUTES

Line 988: l_e_ne_ind Fv_Facts_Attributes.exch_non_exch%TYPE;

984:
985: l_exists VARCHAR2(1);
986: l_row_exists VARCHAR2(1);
987: l_g_ng_ind Fv_Facts_Report_T2.g_ng_indicator%TYPE;
988: l_e_ne_ind Fv_Facts_Attributes.exch_non_exch%TYPE;
989: l_c_nc_ind Fv_Facts_Attributes.cust_non_cust%TYPE;
990: l_c_nc Fv_Facts_Report_T2.cust_non_cust%TYPE;
991: l_budget_sub_ind Fv_Facts_Attributes.budget_subfunction%TYPE;
992: l_budget_sub Fv_Facts_Report_T2.budget_subfunction%TYPE;

Line 989: l_c_nc_ind Fv_Facts_Attributes.cust_non_cust%TYPE;

985: l_exists VARCHAR2(1);
986: l_row_exists VARCHAR2(1);
987: l_g_ng_ind Fv_Facts_Report_T2.g_ng_indicator%TYPE;
988: l_e_ne_ind Fv_Facts_Attributes.exch_non_exch%TYPE;
989: l_c_nc_ind Fv_Facts_Attributes.cust_non_cust%TYPE;
990: l_c_nc Fv_Facts_Report_T2.cust_non_cust%TYPE;
991: l_budget_sub_ind Fv_Facts_Attributes.budget_subfunction%TYPE;
992: l_budget_sub Fv_Facts_Report_T2.budget_subfunction%TYPE;
993:

Line 991: l_budget_sub_ind Fv_Facts_Attributes.budget_subfunction%TYPE;

987: l_g_ng_ind Fv_Facts_Report_T2.g_ng_indicator%TYPE;
988: l_e_ne_ind Fv_Facts_Attributes.exch_non_exch%TYPE;
989: l_c_nc_ind Fv_Facts_Attributes.cust_non_cust%TYPE;
990: l_c_nc Fv_Facts_Report_T2.cust_non_cust%TYPE;
991: l_budget_sub_ind Fv_Facts_Attributes.budget_subfunction%TYPE;
992: l_budget_sub Fv_Facts_Report_T2.budget_subfunction%TYPE;
993:
994: BEGIN
995:

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

1012: p_ene_exception := NULL;
1013:
1014: -- Validate the Account number and return the corresponding SGL
1015: -- number or parent for getting attributes.
1016: -- Verify whether the account number exists in FV_FACTS_ATTRIBUTES table
1017: -- Validate the USSGL Account Number
1018: gbl_error_code := 0;
1019:
1020: GET_USSGL_INFO(p_acct_num, l_ussgl_enabled, l_reporting_type);

Line 1045: FROM fv_facts_attributes

1041: BEGIN
1042:
1043: SELECT 'X', govt_non_govt, exch_non_exch, cust_non_cust, budget_subfunction
1044: INTO l_exists, l_g_ng_ind, l_e_ne_ind, l_c_nc_ind, l_budget_sub_ind
1045: FROM fv_facts_attributes
1046: WHERE facts_acct_number = p_acct_num
1047: AND set_of_books_id = gbl_set_of_books_id;
1048:
1049: p_govt_non_govt := l_g_ng_ind;

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

1048:
1049: p_govt_non_govt := l_g_ng_ind;
1050:
1051: -- Account Number Valid
1052: -- If Budget_Subfunction is Checked 'Y' in FV_FACTS_ATTRIBUTES
1053: -- but Budget_Subfunction is empty in FV_FUND_PARAMETERS then
1054: -- the account gets reported to exception report
1055:
1056: IF (l_budget_sub_ind = 'Y') THEN

Line 1139: FROM fv_facts_attributes

1135: --so checking facts_attributes for a/c itself') ;
1136: BEGIN
1137: SELECT 'X', govt_non_govt, exch_non_exch, cust_non_cust, budget_subfunction
1138: INTO l_exists, l_g_ng_ind, l_e_ne_ind, l_c_nc_ind, l_budget_sub_ind
1139: FROM fv_facts_attributes
1140: WHERE facts_acct_number = p_acct_num
1141: AND set_of_books_id = gbl_set_of_books_id;
1142:
1143: EXCEPTION

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

1184:
1185: IF l_exists IS NOT NULL THEN
1186: --fnd_file.put_line(fnd_file.log , 'USSGL exists and facts
1187: --attributes found for' || p_acct_num );
1188: -- Parent is Valid USSGL Acct. Child exists on FV_FACTS_ATTRIBUTES
1189: p_govt_non_govt := l_g_ng_ind;
1190:
1191: -- If Budget_Subfunction is Checked 'Y' in FV_FACTS_ATTRIBUTES
1192: -- but Budget_Subfunction is empty in FV_FUND_PARAMETERS then

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

1187: --attributes found for' || p_acct_num );
1188: -- Parent is Valid USSGL Acct. Child exists on FV_FACTS_ATTRIBUTES
1189: p_govt_non_govt := l_g_ng_ind;
1190:
1191: -- If Budget_Subfunction is Checked 'Y' in FV_FACTS_ATTRIBUTES
1192: -- but Budget_Subfunction is empty in FV_FUND_PARAMETERS then
1193: -- the account gets reported to exception report
1194: IF (l_budget_sub_ind = 'Y') THEN
1195: SELECT 'X', budget_subfunction

Line 1252: FROM fv_facts_attributes

1248: --USSGL exists but no facts attributes found for the acct num.
1249: --So check facts attribuetes from its USSGL acct.
1250: SELECT 'X', govt_non_govt, exch_non_exch, cust_non_cust, budget_subfunction
1251: INTO l_exists, l_g_ng_ind, l_e_ne_ind, l_c_nc_ind, l_budget_sub_ind
1252: FROM fv_facts_attributes
1253: WHERE facts_acct_number = l_ussgl_acct_num
1254: AND set_of_books_id = gbl_set_of_books_id;
1255:
1256: --fnd_file.put_line(fnd_file.log , 'facts-attibutes found for' || p_acct_num );

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

3148:
3149: End submit_exception_report;
3150: --------------------------------------------------------------------------------
3151: -- Purpose of this procedure is to process all Federal or
3152: -- Federal/Non-Federal accounts in FV_FACTS_ATTRIBUTES Table.
3153: --
3154: -- For each such account, find if its a child account. If yes, insert
3155: -- this account along with its parent and fed_nonfed attribute into
3156: -- FV_FACTS_FED_ACCOUNTS table.

Line 3190: FROM fv_facts_attributes

3186: message VARCHAR2(80);
3187:
3188: CURSOR facts_attributes_cur IS
3189: SELECT facts_acct_number, govt_non_govt
3190: FROM fv_facts_attributes
3191: WHERE set_of_books_id = p_sob_id --vg_sob_id
3192: AND govt_non_govt in ('F', 'Y');
3193:
3194: CURSOR fnd_flex_value_hierarchies_cur IS

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

3226: FV_UTILITY.LOG_MESG('Accounting Segment: '||gbl_acc_segment_name);
3227: FV_UTILITY.LOG_MESG('Chart of Account ID: '||gbl_coa_id);
3228: FV_UTILITY.LOG_MESG('Account Value Set ID: '||gbl_acc_value_set_id);
3229:
3230: -- Loop through records in FV_FACTS_ATTRIBUTES table with F/Y as Fed_NonFed Attribute
3231: FOR facts_attributes_rec IN facts_attributes_cur
3232: LOOP
3233: vg_acct_number := NULL;
3234: vg_fed_nonfed := NULL;