APPS.AMS_LISTGENERATION_PKG dependencies on JTF_VARCHAR2_TABLE_100

Line 2629: l_field_col_tbl JTF_VARCHAR2_TABLE_100;

2625: x_final_string OUT NOCOPY varchar2
2626: ) is
2627: -- child_type IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
2628: l_data_source_types varchar2(2000);
2629: l_field_col_tbl JTF_VARCHAR2_TABLE_100;
2630: l_source_col_tbl JTF_VARCHAR2_TABLE_100;
2631: l_view_tbl JTF_VARCHAR2_TABLE_100;
2632: l_source_col_dt_tbl JTF_VARCHAR2_TABLE_100;
2633: cursor c_master_source_type is

Line 2630: l_source_col_tbl JTF_VARCHAR2_TABLE_100;

2626: ) is
2627: -- child_type IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
2628: l_data_source_types varchar2(2000);
2629: l_field_col_tbl JTF_VARCHAR2_TABLE_100;
2630: l_source_col_tbl JTF_VARCHAR2_TABLE_100;
2631: l_view_tbl JTF_VARCHAR2_TABLE_100;
2632: l_source_col_dt_tbl JTF_VARCHAR2_TABLE_100;
2633: cursor c_master_source_type is
2634: select source_object_name , source_object_name || '.' || source_object_pk_field , list_source_type_id

Line 2631: l_view_tbl JTF_VARCHAR2_TABLE_100;

2627: -- child_type IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
2628: l_data_source_types varchar2(2000);
2629: l_field_col_tbl JTF_VARCHAR2_TABLE_100;
2630: l_source_col_tbl JTF_VARCHAR2_TABLE_100;
2631: l_view_tbl JTF_VARCHAR2_TABLE_100;
2632: l_source_col_dt_tbl JTF_VARCHAR2_TABLE_100;
2633: cursor c_master_source_type is
2634: select source_object_name , source_object_name || '.' || source_object_pk_field , list_source_type_id
2635: from ams_list_src_types

Line 2632: l_source_col_dt_tbl JTF_VARCHAR2_TABLE_100;

2628: l_data_source_types varchar2(2000);
2629: l_field_col_tbl JTF_VARCHAR2_TABLE_100;
2630: l_source_col_tbl JTF_VARCHAR2_TABLE_100;
2631: l_view_tbl JTF_VARCHAR2_TABLE_100;
2632: l_source_col_dt_tbl JTF_VARCHAR2_TABLE_100;
2633: cursor c_master_source_type is
2634: select source_object_name , source_object_name || '.' || source_object_pk_field , list_source_type_id
2635: from ams_list_src_types
2636: where source_type_code = p_master_type;

Line 12387: l_field_col_tbl JTF_VARCHAR2_TABLE_100;

12383: x_final_string OUT NOCOPY varchar2
12384: ) is
12385: -- child_type IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
12386: l_data_source_types varchar2(2000);
12387: l_field_col_tbl JTF_VARCHAR2_TABLE_100;
12388: l_source_col_tbl JTF_VARCHAR2_TABLE_100;
12389: l_view_tbl JTF_VARCHAR2_TABLE_100;
12390: l_source_col_dt_tbl JTF_VARCHAR2_TABLE_100;
12391: cursor c_master_source_type is

Line 12388: l_source_col_tbl JTF_VARCHAR2_TABLE_100;

12384: ) is
12385: -- child_type IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
12386: l_data_source_types varchar2(2000);
12387: l_field_col_tbl JTF_VARCHAR2_TABLE_100;
12388: l_source_col_tbl JTF_VARCHAR2_TABLE_100;
12389: l_view_tbl JTF_VARCHAR2_TABLE_100;
12390: l_source_col_dt_tbl JTF_VARCHAR2_TABLE_100;
12391: cursor c_master_source_type is
12392: select source_object_name , source_object_name || '.' || source_object_pk_field

Line 12389: l_view_tbl JTF_VARCHAR2_TABLE_100;

12385: -- child_type IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
12386: l_data_source_types varchar2(2000);
12387: l_field_col_tbl JTF_VARCHAR2_TABLE_100;
12388: l_source_col_tbl JTF_VARCHAR2_TABLE_100;
12389: l_view_tbl JTF_VARCHAR2_TABLE_100;
12390: l_source_col_dt_tbl JTF_VARCHAR2_TABLE_100;
12391: cursor c_master_source_type is
12392: select source_object_name , source_object_name || '.' || source_object_pk_field
12393: from ams_list_src_types

Line 12390: l_source_col_dt_tbl JTF_VARCHAR2_TABLE_100;

12386: l_data_source_types varchar2(2000);
12387: l_field_col_tbl JTF_VARCHAR2_TABLE_100;
12388: l_source_col_tbl JTF_VARCHAR2_TABLE_100;
12389: l_view_tbl JTF_VARCHAR2_TABLE_100;
12390: l_source_col_dt_tbl JTF_VARCHAR2_TABLE_100;
12391: cursor c_master_source_type is
12392: select source_object_name , source_object_name || '.' || source_object_pk_field
12393: from ams_list_src_types
12394: where source_type_code = p_master_type;