DBA Data[Home] [Help]

APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_FLEX_VALIDATION_TABLES

Line 321: FROM fnd_flex_validation_tables

317: BEGIN
318: SELECT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */
319: id_column_name
320: INTO l_vc2
321: FROM fnd_flex_validation_tables
322: WHERE flex_value_set_id = p_vset_rec.flex_value_set_id;
323: EXCEPTION
324: WHEN OTHERS THEN
325: x_error := set_error(l_func_name,

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

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

Line 1064: FROM fnd_flex_validation_tables

1060: BEGIN
1061: SELECT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */
1062: additional_where_clause
1063: INTO l_long
1064: FROM fnd_flex_validation_tables
1065: WHERE flex_value_set_id = l_old_vset_rec.flex_value_set_id;
1066: EXCEPTION
1067: WHEN OTHERS THEN
1068: report_error(l_func_name,

Line 1069: 'SELECT FROM fnd_flex_validation_tables failed.',

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

Line 1075: INSERT INTO fnd_flex_validation_tables

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

Line 1133: FROM fnd_flex_validation_tables

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

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

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

Line 1146: 'INSERT INTO fnd_flex_validation_tables failed.',

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