APPS.AHL_WARRANTY_UTILS_PVT_W dependencies on AHL_WARRANTY_UTILS_PVT

Line 1: package body ahl_warranty_utils_pvt_w as

1: package body ahl_warranty_utils_pvt_w as
2: /* $Header: AHLWSWUB.pls 120.1.12020000.2 2012/12/14 06:46:52 shnatu ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy ahl_warranty_utils_pvt.warranty_contract_id_tbl_type, a0 JTF_NUMBER_TABLE) as
4: ddindx binary_integer; indx binary_integer;
5: begin

Line 3: procedure rosetta_table_copy_in_p0(t out nocopy ahl_warranty_utils_pvt.warranty_contract_id_tbl_type, a0 JTF_NUMBER_TABLE) as

1: package body ahl_warranty_utils_pvt_w as
2: /* $Header: AHLWSWUB.pls 120.1.12020000.2 2012/12/14 06:46:52 shnatu ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy ahl_warranty_utils_pvt.warranty_contract_id_tbl_type, a0 JTF_NUMBER_TABLE) as
4: ddindx binary_integer; indx binary_integer;
5: begin
6: if a0 is not null and a0.count > 0 then
7: if a0.count > 0 then

Line 21: procedure rosetta_table_copy_out_p0(t ahl_warranty_utils_pvt.warranty_contract_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

17: end loop;
18: end if;
19: end if;
20: end rosetta_table_copy_in_p0;
21: procedure rosetta_table_copy_out_p0(t ahl_warranty_utils_pvt.warranty_contract_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
22: ddindx binary_integer; indx binary_integer;
23: begin
24: if t is null or t.count = 0 then
25: a0 := JTF_NUMBER_TABLE();

Line 44: procedure rosetta_table_copy_in_p1(t out nocopy ahl_warranty_utils_pvt.warranty_vendor_id_tbl_type, a0 JTF_NUMBER_TABLE) as

40: end if;
41: end if;
42: end rosetta_table_copy_out_p0;
43:
44: procedure rosetta_table_copy_in_p1(t out nocopy ahl_warranty_utils_pvt.warranty_vendor_id_tbl_type, a0 JTF_NUMBER_TABLE) as
45: ddindx binary_integer; indx binary_integer;
46: begin
47: if a0 is not null and a0.count > 0 then
48: if a0.count > 0 then

Line 62: procedure rosetta_table_copy_out_p1(t ahl_warranty_utils_pvt.warranty_vendor_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

58: end loop;
59: end if;
60: end if;
61: end rosetta_table_copy_in_p1;
62: procedure rosetta_table_copy_out_p1(t ahl_warranty_utils_pvt.warranty_vendor_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
63: ddindx binary_integer; indx binary_integer;
64: begin
65: if t is null or t.count = 0 then
66: a0 := JTF_NUMBER_TABLE();

Line 85: procedure rosetta_table_copy_in_p3(t out nocopy ahl_warranty_utils_pvt.turnover_notes_tbl_type, a0 JTF_NUMBER_TABLE

81: end if;
82: end if;
83: end rosetta_table_copy_out_p1;
84:
85: procedure rosetta_table_copy_in_p3(t out nocopy ahl_warranty_utils_pvt.turnover_notes_tbl_type, a0 JTF_NUMBER_TABLE
86: , a1 JTF_NUMBER_TABLE
87: , a2 JTF_VARCHAR2_TABLE_100
88: , a3 JTF_VARCHAR2_TABLE_2000
89: , a4 JTF_NUMBER_TABLE

Line 116: procedure rosetta_table_copy_out_p3(t ahl_warranty_utils_pvt.turnover_notes_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

112: end loop;
113: end if;
114: end if;
115: end rosetta_table_copy_in_p3;
116: procedure rosetta_table_copy_out_p3(t ahl_warranty_utils_pvt.turnover_notes_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
117: , a1 out nocopy JTF_NUMBER_TABLE
118: , a2 out nocopy JTF_VARCHAR2_TABLE_100
119: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
120: , a4 out nocopy JTF_NUMBER_TABLE

Line 182: ddp_warranty_contract_id_tbl ahl_warranty_utils_pvt.warranty_contract_id_tbl_type;

178: , x_msg_data out nocopy VARCHAR2
179: )
180:
181: as
182: ddp_warranty_contract_id_tbl ahl_warranty_utils_pvt.warranty_contract_id_tbl_type;
183: ddindx binary_integer; indx binary_integer;
184: begin
185:
186: -- copy data to the local IN or IN-OUT args, if any

Line 192: ahl_warranty_utils_pvt_w.rosetta_table_copy_in_p0(ddp_warranty_contract_id_tbl, p_warranty_contract_id_tbl);

188:
189:
190:
191:
192: ahl_warranty_utils_pvt_w.rosetta_table_copy_in_p0(ddp_warranty_contract_id_tbl, p_warranty_contract_id_tbl);
193:
194:
195:
196:

Line 198: ahl_warranty_utils_pvt.calc_contract_exp_date(p_api_version,

194:
195:
196:
197: -- here's the delegated call to the old PL/SQL routine
198: ahl_warranty_utils_pvt.calc_contract_exp_date(p_api_version,
199: p_init_msg_list,
200: p_commit,
201: p_validation_level,
202: p_module_type,

Line 231: ddp_warranty_vendor_id_tbl ahl_warranty_utils_pvt.warranty_vendor_id_tbl_type;

227: , x_msg_data out nocopy VARCHAR2
228: )
229:
230: as
231: ddp_warranty_vendor_id_tbl ahl_warranty_utils_pvt.warranty_vendor_id_tbl_type;
232: ddindx binary_integer; indx binary_integer;
233: begin
234:
235: -- copy data to the local IN or IN-OUT args, if any

Line 241: ahl_warranty_utils_pvt_w.rosetta_table_copy_in_p1(ddp_warranty_vendor_id_tbl, p_warranty_vendor_id_tbl);

237:
238:
239:
240:
241: ahl_warranty_utils_pvt_w.rosetta_table_copy_in_p1(ddp_warranty_vendor_id_tbl, p_warranty_vendor_id_tbl);
242:
243:
244:
245:

Line 247: ahl_warranty_utils_pvt.disable_templates_for_vendor(p_api_version,

243:
244:
245:
246: -- here's the delegated call to the old PL/SQL routine
247: ahl_warranty_utils_pvt.disable_templates_for_vendor(p_api_version,
248: p_init_msg_list,
249: p_commit,
250: p_validation_level,
251: p_module_type,

Line 287: ddp_trunover_notes_tbl ahl_warranty_utils_pvt.turnover_notes_tbl_type;

283: , p9_a6 in out nocopy JTF_DATE_TABLE
284: )
285:
286: as
287: ddp_trunover_notes_tbl ahl_warranty_utils_pvt.turnover_notes_tbl_type;
288: ddindx binary_integer; indx binary_integer;
289: begin
290:
291: -- copy data to the local IN or IN-OUT args, if any

Line 301: ahl_warranty_utils_pvt_w.rosetta_table_copy_in_p3(ddp_trunover_notes_tbl, p9_a0

297:
298:
299:
300:
301: ahl_warranty_utils_pvt_w.rosetta_table_copy_in_p3(ddp_trunover_notes_tbl, p9_a0
302: , p9_a1
303: , p9_a2
304: , p9_a3
305: , p9_a4

Line 311: ahl_warranty_utils_pvt.insert_turnover_notes(p_api_version,

307: , p9_a6
308: );
309:
310: -- here's the delegated call to the old PL/SQL routine
311: ahl_warranty_utils_pvt.insert_turnover_notes(p_api_version,
312: p_init_msg_list,
313: p_commit,
314: p_validation_level,
315: p_default,

Line 332: ahl_warranty_utils_pvt_w.rosetta_table_copy_out_p3(ddp_trunover_notes_tbl, p9_a0

328:
329:
330:
331:
332: ahl_warranty_utils_pvt_w.rosetta_table_copy_out_p3(ddp_trunover_notes_tbl, p9_a0
333: , p9_a1
334: , p9_a2
335: , p9_a3
336: , p9_a4

Line 342: end ahl_warranty_utils_pvt_w;

338: , p9_a6
339: );
340: end;
341:
342: end ahl_warranty_utils_pvt_w;