eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_HIERARCHY_V2PUB_JW dependencies on JTF_VARCHAR2_TABLE_100

Line 23: , a1 JTF_VARCHAR2_TABLE_100

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
27: , a5 JTF_VARCHAR2_TABLE_100

Line 24: , a2 JTF_VARCHAR2_TABLE_100

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
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_DATE_TABLE

Line 26: , a4 JTF_VARCHAR2_TABLE_100

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
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE

Line 27: , a5 JTF_VARCHAR2_TABLE_100

23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
31: ) as

Line 58: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
62: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 59: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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
62: , a5 out nocopy JTF_VARCHAR2_TABLE_100
63: , a6 out nocopy JTF_DATE_TABLE

Line 61: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
62: , a5 out nocopy JTF_VARCHAR2_TABLE_100
63: , a6 out nocopy JTF_DATE_TABLE
64: , a7 out nocopy JTF_DATE_TABLE
65: , a8 out nocopy JTF_NUMBER_TABLE

Line 62: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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
62: , a5 out nocopy JTF_VARCHAR2_TABLE_100
63: , a6 out nocopy JTF_DATE_TABLE
64: , a7 out nocopy JTF_DATE_TABLE
65: , a8 out nocopy JTF_NUMBER_TABLE
66: ) as

Line 71: a1 := JTF_VARCHAR2_TABLE_100();

67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_VARCHAR2_TABLE_100();
72: a2 := JTF_VARCHAR2_TABLE_100();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_VARCHAR2_TABLE_100();

Line 72: a2 := JTF_VARCHAR2_TABLE_100();

68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_VARCHAR2_TABLE_100();
72: a2 := JTF_VARCHAR2_TABLE_100();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_VARCHAR2_TABLE_100();
76: a6 := JTF_DATE_TABLE();

Line 74: a4 := JTF_VARCHAR2_TABLE_100();

70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_VARCHAR2_TABLE_100();
72: a2 := JTF_VARCHAR2_TABLE_100();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_VARCHAR2_TABLE_100();
76: a6 := JTF_DATE_TABLE();
77: a7 := JTF_DATE_TABLE();
78: a8 := JTF_NUMBER_TABLE();

Line 75: a5 := JTF_VARCHAR2_TABLE_100();

71: a1 := JTF_VARCHAR2_TABLE_100();
72: a2 := JTF_VARCHAR2_TABLE_100();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_VARCHAR2_TABLE_100();
76: a6 := JTF_DATE_TABLE();
77: a7 := JTF_DATE_TABLE();
78: a8 := JTF_NUMBER_TABLE();
79: else

Line 81: a1 := JTF_VARCHAR2_TABLE_100();

77: a7 := JTF_DATE_TABLE();
78: a8 := JTF_NUMBER_TABLE();
79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_VARCHAR2_TABLE_100();
82: a2 := JTF_VARCHAR2_TABLE_100();
83: a3 := JTF_NUMBER_TABLE();
84: a4 := JTF_VARCHAR2_TABLE_100();
85: a5 := JTF_VARCHAR2_TABLE_100();

Line 82: a2 := JTF_VARCHAR2_TABLE_100();

78: a8 := JTF_NUMBER_TABLE();
79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_VARCHAR2_TABLE_100();
82: a2 := JTF_VARCHAR2_TABLE_100();
83: a3 := JTF_NUMBER_TABLE();
84: a4 := JTF_VARCHAR2_TABLE_100();
85: a5 := JTF_VARCHAR2_TABLE_100();
86: a6 := JTF_DATE_TABLE();

Line 84: a4 := JTF_VARCHAR2_TABLE_100();

80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_VARCHAR2_TABLE_100();
82: a2 := JTF_VARCHAR2_TABLE_100();
83: a3 := JTF_NUMBER_TABLE();
84: a4 := JTF_VARCHAR2_TABLE_100();
85: a5 := JTF_VARCHAR2_TABLE_100();
86: a6 := JTF_DATE_TABLE();
87: a7 := JTF_DATE_TABLE();
88: a8 := JTF_NUMBER_TABLE();

Line 85: a5 := JTF_VARCHAR2_TABLE_100();

81: a1 := JTF_VARCHAR2_TABLE_100();
82: a2 := JTF_VARCHAR2_TABLE_100();
83: a3 := JTF_NUMBER_TABLE();
84: a4 := JTF_VARCHAR2_TABLE_100();
85: a5 := JTF_VARCHAR2_TABLE_100();
86: a6 := JTF_DATE_TABLE();
87: a7 := JTF_DATE_TABLE();
88: a8 := JTF_NUMBER_TABLE();
89: if t.count > 0 then

Line 252: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100

248: , p_include_node VARCHAR2
249: , p_effective_date date
250: , p_no_of_records NUMBER
251: , p10_a0 out nocopy JTF_NUMBER_TABLE
252: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
253: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
254: , p10_a3 out nocopy JTF_NUMBER_TABLE
255: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
256: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 253: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100

249: , p_effective_date date
250: , p_no_of_records NUMBER
251: , p10_a0 out nocopy JTF_NUMBER_TABLE
252: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
253: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
254: , p10_a3 out nocopy JTF_NUMBER_TABLE
255: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
256: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
257: , p10_a6 out nocopy JTF_DATE_TABLE

Line 255: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100

251: , p10_a0 out nocopy JTF_NUMBER_TABLE
252: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
253: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
254: , p10_a3 out nocopy JTF_NUMBER_TABLE
255: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
256: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
257: , p10_a6 out nocopy JTF_DATE_TABLE
258: , p10_a7 out nocopy JTF_DATE_TABLE
259: , p10_a8 out nocopy JTF_NUMBER_TABLE

Line 256: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100

252: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
253: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
254: , p10_a3 out nocopy JTF_NUMBER_TABLE
255: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
256: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
257: , p10_a6 out nocopy JTF_DATE_TABLE
258: , p10_a7 out nocopy JTF_DATE_TABLE
259: , p10_a8 out nocopy JTF_NUMBER_TABLE
260: , x_return_status out nocopy VARCHAR2

Line 339: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100

335: , p_include_node VARCHAR2
336: , p_effective_date date
337: , p_no_of_records NUMBER
338: , p10_a0 out nocopy JTF_NUMBER_TABLE
339: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
340: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
341: , p10_a3 out nocopy JTF_NUMBER_TABLE
342: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
343: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 340: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100

336: , p_effective_date date
337: , p_no_of_records NUMBER
338: , p10_a0 out nocopy JTF_NUMBER_TABLE
339: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
340: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
341: , p10_a3 out nocopy JTF_NUMBER_TABLE
342: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
343: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
344: , p10_a6 out nocopy JTF_DATE_TABLE

Line 342: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100

338: , p10_a0 out nocopy JTF_NUMBER_TABLE
339: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
340: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
341: , p10_a3 out nocopy JTF_NUMBER_TABLE
342: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
343: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
344: , p10_a6 out nocopy JTF_DATE_TABLE
345: , p10_a7 out nocopy JTF_DATE_TABLE
346: , p10_a8 out nocopy JTF_NUMBER_TABLE

Line 343: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100

339: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
340: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
341: , p10_a3 out nocopy JTF_NUMBER_TABLE
342: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
343: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
344: , p10_a6 out nocopy JTF_DATE_TABLE
345: , p10_a7 out nocopy JTF_DATE_TABLE
346: , p10_a8 out nocopy JTF_NUMBER_TABLE
347: , x_return_status out nocopy VARCHAR2

Line 422: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

418: , p_parent_object_type VARCHAR2
419: , p_effective_date date
420: , p_no_of_records NUMBER
421: , p6_a0 out nocopy JTF_NUMBER_TABLE
422: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
424: , p6_a3 out nocopy JTF_NUMBER_TABLE
425: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
426: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 423: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

419: , p_effective_date date
420: , p_no_of_records NUMBER
421: , p6_a0 out nocopy JTF_NUMBER_TABLE
422: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
424: , p6_a3 out nocopy JTF_NUMBER_TABLE
425: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
426: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
427: , p6_a6 out nocopy JTF_DATE_TABLE

Line 425: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

421: , p6_a0 out nocopy JTF_NUMBER_TABLE
422: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
424: , p6_a3 out nocopy JTF_NUMBER_TABLE
425: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
426: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
427: , p6_a6 out nocopy JTF_DATE_TABLE
428: , p6_a7 out nocopy JTF_DATE_TABLE
429: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 426: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

422: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
424: , p6_a3 out nocopy JTF_NUMBER_TABLE
425: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
426: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
427: , p6_a6 out nocopy JTF_DATE_TABLE
428: , p6_a7 out nocopy JTF_DATE_TABLE
429: , p6_a8 out nocopy JTF_NUMBER_TABLE
430: , x_return_status out nocopy VARCHAR2