DBA Data[Home] [Help]

APPS.FND_FLEX_KEY_API dependencies on FND_API

Line 312: IF(val = fnd_api.g_miss_char) THEN

308: FUNCTION is_default(val IN VARCHAR2)
309: RETURN BOOLEAN
310: IS
311: BEGIN
312: IF(val = fnd_api.g_miss_char) THEN
313: RETURN TRUE;
314: ELSE
315: RETURN FALSE;
316: END IF;

Line 322: IF(val = fnd_api.g_miss_num) THEN

318:
319: FUNCTION is_default(val IN NUMBER) RETURN BOOLEAN
320: IS
321: BEGIN
322: IF(val = fnd_api.g_miss_num) THEN
323: RETURN TRUE;
324: ELSE
325: RETURN FALSE;
326: END IF;

Line 332: val := fnd_api.g_miss_char;

328:
329: PROCEDURE make_default(val IN OUT nocopy VARCHAR2)
330: IS
331: BEGIN
332: val := fnd_api.g_miss_char;
333: END;
334:
335: PROCEDURE make_default(val IN OUT nocopy NUMBER)
336: IS

Line 338: val := fnd_api.g_miss_num;

334:
335: PROCEDURE make_default(val IN OUT nocopy NUMBER)
336: IS
337: BEGIN
338: val := fnd_api.g_miss_num;
339: END;
340:
341: PROCEDURE set_value(val IN VARCHAR2, var OUT nocopy VARCHAR2)
342: IS

Line 344: if ( val <> fnd_api.g_miss_char ) then

340:
341: PROCEDURE set_value(val IN VARCHAR2, var OUT nocopy VARCHAR2)
342: IS
343: BEGIN
344: if ( val <> fnd_api.g_miss_char ) then
345: var := val;
346: else
347: var := NULL;
348: end if;

Line 354: if ( val <> fnd_api.g_miss_num ) then

350:
351: PROCEDURE set_value(val IN NUMBER, var OUT nocopy NUMBER)
352: IS
353: BEGIN
354: if ( val <> fnd_api.g_miss_num ) then
355: var := val;
356: else
357: var := NULL;
358: end if;

Line 920: IF(chng = fnd_api.g_miss_char) THEN

916: chng IN VARCHAR2,
917: dcnt IN OUT nocopy NUMBER) RETURN VARCHAR2
918: IS
919: BEGIN
920: IF(chng = fnd_api.g_miss_char) THEN
921: dcnt := dcnt + 1;
922: RETURN orig;
923: ELSE
924: RETURN chng;

Line 935: IF(chng = fnd_api.g_miss_num) THEN

931: chng IN NUMBER,
932: dcnt IN OUT nocopy NUMBER) RETURN NUMBER
933: IS
934: BEGIN
935: IF(chng = fnd_api.g_miss_num) THEN
936: dcnt := dcnt + 1;
937: RETURN orig;
938: ELSE
939: RETURN chng;

Line 1210: (appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1206: END;
1207:
1208: /* ---------------------------------------------------------------------- */
1209: FUNCTION new_flexfield
1210: (appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1211: flex_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1212: flex_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1213: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1214: table_appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1211: flex_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1207:
1208: /* ---------------------------------------------------------------------- */
1209: FUNCTION new_flexfield
1210: (appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1211: flex_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1212: flex_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1213: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1214: table_appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1215: table_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1212: flex_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1208: /* ---------------------------------------------------------------------- */
1209: FUNCTION new_flexfield
1210: (appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1211: flex_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1212: flex_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1213: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1214: table_appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1215: table_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1216: unique_id_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1213: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1209: FUNCTION new_flexfield
1210: (appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1211: flex_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1212: flex_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1213: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1214: table_appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1215: table_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1216: unique_id_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1217: structure_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1214: table_appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1210: (appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1211: flex_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1212: flex_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1213: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1214: table_appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1215: table_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1216: unique_id_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1217: structure_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1218: dynamic_inserts IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1215: table_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1211: flex_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1212: flex_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1213: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1214: table_appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1215: table_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1216: unique_id_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1217: structure_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1218: dynamic_inserts IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1219: allow_id_value_sets IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1216: unique_id_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1212: flex_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1213: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1214: table_appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1215: table_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1216: unique_id_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1217: structure_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1218: dynamic_inserts IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1219: allow_id_value_sets IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1220: index_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1217: structure_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1213: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1214: table_appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1215: table_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1216: unique_id_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1217: structure_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1218: dynamic_inserts IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1219: allow_id_value_sets IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1220: index_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1221: concat_seg_len_max IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 1218: dynamic_inserts IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1214: table_appl_short_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1215: table_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1216: unique_id_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1217: structure_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1218: dynamic_inserts IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1219: allow_id_value_sets IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1220: index_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1221: concat_seg_len_max IN NUMBER DEFAULT fnd_api.g_miss_num,
1222: concat_len_warning IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 1219: allow_id_value_sets IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1215: table_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1216: unique_id_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1217: structure_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1218: dynamic_inserts IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1219: allow_id_value_sets IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1220: index_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1221: concat_seg_len_max IN NUMBER DEFAULT fnd_api.g_miss_num,
1222: concat_len_warning IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1223: concatenated_segs_view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char)

Line 1220: index_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1216: unique_id_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1217: structure_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1218: dynamic_inserts IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1219: allow_id_value_sets IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1220: index_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1221: concat_seg_len_max IN NUMBER DEFAULT fnd_api.g_miss_num,
1222: concat_len_warning IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1223: concatenated_segs_view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
1224: RETURN flexfield_type

Line 1221: concat_seg_len_max IN NUMBER DEFAULT fnd_api.g_miss_num,

1217: structure_column IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1218: dynamic_inserts IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1219: allow_id_value_sets IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1220: index_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1221: concat_seg_len_max IN NUMBER DEFAULT fnd_api.g_miss_num,
1222: concat_len_warning IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1223: concatenated_segs_view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
1224: RETURN flexfield_type
1225: IS

Line 1222: concat_len_warning IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1218: dynamic_inserts IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1219: allow_id_value_sets IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1220: index_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1221: concat_seg_len_max IN NUMBER DEFAULT fnd_api.g_miss_num,
1222: concat_len_warning IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1223: concatenated_segs_view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
1224: RETURN flexfield_type
1225: IS
1226: flexfield flexfield_type;

Line 1223: concatenated_segs_view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char)

1219: allow_id_value_sets IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1220: index_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1221: concat_seg_len_max IN NUMBER DEFAULT fnd_api.g_miss_num,
1222: concat_len_warning IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1223: concatenated_segs_view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
1224: RETURN flexfield_type
1225: IS
1226: flexfield flexfield_type;
1227: BEGIN

Line 2187: structure_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2183: /* ------------------------------------------------------------ */
2184: /* STRUCTURE RELATED FUNCTIONS */
2185: /* ------------------------------------------------------------ */
2186: FUNCTION new_structure(flexfield IN flexfield_type,
2187: structure_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2188: structure_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2189: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2190: view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2191: freeze_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 2188: structure_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2184: /* STRUCTURE RELATED FUNCTIONS */
2185: /* ------------------------------------------------------------ */
2186: FUNCTION new_structure(flexfield IN flexfield_type,
2187: structure_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2188: structure_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2189: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2190: view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2191: freeze_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2192: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 2189: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2185: /* ------------------------------------------------------------ */
2186: FUNCTION new_structure(flexfield IN flexfield_type,
2187: structure_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2188: structure_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2189: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2190: view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2191: freeze_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2192: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2193: segment_separator IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 2190: view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2186: FUNCTION new_structure(flexfield IN flexfield_type,
2187: structure_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2188: structure_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2189: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2190: view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2191: freeze_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2192: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2193: segment_separator IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2194: cross_val_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 2191: freeze_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2187: structure_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2188: structure_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2189: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2190: view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2191: freeze_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2192: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2193: segment_separator IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2194: cross_val_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2195: freeze_rollup_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 2192: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2188: structure_title IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2189: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2190: view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2191: freeze_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2192: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2193: segment_separator IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2194: cross_val_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2195: freeze_rollup_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2196: dynamic_insert_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 2193: segment_separator IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2189: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2190: view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2191: freeze_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2192: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2193: segment_separator IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2194: cross_val_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2195: freeze_rollup_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2196: dynamic_insert_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2197: shorthand_enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 2194: cross_val_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2190: view_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2191: freeze_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2192: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2193: segment_separator IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2194: cross_val_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2195: freeze_rollup_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2196: dynamic_insert_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2197: shorthand_enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2198: shorthand_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 2195: freeze_rollup_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2191: freeze_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2192: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2193: segment_separator IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2194: cross_val_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2195: freeze_rollup_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2196: dynamic_insert_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2197: shorthand_enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2198: shorthand_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2199: shorthand_length IN NUMBER DEFAULT fnd_api.g_miss_num)

Line 2196: dynamic_insert_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2192: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2193: segment_separator IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2194: cross_val_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2195: freeze_rollup_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2196: dynamic_insert_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2197: shorthand_enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2198: shorthand_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2199: shorthand_length IN NUMBER DEFAULT fnd_api.g_miss_num)
2200: RETURN structure_type

Line 2197: shorthand_enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2193: segment_separator IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2194: cross_val_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2195: freeze_rollup_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2196: dynamic_insert_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2197: shorthand_enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2198: shorthand_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2199: shorthand_length IN NUMBER DEFAULT fnd_api.g_miss_num)
2200: RETURN structure_type
2201: IS

Line 2198: shorthand_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2194: cross_val_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2195: freeze_rollup_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2196: dynamic_insert_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2197: shorthand_enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2198: shorthand_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2199: shorthand_length IN NUMBER DEFAULT fnd_api.g_miss_num)
2200: RETURN structure_type
2201: IS
2202: structure structure_type;

Line 2199: shorthand_length IN NUMBER DEFAULT fnd_api.g_miss_num)

2195: freeze_rollup_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2196: dynamic_insert_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2197: shorthand_enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2198: shorthand_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2199: shorthand_length IN NUMBER DEFAULT fnd_api.g_miss_num)
2200: RETURN structure_type
2201: IS
2202: structure structure_type;
2203: BEGIN

Line 2595: segment_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2591: /* ---------------------------------------------------------------------- */
2592: FUNCTION new_segment
2593: (flexfield IN flexfield_type,
2594: structure IN structure_type,
2595: segment_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2596: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2597: column_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2598: segment_number IN NUMBER DEFAULT fnd_api.g_miss_num,
2599: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 2596: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2592: FUNCTION new_segment
2593: (flexfield IN flexfield_type,
2594: structure IN structure_type,
2595: segment_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2596: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2597: column_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2598: segment_number IN NUMBER DEFAULT fnd_api.g_miss_num,
2599: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2600: displayed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 2597: column_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2593: (flexfield IN flexfield_type,
2594: structure IN structure_type,
2595: segment_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2596: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2597: column_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2598: segment_number IN NUMBER DEFAULT fnd_api.g_miss_num,
2599: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2600: displayed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2601: indexed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 2598: segment_number IN NUMBER DEFAULT fnd_api.g_miss_num,

2594: structure IN structure_type,
2595: segment_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2596: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2597: column_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2598: segment_number IN NUMBER DEFAULT fnd_api.g_miss_num,
2599: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2600: displayed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2601: indexed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2602:

Line 2599: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2595: segment_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2596: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2597: column_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2598: segment_number IN NUMBER DEFAULT fnd_api.g_miss_num,
2599: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2600: displayed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2601: indexed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2602:
2603: /* validation */

Line 2600: displayed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2596: description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2597: column_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2598: segment_number IN NUMBER DEFAULT fnd_api.g_miss_num,
2599: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2600: displayed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2601: indexed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2602:
2603: /* validation */
2604: value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 2601: indexed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2597: column_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2598: segment_number IN NUMBER DEFAULT fnd_api.g_miss_num,
2599: enabled_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2600: displayed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2601: indexed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2602:
2603: /* validation */
2604: value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2605: default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 2604: value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2600: displayed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2601: indexed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2602:
2603: /* validation */
2604: value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2605: default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2606: default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2607: required_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2608: security_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 2605: default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2601: indexed_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2602:
2603: /* validation */
2604: value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2605: default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2606: default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2607: required_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2608: security_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2609: range_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 2606: default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2602:
2603: /* validation */
2604: value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2605: default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2606: default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2607: required_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2608: security_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2609: range_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2610:

Line 2607: required_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2603: /* validation */
2604: value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2605: default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2606: default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2607: required_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2608: security_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2609: range_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2610:
2611: /* sizes */

Line 2608: security_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2604: value_set IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2605: default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2606: default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2607: required_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2608: security_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2609: range_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2610:
2611: /* sizes */
2612: display_size IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 2609: range_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2605: default_type IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2606: default_value IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2607: required_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2608: security_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2609: range_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2610:
2611: /* sizes */
2612: display_size IN NUMBER DEFAULT fnd_api.g_miss_num,
2613: description_size IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 2612: display_size IN NUMBER DEFAULT fnd_api.g_miss_num,

2608: security_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2609: range_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2610:
2611: /* sizes */
2612: display_size IN NUMBER DEFAULT fnd_api.g_miss_num,
2613: description_size IN NUMBER DEFAULT fnd_api.g_miss_num,
2614: concat_size IN NUMBER DEFAULT fnd_api.g_miss_num,
2615:
2616: /* prompts */

Line 2613: description_size IN NUMBER DEFAULT fnd_api.g_miss_num,

2609: range_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2610:
2611: /* sizes */
2612: display_size IN NUMBER DEFAULT fnd_api.g_miss_num,
2613: description_size IN NUMBER DEFAULT fnd_api.g_miss_num,
2614: concat_size IN NUMBER DEFAULT fnd_api.g_miss_num,
2615:
2616: /* prompts */
2617: lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 2614: concat_size IN NUMBER DEFAULT fnd_api.g_miss_num,

2610:
2611: /* sizes */
2612: display_size IN NUMBER DEFAULT fnd_api.g_miss_num,
2613: description_size IN NUMBER DEFAULT fnd_api.g_miss_num,
2614: concat_size IN NUMBER DEFAULT fnd_api.g_miss_num,
2615:
2616: /* prompts */
2617: lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2618: window_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 2617: lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2613: description_size IN NUMBER DEFAULT fnd_api.g_miss_num,
2614: concat_size IN NUMBER DEFAULT fnd_api.g_miss_num,
2615:
2616: /* prompts */
2617: lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2618: window_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2619: runtime_property_function IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2620: additional_where_clause IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
2621: RETURN segment_type

Line 2618: window_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2614: concat_size IN NUMBER DEFAULT fnd_api.g_miss_num,
2615:
2616: /* prompts */
2617: lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2618: window_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2619: runtime_property_function IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2620: additional_where_clause IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
2621: RETURN segment_type
2622: IS

Line 2619: runtime_property_function IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

2615:
2616: /* prompts */
2617: lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2618: window_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2619: runtime_property_function IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2620: additional_where_clause IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
2621: RETURN segment_type
2622: IS
2623: segment segment_type;

Line 2620: additional_where_clause IN VARCHAR2 DEFAULT fnd_api.g_miss_char)

2616: /* prompts */
2617: lov_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2618: window_prompt IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2619: runtime_property_function IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
2620: additional_where_clause IN VARCHAR2 DEFAULT fnd_api.g_miss_char)
2621: RETURN segment_type
2622: IS
2623: segment segment_type;
2624: BEGIN