APPS.FV_YE_CLOSE dependencies on FND_FLEX_VALUES

Line 75: vg_acct_val_set_id Fnd_Flex_Values.flex_value_set_id%TYPE;

71: e_error EXCEPTION;
72: e_invalid EXCEPTION;
73:
74: vg_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
75: vg_acct_val_set_id Fnd_Flex_Values.flex_value_set_id%TYPE;
76: vg_num_segs NUMBER;
77: vg_factsi_attr_exists VARCHAR2(1) ;
78: vg_factsi_bal_cnt NUMBER;
79: vg_factsi_attribute Fv_System_Parameters.factsi_journal_attribute%TYPE;

Line 709: vl_acct Fnd_Flex_Values_Vl.flex_value%TYPE;

705: WHERE set_of_books_id = vg_sob_id
706: ORDER BY to_account;
707:
708: vl_parent_flag VARCHAR2(1) ;
709: vl_acct Fnd_Flex_Values_Vl.flex_value%TYPE;
710:
711: CURSOR get_parentflag_cur IS
712: SELECT summary_flag
713: FROM Fnd_Flex_Values_Vl

Line 713: FROM Fnd_Flex_Values_Vl

709: vl_acct Fnd_Flex_Values_Vl.flex_value%TYPE;
710:
711: CURSOR get_parentflag_cur IS
712: SELECT summary_flag
713: FROM Fnd_Flex_Values_Vl
714: WHERE flex_value_set_id = vg_acct_val_set_id
715: AND flex_value = vl_acct;
716:
717: l_module_name VARCHAR2(200) ;

Line 1654: vl_child_low Fnd_Flex_Values_Vl.flex_value%TYPE;

1650: -- calls the procedure Determine_DrCr.
1651: -- ------------------------------------------------------------------
1652: PROCEDURE Determine_Child_Accounts IS
1653: vl_parent_cnt NUMBER;
1654: vl_child_low Fnd_Flex_Values_Vl.flex_value%TYPE;
1655: vl_child_high Fnd_Flex_Values_Vl.flex_value%TYPE;
1656:
1657: TYPE t_getbal_cnt IS REF CURSOR;
1658: vc_getbal_cnt t_getbal_cnt;

Line 1655: vl_child_high Fnd_Flex_Values_Vl.flex_value%TYPE;

1651: -- ------------------------------------------------------------------
1652: PROCEDURE Determine_Child_Accounts IS
1653: vl_parent_cnt NUMBER;
1654: vl_child_low Fnd_Flex_Values_Vl.flex_value%TYPE;
1655: vl_child_high Fnd_Flex_Values_Vl.flex_value%TYPE;
1656:
1657: TYPE t_getbal_cnt IS REF CURSOR;
1658: vc_getbal_cnt t_getbal_cnt;
1659: vl_select VARCHAR2(2000);

Line 1670: FROM Fnd_Flex_Values_Vl

1666: AND flex_value_set_id = vg_acct_val_set_id;
1667:
1668: CURSOR get_child_values_cur IS
1669: SELECT flex_value
1670: FROM Fnd_Flex_Values_Vl
1671: WHERE flex_value_set_id = vg_acct_val_set_id
1672: AND flex_value BETWEEN vl_child_low AND vl_child_high
1673: ORDER BY flex_value;
1674:

Line 1690: FROM Fnd_Flex_Values_Vl

1686: BEGIN
1687: -- Check to see if the from account is a parent
1688: SELECT COUNT(*)
1689: INTO vl_parent_cnt
1690: FROM Fnd_Flex_Values_Vl
1691: WHERE flex_value_set_id = vg_acct_val_set_id
1692: AND summary_flag = 'Y'
1693: AND flex_value = vg_from_acct;
1694: