APPS.FND_FLEX_HIERARCHY_COMPILER dependencies on FND_FLEX_VALUE_HIER_ALL

Line 38: -- FND_FLEX_VALUE_HIER_ALL

34: -- NA SF SF NA:US-US -> US:CA-CA -> CA:SF-SF
35: -- US LA LA US:CA-CA -> CA:LA-LA
36: -- US SF SF US:CA-CA -> CA:SF-SF
37: --
38: -- FND_FLEX_VALUE_HIER_ALL
39: -- ===========================================
40: -- PARENT CHILD_LOW CHILD_HIGH RANGE LEVEL COMMENT
41: -- ------- --------- ---------- ----- ----- ----------
42: -- CA LA LA C 1 CA:LA-LA

Line 671: INTO fnd_flex_value_hier_all

667: p_hierarchy_level IN NUMBER)
668: IS
669: BEGIN
670: INSERT /* $Header: AFFFCHYB.pls 120.2.12010000.1 2008/07/25 14:13:37 appldev ship $ */
671: INTO fnd_flex_value_hier_all
672: (flex_value_set_id, parent_flex_value, range_attribute,
673: child_flex_value_low, child_flex_value_high, hierarchy_level,
674: last_update_date, last_updated_by,
675: creation_date, created_by)

Line 793: -- Compiles the flex value hierarchies in FND_FLEX_VALUE_HIER_ALL table.

789:
790: -- ======================================================================
791: -- PROCEDURE : compile_value_hierarchies_all
792: -- ======================================================================
793: -- Compiles the flex value hierarchies in FND_FLEX_VALUE_HIER_ALL table.
794: --
795: PROCEDURE compile_value_hierarchies_all
796: IS
797: CURSOR main_norm_cur IS

Line 876: FROM fnd_flex_value_hier_all

872: -- In case of error, delete the inserted rows (kind of rollback).
873: --
874: BEGIN
875: DELETE /* $Header: AFFFCHYB.pls 120.2.12010000.1 2008/07/25 14:13:37 appldev ship $ */
876: FROM fnd_flex_value_hier_all
877: WHERE flex_value_set_id = g_vset.flex_value_set_id;
878: COMMIT;
879: EXCEPTION
880: WHEN OTHERS THEN

Line 920: FROM fnd_flex_value_hier_all

916: BEGIN
917: l_row_count := 1;
918: WHILE (l_row_count > 0) LOOP
919: DELETE /* $Header: AFFFCHYB.pls 120.2.12010000.1 2008/07/25 14:13:37 appldev ship $ */
920: FROM fnd_flex_value_hier_all
921: WHERE flex_value_set_id = g_vset.flex_value_set_id and
922: rownum < 1000;
923: l_row_count := SQL%rowcount;
924: COMMIT;

Line 929: 'Unable to delete data in FND_FLEX_VALUE_HIER_ALL table.');

925: END LOOP;
926: EXCEPTION
927: WHEN OTHERS THEN
928: raise_exception_error(error_delete_hierarchies,
929: 'Unable to delete data in FND_FLEX_VALUE_HIER_ALL table.');
930: END delete_value_hierarchies_all;
931:
932:
933: PROCEDURE update_value_hierarchies

Line 966: fnd_flex_value_hier_all

962: BEGIN
963: l_row_count := 1;
964: WHILE (l_row_count > 0) LOOP
965: UPDATE /* $Header: AFFFCHYB.pls 120.2.12010000.1 2008/07/25 14:13:37 appldev ship $ */
966: fnd_flex_value_hier_all
967: SET flex_value_set_id=g_vset.flex_value_set_id
968: WHERE flex_value_set_id = g_vset.flex_value_set_id*(-1) and
969: rownum < 1000;
970: l_row_count := SQL%rowcount;