APPS.FV_FUNDS_AVAILABLE_PKG dependencies on FND_FLEX_VALUES

Line 28: acct_flex_id fnd_flex_values.flex_value_id%TYPE;

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

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

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

Line 139: parent_value_id IN fnd_flex_values.flex_value_id%TYPE,

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

Line 290: from fnd_flex_values

286:
287: begin
288: select substr(compiled_value_attributes,5,1)
289: into v_compiled_value
290: from fnd_flex_values
291: where flex_value = v_parent_value
292: and flex_value_set_id = parent_value_id;
293: if (v_compiled_value = 'C') then
294: grand_total := (nvl(tot_balances,0) + nvl(tot_packets,0))*-1;

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

314:
315: /******************************************************************/
316: /* This function finds the flex_value_id for the account being processed.*/
317: /******************************************************************/
318: FUNCTION get_flex_value_id(v_flex_value fnd_flex_values.flex_value%TYPE)
319: return number
320: IS
321: l_module_name VARCHAR2(200) := g_module_name || 'get_flex_value_id';
322: v_flex_value_id fnd_flex_values.flex_value_id%TYPE;

Line 322: v_flex_value_id fnd_flex_values.flex_value_id%TYPE;

318: FUNCTION get_flex_value_id(v_flex_value fnd_flex_values.flex_value%TYPE)
319: return number
320: IS
321: l_module_name VARCHAR2(200) := g_module_name || 'get_flex_value_id';
322: v_flex_value_id fnd_flex_values.flex_value_id%TYPE;
323: BEGIN
324: v_statement := 'L';
325: SELECT flex_value_set_id
326: INTO v_flex_value_id