APPS.FND_FLEX_HIERARCHY_COMPILER dependencies on FND_FLEX_SEC_RULE_ALLOWED_VALS

Line 943: FROM fnd_flex_sec_rule_allowed_vals

939: BEGIN
940: l_row_count := 1;
941: WHILE (l_row_count > 0) LOOP
942: DELETE /* $Header: AFFFCHYB.pls 120.4 2011/11/08 19:05:50 hgeorgi ship $ */
943: FROM fnd_flex_sec_rule_allowed_vals
944: WHERE flex_value_set_id = g_vset.flex_value_set_id and
945: rownum < 1000;
946: l_row_count := SQL%rowcount;
947: COMMIT;

Line 952: 'Unable to delete data in FND_FLEX_SEC_RULE_ALLOWED_VALS table.');

948: END LOOP;
949: EXCEPTION
950: WHEN OTHERS THEN
951: raise_exception_error(error_delete_hierarchies,
952: 'Unable to delete data in FND_FLEX_SEC_RULE_ALLOWED_VALS table.');
953: END delete_sec_rule_allowed_vals;
954:
955:
956:

Line 1017: fnd_flex_sec_rule_allowed_vals

1013: BEGIN
1014: l_row_count := 1;
1015: WHILE (l_row_count > 0) LOOP
1016: UPDATE /* $Header: AFFFCHYB.pls 120.4 2011/11/08 19:05:50 hgeorgi ship $ */
1017: fnd_flex_sec_rule_allowed_vals
1018: SET flex_value_set_id=g_vset.flex_value_set_id
1019: WHERE flex_value_set_id = g_vset.flex_value_set_id*(-1) and
1020: rownum < 1000;
1021: l_row_count := SQL%rowcount;

Line 1046: into fnd_flex_sec_rule_allowed_vals

1042: BEGIN
1043:
1044: IF (g_vset.format_type ='N') THEN -- Number format type
1045: INSERT /* $Header: AFFFCHYB.pls 120.4 2011/11/08 19:05:50 hgeorgi ship $ */
1046: into fnd_flex_sec_rule_allowed_vals
1047: (FLEX_VALUE_SET_ID,
1048: FLEX_VALUE_RULE_ID,
1049: FLEX_VALUE,
1050: LAST_UPDATE_DATE,

Line 1127: into fnd_flex_sec_rule_allowed_vals

1123:
1124: ELSE -- Character format type (DATE TIME are not supported)
1125:
1126: INSERT /* $Header: AFFFCHYB.pls 120.4 2011/11/08 19:05:50 hgeorgi ship $ */
1127: into fnd_flex_sec_rule_allowed_vals
1128: (FLEX_VALUE_SET_ID,
1129: FLEX_VALUE_RULE_ID,
1130: FLEX_VALUE,
1131: LAST_UPDATE_DATE,

Line 1205: 'Unable to insert data in FND_FLEX_SEC_RULE_ALLOWED_VALS table.');

1201: COMMIT;
1202: EXCEPTION
1203: WHEN OTHERS THEN
1204: raise_exception_error(error_update_hierarchies,
1205: 'Unable to insert data in FND_FLEX_SEC_RULE_ALLOWED_VALS table.');
1206: END compile_sec_rule_allowed_vals;
1207:
1208:
1209: