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_FACTS1_PKG dependencies on FND_FLEX_VALUES

Line 1482: FROM fnd_flex_values

1478: --FV_UTILITY.LOG_MESG('In '||l_module_name);
1479:
1480: SELECT SUBSTR(compiled_value_attributes, 5, 1)
1481: INTO l_account_type
1482: FROM fnd_flex_values
1483: WHERE flex_value = p_account_number
1484: AND flex_value_set_id = gbl_acc_value_set_id;
1485:
1486: RETURN (l_account_type);

Line 3278: CURSOR fnd_flex_values_cur IS

3274: FROM fnd_flex_value_hierarchies
3275: WHERE flex_value_set_id = gbl_acc_value_set_id
3276: AND parent_flex_value = vg_sgl_acct_number;
3277:
3278: CURSOR fnd_flex_values_cur IS
3279: SELECT flex_value
3280: FROM fnd_flex_values
3281: WHERE flex_value_set_id = gbl_acc_value_set_id
3282: AND flex_value BETWEEN vl_child_flex_value_low AND vl_child_flex_value_high;

Line 3280: FROM fnd_flex_values

3276: AND parent_flex_value = vg_sgl_acct_number;
3277:
3278: CURSOR fnd_flex_values_cur IS
3279: SELECT flex_value
3280: FROM fnd_flex_values
3281: WHERE flex_value_set_id = gbl_acc_value_set_id
3282: AND flex_value BETWEEN vl_child_flex_value_low AND vl_child_flex_value_high;
3283:
3284:

Line 3360: FOR fnd_flex_values_rec IN fnd_flex_values_cur

3356: vl_child_flex_value_high := NULL;
3357: vl_child_flex_value_low := fnd_flex_value_hierarchies_rec.child_flex_value_low;
3358: vl_child_flex_value_high := fnd_flex_value_hierarchies_rec.child_flex_value_high;
3359:
3360: FOR fnd_flex_values_rec IN fnd_flex_values_cur
3361: LOOP
3362: vg_acct_number := fnd_flex_values_rec.flex_value;
3363: POPULATE_FV_FACTS_FED_ACCOUNTS;
3364:

Line 3362: vg_acct_number := fnd_flex_values_rec.flex_value;

3358: vl_child_flex_value_high := fnd_flex_value_hierarchies_rec.child_flex_value_high;
3359:
3360: FOR fnd_flex_values_rec IN fnd_flex_values_cur
3361: LOOP
3362: vg_acct_number := fnd_flex_values_rec.flex_value;
3363: POPULATE_FV_FACTS_FED_ACCOUNTS;
3364:
3365: IF gbl_error_code <> 0 THEN
3366: p_err_code := gbl_error_code;

Line 3373: END LOOP; -- fnd_flex_values_cur

3369: RETURN;
3370: END IF;
3371:
3372:
3373: END LOOP; -- fnd_flex_values_cur
3374: END LOOP; -- fnd_flex_value_hierarchies_cur
3375: END; -- Exception
3376: END LOOP; -- facts_attributes_cur
3377: