DBA Data[Home] [Help]

APPS.FND_FLEX_LOADER_APIS dependencies on FND_FLEX_VALIDATION_TABLES

Line 69: SUBTYPE vst_tbl_type IS fnd_flex_validation_tables%ROWTYPE;

65: SUBTYPE col_type IS fnd_columns%ROWTYPE;
66: SUBTYPE resp_type IS fnd_responsibility%ROWTYPE;
67:
68: SUBTYPE vst_set_type IS fnd_flex_value_sets%ROWTYPE;
69: SUBTYPE vst_tbl_type IS fnd_flex_validation_tables%ROWTYPE;
70: SUBTYPE vst_evt_type IS fnd_flex_validation_events%ROWTYPE;
71: SUBTYPE vst_scr_type IS fnd_flex_value_rules%ROWTYPE;
72: SUBTYPE vst_scr_tl_type IS fnd_flex_value_rules_tl%ROWTYPE;
73: SUBTYPE vst_scl_type IS fnd_flex_value_rule_lines%ROWTYPE;

Line 1304: FROM fnd_flex_validation_tables

1300: BEGIN
1301: l_func_name := g_api_name || 'get_vst_tbl(F)';
1302: SELECT *
1303: INTO x_vst_tbl
1304: FROM fnd_flex_validation_tables
1305: WHERE flex_value_set_id = p_vst_set.flex_value_set_id;
1306: RETURN TRUE;
1307: EXCEPTION
1308: WHEN no_data_found THEN

Line 4380: UPDATE fnd_flex_validation_tables SET

4376:
4377: IF (g_debug_on) THEN
4378: debug(l_func_name, 'Updating VSET_TABLE.(no-TL)');
4379: END IF;
4380: UPDATE fnd_flex_validation_tables SET
4381: last_updated_by = l_file_who.last_updated_by,
4382: last_update_date = l_file_who.last_update_date,
4383: last_update_login = l_file_who.last_update_login,
4384: table_application_id = l_table_app.application_id,

Line 4410: INSERT INTO fnd_flex_validation_tables

4406: IF (SQL%notfound) THEN
4407: IF (g_debug_on) THEN
4408: debug(l_func_name, 'Inserting VSET_TABLE.(no-TL)');
4409: END IF;
4410: INSERT INTO fnd_flex_validation_tables
4411: (
4412: flex_value_set_id,
4413:
4414: created_by,