APPS.JTF_REGION_PUB dependencies on JTF_REGION_PUB

Line 1: PACKAGE BODY jtf_region_pub AS

1: PACKAGE BODY jtf_region_pub AS
2: /* $Header: jtfregnb.pls 120.3 2005/11/01 21:25:22 psanyal ship $ */
3: JTT_IGNORE_COLUMN_NAME varchar2(23) := 'JTT_IGNORE_COLUMN_NAME_';
4: TYPE region_item is record (
5: attribute_label_long ak_region_items_vl.attribute_label_long%type -- varchar2(50)

Line 71: p_region_items_table jtf_region_pub.ak_region_items_table,

67: p_respid number,
68: p_object_name varchar2,
69: p_region_name varchar2,
70: p_region_description varchar2,
71: p_region_items_table jtf_region_pub.ak_region_items_table,
72: p_ret_region_codes in out nocopy short_varchar2_table,
73: p_ret_resp_ids in out nocopy number_table,
74: p_ret_object_name in out nocopy short_varchar2_table,
75: p_ret_region_name in out nocopy short_varchar2_table,

Line 77: p_ret_region_items_table IN OUT nocopy jtf_region_pub.ak_region_items_table) is

73: p_ret_resp_ids in out nocopy number_table,
74: p_ret_object_name in out nocopy short_varchar2_table,
75: p_ret_region_name in out nocopy short_varchar2_table,
76: p_ret_region_description in out nocopy long_varchar2_table,
77: p_ret_region_items_table IN OUT nocopy jtf_region_pub.ak_region_items_table) is
78: t_row number := 1+p_ret_region_codes.count;
79: t_idx number;
80: begin
81: if p_region_items_table.count = 0 then return; end if;

Line 116: p_ret_region_items_table OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_region_items_table) is

112: p_ret_resp_ids OUT NOCOPY /* file.sql.39 change */ number_table,
113: p_ret_object_name OUT NOCOPY /* file.sql.39 change */ short_varchar2_table,
114: p_ret_region_name OUT NOCOPY /* file.sql.39 change */ short_varchar2_table,
115: p_ret_region_description OUT NOCOPY /* file.sql.39 change */ long_varchar2_table,
116: p_ret_region_items_table OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_region_items_table) is
117: t_region_codes short_varchar2_table;
118: t_respids number_table;
119: t_respids_first number;
120: t_respids_index number;

Line 127: t_region_items_table jtf_region_pub.ak_region_items_table;

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
131:

Line 568: end jtf_region_pub;

564: p_ak_result_table(1) := null;
565: /*dbms_output.put_line('No data found exception');*/
566: END ak_query;
567:
568: end jtf_region_pub;