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.4 2011/11/08 19:05:50 hgeorgi 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.4 2011/11/08 19:05:50 hgeorgi 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.4 2011/11/08 19:05:50 hgeorgi 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 969: fnd_flex_value_hierarchies

965: BEGIN
966: l_row_count := 1;
967: WHILE (l_row_count > 0) LOOP
968: UPDATE /* $Header: AFFFCHYB.pls 120.4 2011/11/08 19:05:50 hgeorgi ship $ */
969: fnd_flex_value_hierarchies
970: SET flex_value_set_id = g_vset.flex_value_set_id
971: WHERE flex_value_set_id = g_vset.flex_value_set_id*(-1) and
972: rownum < 1000;
973: l_row_count := SQL%rowcount;

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

975: END LOOP;
976: EXCEPTION
977: WHEN OTHERS THEN
978: raise_exception_error(error_update_hierarchies,
979: 'Unable to update data in FND_FLEX_VALUE_HIERARCHIES table.');
980: END update_value_hierarchies;
981:
982: PROCEDURE update_value_hierarchies_all
983: --

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

998: END LOOP;
999: EXCEPTION
1000: WHEN OTHERS THEN
1001: raise_exception_error(error_update_hierarchies,
1002: 'Unable to update data in FND_FLEX_VALUE_HIERARCHIES table.');
1003: END update_value_hierarchies_all;
1004:
1005:
1006:

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

1023: END LOOP;
1024: EXCEPTION
1025: WHEN OTHERS THEN
1026: raise_exception_error(error_update_hierarchies,
1027: 'Unable to update data in FND_FLEX_VALUE_HIERARCHIES table.');
1028: END update_sec_rule_allowed_vals;
1029:
1030:
1031: PROCEDURE compile_sec_rule_allowed_vals