eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_QA_DATA_INTEGRITY dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 615: l_end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE;

611: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
612: TYPE l_info_type IS REF CURSOR;
613: l_info_csr l_info_type;
614: sql_stmt VARCHAR2(2000);
615: l_end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE;
616: l_rule_information OKC_RULES_V.RULE_INFORMATION1%TYPE;
617: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;
618: l_required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE;
619:

Line 617: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;

613: l_info_csr l_info_type;
614: sql_stmt VARCHAR2(2000);
615: l_end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE;
616: l_rule_information OKC_RULES_V.RULE_INFORMATION1%TYPE;
617: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;
618: l_required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE;
619:
620: l_missing_values VARCHAR2(1) := 'N';
621: l_all_must_be_present BOOLEAN := False;

Line 618: l_required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE;

614: sql_stmt VARCHAR2(2000);
615: l_end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE;
616: l_rule_information OKC_RULES_V.RULE_INFORMATION1%TYPE;
617: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;
618: l_required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE;
619:
620: l_missing_values VARCHAR2(1) := 'N';
621: l_all_must_be_present BOOLEAN := False;
622:

Line 729: ' FROM FND_DESCR_FLEX_COL_USAGE_VL dfcu ' ||

725:
726: /*
727: -- SQL statement to retrieve the developer descriptive flex field information
728: sql_stmt := 'SELECT END_USER_COLUMN_NAME, FLEX_VALUE_SET_ID, REQUIRED_FLAG ' ||
729: ' FROM FND_DESCR_FLEX_COL_USAGE_VL dfcu ' ||
730: ' WHERE dfcu.application_id=510 and dfcu.descriptive_flexfield_name = ' ||
731: ''''||G_DESCRIPTIVE_FLEXFIELD_NAME||'''' ||
732: ' AND dfcu.descriptive_flex_context_code = :rule_cat ' ||
733: ' AND dfcu.application_column_name = :attribute' ;