APPS.FV_FUNDS_AVAILABLE_PKG dependencies on FND_FLEX_VALUES

Line 27: acct_flex_id fnd_flex_values.flex_value_id%TYPE;

23: v_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
24: temp_v_treasury_symbol_id varchar2(20) ; --Bug 1575992
25: v_statement varchar2(100);
26: err_message varchar2(300);
27: acct_flex_id fnd_flex_values.flex_value_id%TYPE;
28: v_ca_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
29: bud_child_value_low fnd_flex_value_hierarchies.child_flex_value_low%TYPE;
30: bud_child_value_high fnd_flex_value_hierarchies.child_flex_value_high%TYPE;
31: spd_child_value_low fnd_flex_value_hierarchies.child_flex_value_low%TYPE;

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

131: /* This procedure sums the spending accounts for the account */
132: /* passed to it. */
133: /******************************************************************/
134: PROCEDURE sum_children_spending
135: (v_parent_value IN fnd_flex_values.flex_value%TYPE,
136: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,
137: grand_total OUT NOCOPY number)
138:
139: IS

Line 136: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,

132: /* passed to it. */
133: /******************************************************************/
134: PROCEDURE sum_children_spending
135: (v_parent_value IN fnd_flex_values.flex_value%TYPE,
136: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,
137: grand_total OUT NOCOPY number)
138:
139: IS
140: l_module_name VARCHAR2(200) := g_module_name || 'sum_children_spending';

Line 274: from fnd_flex_values

270:
271: begin
272: select substr(compiled_value_attributes,5,1)
273: into v_compiled_value
274: from fnd_flex_values
275: where flex_value = v_parent_value
276: and flex_value_set_id = parent_value_id;
277: if (v_compiled_value = 'C') then
278: grand_total := (nvl(tot_balances,0) + nvl(tot_packets,0))*-1;

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

298:
299: /******************************************************************/
300: /* This function finds the flex_value_id for the account being processed.*/
301: /******************************************************************/
302: FUNCTION get_flex_value_id(v_flex_value fnd_flex_values.flex_value%TYPE)
303: return number
304: IS
305: l_module_name VARCHAR2(200) := g_module_name || 'get_flex_value_id';
306: v_flex_value_id fnd_flex_values.flex_value_id%TYPE;

Line 306: v_flex_value_id fnd_flex_values.flex_value_id%TYPE;

302: FUNCTION get_flex_value_id(v_flex_value fnd_flex_values.flex_value%TYPE)
303: return number
304: IS
305: l_module_name VARCHAR2(200) := g_module_name || 'get_flex_value_id';
306: v_flex_value_id fnd_flex_values.flex_value_id%TYPE;
307: BEGIN
308: v_statement := 'L';
309: SELECT flex_value_set_id
310: INTO v_flex_value_id