APPS.FV_FACTS1_PKG dependencies on FV_FACTS1_PERIOD_ATTRIBUTES

Line 24: gbl_govt_non_govt_ind fv_facts1_period_attributes.g_ng_indicator%TYPE;

20: gbl_low_period_name gl_period_statuses.period_name%TYPE;
21: gbl_prev_acct fv_facts_report_t2.account_number%TYPE;
22: gbl_bal_segment fv_facts_report_t2.fund_value%TYPE;
23: gbl_sgl_acct_num VARCHAR2(4);
24: gbl_govt_non_govt_ind fv_facts1_period_attributes.g_ng_indicator%TYPE;
25: gbl_exch_non_exch fv_facts1_period_attributes.exch_non_exch%TYPE;
26: gbl_cust_non_cust fv_facts1_period_attributes.cust_non_cust%TYPE;
27: gbl_budget_subfunction fv_facts1_period_attributes.budget_subfunction%TYPE;
28: gbl_ene_exception VARCHAR2(25);

Line 25: gbl_exch_non_exch fv_facts1_period_attributes.exch_non_exch%TYPE;

21: gbl_prev_acct fv_facts_report_t2.account_number%TYPE;
22: gbl_bal_segment fv_facts_report_t2.fund_value%TYPE;
23: gbl_sgl_acct_num VARCHAR2(4);
24: gbl_govt_non_govt_ind fv_facts1_period_attributes.g_ng_indicator%TYPE;
25: gbl_exch_non_exch fv_facts1_period_attributes.exch_non_exch%TYPE;
26: gbl_cust_non_cust fv_facts1_period_attributes.cust_non_cust%TYPE;
27: gbl_budget_subfunction fv_facts1_period_attributes.budget_subfunction%TYPE;
28: gbl_ene_exception VARCHAR2(25);
29: gbl_cnc_exception VARCHAR2(25);

Line 26: gbl_cust_non_cust fv_facts1_period_attributes.cust_non_cust%TYPE;

22: gbl_bal_segment fv_facts_report_t2.fund_value%TYPE;
23: gbl_sgl_acct_num VARCHAR2(4);
24: gbl_govt_non_govt_ind fv_facts1_period_attributes.g_ng_indicator%TYPE;
25: gbl_exch_non_exch fv_facts1_period_attributes.exch_non_exch%TYPE;
26: gbl_cust_non_cust fv_facts1_period_attributes.cust_non_cust%TYPE;
27: gbl_budget_subfunction fv_facts1_period_attributes.budget_subfunction%TYPE;
28: gbl_ene_exception VARCHAR2(25);
29: gbl_cnc_exception VARCHAR2(25);
30: gbl_bsf_exception VARCHAR2(25);

Line 27: gbl_budget_subfunction fv_facts1_period_attributes.budget_subfunction%TYPE;

23: gbl_sgl_acct_num VARCHAR2(4);
24: gbl_govt_non_govt_ind fv_facts1_period_attributes.g_ng_indicator%TYPE;
25: gbl_exch_non_exch fv_facts1_period_attributes.exch_non_exch%TYPE;
26: gbl_cust_non_cust fv_facts1_period_attributes.cust_non_cust%TYPE;
27: gbl_budget_subfunction fv_facts1_period_attributes.budget_subfunction%TYPE;
28: gbl_ene_exception VARCHAR2(25);
29: gbl_cnc_exception VARCHAR2(25);
30: gbl_bsf_exception VARCHAR2(25);
31: gbl_exception_category VARCHAR2(25);

Line 2553: from fv_facts1_period_attributes

2549: LOOP
2550:
2551: begin
2552: select 'N' into l_new_record_l(i)
2553: from fv_facts1_period_attributes
2554: where ccid = l_ccid_l(i)
2555: and period_year = gbl_fiscal_year
2556: and set_of_books_id = gbl_set_of_books_id;
2557: exception

Line 2935: INSERT INTO fv_facts1_period_attributes

2931:
2932:
2933: FV_UTILITY.log_MESG('Inserting no of new records ' || l_indx);
2934: FORALL i IN 1 .. l_indx
2935: INSERT INTO fv_facts1_period_attributes
2936: ( period_year,
2937: period_num,
2938: period_name,
2939: set_of_books_id,

Line 2989: -- Update facts attributes in fv_facts1_period_attributes

2985: DECODE(l_govt_non_govt_ind_n(i), 'F', 'Y', 'Y', 'Y', 'N')
2986: );
2987:
2988:
2989: -- Update facts attributes in fv_facts1_period_attributes
2990:
2991: FV_UTILITY.log_MESG( 'Updating records ' || (l_ccid_l.count - l_indx));
2992:
2993: FORALL i IN l_ccid_l.first .. l_ccid_l.last

Line 2994: UPDATE fv_facts1_period_attributes

2990:
2991: FV_UTILITY.log_MESG( 'Updating records ' || (l_ccid_l.count - l_indx));
2992:
2993: FORALL i IN l_ccid_l.first .. l_ccid_l.last
2994: UPDATE fv_facts1_period_attributes
2995: SET ussgl_account = l_sgl_acct_num_l(i),
2996: exch_non_exch = l_exch_non_exch_l(i),
2997: cust_non_cust = l_cust_non_cust_l(i),
2998: account_type = l_account_type_l(i),