DBA Data[Home] [Help]

APPS.PV_CONTEXT_VALUES dependencies on JTF_VARCHAR2_TABLE_4000

Line 3141: l_output_tbl JTF_VARCHAR2_TABLE_4000;

3137: IS
3138: TYPE t_ref_cursor IS REF CURSOR;
3139: c_perf_attributes t_ref_cursor;
3140:
3141: l_output_tbl JTF_VARCHAR2_TABLE_4000;
3142: l_tmp_tbl JTF_VARCHAR2_TABLE_4000;
3143: l_user_id NUMBER := FND_GLOBAL.USER_ID();
3144: l_output VARCHAR2(2000);
3145: l_attr_text VARCHAR2(2000);

Line 3142: l_tmp_tbl JTF_VARCHAR2_TABLE_4000;

3138: TYPE t_ref_cursor IS REF CURSOR;
3139: c_perf_attributes t_ref_cursor;
3140:
3141: l_output_tbl JTF_VARCHAR2_TABLE_4000;
3142: l_tmp_tbl JTF_VARCHAR2_TABLE_4000;
3143: l_user_id NUMBER := FND_GLOBAL.USER_ID();
3144: l_output VARCHAR2(2000);
3145: l_attr_text VARCHAR2(2000);
3146: l_attr_value NUMBER;

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

3165: -- PLSQL table.
3166: -- ---------------------------------------------------------------------
3167: SELECT CAST(MULTISET(
3168: SELECT DISTINCT column_value
3169: FROM TABLE (CAST(l_output_tbl AS JTF_VARCHAR2_TABLE_4000)))
3170: AS JTF_VARCHAR2_TABLE_4000)
3171: INTO l_tmp_tbl
3172: FROM dual;
3173:

Line 3170: AS JTF_VARCHAR2_TABLE_4000)

3166: -- ---------------------------------------------------------------------
3167: SELECT CAST(MULTISET(
3168: SELECT DISTINCT column_value
3169: FROM TABLE (CAST(l_output_tbl AS JTF_VARCHAR2_TABLE_4000)))
3170: AS JTF_VARCHAR2_TABLE_4000)
3171: INTO l_tmp_tbl
3172: FROM dual;
3173:
3174: l_output_tbl := l_tmp_tbl;