DBA Data[Home] [Help]

APPS.HXT_UTIL dependencies on FND_ID_FLEX_STRUCTURES

Line 1169: Select vital information from the fnd_id_flex_structures and

1165: --
1166: --------------------------Build Cost Alloc Flex Entry --------------------------
1167: /******************************************************************
1168: build_cost_alloc_flex_entry()
1169: Select vital information from the fnd_id_flex_structures and
1170: fnd_id_flex_segments tables to build concatenated segments
1171: string using the segment values passed into this function.
1172: Then create a new entry to the pay_cost_allocation_keyflex table
1173: for the Cost Allocation Flexfield or retrieve the id of an existing

Line 1220: FROM fnd_id_flex_structures fifs,

1216: SELECT fifs.concatenated_segment_delimiter,
1217: fifs.dynamic_inserts_allowed_flag,
1218: fifs.enabled_flag,
1219: fifs.freeze_flex_definition_flag
1220: FROM fnd_id_flex_structures fifs,
1221: per_business_groups_perf pbg
1222: WHERE fifs.id_flex_code = 'COST'
1223: AND fifs.application_id = 801
1224: AND pbg.business_group_id = i_business_group_id

Line 1276: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE;

1272: l_return_code NUMBER;
1273:
1274: --l_concatenated_segments pay_cost_allocation_keyflex.concatenated_segments%TYPE DEFAULT NULL;
1275:
1276: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE;
1277: l_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
1278: l_allowed fnd_id_flex_structures.dynamic_inserts_allowed_flag%TYPE;
1279: l_enabled fnd_id_flex_structures.enabled_flag%TYPE;
1280: l_frozen fnd_id_flex_structures.freeze_flex_definition_flag%TYPE;

Line 1277: l_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;

1273:
1274: --l_concatenated_segments pay_cost_allocation_keyflex.concatenated_segments%TYPE DEFAULT NULL;
1275:
1276: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE;
1277: l_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
1278: l_allowed fnd_id_flex_structures.dynamic_inserts_allowed_flag%TYPE;
1279: l_enabled fnd_id_flex_structures.enabled_flag%TYPE;
1280: l_frozen fnd_id_flex_structures.freeze_flex_definition_flag%TYPE;
1281:

Line 1278: l_allowed fnd_id_flex_structures.dynamic_inserts_allowed_flag%TYPE;

1274: --l_concatenated_segments pay_cost_allocation_keyflex.concatenated_segments%TYPE DEFAULT NULL;
1275:
1276: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE;
1277: l_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
1278: l_allowed fnd_id_flex_structures.dynamic_inserts_allowed_flag%TYPE;
1279: l_enabled fnd_id_flex_structures.enabled_flag%TYPE;
1280: l_frozen fnd_id_flex_structures.freeze_flex_definition_flag%TYPE;
1281:
1282: --l_key_num VARCHAR2(32);

Line 1279: l_enabled fnd_id_flex_structures.enabled_flag%TYPE;

1275:
1276: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE;
1277: l_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
1278: l_allowed fnd_id_flex_structures.dynamic_inserts_allowed_flag%TYPE;
1279: l_enabled fnd_id_flex_structures.enabled_flag%TYPE;
1280: l_frozen fnd_id_flex_structures.freeze_flex_definition_flag%TYPE;
1281:
1282: --l_key_num VARCHAR2(32);
1283:

Line 1280: l_frozen fnd_id_flex_structures.freeze_flex_definition_flag%TYPE;

1276: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE;
1277: l_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
1278: l_allowed fnd_id_flex_structures.dynamic_inserts_allowed_flag%TYPE;
1279: l_enabled fnd_id_flex_structures.enabled_flag%TYPE;
1280: l_frozen fnd_id_flex_structures.freeze_flex_definition_flag%TYPE;
1281:
1282: --l_key_num VARCHAR2(32);
1283:
1284: flex_not_found EXCEPTION;