APPS.HZ_HIERARCHY_V2PUB_JW dependencies on HZ_HIERARCHY_V2PUB

Line 1: package body hz_hierarchy_v2pub_jw as

1: package body hz_hierarchy_v2pub_jw as
2: /* $Header: ARH2HIJB.pls 120.2 2005/06/18 04:28:22 jhuang noship $ */
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_p1(t out nocopy hz_hierarchy_v2pub.related_nodes_list_type, a0 JTF_NUMBER_TABLE

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_p1(t out nocopy hz_hierarchy_v2pub.related_nodes_list_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 57: procedure rosetta_table_copy_out_p1(t hz_hierarchy_v2pub.related_nodes_list_type, a0 out nocopy JTF_NUMBER_TABLE

53: end loop;
54: end if;
55: end if;
56: end rosetta_table_copy_in_p1;
57: procedure rosetta_table_copy_out_p1(t hz_hierarchy_v2pub.related_nodes_list_type, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , a2 out nocopy JTF_VARCHAR2_TABLE_100
60: , a3 out nocopy JTF_NUMBER_TABLE
61: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 150: hz_hierarchy_v2pub.is_top_parent(p_init_msg_list,

146:
147:
148:
149: -- here's the delegated call to the old PL/SQL routine
150: hz_hierarchy_v2pub.is_top_parent(p_init_msg_list,
151: p_hierarchy_type,
152: p_parent_id,
153: p_parent_table_name,
154: p_parent_object_type,

Line 210: hz_hierarchy_v2pub.check_parent_child(p_init_msg_list,

206:
207:
208:
209: -- here's the delegated call to the old PL/SQL routine
210: hz_hierarchy_v2pub.check_parent_child(p_init_msg_list,
211: p_hierarchy_type,
212: p_parent_id,
213: p_parent_table_name,
214: p_parent_object_type,

Line 266: ddx_related_nodes_list hz_hierarchy_v2pub.related_nodes_list_type;

262: , x_msg_data out nocopy VARCHAR2
263: )
264: as
265: ddp_effective_date date;
266: ddx_related_nodes_list hz_hierarchy_v2pub.related_nodes_list_type;
267: ddindx binary_integer; indx binary_integer;
268: begin
269:
270: -- copy data to the local IN or IN-OUT args, if any

Line 287: hz_hierarchy_v2pub.get_parent_nodes(p_init_msg_list,

283:
284:
285:
286: -- here's the delegated call to the old PL/SQL routine
287: hz_hierarchy_v2pub.get_parent_nodes(p_init_msg_list,
288: p_hierarchy_type,
289: p_child_id,
290: p_child_table_name,
291: p_child_object_type,

Line 313: hz_hierarchy_v2pub_jw.rosetta_table_copy_out_p1(ddx_related_nodes_list, p10_a0

309:
310:
311:
312:
313: hz_hierarchy_v2pub_jw.rosetta_table_copy_out_p1(ddx_related_nodes_list, p10_a0
314: , p10_a1
315: , p10_a2
316: , p10_a3
317: , p10_a4

Line 353: ddx_related_nodes_list hz_hierarchy_v2pub.related_nodes_list_type;

349: , x_msg_data out nocopy VARCHAR2
350: )
351: as
352: ddp_effective_date date;
353: ddx_related_nodes_list hz_hierarchy_v2pub.related_nodes_list_type;
354: ddindx binary_integer; indx binary_integer;
355: begin
356:
357: -- copy data to the local IN or IN-OUT args, if any

Line 374: hz_hierarchy_v2pub.get_child_nodes(p_init_msg_list,

370:
371:
372:
373: -- here's the delegated call to the old PL/SQL routine
374: hz_hierarchy_v2pub.get_child_nodes(p_init_msg_list,
375: p_hierarchy_type,
376: p_parent_id,
377: p_parent_table_name,
378: p_parent_object_type,

Line 400: hz_hierarchy_v2pub_jw.rosetta_table_copy_out_p1(ddx_related_nodes_list, p10_a0

396:
397:
398:
399:
400: hz_hierarchy_v2pub_jw.rosetta_table_copy_out_p1(ddx_related_nodes_list, p10_a0
401: , p10_a1
402: , p10_a2
403: , p10_a3
404: , p10_a4

Line 436: ddx_top_parent_list hz_hierarchy_v2pub.related_nodes_list_type;

432: , x_msg_data out nocopy VARCHAR2
433: )
434: as
435: ddp_effective_date date;
436: ddx_top_parent_list hz_hierarchy_v2pub.related_nodes_list_type;
437: ddindx binary_integer; indx binary_integer;
438: begin
439:
440: -- copy data to the local IN or IN-OUT args, if any

Line 453: hz_hierarchy_v2pub.get_top_parent_nodes(p_init_msg_list,

449:
450:
451:
452: -- here's the delegated call to the old PL/SQL routine
453: hz_hierarchy_v2pub.get_top_parent_nodes(p_init_msg_list,
454: p_hierarchy_type,
455: p_parent_table_name,
456: p_parent_object_type,
457: ddp_effective_date,

Line 471: hz_hierarchy_v2pub_jw.rosetta_table_copy_out_p1(ddx_top_parent_list, p6_a0

467:
468:
469:
470:
471: hz_hierarchy_v2pub_jw.rosetta_table_copy_out_p1(ddx_top_parent_list, p6_a0
472: , p6_a1
473: , p6_a2
474: , p6_a3
475: , p6_a4

Line 486: end hz_hierarchy_v2pub_jw;

482:
483:
484: end;
485:
486: end hz_hierarchy_v2pub_jw;