APPS.JTF_TPLCATEGORY_GRP_W dependencies on JTF_TPLCATEGORY_GRP

Line 1: package body jtf_tplcategory_grp_w as

1: package body jtf_tplcategory_grp_w as
2: /* $Header: JTFGRTGB.pls 115.6 2004/07/09 18:51:06 applrt 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 jtf_tplcategory_grp.category_id_tbl_type, a0 JTF_NUMBER_TABLE) as

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out jtf_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 jtf_tplcategory_grp.category_id_tbl_type, a0 out 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 jtf_tplcategory_grp.category_id_tbl_type, a0 out 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 jtf_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 jtf_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 jtf_tplcategory_grp.template_id_tbl_type, a0 out 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 jtf_tplcategory_grp.template_id_tbl_type, a0 out 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 jtf_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 jtf_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 jtf_tplcategory_grp.tpl_ctg_id_tbl_type, a0 out 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 jtf_tplcategory_grp.tpl_ctg_id_tbl_type, a0 out 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 155: ddp_category_id_tbl jtf_tplcategory_grp.category_id_tbl_type;

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

Line 167: jtf_tplcategory_grp_w.rosetta_table_copy_in_p2(ddp_category_id_tbl, p_category_id_tbl);

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

Line 170: jtf_tplcategory_grp.add_tpl_ctg(p_api_version,

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

Line 198: ddp_tpl_ctg_id_tbl jtf_tplcategory_grp.tpl_ctg_id_tbl_type;

194: , x_msg_data out VARCHAR2
195: , p_tpl_ctg_id_tbl JTF_NUMBER_TABLE
196: )
197: as
198: ddp_tpl_ctg_id_tbl jtf_tplcategory_grp.tpl_ctg_id_tbl_type;
199: ddindx binary_integer; indx binary_integer;
200: begin
201:
202: -- copy data to the local IN or IN-OUT args, if any

Line 209: jtf_tplcategory_grp_w.rosetta_table_copy_in_p4(ddp_tpl_ctg_id_tbl, p_tpl_ctg_id_tbl);

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

Line 212: jtf_tplcategory_grp.delete_tpl_ctg_relation(p_api_version,

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

Line 239: ddp_template_id_tbl jtf_tplcategory_grp.template_id_tbl_type;

235: , p_category_id NUMBER
236: , p_template_id_tbl JTF_NUMBER_TABLE
237: )
238: as
239: ddp_template_id_tbl jtf_tplcategory_grp.template_id_tbl_type;
240: ddindx binary_integer; indx binary_integer;
241: begin
242:
243: -- copy data to the local IN or IN-OUT args, if any

Line 251: jtf_tplcategory_grp_w.rosetta_table_copy_in_p3(ddp_template_id_tbl, p_template_id_tbl);

247:
248:
249:
250:
251: jtf_tplcategory_grp_w.rosetta_table_copy_in_p3(ddp_template_id_tbl, p_template_id_tbl);
252:
253: -- here's the delegated call to the old PL/SQL routine
254: jtf_tplcategory_grp.add_ctg_tpl(p_api_version,
255: p_init_msg_list,

Line 254: jtf_tplcategory_grp.add_ctg_tpl(p_api_version,

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

Line 273: end jtf_tplcategory_grp_w;

269:
270:
271: end;
272:
273: end jtf_tplcategory_grp_w;