DBA Data[Home] [Help]

APPS.PV_CONTEXT_VALUES dependencies on JTF_VARCHAR2_TABLE_4000

Line 3163: l_output_tbl JTF_VARCHAR2_TABLE_4000;

3159: IS
3160: TYPE t_ref_cursor IS REF CURSOR;
3161: c_perf_attributes t_ref_cursor;
3162:
3163: l_output_tbl JTF_VARCHAR2_TABLE_4000;
3164: l_tmp_tbl JTF_VARCHAR2_TABLE_4000;
3165: l_user_id NUMBER := FND_GLOBAL.USER_ID();
3166: l_output VARCHAR2(2000);
3167: l_attr_text VARCHAR2(2000);

Line 3164: l_tmp_tbl JTF_VARCHAR2_TABLE_4000;

3160: TYPE t_ref_cursor IS REF CURSOR;
3161: c_perf_attributes t_ref_cursor;
3162:
3163: l_output_tbl JTF_VARCHAR2_TABLE_4000;
3164: l_tmp_tbl JTF_VARCHAR2_TABLE_4000;
3165: l_user_id NUMBER := FND_GLOBAL.USER_ID();
3166: l_output VARCHAR2(2000);
3167: l_attr_text VARCHAR2(2000);
3168: l_attr_value NUMBER;

Line 3191: FROM TABLE (CAST(l_output_tbl AS JTF_VARCHAR2_TABLE_4000)))

3187: -- PLSQL table.
3188: -- ---------------------------------------------------------------------
3189: SELECT CAST(MULTISET(
3190: SELECT DISTINCT column_value
3191: FROM TABLE (CAST(l_output_tbl AS JTF_VARCHAR2_TABLE_4000)))
3192: AS JTF_VARCHAR2_TABLE_4000)
3193: INTO l_tmp_tbl
3194: FROM dual;
3195:

Line 3192: AS JTF_VARCHAR2_TABLE_4000)

3188: -- ---------------------------------------------------------------------
3189: SELECT CAST(MULTISET(
3190: SELECT DISTINCT column_value
3191: FROM TABLE (CAST(l_output_tbl AS JTF_VARCHAR2_TABLE_4000)))
3192: AS JTF_VARCHAR2_TABLE_4000)
3193: INTO l_tmp_tbl
3194: FROM dual;
3195:
3196: l_output_tbl := l_tmp_tbl;