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_RUL_PVT dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 12: --TYPE varchar_tbl_type1 is table of fnd_descr_flex_col_usage_vl.descriptive_flex_context_code%type index by binary_integer;

8: --TYPE num_tbl_type is table of number index by binary_integer;
9: --TYPE varchar_tbl_type is table of varchar2(30) index by binary_integer;
10:
11: /* added by marat -- begin */
12: --TYPE varchar_tbl_type1 is table of fnd_descr_flex_col_usage_vl.descriptive_flex_context_code%type index by binary_integer;
13: --TYPE varchar_tbl_type2 is table of fnd_descr_flex_col_usage_vl.end_user_column_name%type index by binary_integer;
14: --TYPE varchar_tbl_type3 is table of fnd_descr_flex_col_usage_vl.required_flag%type index by binary_integer;
15: --TYPE varchar_tbl_type4 is table of fnd_descr_flex_col_usage_vl.application_column_name%type index by binary_integer;
16: --TYPE varchar_tbl_type5 is table of fnd_descr_flex_col_usage_vl.form_left_prompt%type index by binary_integer;

Line 13: --TYPE varchar_tbl_type2 is table of fnd_descr_flex_col_usage_vl.end_user_column_name%type index by binary_integer;

9: --TYPE varchar_tbl_type is table of varchar2(30) index by binary_integer;
10:
11: /* added by marat -- begin */
12: --TYPE varchar_tbl_type1 is table of fnd_descr_flex_col_usage_vl.descriptive_flex_context_code%type index by binary_integer;
13: --TYPE varchar_tbl_type2 is table of fnd_descr_flex_col_usage_vl.end_user_column_name%type index by binary_integer;
14: --TYPE varchar_tbl_type3 is table of fnd_descr_flex_col_usage_vl.required_flag%type index by binary_integer;
15: --TYPE varchar_tbl_type4 is table of fnd_descr_flex_col_usage_vl.application_column_name%type index by binary_integer;
16: --TYPE varchar_tbl_type5 is table of fnd_descr_flex_col_usage_vl.form_left_prompt%type index by binary_integer;
17: /* added by marat -- end */

Line 14: --TYPE varchar_tbl_type3 is table of fnd_descr_flex_col_usage_vl.required_flag%type index by binary_integer;

10:
11: /* added by marat -- begin */
12: --TYPE varchar_tbl_type1 is table of fnd_descr_flex_col_usage_vl.descriptive_flex_context_code%type index by binary_integer;
13: --TYPE varchar_tbl_type2 is table of fnd_descr_flex_col_usage_vl.end_user_column_name%type index by binary_integer;
14: --TYPE varchar_tbl_type3 is table of fnd_descr_flex_col_usage_vl.required_flag%type index by binary_integer;
15: --TYPE varchar_tbl_type4 is table of fnd_descr_flex_col_usage_vl.application_column_name%type index by binary_integer;
16: --TYPE varchar_tbl_type5 is table of fnd_descr_flex_col_usage_vl.form_left_prompt%type index by binary_integer;
17: /* added by marat -- end */
18:

Line 15: --TYPE varchar_tbl_type4 is table of fnd_descr_flex_col_usage_vl.application_column_name%type index by binary_integer;

11: /* added by marat -- begin */
12: --TYPE varchar_tbl_type1 is table of fnd_descr_flex_col_usage_vl.descriptive_flex_context_code%type index by binary_integer;
13: --TYPE varchar_tbl_type2 is table of fnd_descr_flex_col_usage_vl.end_user_column_name%type index by binary_integer;
14: --TYPE varchar_tbl_type3 is table of fnd_descr_flex_col_usage_vl.required_flag%type index by binary_integer;
15: --TYPE varchar_tbl_type4 is table of fnd_descr_flex_col_usage_vl.application_column_name%type index by binary_integer;
16: --TYPE varchar_tbl_type5 is table of fnd_descr_flex_col_usage_vl.form_left_prompt%type index by binary_integer;
17: /* added by marat -- end */
18:
19: /* modified by marat -- begin */

Line 16: --TYPE varchar_tbl_type5 is table of fnd_descr_flex_col_usage_vl.form_left_prompt%type index by binary_integer;

12: --TYPE varchar_tbl_type1 is table of fnd_descr_flex_col_usage_vl.descriptive_flex_context_code%type index by binary_integer;
13: --TYPE varchar_tbl_type2 is table of fnd_descr_flex_col_usage_vl.end_user_column_name%type index by binary_integer;
14: --TYPE varchar_tbl_type3 is table of fnd_descr_flex_col_usage_vl.required_flag%type index by binary_integer;
15: --TYPE varchar_tbl_type4 is table of fnd_descr_flex_col_usage_vl.application_column_name%type index by binary_integer;
16: --TYPE varchar_tbl_type5 is table of fnd_descr_flex_col_usage_vl.form_left_prompt%type index by binary_integer;
17: /* added by marat -- end */
18:
19: /* modified by marat -- begin */
20: --g_ddf_context_code_tbl varchar_tbl_type1; -- holds descriptive_flex_context_code

Line 795: l_end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE;

791: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
792: TYPE l_info_type IS REF CURSOR;
793: l_info_csr l_info_type;
794: sql_stmt VARCHAR2(4000);
795: l_end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE;
796: l_rule_information OKC_RULES_V.RULE_INFORMATION1%TYPE;
797: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;
798: l_required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE;
799: l_row_notfound Boolean;

Line 797: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;

793: l_info_csr l_info_type;
794: sql_stmt VARCHAR2(4000);
795: l_end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE;
796: l_rule_information OKC_RULES_V.RULE_INFORMATION1%TYPE;
797: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;
798: l_required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE;
799: l_row_notfound Boolean;
800:
801: CURSOR l_fvs_csr IS

Line 798: l_required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE;

794: sql_stmt VARCHAR2(4000);
795: l_end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE;
796: l_rule_information OKC_RULES_V.RULE_INFORMATION1%TYPE;
797: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;
798: l_required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE;
799: l_row_notfound Boolean;
800:
801: CURSOR l_fvs_csr IS
802: SELECT VALIDATION_TYPE, FORMAT_TYPE, MAXIMUM_SIZE,

Line 1269: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;

1265: l_object_id2 OKC_RULES_V.OBJECT1_ID2%TYPE;
1266: jtot_object_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
1267: l_from_table JTF_OBJECTS_VL.FROM_TABLE%TYPE;
1268: l_where_clause varchar2(4000);
1269: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;
1270: TYPE l_info_type IS REF CURSOR;
1271: l_info_csr l_info_type;
1272:
1273: CURSOR l_jtot_csr IS

Line 1615: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;

1611: l_object_id2 OKC_RULES_V.OBJECT1_ID2%TYPE;
1612: l_jtot_object_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
1613: l_from_table JTF_OBJECTS_VL.FROM_TABLE%TYPE;
1614: l_where_clause varchar2(4000);
1615: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;
1616: CURSOR l_jtot_csr IS
1617: SELECT decode(where_clause,'','','and '||where_clause) where_clause,
1618: from_table
1619: FROM JTF_OBJECTS_B jtot

Line 1708: l_end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE;

1704: --
1705: TYPE l_info_type IS REF CURSOR;
1706: l_info_csr l_info_type;
1707: sql_stmt VARCHAR2(4000);
1708: l_end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE;
1709: l_rule_information OKC_RULES_V.RULE_INFORMATION1%TYPE;
1710: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;
1711: l_required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE;
1712:

Line 1710: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;

1706: l_info_csr l_info_type;
1707: sql_stmt VARCHAR2(4000);
1708: l_end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE;
1709: l_rule_information OKC_RULES_V.RULE_INFORMATION1%TYPE;
1710: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;
1711: l_required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE;
1712:
1713: CURSOR l_fvs_csr IS
1714: SELECT VALIDATION_TYPE, FORMAT_TYPE, MAXIMUM_SIZE,

Line 1711: l_required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE;

1707: sql_stmt VARCHAR2(4000);
1708: l_end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE;
1709: l_rule_information OKC_RULES_V.RULE_INFORMATION1%TYPE;
1710: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;
1711: l_required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE;
1712:
1713: CURSOR l_fvs_csr IS
1714: SELECT VALIDATION_TYPE, FORMAT_TYPE, MAXIMUM_SIZE,
1715: UPPERCASE_ONLY_FLAG, NUMERIC_MODE_ENABLED_FLAG,

Line 6494: FROM fnd_descr_flex_col_usage_vl dfcu

6490: required_flag,
6491: application_column_name,
6492: SUBSTR(application_column_name,17,2) seq_no,
6493: form_left_prompt
6494: FROM fnd_descr_flex_col_usage_vl dfcu
6495: -- WHERE dfcu.descriptive_flexfield_name = l_desc_ff_name -- /striping/
6496: WHERE dfcu.descriptive_flexfield_name = p_dff_name
6497: AND application_column_name like l_app_col_name
6498: -- AND dfcu.application_id =510 -- /striping/

Line 6575: FROM fnd_descr_flex_col_usage_vl dfcu

6571: descriptive_flex_context_code ,
6572: 'x',
6573: SUBSTR(application_column_name,12,1) seq_no ,
6574: form_left_prompt
6575: FROM fnd_descr_flex_col_usage_vl dfcu
6576: -- WHERE dfcu.descriptive_flexfield_name = l_desc_ff_name -- /striping/
6577: WHERE dfcu.descriptive_flexfield_name = p_dff_name
6578: AND application_column_name like l_app_col_name
6579: -- AND dfcu.application_id =510 -- /striping/