APPS.IBE_TPLCATEGORY_GRP_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy ibe_tplcategory_grp.category_id_tbl_type, a0 JTF_NUMBER_TABLE) as

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy ibe_tplcategory_grp.category_id_tbl_type, a0 JTF_NUMBER_TABLE) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is not null and a0.count > 0 then
26: if a0.count > 0 then

Line 40: procedure rosetta_table_copy_out_p2(t ibe_tplcategory_grp.category_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

36: end loop;
37: end if;
38: end if;
39: end rosetta_table_copy_in_p2;
40: procedure rosetta_table_copy_out_p2(t ibe_tplcategory_grp.category_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_NUMBER_TABLE();

Line 44: a0 := JTF_NUMBER_TABLE();

40: procedure rosetta_table_copy_out_p2(t ibe_tplcategory_grp.category_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_NUMBER_TABLE();
45: else
46: a0 := JTF_NUMBER_TABLE();
47: if t.count > 0 then
48: a0.extend(t.count);

Line 46: a0 := JTF_NUMBER_TABLE();

42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_NUMBER_TABLE();
45: else
46: a0 := JTF_NUMBER_TABLE();
47: if t.count > 0 then
48: a0.extend(t.count);
49: ddindx := t.first;
50: indx := 1;

Line 63: procedure rosetta_table_copy_in_p3(t out nocopy ibe_tplcategory_grp.template_id_tbl_type, a0 JTF_NUMBER_TABLE) as

59: end if;
60: end if;
61: end rosetta_table_copy_out_p2;
62:
63: procedure rosetta_table_copy_in_p3(t out nocopy ibe_tplcategory_grp.template_id_tbl_type, a0 JTF_NUMBER_TABLE) as
64: ddindx binary_integer; indx binary_integer;
65: begin
66: if a0 is not null and a0.count > 0 then
67: if a0.count > 0 then

Line 81: procedure rosetta_table_copy_out_p3(t ibe_tplcategory_grp.template_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

77: end loop;
78: end if;
79: end if;
80: end rosetta_table_copy_in_p3;
81: procedure rosetta_table_copy_out_p3(t ibe_tplcategory_grp.template_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();

Line 85: a0 := JTF_NUMBER_TABLE();

81: procedure rosetta_table_copy_out_p3(t ibe_tplcategory_grp.template_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();
86: else
87: a0 := JTF_NUMBER_TABLE();
88: if t.count > 0 then
89: a0.extend(t.count);

Line 87: a0 := JTF_NUMBER_TABLE();

83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();
86: else
87: a0 := JTF_NUMBER_TABLE();
88: if t.count > 0 then
89: a0.extend(t.count);
90: ddindx := t.first;
91: indx := 1;

Line 104: procedure rosetta_table_copy_in_p4(t out nocopy ibe_tplcategory_grp.tpl_ctg_id_tbl_type, a0 JTF_NUMBER_TABLE) as

100: end if;
101: end if;
102: end rosetta_table_copy_out_p3;
103:
104: procedure rosetta_table_copy_in_p4(t out nocopy ibe_tplcategory_grp.tpl_ctg_id_tbl_type, a0 JTF_NUMBER_TABLE) as
105: ddindx binary_integer; indx binary_integer;
106: begin
107: if a0 is not null and a0.count > 0 then
108: if a0.count > 0 then

Line 122: procedure rosetta_table_copy_out_p4(t ibe_tplcategory_grp.tpl_ctg_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

118: end loop;
119: end if;
120: end if;
121: end rosetta_table_copy_in_p4;
122: procedure rosetta_table_copy_out_p4(t ibe_tplcategory_grp.tpl_ctg_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
123: ddindx binary_integer; indx binary_integer;
124: begin
125: if t is null or t.count = 0 then
126: a0 := JTF_NUMBER_TABLE();

Line 126: a0 := JTF_NUMBER_TABLE();

122: procedure rosetta_table_copy_out_p4(t ibe_tplcategory_grp.tpl_ctg_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
123: ddindx binary_integer; indx binary_integer;
124: begin
125: if t is null or t.count = 0 then
126: a0 := JTF_NUMBER_TABLE();
127: else
128: a0 := JTF_NUMBER_TABLE();
129: if t.count > 0 then
130: a0.extend(t.count);

Line 128: a0 := JTF_NUMBER_TABLE();

124: begin
125: if t is null or t.count = 0 then
126: a0 := JTF_NUMBER_TABLE();
127: else
128: a0 := JTF_NUMBER_TABLE();
129: if t.count > 0 then
130: a0.extend(t.count);
131: ddindx := t.first;
132: indx := 1;

Line 152: , p_category_id_tbl JTF_NUMBER_TABLE

148: , x_return_status out nocopy VARCHAR2
149: , x_msg_count out nocopy NUMBER
150: , x_msg_data out nocopy VARCHAR2
151: , p_template_id NUMBER
152: , p_category_id_tbl JTF_NUMBER_TABLE
153: )
154:
155: as
156: ddp_category_id_tbl ibe_tplcategory_grp.category_id_tbl_type;

Line 196: , p_tpl_ctg_id_tbl JTF_NUMBER_TABLE

192: , p_commit VARCHAR2
193: , x_return_status out nocopy VARCHAR2
194: , x_msg_count out nocopy NUMBER
195: , x_msg_data out nocopy VARCHAR2
196: , p_tpl_ctg_id_tbl JTF_NUMBER_TABLE
197: )
198:
199: as
200: ddp_tpl_ctg_id_tbl ibe_tplcategory_grp.tpl_ctg_id_tbl_type;

Line 238: , p_template_id_tbl JTF_NUMBER_TABLE

234: , x_return_status out nocopy VARCHAR2
235: , x_msg_count out nocopy NUMBER
236: , x_msg_data out nocopy VARCHAR2
237: , p_category_id NUMBER
238: , p_template_id_tbl JTF_NUMBER_TABLE
239: )
240:
241: as
242: ddp_template_id_tbl ibe_tplcategory_grp.template_id_tbl_type;