DBA Data[Home] [Help]

APPS.ENI_PROD_VALUESET dependencies on FND_FLEX_VAL_API

Line 356: FND_FLEX_VAL_API.CREATE_INDEPENDENT_VSET_VALUE

352:
353: EXIT WHEN new_values_cursor%NOTFOUND;
354:
355: BEGIN
356: FND_FLEX_VAL_API.CREATE_INDEPENDENT_VSET_VALUE
357: (p_flex_value_set_name => l_value_set_name,
358: p_flex_value => l_flex_value,
359: p_description => l_new_description,
360: p_enabled_flag => l_new_enabled_flag,

Line 474: l_new_enabled_flag := fnd_flex_val_api.g_null_varchar2;

470: -- you will need to pass the global constants that they provide
471: -- Hence this if-then clause...
472:
473: IF l_new_enabled_flag IS NULL THEN
474: l_new_enabled_flag := fnd_flex_val_api.g_null_varchar2;
475: END IF;
476:
477: IF l_new_description IS NULL THEN
478: l_new_description := fnd_flex_val_api.g_null_varchar2;

Line 478: l_new_description := fnd_flex_val_api.g_null_varchar2;

474: l_new_enabled_flag := fnd_flex_val_api.g_null_varchar2;
475: END IF;
476:
477: IF l_new_description IS NULL THEN
478: l_new_description := fnd_flex_val_api.g_null_varchar2;
479: END IF;
480:
481: IF l_new_start_date IS NULL THEN
482: l_new_start_date := fnd_flex_val_api.g_null_date;

Line 482: l_new_start_date := fnd_flex_val_api.g_null_date;

478: l_new_description := fnd_flex_val_api.g_null_varchar2;
479: END IF;
480:
481: IF l_new_start_date IS NULL THEN
482: l_new_start_date := fnd_flex_val_api.g_null_date;
483: END IF;
484:
485: IF l_new_end_date IS NULL or l_new_end_date = '' THEN
486: l_new_end_date := fnd_flex_val_api.g_null_date;

Line 486: l_new_end_date := fnd_flex_val_api.g_null_date;

482: l_new_start_date := fnd_flex_val_api.g_null_date;
483: END IF;
484:
485: IF l_new_end_date IS NULL or l_new_end_date = '' THEN
486: l_new_end_date := fnd_flex_val_api.g_null_date;
487: END IF;
488:
489: IF l_new_summary_flag IS NULL THEN
490: l_new_summary_flag := fnd_flex_val_api.g_null_varchar2;

Line 490: l_new_summary_flag := fnd_flex_val_api.g_null_varchar2;

486: l_new_end_date := fnd_flex_val_api.g_null_date;
487: END IF;
488:
489: IF l_new_summary_flag IS NULL THEN
490: l_new_summary_flag := fnd_flex_val_api.g_null_varchar2;
491: END IF;
492:
493:
494: FND_FLEX_VAL_API.UPDATE_INDEPENDENT_VSET_VALUE

Line 494: FND_FLEX_VAL_API.UPDATE_INDEPENDENT_VSET_VALUE

490: l_new_summary_flag := fnd_flex_val_api.g_null_varchar2;
491: END IF;
492:
493:
494: FND_FLEX_VAL_API.UPDATE_INDEPENDENT_VSET_VALUE
495: (p_flex_value_set_name => l_value_set_name,
496: p_flex_value => l_flex_value,
497: p_description => l_new_description,
498: p_enabled_flag => l_new_enabled_flag,

Line 541: FND_FLEX_VAL_API.UPDATE_INDEPENDENT_VSET_VALUE

537:
538: If l_summary_flag = 'N' OR l_enabled_flag = 'N' then
539:
540: begin
541: FND_FLEX_VAL_API.UPDATE_INDEPENDENT_VSET_VALUE
542: (p_flex_value_set_name => l_value_set_name,
543: p_flex_value => l_top_node,
544: p_summary_flag => 'Y',
545: p_enabled_flag => 'Y',

Line 565: FND_FLEX_VAL_API.CREATE_VALUE_HIERARCHY(

561:
562: -- Inserting new nodes under the top node specified in the UI
563: FOR i in c_hierarchy_top_node(l_top_node) loop
564: BEGIN
565: FND_FLEX_VAL_API.CREATE_VALUE_HIERARCHY(
566: p_flex_value_set_name => l_value_set_name,
567: p_parent_flex_value => i.PARENT_CODE,
568: p_range_attribute => i.RANGE_ATTRIBUTE,
569: p_child_flex_value_low => i.CHILD_CODE,

Line 599: FND_FLEX_VAL_API.CREATE_VALUE_HIERARCHY(

595: l_count := 0;
596:
597: FOR i IN hierarchy LOOP
598: BEGIN
599: FND_FLEX_VAL_API.CREATE_VALUE_HIERARCHY(
600: p_flex_value_set_name => l_value_set_name,
601: p_parent_flex_value => i.PARENT_CODE,
602: p_range_attribute => i.RANGE_ATTRIBUTE,
603: p_child_flex_value_low => i.CHILD_CODE,

Line 696: FND_FLEX_VAL_API.SUBMIT_VSET_HIERARCHY_COMPILER

692:
693: -- Catch the exception if the compiler fails to compile
694: BEGIN
695:
696: FND_FLEX_VAL_API.SUBMIT_VSET_HIERARCHY_COMPILER
697: (p_flex_value_set_name => l_value_set_name,
698: x_request_id => l_msg);
699:
700: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Submitted request '||l_msg);