APPS.FV_STATUS_OF_FUNDS_PKG dependencies on FND_FLEX_VALUES

Line 20: acct_flex_id fnd_flex_values.flex_value_id%TYPE;

16: v_treasury_symbol fv_fund_parameters.treasury_symbol%TYPE;
17: v_treasury_symbol1 fv_fund_parameters.treasury_symbol%TYPE;
18: v_statement varchar2(2);
19: err_message varchar2(300);
20: acct_flex_id fnd_flex_values.flex_value_id%TYPE;
21: v_ca_id gl_sets_of_books.chart_of_accounts_id%TYPE;
22: x_period_num gl_period_statuses.period_num%TYPE;
23: v_segment_low_name number;
24: v_segment_num number;

Line 776: (v_parent_value IN fnd_flex_values.flex_value%TYPE,

772: /******************************************************************/
773: /* This procedures sums the budget authority */
774: /******************************************************************/
775: PROCEDURE sum_children_budget
776: (v_parent_value IN fnd_flex_values.flex_value%TYPE,
777: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,
778: sob_id1 IN gl_balances.ledger_id%TYPE,
779: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,
780: v_fund_value1 IN fv_fund_parameters.fund_value%TYPE,

Line 777: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,

773: /* This procedures sums the budget authority */
774: /******************************************************************/
775: PROCEDURE sum_children_budget
776: (v_parent_value IN fnd_flex_values.flex_value%TYPE,
777: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,
778: sob_id1 IN gl_balances.ledger_id%TYPE,
779: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,
780: v_fund_value1 IN fv_fund_parameters.fund_value%TYPE,
781: v_treasury_symbol_id1 IN fv_treasury_symbols.treasury_symbol_id%TYPE ) --Changed to Fix 1575992

Line 796: from fnd_flex_values

792:
793: begin
794: select substr(compiled_value_attributes,5,1)
795: into v_sign
796: from fnd_flex_values
797: where flex_value = v_parent_value
798: and flex_value_set_id = parent_value_id;
799:
800: EXCEPTION

Line 930: (v_parent_value IN fnd_flex_values.flex_value%TYPE,

926: /* This procedures sums the transfers accounts for the account */
927: /* passed to it. */
928: /******************************************************************/
929: PROCEDURE sum_children_transfers
930: (v_parent_value IN fnd_flex_values.flex_value%TYPE,
931: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,
932: v_trans_type IN VARCHAR2,
933: sob_id1 IN gl_balances.ledger_id%TYPE,
934: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,

Line 931: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,

927: /* passed to it. */
928: /******************************************************************/
929: PROCEDURE sum_children_transfers
930: (v_parent_value IN fnd_flex_values.flex_value%TYPE,
931: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,
932: v_trans_type IN VARCHAR2,
933: sob_id1 IN gl_balances.ledger_id%TYPE,
934: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,
935: v_fund_value1 IN fv_fund_parameters.fund_value%TYPE,

Line 953: from fnd_flex_values

949:
950: begin
951: select substr(compiled_value_attributes,5,1)
952: into v_sign
953: from fnd_flex_values
954: where flex_value = v_parent_value
955: and flex_value_set_id = parent_value_id;
956:
957: EXCEPTION

Line 1128: (v_parent_value IN fnd_flex_values.flex_value%TYPE,

1124: /* passed to it. */
1125: /******************************************************************/
1126: -- Modified to Fix bug.1575992
1127: PROCEDURE sum_children_spending
1128: (v_parent_value IN fnd_flex_values.flex_value%TYPE,
1129: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,
1130: v_spend_type IN varchar2,
1131: sob_id1 IN gl_balances.ledger_id%TYPE,
1132: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,

Line 1129: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,

1125: /******************************************************************/
1126: -- Modified to Fix bug.1575992
1127: PROCEDURE sum_children_spending
1128: (v_parent_value IN fnd_flex_values.flex_value%TYPE,
1129: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,
1130: v_spend_type IN varchar2,
1131: sob_id1 IN gl_balances.ledger_id%TYPE,
1132: v_treasury_symbol1 IN fv_fund_parameters.treasury_symbol%TYPE,
1133: v_fund_value1 IN fv_fund_parameters.fund_value%TYPE,

Line 1347: FUNCTION get_flex_value_id(v_flex_value fnd_flex_values.flex_value%TYPE)

1343:
1344: /*************************************************************************/
1345: /* This function finds the flex_value_id for the account being processed.*/
1346: /*************************************************************************/
1347: FUNCTION get_flex_value_id(v_flex_value fnd_flex_values.flex_value%TYPE)
1348: return number
1349: IS
1350: v_flex_value_id fnd_flex_values.flex_value_id%TYPE;
1351: l_module_name varchar2(200) := g_module_name || 'get_flax_value_id';

Line 1350: v_flex_value_id fnd_flex_values.flex_value_id%TYPE;

1346: /*************************************************************************/
1347: FUNCTION get_flex_value_id(v_flex_value fnd_flex_values.flex_value%TYPE)
1348: return number
1349: IS
1350: v_flex_value_id fnd_flex_values.flex_value_id%TYPE;
1351: l_module_name varchar2(200) := g_module_name || 'get_flax_value_id';
1352: BEGIN
1353: v_statement := 'L';
1354: SELECT flex_value_set_id