eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_GTAS_INTERFACE dependencies on FND_FLEX_VALUE_HIERARCHIES

Line 811: FROM fnd_flex_value_hierarchies

807: If L_Ussgl_Not_Found = 'Y' Then --1
808: BEGIN
809: SELECT SUBSTR(parent_flex_value,1,6)
810: INTO l_ussgl_acct_num
811: FROM fnd_flex_value_hierarchies
812: WHERE (p_acct_num BETWEEN child_flex_value_low
813: AND child_flex_value_high)
814: AND flex_value_set_id = gbl_acc_value_set_id
815: AND parent_flex_value <> 'T'

Line 2714: vl_child_flex_value_low Fnd_Flex_Value_Hierarchies.child_flex_value_low%TYPE;

2710: p_run_year IN NUMBER)
2711: IS
2712: l_module_name VARCHAR2(200);
2713:
2714: vl_child_flex_value_low Fnd_Flex_Value_Hierarchies.child_flex_value_low%TYPE;
2715: vl_child_flex_value_high Fnd_Flex_Value_Hierarchies.child_flex_value_high%TYPE;
2716:
2717: CURSOR gtas_attributes_cur IS
2718: SELECT gtas_acct_number, fed_non_fed1, fed_non_fed2, fed_non_fed3,

Line 2715: vl_child_flex_value_high Fnd_Flex_Value_Hierarchies.child_flex_value_high%TYPE;

2711: IS
2712: l_module_name VARCHAR2(200);
2713:
2714: vl_child_flex_value_low Fnd_Flex_Value_Hierarchies.child_flex_value_low%TYPE;
2715: vl_child_flex_value_high Fnd_Flex_Value_Hierarchies.child_flex_value_high%TYPE;
2716:
2717: CURSOR gtas_attributes_cur IS
2718: SELECT gtas_acct_number, fed_non_fed1, fed_non_fed2, fed_non_fed3,
2719: authority_type1, authority_type2, authority_type3,

Line 2734: CURSOR fnd_flex_value_hierarchies_cur IS

2730: (bud_impact_ind1 IS NOT NULL OR bud_impact_ind2 IS NOT NULL)
2731: )
2732: ORDER BY 1 ;
2733:
2734: CURSOR fnd_flex_value_hierarchies_cur IS
2735: SELECT child_flex_value_low, child_flex_value_high
2736: FROM fnd_flex_value_hierarchies
2737: WHERE flex_value_set_id = gbl_acc_value_set_id
2738: AND SUBSTR(parent_flex_value,1,6) = vg_sgl_acct_number;

Line 2736: FROM fnd_flex_value_hierarchies

2732: ORDER BY 1 ;
2733:
2734: CURSOR fnd_flex_value_hierarchies_cur IS
2735: SELECT child_flex_value_low, child_flex_value_high
2736: FROM fnd_flex_value_hierarchies
2737: WHERE flex_value_set_id = gbl_acc_value_set_id
2738: AND SUBSTR(parent_flex_value,1,6) = vg_sgl_acct_number;
2739: --AND parent_flex_value = vg_sgl_acct_number;
2740:

Line 2827: FROM fnd_flex_value_hierarchies

2823:
2824: BEGIN
2825: SELECT SUBSTR(parent_flex_value,1,6)
2826: INTO vg_sgl_acct_number
2827: FROM fnd_flex_value_hierarchies
2828: WHERE vg_acct_number
2829: BETWEEN child_flex_value_low AND child_flex_value_high
2830: AND flex_value_set_id = gbl_acc_value_set_id
2831: AND parent_flex_value <> 'T'

Line 2870: FOR fnd_flex_value_hierarchies_rec IN fnd_flex_value_hierarchies_cur

2866: vg_sgl_acct_number := vg_acct_number;
2867:
2868: log(l_module_name, 'g_is_acct_parent: '||g_is_acct_parent);
2869:
2870: FOR fnd_flex_value_hierarchies_rec IN fnd_flex_value_hierarchies_cur
2871: LOOP
2872: log(l_module_name, 'fnd_flex_value_hierarchies_rec LOOP Begins');
2873: vl_child_flex_value_low := NULL;
2874: vl_child_flex_value_high := NULL;

Line 2872: log(l_module_name, 'fnd_flex_value_hierarchies_rec LOOP Begins');

2868: log(l_module_name, 'g_is_acct_parent: '||g_is_acct_parent);
2869:
2870: FOR fnd_flex_value_hierarchies_rec IN fnd_flex_value_hierarchies_cur
2871: LOOP
2872: log(l_module_name, 'fnd_flex_value_hierarchies_rec LOOP Begins');
2873: vl_child_flex_value_low := NULL;
2874: vl_child_flex_value_high := NULL;
2875: vl_child_flex_value_low := fnd_flex_value_hierarchies_rec.child_flex_value_low;
2876: vl_child_flex_value_high := fnd_flex_value_hierarchies_rec.child_flex_value_high;

Line 2875: vl_child_flex_value_low := fnd_flex_value_hierarchies_rec.child_flex_value_low;

2871: LOOP
2872: log(l_module_name, 'fnd_flex_value_hierarchies_rec LOOP Begins');
2873: vl_child_flex_value_low := NULL;
2874: vl_child_flex_value_high := NULL;
2875: vl_child_flex_value_low := fnd_flex_value_hierarchies_rec.child_flex_value_low;
2876: vl_child_flex_value_high := fnd_flex_value_hierarchies_rec.child_flex_value_high;
2877:
2878: log(l_module_name, 'vl_child_flex_value_low: '||vl_child_flex_value_low);
2879: log(l_module_name, 'vl_child_flex_value_high: '||vl_child_flex_value_high);

Line 2876: vl_child_flex_value_high := fnd_flex_value_hierarchies_rec.child_flex_value_high;

2872: log(l_module_name, 'fnd_flex_value_hierarchies_rec LOOP Begins');
2873: vl_child_flex_value_low := NULL;
2874: vl_child_flex_value_high := NULL;
2875: vl_child_flex_value_low := fnd_flex_value_hierarchies_rec.child_flex_value_low;
2876: vl_child_flex_value_high := fnd_flex_value_hierarchies_rec.child_flex_value_high;
2877:
2878: log(l_module_name, 'vl_child_flex_value_low: '||vl_child_flex_value_low);
2879: log(l_module_name, 'vl_child_flex_value_high: '||vl_child_flex_value_high);
2880:

Line 2899: log(l_module_name, 'END of fnd_flex_value_hierarchies_cur Loop');

2895: END IF;
2896:
2897: log(l_module_name, 'END of fnd_flex_values_rec Loop');
2898: END LOOP; -- fnd_flex_values_cur
2899: log(l_module_name, 'END of fnd_flex_value_hierarchies_cur Loop');
2900: END LOOP; -- fnd_flex_value_hierarchies_cur
2901: END; -- Exception
2902: log(l_module_name, 'END of gtas_attributes_cur Loop');
2903: END LOOP; -- gtas_attributes_cur

Line 2900: END LOOP; -- fnd_flex_value_hierarchies_cur

2896:
2897: log(l_module_name, 'END of fnd_flex_values_rec Loop');
2898: END LOOP; -- fnd_flex_values_cur
2899: log(l_module_name, 'END of fnd_flex_value_hierarchies_cur Loop');
2900: END LOOP; -- fnd_flex_value_hierarchies_cur
2901: END; -- Exception
2902: log(l_module_name, 'END of gtas_attributes_cur Loop');
2903: END LOOP; -- gtas_attributes_cur
2904:

Line 2980: FROM fnd_flex_value_hierarchies

2976: --If it has multiple parents which are enabled, then error
2977: BEGIN
2978: SELECT 1
2979: INTO l_dummy
2980: FROM fnd_flex_value_hierarchies
2981: WHERE vg_acct_number
2982: BETWEEN child_flex_value_low AND child_flex_value_high
2983: AND flex_value_set_id = gbl_acc_value_set_id
2984: AND parent_flex_value <> 'T'