APPS.IBE_TPLCATEGORY_GRP_W dependencies on IBE_TPLCATEGORY_GRP

Line 1: package body ibe_tplcategory_grp_w as

1: package body ibe_tplcategory_grp_w as
2: /* $Header: IBEGRTGB.pls 115.1 2002/12/18 07:10:23 schak ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

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 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 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 156: ddp_category_id_tbl ibe_tplcategory_grp.category_id_tbl_type;

152: , p_category_id_tbl JTF_NUMBER_TABLE
153: )
154:
155: as
156: ddp_category_id_tbl ibe_tplcategory_grp.category_id_tbl_type;
157: ddindx binary_integer; indx binary_integer;
158: begin
159:
160: -- copy data to the local IN or IN-OUT args, if any

Line 168: ibe_tplcategory_grp_w.rosetta_table_copy_in_p2(ddp_category_id_tbl, p_category_id_tbl);

164:
165:
166:
167:
168: ibe_tplcategory_grp_w.rosetta_table_copy_in_p2(ddp_category_id_tbl, p_category_id_tbl);
169:
170: -- here's the delegated call to the old PL/SQL routine
171: ibe_tplcategory_grp.add_tpl_ctg(p_api_version,
172: p_init_msg_list,

Line 171: ibe_tplcategory_grp.add_tpl_ctg(p_api_version,

167:
168: ibe_tplcategory_grp_w.rosetta_table_copy_in_p2(ddp_category_id_tbl, p_category_id_tbl);
169:
170: -- here's the delegated call to the old PL/SQL routine
171: ibe_tplcategory_grp.add_tpl_ctg(p_api_version,
172: p_init_msg_list,
173: p_commit,
174: x_return_status,
175: x_msg_count,

Line 200: ddp_tpl_ctg_id_tbl ibe_tplcategory_grp.tpl_ctg_id_tbl_type;

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;
201: ddindx binary_integer; indx binary_integer;
202: begin
203:
204: -- copy data to the local IN or IN-OUT args, if any

Line 211: ibe_tplcategory_grp_w.rosetta_table_copy_in_p4(ddp_tpl_ctg_id_tbl, p_tpl_ctg_id_tbl);

207:
208:
209:
210:
211: ibe_tplcategory_grp_w.rosetta_table_copy_in_p4(ddp_tpl_ctg_id_tbl, p_tpl_ctg_id_tbl);
212:
213: -- here's the delegated call to the old PL/SQL routine
214: ibe_tplcategory_grp.delete_tpl_ctg_relation(p_api_version,
215: p_init_msg_list,

Line 214: ibe_tplcategory_grp.delete_tpl_ctg_relation(p_api_version,

210:
211: ibe_tplcategory_grp_w.rosetta_table_copy_in_p4(ddp_tpl_ctg_id_tbl, p_tpl_ctg_id_tbl);
212:
213: -- here's the delegated call to the old PL/SQL routine
214: ibe_tplcategory_grp.delete_tpl_ctg_relation(p_api_version,
215: p_init_msg_list,
216: p_commit,
217: x_return_status,
218: x_msg_count,

Line 242: ddp_template_id_tbl ibe_tplcategory_grp.template_id_tbl_type;

238: , p_template_id_tbl JTF_NUMBER_TABLE
239: )
240:
241: as
242: ddp_template_id_tbl ibe_tplcategory_grp.template_id_tbl_type;
243: ddindx binary_integer; indx binary_integer;
244: begin
245:
246: -- copy data to the local IN or IN-OUT args, if any

Line 254: ibe_tplcategory_grp_w.rosetta_table_copy_in_p3(ddp_template_id_tbl, p_template_id_tbl);

250:
251:
252:
253:
254: ibe_tplcategory_grp_w.rosetta_table_copy_in_p3(ddp_template_id_tbl, p_template_id_tbl);
255:
256: -- here's the delegated call to the old PL/SQL routine
257: ibe_tplcategory_grp.add_ctg_tpl(p_api_version,
258: p_init_msg_list,

Line 257: ibe_tplcategory_grp.add_ctg_tpl(p_api_version,

253:
254: ibe_tplcategory_grp_w.rosetta_table_copy_in_p3(ddp_template_id_tbl, p_template_id_tbl);
255:
256: -- here's the delegated call to the old PL/SQL routine
257: ibe_tplcategory_grp.add_ctg_tpl(p_api_version,
258: p_init_msg_list,
259: p_commit,
260: x_return_status,
261: x_msg_count,

Line 276: end ibe_tplcategory_grp_w;

272:
273:
274: end;
275:
276: end ibe_tplcategory_grp_w;