APPS.GL_DRM_INTEGRATION_PKG dependencies on FND_FLEX_HIERARCHIES

Line 234: l_rollup_id FND_FLEX_HIERARCHIES.hierarchy_id%TYPE;

230: AND ffv.flex_value = p_value;
231:
232: -- Local variables
233: rec_existing_value c_fnd_flex_values%ROWTYPE;
234: l_rollup_id FND_FLEX_HIERARCHIES.hierarchy_id%TYPE;
235: l_old_account_type FND_FLEX_VALUES.compiled_value_attributes%TYPE;
236: l_val_exists BOOLEAN;
237:
238: BEGIN

Line 295: FROM fnd_flex_hierarchies ffh

291: THEN
292: BEGIN
293: SELECT hierarchy_id
294: INTO l_rollup_id
295: FROM fnd_flex_hierarchies ffh
296: WHERE ffh.flex_value_set_id = g_value_set_id
297: AND ffh.hierarchy_code = p_rollup_group;
298: EXCEPTION
299: WHEN No_Data_Found THEN

Line 1217: fnd_flex_hierarchies ffh

1213: ffv.compiled_value_attributes,
1214: ffh.hierarchy_code rollup_group,
1215: ffv.hierarchy_level
1216: FROM fnd_flex_values_vl ffv,
1217: fnd_flex_hierarchies ffh
1218: WHERE ffv.flex_value_set_id = p_value_set_id
1219: AND ffv.flex_value_set_id = ffh.flex_value_set_id(+)
1220: AND ffv.structured_hierarchy_level = ffh.hierarchy_id(+);
1221:

Line 1224: cp_flex_value_set_id IN fnd_flex_hierarchies.flex_value_set_id%TYPE,

1220: AND ffv.structured_hierarchy_level = ffh.hierarchy_id(+);
1221:
1222: /* cursor to fetch assigned segment qualifiers for a given value set */
1223: CURSOR c_flex_val_qual (
1224: cp_flex_value_set_id IN fnd_flex_hierarchies.flex_value_set_id%TYPE,
1225: cp_id_flex_code IN fnd_flex_validation_qualifiers.id_flex_code%TYPE,
1226: cp_id_flex_application_id IN fnd_flex_validation_qualifiers.id_flex_application_id%TYPE)
1227: IS
1228: SELECT

Line 1276: l_rollup FND_FLEX_HIERARCHIES.hierarchy_code%TYPE;

1272: l_leaf VARCHAR2(10);
1273: l_enabled VARCHAR2(10);
1274: l_from VARCHAR2(240);
1275: l_to VARCHAR2(240);
1276: l_rollup FND_FLEX_HIERARCHIES.hierarchy_code%TYPE;
1277: l_level FND_FLEX_VALUES.hierarchy_level%TYPE;
1278: l_budgeting VARCHAR2(240);
1279: l_posting VARCHAR2(240);
1280: l_accttype VARCHAR2(240);