APPS.FV_FACTS1_PKG dependencies on FND_FLEX_VALUE_HIERARCHIES

Line 1151: FROM fnd_flex_value_hierarchies

1147:
1148: BEGIN
1149: SELECT parent_flex_value
1150: INTO l_ussgl_acct_num
1151: FROM fnd_flex_value_hierarchies
1152: WHERE (p_acct_num BETWEEN child_flex_value_low
1153: AND child_flex_value_high)
1154: AND flex_value_set_id = gbl_acc_value_set_id
1155: AND parent_flex_value <> 'T'

Line 3171: vl_child_flex_value_low Fnd_Flex_Value_Hierarchies.child_flex_value_low%TYPE;

3167: e_invalid_acc_segment EXCEPTION;
3168: vl_segment_status BOOLEAN;
3169: vl_apps_id NUMBER := 101;
3170: vl_flex_code VARCHAR2(25) := 'GL#';
3171: vl_child_flex_value_low Fnd_Flex_Value_Hierarchies.child_flex_value_low%TYPE;
3172: vl_child_flex_value_high Fnd_Flex_Value_Hierarchies.child_flex_value_high%TYPE;
3173: l_je_header_id number(15);
3174: l_no_new_accounts number(15);
3175: l_period_num number(15);

Line 3172: vl_child_flex_value_high Fnd_Flex_Value_Hierarchies.child_flex_value_high%TYPE;

3168: vl_segment_status BOOLEAN;
3169: vl_apps_id NUMBER := 101;
3170: vl_flex_code VARCHAR2(25) := 'GL#';
3171: vl_child_flex_value_low Fnd_Flex_Value_Hierarchies.child_flex_value_low%TYPE;
3172: vl_child_flex_value_high Fnd_Flex_Value_Hierarchies.child_flex_value_high%TYPE;
3173: l_je_header_id number(15);
3174: l_no_new_accounts number(15);
3175: l_period_num number(15);
3176: l_error_code varchar2(25);

Line 3194: CURSOR fnd_flex_value_hierarchies_cur IS

3190: FROM fv_facts_attributes
3191: WHERE set_of_books_id = p_sob_id --vg_sob_id
3192: AND govt_non_govt in ('F', 'Y');
3193:
3194: CURSOR fnd_flex_value_hierarchies_cur IS
3195: SELECT child_flex_value_low, child_flex_value_high
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;

Line 3196: FROM fnd_flex_value_hierarchies

3192: AND govt_non_govt in ('F', 'Y');
3193:
3194: CURSOR fnd_flex_value_hierarchies_cur IS
3195: SELECT child_flex_value_low, child_flex_value_high
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

Line 3243: FROM fnd_flex_value_hierarchies

3239:
3240: BEGIN
3241: SELECT parent_flex_value
3242: INTO vg_sgl_acct_number
3243: FROM fnd_flex_value_hierarchies
3244: WHERE vg_acct_number
3245: BETWEEN child_flex_value_low AND child_flex_value_high
3246: AND flex_value_set_id = gbl_acc_value_set_id
3247: AND parent_flex_value <> 'T'

Line 3275: FOR fnd_flex_value_hierarchies_rec IN fnd_flex_value_hierarchies_cur

3271:
3272: -- If parent not found, then account itself is parent, find all its child accounts
3273: -- and insert them into FV_FACTS_FED_ACCOUNTS table if not already present.
3274:
3275: FOR fnd_flex_value_hierarchies_rec IN fnd_flex_value_hierarchies_cur
3276: LOOP
3277: vl_child_flex_value_low := NULL;
3278: vl_child_flex_value_high := NULL;
3279: vl_child_flex_value_low := fnd_flex_value_hierarchies_rec.child_flex_value_low;

Line 3279: vl_child_flex_value_low := fnd_flex_value_hierarchies_rec.child_flex_value_low;

3275: FOR fnd_flex_value_hierarchies_rec IN fnd_flex_value_hierarchies_cur
3276: LOOP
3277: vl_child_flex_value_low := NULL;
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

Line 3280: vl_child_flex_value_high := fnd_flex_value_hierarchies_rec.child_flex_value_high;

3276: LOOP
3277: vl_child_flex_value_low := NULL;
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;

Line 3296: END LOOP; -- fnd_flex_value_hierarchies_cur

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