APPS.JTF_REGION_PUB dependencies on AK_REGIONS_VL

Line 124: t_object_name ak_regions_vl.object_name%type;

120: t_respids_index number;
121: t_asn fnd_application.application_short_name%type;
122: t_region_code_index number := 1;
123: t_respid_index number := 1;
124: t_object_name ak_regions_vl.object_name%type;
125: t_region_name ak_regions_vl.name%type;
126: t_region_description ak_regions_vl.description%type;
127: t_region_items_table jtf_region_pub.ak_region_items_table;
128: t_missing_or_invalid boolean;

Line 125: t_region_name ak_regions_vl.name%type;

121: t_asn fnd_application.application_short_name%type;
122: t_region_code_index number := 1;
123: t_respid_index number := 1;
124: t_object_name ak_regions_vl.object_name%type;
125: t_region_name ak_regions_vl.name%type;
126: t_region_description ak_regions_vl.description%type;
127: t_region_items_table jtf_region_pub.ak_region_items_table;
128: t_missing_or_invalid boolean;
129: t_prefix varchar2(25);

Line 126: t_region_description ak_regions_vl.description%type;

122: t_region_code_index number := 1;
123: t_respid_index number := 1;
124: t_object_name ak_regions_vl.object_name%type;
125: t_region_name ak_regions_vl.name%type;
126: t_region_description ak_regions_vl.description%type;
127: t_region_items_table jtf_region_pub.ak_region_items_table;
128: t_missing_or_invalid boolean;
129: t_prefix varchar2(25);
130: begin

Line 144: for rc in (select unique region_code from ak_regions_vl

140: if p_get_region_codes.count > 0 then
141: t_region_codes := p_get_region_codes;
142: else
143: t_region_code_index := 1;
144: for rc in (select unique region_code from ak_regions_vl
145: where region_application_id = p_get_application_id) loop
146: t_region_codes(t_region_code_index) := rc.region_code;
147: t_region_code_index := t_region_code_index+1;
148: end loop;

Line 254: temp_database_object_name ak_regions_vl.database_object_name%type;

250: ) IS
251: cnt number := 0;
252: l_region_items_table region_items_table;
253: p_column_name varchar2(30) := null;
254: temp_database_object_name ak_regions_vl.database_object_name%type;
255: t_punt_column_names boolean;
256: t_region_code ak_regions_vl.region_code%type;
257: BEGIN
258: -- decode the p_region_code value. If p_region_code is a string longer than

Line 256: t_region_code ak_regions_vl.region_code%type;

252: l_region_items_table region_items_table;
253: p_column_name varchar2(30) := null;
254: temp_database_object_name ak_regions_vl.database_object_name%type;
255: t_punt_column_names boolean;
256: t_region_code ak_regions_vl.region_code%type;
257: BEGIN
258: -- decode the p_region_code value. If p_region_code is a string longer than
259: -- and beginning with 'JTT_IGNORE_COLUMN_NAME_', then remove the
260: -- 'JTT_IGNORE_COLUMN_NAME_' and assume we should punt on getting the

Line 275: from ak_regions_vl

271:
272: select object_name,name,description,database_object_name
273: into p_object_name, p_region_name,p_region_description,
274: temp_database_object_name
275: from ak_regions_vl
276: where region_code = t_region_code and
277: region_application_id = p_application_id;
278:
279: for c1 in (select attribute_label_long,attribute_label_short,data_type,