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 1455: FROM fnd_flex_values

1451: --FV_UTILITY.LOG_MESG('In '||l_module_name);
1452:
1453: SELECT SUBSTR(compiled_value_attributes, 5, 1)
1454: INTO l_account_type
1455: FROM fnd_flex_values
1456: WHERE flex_value = p_account_number
1457: AND flex_value_set_id = gbl_acc_value_set_id;
1458:
1459: RETURN (l_account_type);

Line 3200: CURSOR fnd_flex_values_cur IS

3196: FROM fnd_flex_value_hierarchies
3197: WHERE flex_value_set_id = gbl_acc_value_set_id
3198: AND parent_flex_value = vg_sgl_acct_number;
3199:
3200: CURSOR fnd_flex_values_cur IS
3201: SELECT flex_value
3202: FROM fnd_flex_values
3203: WHERE flex_value_set_id = gbl_acc_value_set_id
3204: AND flex_value BETWEEN vl_child_flex_value_low AND vl_child_flex_value_high;

Line 3202: FROM fnd_flex_values

3198: AND parent_flex_value = vg_sgl_acct_number;
3199:
3200: CURSOR fnd_flex_values_cur IS
3201: SELECT flex_value
3202: FROM fnd_flex_values
3203: WHERE flex_value_set_id = gbl_acc_value_set_id
3204: AND flex_value BETWEEN vl_child_flex_value_low AND vl_child_flex_value_high;
3205:
3206:

Line 3282: FOR fnd_flex_values_rec IN fnd_flex_values_cur

3278: vl_child_flex_value_high := NULL;
3279: vl_child_flex_value_low := fnd_flex_value_hierarchies_rec.child_flex_value_low;
3280: vl_child_flex_value_high := fnd_flex_value_hierarchies_rec.child_flex_value_high;
3281:
3282: FOR fnd_flex_values_rec IN fnd_flex_values_cur
3283: LOOP
3284: vg_acct_number := fnd_flex_values_rec.flex_value;
3285: POPULATE_FV_FACTS_FED_ACCOUNTS;
3286:

Line 3284: vg_acct_number := fnd_flex_values_rec.flex_value;

3280: vl_child_flex_value_high := fnd_flex_value_hierarchies_rec.child_flex_value_high;
3281:
3282: FOR fnd_flex_values_rec IN fnd_flex_values_cur
3283: LOOP
3284: vg_acct_number := fnd_flex_values_rec.flex_value;
3285: POPULATE_FV_FACTS_FED_ACCOUNTS;
3286:
3287: IF gbl_error_code <> 0 THEN
3288: p_err_code := gbl_error_code;

Line 3295: END LOOP; -- fnd_flex_values_cur

3291: RETURN;
3292: END IF;
3293:
3294:
3295: END LOOP; -- fnd_flex_values_cur
3296: END LOOP; -- fnd_flex_value_hierarchies_cur
3297: END; -- Exception
3298: END LOOP; -- facts_attributes_cur
3299: