DBA Data[Home] [Help]

APPS.AMS_ACT_LIST_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 3317: l_field_col_tbl JTF_VARCHAR2_TABLE_100;

3313: x_final_string OUT NOCOPY varchar2
3314: ) is
3315: -- child_type IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
3316: l_data_source_types varchar2(2000);
3317: l_field_col_tbl JTF_VARCHAR2_TABLE_100;
3318: l_source_col_tbl JTF_VARCHAR2_TABLE_100;
3319: l_view_tbl JTF_VARCHAR2_TABLE_100;
3320: cursor c_master_source_type is
3321: select source_object_name , source_object_name || '.' || source_object_pk_field

Line 3318: l_source_col_tbl JTF_VARCHAR2_TABLE_100;

3314: ) is
3315: -- child_type IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
3316: l_data_source_types varchar2(2000);
3317: l_field_col_tbl JTF_VARCHAR2_TABLE_100;
3318: l_source_col_tbl JTF_VARCHAR2_TABLE_100;
3319: l_view_tbl JTF_VARCHAR2_TABLE_100;
3320: cursor c_master_source_type is
3321: select source_object_name , source_object_name || '.' || source_object_pk_field
3322: from ams_list_src_types

Line 3319: l_view_tbl JTF_VARCHAR2_TABLE_100;

3315: -- child_type IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
3316: l_data_source_types varchar2(2000);
3317: l_field_col_tbl JTF_VARCHAR2_TABLE_100;
3318: l_source_col_tbl JTF_VARCHAR2_TABLE_100;
3319: l_view_tbl JTF_VARCHAR2_TABLE_100;
3320: cursor c_master_source_type is
3321: select source_object_name , source_object_name || '.' || source_object_pk_field
3322: from ams_list_src_types
3323: where source_type_code = p_master_type;