APPS.AMV_MATCH_PVT_W dependencies on AMV_MATCH_PVT

Line 1: package body amv_match_pvt_w as

1: package body amv_match_pvt_w as
2: /* $Header: amvwmatb.pls 120.2 2005/06/30 08:06 appldev 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_p3(t out nocopy amv_match_pvt.terr_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_p3(t out nocopy amv_match_pvt.terr_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_p3(t amv_match_pvt.terr_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_p3;
40: procedure rosetta_table_copy_out_p3(t amv_match_pvt.terr_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_p4(t out nocopy amv_match_pvt.terr_name_tbl_type, a0 JTF_VARCHAR2_TABLE_4000) as

59: end if;
60: end if;
61: end rosetta_table_copy_out_p3;
62:
63: procedure rosetta_table_copy_in_p4(t out nocopy amv_match_pvt.terr_name_tbl_type, a0 JTF_VARCHAR2_TABLE_4000) 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_p4(t amv_match_pvt.terr_name_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000) as

77: end loop;
78: end if;
79: end if;
80: end rosetta_table_copy_in_p4;
81: procedure rosetta_table_copy_out_p4(t amv_match_pvt.terr_name_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000) as
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_VARCHAR2_TABLE_4000();

Line 122: ddp_territory_tbl amv_match_pvt.terr_id_tbl_type;

118: , p_territory_tbl JTF_NUMBER_TABLE
119: )
120:
121: as
122: ddp_territory_tbl amv_match_pvt.terr_id_tbl_type;
123: ddindx binary_integer; indx binary_integer;
124: begin
125:
126: -- copy data to the local IN or IN-OUT args, if any

Line 141: amv_match_pvt_w.rosetta_table_copy_in_p3(ddp_territory_tbl, p_territory_tbl);

137:
138:
139:
140:
141: amv_match_pvt_w.rosetta_table_copy_in_p3(ddp_territory_tbl, p_territory_tbl);
142:
143: -- here's the delegated call to the old PL/SQL routine
144: amv_match_pvt.do_itemchannelmatch(p_api_version,
145: p_init_msg_list,

Line 144: amv_match_pvt.do_itemchannelmatch(p_api_version,

140:
141: amv_match_pvt_w.rosetta_table_copy_in_p3(ddp_territory_tbl, p_territory_tbl);
142:
143: -- here's the delegated call to the old PL/SQL routine
144: amv_match_pvt.do_itemchannelmatch(p_api_version,
145: p_init_msg_list,
146: p_commit,
147: p_validation_level,
148: x_return_status,

Line 190: ddx_terr_id_tbl amv_match_pvt.terr_id_tbl_type;

186: , x_terr_name_tbl out nocopy JTF_VARCHAR2_TABLE_4000
187: )
188:
189: as
190: ddx_terr_id_tbl amv_match_pvt.terr_id_tbl_type;
191: ddx_terr_name_tbl amv_match_pvt.terr_name_tbl_type;
192: ddindx binary_integer; indx binary_integer;
193: begin
194:

Line 191: ddx_terr_name_tbl amv_match_pvt.terr_name_tbl_type;

187: )
188:
189: as
190: ddx_terr_id_tbl amv_match_pvt.terr_id_tbl_type;
191: ddx_terr_name_tbl amv_match_pvt.terr_name_tbl_type;
192: ddindx binary_integer; indx binary_integer;
193: begin
194:
195: -- copy data to the local IN or IN-OUT args, if any

Line 207: amv_match_pvt.get_userterritory(p_api_version,

203:
204:
205:
206: -- here's the delegated call to the old PL/SQL routine
207: amv_match_pvt.get_userterritory(p_api_version,
208: p_init_msg_list,
209: x_return_status,
210: x_msg_count,
211: x_msg_data,

Line 227: amv_match_pvt_w.rosetta_table_copy_out_p3(ddx_terr_id_tbl, x_terr_id_tbl);

223:
224:
225:
226:
227: amv_match_pvt_w.rosetta_table_copy_out_p3(ddx_terr_id_tbl, x_terr_id_tbl);
228:
229: amv_match_pvt_w.rosetta_table_copy_out_p4(ddx_terr_name_tbl, x_terr_name_tbl);
230: end;
231:

Line 229: amv_match_pvt_w.rosetta_table_copy_out_p4(ddx_terr_name_tbl, x_terr_name_tbl);

225:
226:
227: amv_match_pvt_w.rosetta_table_copy_out_p3(ddx_terr_id_tbl, x_terr_id_tbl);
228:
229: amv_match_pvt_w.rosetta_table_copy_out_p4(ddx_terr_name_tbl, x_terr_name_tbl);
230: end;
231:
232: procedure get_publishedterritories(p_api_version NUMBER
233: , p_init_msg_list VARCHAR2

Line 244: ddx_item_id_tbl amv_match_pvt.terr_id_tbl_type;

240: , x_item_id_tbl out nocopy JTF_NUMBER_TABLE
241: )
242:
243: as
244: ddx_item_id_tbl amv_match_pvt.terr_id_tbl_type;
245: ddindx binary_integer; indx binary_integer;
246: begin
247:
248: -- copy data to the local IN or IN-OUT args, if any

Line 259: amv_match_pvt.get_publishedterritories(p_api_version,

255:
256:
257:
258: -- here's the delegated call to the old PL/SQL routine
259: amv_match_pvt.get_publishedterritories(p_api_version,
260: p_init_msg_list,
261: x_return_status,
262: x_msg_count,
263: x_msg_data,

Line 278: amv_match_pvt_w.rosetta_table_copy_out_p3(ddx_item_id_tbl, x_item_id_tbl);

274:
275:
276:
277:
278: amv_match_pvt_w.rosetta_table_copy_out_p3(ddx_item_id_tbl, x_item_id_tbl);
279: end;
280:
281: end amv_match_pvt_w;

Line 281: end amv_match_pvt_w;

277:
278: amv_match_pvt_w.rosetta_table_copy_out_p3(ddx_item_id_tbl, x_item_id_tbl);
279: end;
280:
281: end amv_match_pvt_w;