DBA Data[Home] [Help]

APPS.AHL_UC_TREE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE

Line 19: , a3 JTF_VARCHAR2_TABLE_100

15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100

Line 22: , a6 JTF_VARCHAR2_TABLE_100

18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100

Line 23: , a7 JTF_VARCHAR2_TABLE_100

19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: ) as

Line 24: , a8 JTF_VARCHAR2_TABLE_100

20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: ) as
28: ddindx binary_integer; indx binary_integer;

Line 25: , a9 JTF_VARCHAR2_TABLE_100

21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: ) as
28: ddindx binary_integer; indx binary_integer;
29: begin

Line 26: , a10 JTF_VARCHAR2_TABLE_100

22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_100
27: ) as
28: ddindx binary_integer; indx binary_integer;
29: begin
30: if a0 is not null and a0.count > 0 then

Line 55: procedure rosetta_table_copy_out_p1(t ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

51: end loop;
52: end if;
53: end if;
54: end rosetta_table_copy_in_p1;
55: procedure rosetta_table_copy_out_p1(t ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , a1 out nocopy JTF_NUMBER_TABLE
57: , a2 out nocopy JTF_NUMBER_TABLE
58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_NUMBER_TABLE

Line 58: , a3 out nocopy JTF_VARCHAR2_TABLE_100

54: end rosetta_table_copy_in_p1;
55: procedure rosetta_table_copy_out_p1(t ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , a1 out nocopy JTF_NUMBER_TABLE
57: , a2 out nocopy JTF_NUMBER_TABLE
58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_NUMBER_TABLE
60: , a5 out nocopy JTF_NUMBER_TABLE
61: , a6 out nocopy JTF_VARCHAR2_TABLE_100
62: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 61: , a6 out nocopy JTF_VARCHAR2_TABLE_100

57: , a2 out nocopy JTF_NUMBER_TABLE
58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_NUMBER_TABLE
60: , a5 out nocopy JTF_NUMBER_TABLE
61: , a6 out nocopy JTF_VARCHAR2_TABLE_100
62: , a7 out nocopy JTF_VARCHAR2_TABLE_100
63: , a8 out nocopy JTF_VARCHAR2_TABLE_100
64: , a9 out nocopy JTF_VARCHAR2_TABLE_100
65: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 62: , a7 out nocopy JTF_VARCHAR2_TABLE_100

58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_NUMBER_TABLE
60: , a5 out nocopy JTF_NUMBER_TABLE
61: , a6 out nocopy JTF_VARCHAR2_TABLE_100
62: , a7 out nocopy JTF_VARCHAR2_TABLE_100
63: , a8 out nocopy JTF_VARCHAR2_TABLE_100
64: , a9 out nocopy JTF_VARCHAR2_TABLE_100
65: , a10 out nocopy JTF_VARCHAR2_TABLE_100
66: ) as

Line 63: , a8 out nocopy JTF_VARCHAR2_TABLE_100

59: , a4 out nocopy JTF_NUMBER_TABLE
60: , a5 out nocopy JTF_NUMBER_TABLE
61: , a6 out nocopy JTF_VARCHAR2_TABLE_100
62: , a7 out nocopy JTF_VARCHAR2_TABLE_100
63: , a8 out nocopy JTF_VARCHAR2_TABLE_100
64: , a9 out nocopy JTF_VARCHAR2_TABLE_100
65: , a10 out nocopy JTF_VARCHAR2_TABLE_100
66: ) as
67: ddindx binary_integer; indx binary_integer;

Line 64: , a9 out nocopy JTF_VARCHAR2_TABLE_100

60: , a5 out nocopy JTF_NUMBER_TABLE
61: , a6 out nocopy JTF_VARCHAR2_TABLE_100
62: , a7 out nocopy JTF_VARCHAR2_TABLE_100
63: , a8 out nocopy JTF_VARCHAR2_TABLE_100
64: , a9 out nocopy JTF_VARCHAR2_TABLE_100
65: , a10 out nocopy JTF_VARCHAR2_TABLE_100
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin

Line 65: , a10 out nocopy JTF_VARCHAR2_TABLE_100

61: , a6 out nocopy JTF_VARCHAR2_TABLE_100
62: , a7 out nocopy JTF_VARCHAR2_TABLE_100
63: , a8 out nocopy JTF_VARCHAR2_TABLE_100
64: , a9 out nocopy JTF_VARCHAR2_TABLE_100
65: , a10 out nocopy JTF_VARCHAR2_TABLE_100
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then

Line 70: a0 := JTF_VARCHAR2_TABLE_100();

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

Line 73: a3 := JTF_VARCHAR2_TABLE_100();

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

Line 76: a6 := JTF_VARCHAR2_TABLE_100();

72: a2 := JTF_NUMBER_TABLE();
73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_NUMBER_TABLE();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_VARCHAR2_TABLE_100();
78: a8 := JTF_VARCHAR2_TABLE_100();
79: a9 := JTF_VARCHAR2_TABLE_100();
80: a10 := JTF_VARCHAR2_TABLE_100();

Line 77: a7 := JTF_VARCHAR2_TABLE_100();

73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_NUMBER_TABLE();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_VARCHAR2_TABLE_100();
78: a8 := JTF_VARCHAR2_TABLE_100();
79: a9 := JTF_VARCHAR2_TABLE_100();
80: a10 := JTF_VARCHAR2_TABLE_100();
81: else

Line 78: a8 := JTF_VARCHAR2_TABLE_100();

74: a4 := JTF_NUMBER_TABLE();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_VARCHAR2_TABLE_100();
78: a8 := JTF_VARCHAR2_TABLE_100();
79: a9 := JTF_VARCHAR2_TABLE_100();
80: a10 := JTF_VARCHAR2_TABLE_100();
81: else
82: a0 := JTF_VARCHAR2_TABLE_100();

Line 79: a9 := JTF_VARCHAR2_TABLE_100();

75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_VARCHAR2_TABLE_100();
78: a8 := JTF_VARCHAR2_TABLE_100();
79: a9 := JTF_VARCHAR2_TABLE_100();
80: a10 := JTF_VARCHAR2_TABLE_100();
81: else
82: a0 := JTF_VARCHAR2_TABLE_100();
83: a1 := JTF_NUMBER_TABLE();

Line 80: a10 := JTF_VARCHAR2_TABLE_100();

76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_VARCHAR2_TABLE_100();
78: a8 := JTF_VARCHAR2_TABLE_100();
79: a9 := JTF_VARCHAR2_TABLE_100();
80: a10 := JTF_VARCHAR2_TABLE_100();
81: else
82: a0 := JTF_VARCHAR2_TABLE_100();
83: a1 := JTF_NUMBER_TABLE();
84: a2 := JTF_NUMBER_TABLE();

Line 82: a0 := JTF_VARCHAR2_TABLE_100();

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

Line 85: a3 := JTF_VARCHAR2_TABLE_100();

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

Line 88: a6 := JTF_VARCHAR2_TABLE_100();

84: a2 := JTF_NUMBER_TABLE();
85: a3 := JTF_VARCHAR2_TABLE_100();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_VARCHAR2_TABLE_100();
89: a7 := JTF_VARCHAR2_TABLE_100();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_VARCHAR2_TABLE_100();

Line 89: a7 := JTF_VARCHAR2_TABLE_100();

85: a3 := JTF_VARCHAR2_TABLE_100();
86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_VARCHAR2_TABLE_100();
89: a7 := JTF_VARCHAR2_TABLE_100();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_VARCHAR2_TABLE_100();
93: if t.count > 0 then

Line 90: a8 := JTF_VARCHAR2_TABLE_100();

86: a4 := JTF_NUMBER_TABLE();
87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_VARCHAR2_TABLE_100();
89: a7 := JTF_VARCHAR2_TABLE_100();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_VARCHAR2_TABLE_100();
93: if t.count > 0 then
94: a0.extend(t.count);

Line 91: a9 := JTF_VARCHAR2_TABLE_100();

87: a5 := JTF_NUMBER_TABLE();
88: a6 := JTF_VARCHAR2_TABLE_100();
89: a7 := JTF_VARCHAR2_TABLE_100();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_VARCHAR2_TABLE_100();
93: if t.count > 0 then
94: a0.extend(t.count);
95: a1.extend(t.count);

Line 92: a10 := JTF_VARCHAR2_TABLE_100();

88: a6 := JTF_VARCHAR2_TABLE_100();
89: a7 := JTF_VARCHAR2_TABLE_100();
90: a8 := JTF_VARCHAR2_TABLE_100();
91: a9 := JTF_VARCHAR2_TABLE_100();
92: a10 := JTF_VARCHAR2_TABLE_100();
93: if t.count > 0 then
94: a0.extend(t.count);
95: a1.extend(t.count);
96: a2.extend(t.count);

Line 136: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100

132: , x_return_status out nocopy VARCHAR2
133: , x_msg_count out nocopy NUMBER
134: , x_msg_data out nocopy VARCHAR2
135: , p_uc_header_id NUMBER
136: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
137: , p7_a1 out nocopy JTF_NUMBER_TABLE
138: , p7_a2 out nocopy JTF_NUMBER_TABLE
139: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
140: , p7_a4 out nocopy JTF_NUMBER_TABLE

Line 139: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

135: , p_uc_header_id NUMBER
136: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
137: , p7_a1 out nocopy JTF_NUMBER_TABLE
138: , p7_a2 out nocopy JTF_NUMBER_TABLE
139: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
140: , p7_a4 out nocopy JTF_NUMBER_TABLE
141: , p7_a5 out nocopy JTF_NUMBER_TABLE
142: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
143: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 142: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

138: , p7_a2 out nocopy JTF_NUMBER_TABLE
139: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
140: , p7_a4 out nocopy JTF_NUMBER_TABLE
141: , p7_a5 out nocopy JTF_NUMBER_TABLE
142: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
143: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
144: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
145: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
146: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 143: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100

139: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
140: , p7_a4 out nocopy JTF_NUMBER_TABLE
141: , p7_a5 out nocopy JTF_NUMBER_TABLE
142: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
143: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
144: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
145: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
146: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
147: )

Line 144: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100

140: , p7_a4 out nocopy JTF_NUMBER_TABLE
141: , p7_a5 out nocopy JTF_NUMBER_TABLE
142: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
143: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
144: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
145: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
146: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
147: )
148:

Line 145: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100

141: , p7_a5 out nocopy JTF_NUMBER_TABLE
142: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
143: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
144: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
145: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
146: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
147: )
148:
149: as

Line 146: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100

142: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
143: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
144: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
145: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
146: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
147: )
148:
149: as
150: ddx_uc_descendant_tbl ahl_uc_tree_pvt.uc_descendant_tbl_type;