DBA Data[Home] [Help]

APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_FLEX_VALIDATION_TABLES

Line 323: FROM fnd_flex_validation_tables

319: BEGIN
320: SELECT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */
321: id_column_name
322: INTO l_vc2
323: FROM fnd_flex_validation_tables
324: WHERE flex_value_set_id = p_vset_rec.flex_value_set_id;
325: EXCEPTION
326: WHEN OTHERS THEN
327: x_error := set_error(l_func_name,

Line 1058: -- Clone the row in FND_FLEX_VALIDATION_TABLES table.

1054: debug('New value set validation type : ' || l_new_vset_rec.validation_type);
1055:
1056: IF (l_new_vset_rec.validation_type = 'F') THEN
1057: --
1058: -- Clone the row in FND_FLEX_VALIDATION_TABLES table.
1059: --
1060: -- Since we have a long column we have to select it first.
1061: --
1062: BEGIN

Line 1066: FROM fnd_flex_validation_tables

1062: BEGIN
1063: SELECT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */
1064: additional_where_clause
1065: INTO l_long
1066: FROM fnd_flex_validation_tables
1067: WHERE flex_value_set_id = l_old_vset_rec.flex_value_set_id;
1068: EXCEPTION
1069: WHEN OTHERS THEN
1070: report_error(l_func_name,

Line 1071: 'SELECT FROM fnd_flex_validation_tables failed.',

1067: WHERE flex_value_set_id = l_old_vset_rec.flex_value_set_id;
1068: EXCEPTION
1069: WHEN OTHERS THEN
1070: report_error(l_func_name,
1071: 'SELECT FROM fnd_flex_validation_tables failed.',
1072: Sqlerrm);
1073: l_ret_code := g_ret_critical_error;
1074: GOTO lbl_return;
1075: END;

Line 1077: INSERT INTO fnd_flex_validation_tables

1073: l_ret_code := g_ret_critical_error;
1074: GOTO lbl_return;
1075: END;
1076: BEGIN
1077: INSERT INTO fnd_flex_validation_tables
1078: (flex_value_set_id,
1079: application_table_name,
1080: value_column_name,
1081: value_column_type,

Line 1135: FROM fnd_flex_validation_tables

1131: l_who_rec.last_update_date,
1132: l_who_rec.last_updated_by,
1133: l_who_rec.creation_date,
1134: l_who_rec.created_by
1135: FROM fnd_flex_validation_tables
1136: WHERE flex_value_set_id = l_old_vset_rec.flex_value_set_id;
1137: IF (SQL%rowcount = 1) THEN
1138: debug('FND_FLEX_VALIDATION_TABLES entry is succesfully cloned.');
1139: ELSE

Line 1138: debug('FND_FLEX_VALIDATION_TABLES entry is succesfully cloned.');

1134: l_who_rec.created_by
1135: FROM fnd_flex_validation_tables
1136: WHERE flex_value_set_id = l_old_vset_rec.flex_value_set_id;
1137: IF (SQL%rowcount = 1) THEN
1138: debug('FND_FLEX_VALIDATION_TABLES entry is succesfully cloned.');
1139: ELSE
1140: report_error(l_func_name,
1141: 'SQL%ROWCOUNT : ' || SQL%rowcount,NULL);
1142: l_ret_code := g_ret_critical_error;

Line 1148: 'INSERT INTO fnd_flex_validation_tables failed.',

1144: END IF;
1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: report_error(l_func_name,
1148: 'INSERT INTO fnd_flex_validation_tables failed.',
1149: Sqlerrm);
1150: l_ret_code := g_ret_critical_error;
1151: GOTO lbl_return;
1152: END;