DBA Data[Home] [Help]

APPS.FND_FLEX_VAL_API dependencies on FND_API

Line 22: -- Rename FND_API constants.

18: g_ret_not_table_validated NUMBER := 51;
19: g_ret_no_table_info NUMBER := 52;
20:
21: --
22: -- Rename FND_API constants.
23: --
24: -- In Update APIs
25: -- NULL means "ignore this field, do not update it", and
26: -- Following constants mean "set the field to NULL."

Line 28: g_null_number NUMBER := fnd_api.g_miss_num;

24: -- In Update APIs
25: -- NULL means "ignore this field, do not update it", and
26: -- Following constants mean "set the field to NULL."
27: --
28: g_null_number NUMBER := fnd_api.g_miss_num;
29: g_null_varchar2 VARCHAR2(10) := fnd_api.g_miss_char;
30: g_null_date DATE := fnd_api.g_miss_date;
31:
32:

Line 29: g_null_varchar2 VARCHAR2(10) := fnd_api.g_miss_char;

25: -- NULL means "ignore this field, do not update it", and
26: -- Following constants mean "set the field to NULL."
27: --
28: g_null_number NUMBER := fnd_api.g_miss_num;
29: g_null_varchar2 VARCHAR2(10) := fnd_api.g_miss_char;
30: g_null_date DATE := fnd_api.g_miss_date;
31:
32:
33: PROCEDURE debug_on ;

Line 30: g_null_date DATE := fnd_api.g_miss_date;

26: -- Following constants mean "set the field to NULL."
27: --
28: g_null_number NUMBER := fnd_api.g_miss_num;
29: g_null_varchar2 VARCHAR2(10) := fnd_api.g_miss_char;
30: g_null_date DATE := fnd_api.g_miss_date;
31:
32:
33: PROCEDURE debug_on ;
34:

Line 278: DEFAULT fnd_api.g_miss_char,

274: --
275: --------------------------------------------------------------
276: PROCEDURE get_independent_vset_select
277: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
278: DEFAULT fnd_api.g_miss_char,
279: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
280: DEFAULT fnd_api.g_miss_num,
281: --
282: -- Do you want to include these columns in SELECT statement?

Line 280: DEFAULT fnd_api.g_miss_num,

276: PROCEDURE get_independent_vset_select
277: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
278: DEFAULT fnd_api.g_miss_char,
279: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
280: DEFAULT fnd_api.g_miss_num,
281: --
282: -- Do you want to include these columns in SELECT statement?
283: -- VALUE column is always included.
284: -- ID and MEANING columns are included by default.

Line 310: DEFAULT fnd_api.g_miss_char,

306:
307:
308: PROCEDURE get_dependent_vset_select
309: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
310: DEFAULT fnd_api.g_miss_char,
311: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
312: DEFAULT fnd_api.g_miss_num,
313: p_independent_value IN VARCHAR2 DEFAULT NULL,
314: --

Line 312: DEFAULT fnd_api.g_miss_num,

308: PROCEDURE get_dependent_vset_select
309: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
310: DEFAULT fnd_api.g_miss_char,
311: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
312: DEFAULT fnd_api.g_miss_num,
313: p_independent_value IN VARCHAR2 DEFAULT NULL,
314: --
315: -- Do you want to include these columns in SELECT statement?
316: -- VALUE column is always included.

Line 343: DEFAULT fnd_api.g_miss_char,

339:
340:
341: PROCEDURE get_table_vset_select
342: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
343: DEFAULT fnd_api.g_miss_char,
344: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
345: DEFAULT fnd_api.g_miss_num,
346: --
347: -- Do you want to include these columns in SELECT statement?

Line 345: DEFAULT fnd_api.g_miss_num,

341: PROCEDURE get_table_vset_select
342: (p_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
343: DEFAULT fnd_api.g_miss_char,
344: p_value_set_id IN fnd_flex_value_sets.flex_value_set_id%TYPE
345: DEFAULT fnd_api.g_miss_num,
346: --
347: -- Do you want to include these columns in SELECT statement?
348: -- VALUE column is always included.
349: -- ID and MEANING columns are included by default.