APPS.HR_FLEXFIELD_INFO dependencies on FND_COLUMNS

Line 608: l_application_column_name fnd_columns.column_name%TYPE;

604: select parent_flex_value_set_id
605: from fnd_flex_value_sets
606: where flex_value_set_id = p_value_set_id;
607:
608: l_application_column_name fnd_columns.column_name%TYPE;
609: l_dep_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
610: l_indep_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
611: l_count number := 1;
612:

Line 685: l_dep_parent_column_name fnd_columns.column_name%TYPE;

681: l_from_start NUMBER;
682: l_additional_and_clause VARCHAR2(2000);
683: l_from_where VARCHAR2(2000);
684: l_select_clause VARCHAR2(2000);
685: l_dep_parent_column_name fnd_columns.column_name%TYPE;
686: --
687: begin
688: --
689:

Line 1387: l_column_type fnd_columns.column_type%TYPE;

1383: p_column_value30 IN VARCHAR2 default null) IS
1384: --
1385: -- Declare local variables
1386: --
1387: l_column_type fnd_columns.column_type%TYPE;
1388: l_placeholder_string_length NUMBER := length(g_app_col_placeholder);
1389: l_placeholder NUMBER;
1390: l_end_placeholder NUMBER;
1391: l_replace_string VARCHAR2(2000);

Line 1449: fnd_columns c

1445: BEGIN
1446: select c.column_type into l_column_type
1447: from fnd_application a,
1448: fnd_tables t,
1449: fnd_columns c
1450: where c.column_name = l_application_column_name
1451: and c.table_id = t.table_id
1452: and c.application_id = a.application_id
1453: and t.application_id = a.application_id

Line 1469: ' is not present in FND_COLUMNS. Unknown '||

1465: END IF;
1466:
1467: --
1468: p_sql_text := 'FAILURE: Column '||l_application_column_name||
1469: ' is not present in FND_COLUMNS. Unknown '||
1470: 'column type. Please specify.';
1471:
1472: raise;
1473: END;