DBA Data[Home] [Help]

APPS.RRS_ATTR_PANE dependencies on FND_FLEX_VALIDATION_TABLES

Line 627: l_app_table_name FND_FLEX_VALIDATION_TABLES.APPLICATION_TABLE_NAME%TYPE;

623: l_x_display_type VARCHAR2(200);
624: l_x_dynamic_url VARCHAR2(1000);
625:
626: /*For Table Value Set query*/
627: l_app_table_name FND_FLEX_VALIDATION_TABLES.APPLICATION_TABLE_NAME%TYPE;
628: l_value_column_name FND_FLEX_VALIDATION_TABLES.VALUE_COLUMN_NAME%TYPE;
629: l_value_column_type FND_FLEX_VALIDATION_TABLES.VALUE_COLUMN_TYPE%TYPE;
630: l_id_column_name FND_FLEX_VALIDATION_TABLES.ID_COLUMN_NAME%TYPE;
631: l_add_where_clause FND_FLEX_VALIDATION_TABLES.ADDITIONAL_WHERE_CLAUSE%TYPE;

Line 628: l_value_column_name FND_FLEX_VALIDATION_TABLES.VALUE_COLUMN_NAME%TYPE;

624: l_x_dynamic_url VARCHAR2(1000);
625:
626: /*For Table Value Set query*/
627: l_app_table_name FND_FLEX_VALIDATION_TABLES.APPLICATION_TABLE_NAME%TYPE;
628: l_value_column_name FND_FLEX_VALIDATION_TABLES.VALUE_COLUMN_NAME%TYPE;
629: l_value_column_type FND_FLEX_VALIDATION_TABLES.VALUE_COLUMN_TYPE%TYPE;
630: l_id_column_name FND_FLEX_VALIDATION_TABLES.ID_COLUMN_NAME%TYPE;
631: l_add_where_clause FND_FLEX_VALIDATION_TABLES.ADDITIONAL_WHERE_CLAUSE%TYPE;
632: l_add_where_clause_holder l_add_where_clause%TYPE;

Line 629: l_value_column_type FND_FLEX_VALIDATION_TABLES.VALUE_COLUMN_TYPE%TYPE;

625:
626: /*For Table Value Set query*/
627: l_app_table_name FND_FLEX_VALIDATION_TABLES.APPLICATION_TABLE_NAME%TYPE;
628: l_value_column_name FND_FLEX_VALIDATION_TABLES.VALUE_COLUMN_NAME%TYPE;
629: l_value_column_type FND_FLEX_VALIDATION_TABLES.VALUE_COLUMN_TYPE%TYPE;
630: l_id_column_name FND_FLEX_VALIDATION_TABLES.ID_COLUMN_NAME%TYPE;
631: l_add_where_clause FND_FLEX_VALIDATION_TABLES.ADDITIONAL_WHERE_CLAUSE%TYPE;
632: l_add_where_clause_holder l_add_where_clause%TYPE;
633:

Line 630: l_id_column_name FND_FLEX_VALIDATION_TABLES.ID_COLUMN_NAME%TYPE;

626: /*For Table Value Set query*/
627: l_app_table_name FND_FLEX_VALIDATION_TABLES.APPLICATION_TABLE_NAME%TYPE;
628: l_value_column_name FND_FLEX_VALIDATION_TABLES.VALUE_COLUMN_NAME%TYPE;
629: l_value_column_type FND_FLEX_VALIDATION_TABLES.VALUE_COLUMN_TYPE%TYPE;
630: l_id_column_name FND_FLEX_VALIDATION_TABLES.ID_COLUMN_NAME%TYPE;
631: l_add_where_clause FND_FLEX_VALIDATION_TABLES.ADDITIONAL_WHERE_CLAUSE%TYPE;
632: l_add_where_clause_holder l_add_where_clause%TYPE;
633:
634: l_date_format_mask VARCHAR2(100);

Line 631: l_add_where_clause FND_FLEX_VALIDATION_TABLES.ADDITIONAL_WHERE_CLAUSE%TYPE;

627: l_app_table_name FND_FLEX_VALIDATION_TABLES.APPLICATION_TABLE_NAME%TYPE;
628: l_value_column_name FND_FLEX_VALIDATION_TABLES.VALUE_COLUMN_NAME%TYPE;
629: l_value_column_type FND_FLEX_VALIDATION_TABLES.VALUE_COLUMN_TYPE%TYPE;
630: l_id_column_name FND_FLEX_VALIDATION_TABLES.ID_COLUMN_NAME%TYPE;
631: l_add_where_clause FND_FLEX_VALIDATION_TABLES.ADDITIONAL_WHERE_CLAUSE%TYPE;
632: l_add_where_clause_holder l_add_where_clause%TYPE;
633:
634: l_date_format_mask VARCHAR2(100);
635:

Line 908: FROM FND_FLEX_VALIDATION_TABLES

904: SELECT APPLICATION_TABLE_NAME, VALUE_COLUMN_NAME,
905: VALUE_COLUMN_TYPE, ID_COLUMN_NAME, ADDITIONAL_WHERE_CLAUSE
906: INTO l_app_table_name, l_value_column_name,
907: l_value_column_type, l_id_column_name, l_add_where_clause
908: FROM FND_FLEX_VALIDATION_TABLES
909: WHERE FLEX_VALUE_SET_ID = l_attr_info.value_set_id;
910:
911: IF l_add_where_clause IS NOT NULL THEN
912: -- use l_add_where_clause_holder as an index ruler for the l_add_where_clause