DBA Data[Home] [Help]

APPS.AMS_MANUAL_LIST_GEN dependencies on JTF_VARCHAR2_TABLE_100

Line 41: l_field_col_tbl JTF_VARCHAR2_TABLE_100;

37: x_final_string OUT NOCOPY varchar2
38: ) is
39: -- child_type IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
40: l_data_source_types varchar2(2000);
41: l_field_col_tbl JTF_VARCHAR2_TABLE_100;
42: l_source_col_tbl JTF_VARCHAR2_TABLE_100;
43: l_view_tbl JTF_VARCHAR2_TABLE_100;
44: cursor c_master_source_type is
45: select source_object_name , source_object_name || '.' || source_object_pk_field

Line 42: l_source_col_tbl JTF_VARCHAR2_TABLE_100;

38: ) is
39: -- child_type IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
40: l_data_source_types varchar2(2000);
41: l_field_col_tbl JTF_VARCHAR2_TABLE_100;
42: l_source_col_tbl JTF_VARCHAR2_TABLE_100;
43: l_view_tbl JTF_VARCHAR2_TABLE_100;
44: cursor c_master_source_type is
45: select source_object_name , source_object_name || '.' || source_object_pk_field
46: from ams_list_src_types

Line 43: l_view_tbl JTF_VARCHAR2_TABLE_100;

39: -- child_type IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
40: l_data_source_types varchar2(2000);
41: l_field_col_tbl JTF_VARCHAR2_TABLE_100;
42: l_source_col_tbl JTF_VARCHAR2_TABLE_100;
43: l_view_tbl JTF_VARCHAR2_TABLE_100;
44: cursor c_master_source_type is
45: select source_object_name , source_object_name || '.' || source_object_pk_field
46: from ams_list_src_types
47: where source_type_code = p_master_type;