DBA Data[Home] [Help]

APPS.HXT_UTIL dependencies on FND_ID_FLEX_STRUCTURES

Line 1150: Select vital information from the fnd_id_flex_structures and

1146: --
1147: --------------------------Build Cost Alloc Flex Entry --------------------------
1148: /******************************************************************
1149: build_cost_alloc_flex_entry()
1150: Select vital information from the fnd_id_flex_structures and
1151: fnd_id_flex_segments tables to build concatenated segments
1152: string using the segment values passed into this function.
1153: Then create a new entry to the pay_cost_allocation_keyflex table
1154: for the Cost Allocation Flexfield or retrieve the id of an existing

Line 1201: FROM fnd_id_flex_structures fifs,

1197: SELECT fifs.concatenated_segment_delimiter,
1198: fifs.dynamic_inserts_allowed_flag,
1199: fifs.enabled_flag,
1200: fifs.freeze_flex_definition_flag
1201: FROM fnd_id_flex_structures fifs,
1202: per_business_groups_perf pbg
1203: WHERE fifs.id_flex_code = 'COST'
1204: AND fifs.application_id = 801
1205: AND pbg.business_group_id = i_business_group_id

Line 1257: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE;

1253: l_return_code NUMBER;
1254:
1255: --l_concatenated_segments pay_cost_allocation_keyflex.concatenated_segments%TYPE DEFAULT NULL;
1256:
1257: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE;
1258: l_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
1259: l_allowed fnd_id_flex_structures.dynamic_inserts_allowed_flag%TYPE;
1260: l_enabled fnd_id_flex_structures.enabled_flag%TYPE;
1261: l_frozen fnd_id_flex_structures.freeze_flex_definition_flag%TYPE;

Line 1258: l_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;

1254:
1255: --l_concatenated_segments pay_cost_allocation_keyflex.concatenated_segments%TYPE DEFAULT NULL;
1256:
1257: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE;
1258: l_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
1259: l_allowed fnd_id_flex_structures.dynamic_inserts_allowed_flag%TYPE;
1260: l_enabled fnd_id_flex_structures.enabled_flag%TYPE;
1261: l_frozen fnd_id_flex_structures.freeze_flex_definition_flag%TYPE;
1262:

Line 1259: l_allowed fnd_id_flex_structures.dynamic_inserts_allowed_flag%TYPE;

1255: --l_concatenated_segments pay_cost_allocation_keyflex.concatenated_segments%TYPE DEFAULT NULL;
1256:
1257: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE;
1258: l_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
1259: l_allowed fnd_id_flex_structures.dynamic_inserts_allowed_flag%TYPE;
1260: l_enabled fnd_id_flex_structures.enabled_flag%TYPE;
1261: l_frozen fnd_id_flex_structures.freeze_flex_definition_flag%TYPE;
1262:
1263: --l_key_num VARCHAR2(32);

Line 1260: l_enabled fnd_id_flex_structures.enabled_flag%TYPE;

1256:
1257: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE;
1258: l_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
1259: l_allowed fnd_id_flex_structures.dynamic_inserts_allowed_flag%TYPE;
1260: l_enabled fnd_id_flex_structures.enabled_flag%TYPE;
1261: l_frozen fnd_id_flex_structures.freeze_flex_definition_flag%TYPE;
1262:
1263: --l_key_num VARCHAR2(32);
1264:

Line 1261: l_frozen fnd_id_flex_structures.freeze_flex_definition_flag%TYPE;

1257: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE;
1258: l_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
1259: l_allowed fnd_id_flex_structures.dynamic_inserts_allowed_flag%TYPE;
1260: l_enabled fnd_id_flex_structures.enabled_flag%TYPE;
1261: l_frozen fnd_id_flex_structures.freeze_flex_definition_flag%TYPE;
1262:
1263: --l_key_num VARCHAR2(32);
1264:
1265: flex_not_found EXCEPTION;