APPS.FND_FLEX_HIERARCHY_COMPILER dependencies on FND_FLEX_VALUE_HIERARCHIES

Line 23: -- FND_FLEX_VALUE_HIERARCHIES

19: -- NA US US P
20: -- US CA CA P
21: -- US NY NY P
22: --
23: -- FND_FLEX_VALUE_HIERARCHIES
24: -- ===========================================
25: -- PARENT CHILD_LOW CHILD_HIGH COMMENT
26: -- ------- --------- ---------- ----------
27: -- CA LA LA CA:LA-LA

Line 444: INTO fnd_flex_value_hierarchies

440: p_child_flex_value_high IN VARCHAR2)
441: IS
442: BEGIN
443: INSERT /* $Header: AFFFCHYB.pls 120.2.12010000.1 2008/07/25 14:13:37 appldev ship $ */
444: INTO fnd_flex_value_hierarchies
445: (flex_value_set_id, parent_flex_value,
446: child_flex_value_low, child_flex_value_high,
447: last_update_date, last_updated_by,
448: creation_date, created_by)

Line 565: -- Compiles the flex value hierarchies in FND_FLEX_VALUE_HIERARCHIES table.

561:
562: -- ======================================================================
563: -- PROCEDURE : compile_value_hierarchies
564: -- ======================================================================
565: -- Compiles the flex value hierarchies in FND_FLEX_VALUE_HIERARCHIES table.
566: --
567: PROCEDURE compile_value_hierarchies
568: IS
569: CURSOR main_norm_cur IS

Line 647: FROM fnd_flex_value_hierarchies

643: -- In case of error, delete the inserted rows (kind of rollback).
644: --
645: BEGIN
646: DELETE /* $Header: AFFFCHYB.pls 120.2.12010000.1 2008/07/25 14:13:37 appldev ship $ */
647: FROM fnd_flex_value_hierarchies
648: WHERE flex_value_set_id = g_vset.flex_value_set_id;
649: COMMIT;
650: EXCEPTION
651: WHEN OTHERS THEN

Line 898: FROM fnd_flex_value_hierarchies

894: BEGIN
895: l_row_count := 1;
896: WHILE (l_row_count > 0) LOOP
897: DELETE /* $Header: AFFFCHYB.pls 120.2.12010000.1 2008/07/25 14:13:37 appldev ship $ */
898: FROM fnd_flex_value_hierarchies
899: WHERE flex_value_set_id = g_vset.flex_value_set_id and
900: rownum < 1000;
901: l_row_count := SQL%rowcount;
902: COMMIT;

Line 907: 'Unable to delete data in FND_FLEX_VALUE_HIERARCHIES table.');

903: END LOOP;
904: EXCEPTION
905: WHEN OTHERS THEN
906: raise_exception_error(error_delete_hierarchies,
907: 'Unable to delete data in FND_FLEX_VALUE_HIERARCHIES table.');
908: END delete_value_hierarchies;
909:
910: PROCEDURE delete_value_hierarchies_all
911: --

Line 943: fnd_flex_value_hierarchies

939: BEGIN
940: l_row_count := 1;
941: WHILE (l_row_count > 0) LOOP
942: UPDATE /* $Header: AFFFCHYB.pls 120.2.12010000.1 2008/07/25 14:13:37 appldev ship $ */
943: fnd_flex_value_hierarchies
944: SET flex_value_set_id = g_vset.flex_value_set_id
945: WHERE flex_value_set_id = g_vset.flex_value_set_id*(-1) and
946: rownum < 1000;
947: l_row_count := SQL%rowcount;

Line 953: 'Unable to update data in FND_FLEX_VALUE_HIERARCHIES table.');

949: END LOOP;
950: EXCEPTION
951: WHEN OTHERS THEN
952: raise_exception_error(error_update_hierarchies,
953: 'Unable to update data in FND_FLEX_VALUE_HIERARCHIES table.');
954: END update_value_hierarchies;
955:
956: PROCEDURE update_value_hierarchies_all
957: --

Line 976: 'Unable to update data in FND_FLEX_VALUE_HIERARCHIES table.');

972: END LOOP;
973: EXCEPTION
974: WHEN OTHERS THEN
975: raise_exception_error(error_update_hierarchies,
976: 'Unable to update data in FND_FLEX_VALUE_HIERARCHIES table.');
977: END update_value_hierarchies_all;
978:
979: PROCEDURE request_lock(p_lock_name IN VARCHAR2,
980: x_lock_handle OUT nocopy VARCHAR2)