APPS.FV_FACTS1_PKG dependencies on FND_FLEX_VALUE_HIERARCHIES

Line 1164: FROM fnd_flex_value_hierarchies

1160:
1161: BEGIN
1162: SELECT parent_flex_value
1163: INTO l_ussgl_acct_num
1164: FROM fnd_flex_value_hierarchies
1165: WHERE (p_acct_num BETWEEN child_flex_value_low
1166: AND child_flex_value_high)
1167: AND flex_value_set_id = gbl_acc_value_set_id
1168: AND parent_flex_value <> 'T'

Line 3249: vl_child_flex_value_low Fnd_Flex_Value_Hierarchies.child_flex_value_low%TYPE;

3245: e_invalid_acc_segment EXCEPTION;
3246: vl_segment_status BOOLEAN;
3247: vl_apps_id NUMBER := 101;
3248: vl_flex_code VARCHAR2(25) := 'GL#';
3249: vl_child_flex_value_low Fnd_Flex_Value_Hierarchies.child_flex_value_low%TYPE;
3250: vl_child_flex_value_high Fnd_Flex_Value_Hierarchies.child_flex_value_high%TYPE;
3251: l_je_header_id number(15);
3252: l_no_new_accounts number(15);
3253: l_period_num number(15);

Line 3250: vl_child_flex_value_high Fnd_Flex_Value_Hierarchies.child_flex_value_high%TYPE;

3246: vl_segment_status BOOLEAN;
3247: vl_apps_id NUMBER := 101;
3248: vl_flex_code VARCHAR2(25) := 'GL#';
3249: vl_child_flex_value_low Fnd_Flex_Value_Hierarchies.child_flex_value_low%TYPE;
3250: vl_child_flex_value_high Fnd_Flex_Value_Hierarchies.child_flex_value_high%TYPE;
3251: l_je_header_id number(15);
3252: l_no_new_accounts number(15);
3253: l_period_num number(15);
3254: l_error_code varchar2(25);

Line 3272: CURSOR fnd_flex_value_hierarchies_cur IS

3268: FROM fv_facts_attributes
3269: WHERE set_of_books_id = p_sob_id --vg_sob_id
3270: AND govt_non_govt in ('F', 'Y');
3271:
3272: CURSOR fnd_flex_value_hierarchies_cur IS
3273: SELECT child_flex_value_low, child_flex_value_high
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;

Line 3274: FROM fnd_flex_value_hierarchies

3270: AND govt_non_govt in ('F', 'Y');
3271:
3272: CURSOR fnd_flex_value_hierarchies_cur IS
3273: SELECT child_flex_value_low, child_flex_value_high
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

Line 3321: FROM fnd_flex_value_hierarchies

3317:
3318: BEGIN
3319: SELECT parent_flex_value
3320: INTO vg_sgl_acct_number
3321: FROM fnd_flex_value_hierarchies
3322: WHERE vg_acct_number
3323: BETWEEN child_flex_value_low AND child_flex_value_high
3324: AND flex_value_set_id = gbl_acc_value_set_id
3325: AND parent_flex_value <> 'T'

Line 3353: FOR fnd_flex_value_hierarchies_rec IN fnd_flex_value_hierarchies_cur

3349:
3350: -- If parent not found, then account itself is parent, find all its child accounts
3351: -- and insert them into FV_FACTS_FED_ACCOUNTS table if not already present.
3352:
3353: FOR fnd_flex_value_hierarchies_rec IN fnd_flex_value_hierarchies_cur
3354: LOOP
3355: vl_child_flex_value_low := NULL;
3356: vl_child_flex_value_high := NULL;
3357: vl_child_flex_value_low := fnd_flex_value_hierarchies_rec.child_flex_value_low;

Line 3357: vl_child_flex_value_low := fnd_flex_value_hierarchies_rec.child_flex_value_low;

3353: FOR fnd_flex_value_hierarchies_rec IN fnd_flex_value_hierarchies_cur
3354: LOOP
3355: vl_child_flex_value_low := NULL;
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

Line 3358: vl_child_flex_value_high := fnd_flex_value_hierarchies_rec.child_flex_value_high;

3354: LOOP
3355: vl_child_flex_value_low := NULL;
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;

Line 3374: END LOOP; -- fnd_flex_value_hierarchies_cur

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:
3378: UPDATE_FACTS1_RUN(P_RUN_YEAR, GBL_SET_OF_BOOKS_ID);