APPS.AHL_REPAIR_CATEGORIES_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: AHLWRCTB.pls 120.0 2005/07/04 03:59 tamdas noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_repair_categories_pvt.repair_category_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_200
10: , a7 JTF_VARCHAR2_TABLE_200

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_200
10: , a7 JTF_VARCHAR2_TABLE_200
11: , a8 JTF_VARCHAR2_TABLE_200
12: , a9 JTF_VARCHAR2_TABLE_200

Line 24: , a21 JTF_VARCHAR2_TABLE_100

20: , a17 JTF_VARCHAR2_TABLE_200
21: , a18 JTF_VARCHAR2_TABLE_200
22: , a19 JTF_VARCHAR2_TABLE_200
23: , a20 JTF_VARCHAR2_TABLE_200
24: , a21 JTF_VARCHAR2_TABLE_100
25: ) as
26: ddindx binary_integer; indx binary_integer;
27: begin
28: if a0 is not null and a0.count > 0 then

Line 67: , a3 out nocopy JTF_VARCHAR2_TABLE_100

63: end rosetta_table_copy_in_p3;
64: procedure rosetta_table_copy_out_p3(t ahl_repair_categories_pvt.repair_category_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
65: , a1 out nocopy JTF_NUMBER_TABLE
66: , a2 out nocopy JTF_NUMBER_TABLE
67: , a3 out nocopy JTF_VARCHAR2_TABLE_100
68: , a4 out nocopy JTF_NUMBER_TABLE
69: , a5 out nocopy JTF_VARCHAR2_TABLE_100
70: , a6 out nocopy JTF_VARCHAR2_TABLE_200
71: , a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 69: , a5 out nocopy JTF_VARCHAR2_TABLE_100

65: , a1 out nocopy JTF_NUMBER_TABLE
66: , a2 out nocopy JTF_NUMBER_TABLE
67: , a3 out nocopy JTF_VARCHAR2_TABLE_100
68: , a4 out nocopy JTF_NUMBER_TABLE
69: , a5 out nocopy JTF_VARCHAR2_TABLE_100
70: , a6 out nocopy JTF_VARCHAR2_TABLE_200
71: , a7 out nocopy JTF_VARCHAR2_TABLE_200
72: , a8 out nocopy JTF_VARCHAR2_TABLE_200
73: , a9 out nocopy JTF_VARCHAR2_TABLE_200

Line 85: , a21 out nocopy JTF_VARCHAR2_TABLE_100

81: , a17 out nocopy JTF_VARCHAR2_TABLE_200
82: , a18 out nocopy JTF_VARCHAR2_TABLE_200
83: , a19 out nocopy JTF_VARCHAR2_TABLE_200
84: , a20 out nocopy JTF_VARCHAR2_TABLE_200
85: , a21 out nocopy JTF_VARCHAR2_TABLE_100
86: ) as
87: ddindx binary_integer; indx binary_integer;
88: begin
89: if t is null or t.count = 0 then

Line 93: a3 := JTF_VARCHAR2_TABLE_100();

89: if t is null or t.count = 0 then
90: a0 := JTF_NUMBER_TABLE();
91: a1 := JTF_NUMBER_TABLE();
92: a2 := JTF_NUMBER_TABLE();
93: a3 := JTF_VARCHAR2_TABLE_100();
94: a4 := JTF_NUMBER_TABLE();
95: a5 := JTF_VARCHAR2_TABLE_100();
96: a6 := JTF_VARCHAR2_TABLE_200();
97: a7 := JTF_VARCHAR2_TABLE_200();

Line 95: a5 := JTF_VARCHAR2_TABLE_100();

91: a1 := JTF_NUMBER_TABLE();
92: a2 := JTF_NUMBER_TABLE();
93: a3 := JTF_VARCHAR2_TABLE_100();
94: a4 := JTF_NUMBER_TABLE();
95: a5 := JTF_VARCHAR2_TABLE_100();
96: a6 := JTF_VARCHAR2_TABLE_200();
97: a7 := JTF_VARCHAR2_TABLE_200();
98: a8 := JTF_VARCHAR2_TABLE_200();
99: a9 := JTF_VARCHAR2_TABLE_200();

Line 111: a21 := JTF_VARCHAR2_TABLE_100();

107: a17 := JTF_VARCHAR2_TABLE_200();
108: a18 := JTF_VARCHAR2_TABLE_200();
109: a19 := JTF_VARCHAR2_TABLE_200();
110: a20 := JTF_VARCHAR2_TABLE_200();
111: a21 := JTF_VARCHAR2_TABLE_100();
112: else
113: a0 := JTF_NUMBER_TABLE();
114: a1 := JTF_NUMBER_TABLE();
115: a2 := JTF_NUMBER_TABLE();

Line 116: a3 := JTF_VARCHAR2_TABLE_100();

112: else
113: a0 := JTF_NUMBER_TABLE();
114: a1 := JTF_NUMBER_TABLE();
115: a2 := JTF_NUMBER_TABLE();
116: a3 := JTF_VARCHAR2_TABLE_100();
117: a4 := JTF_NUMBER_TABLE();
118: a5 := JTF_VARCHAR2_TABLE_100();
119: a6 := JTF_VARCHAR2_TABLE_200();
120: a7 := JTF_VARCHAR2_TABLE_200();

Line 118: a5 := JTF_VARCHAR2_TABLE_100();

114: a1 := JTF_NUMBER_TABLE();
115: a2 := JTF_NUMBER_TABLE();
116: a3 := JTF_VARCHAR2_TABLE_100();
117: a4 := JTF_NUMBER_TABLE();
118: a5 := JTF_VARCHAR2_TABLE_100();
119: a6 := JTF_VARCHAR2_TABLE_200();
120: a7 := JTF_VARCHAR2_TABLE_200();
121: a8 := JTF_VARCHAR2_TABLE_200();
122: a9 := JTF_VARCHAR2_TABLE_200();

Line 134: a21 := JTF_VARCHAR2_TABLE_100();

130: a17 := JTF_VARCHAR2_TABLE_200();
131: a18 := JTF_VARCHAR2_TABLE_200();
132: a19 := JTF_VARCHAR2_TABLE_200();
133: a20 := JTF_VARCHAR2_TABLE_200();
134: a21 := JTF_VARCHAR2_TABLE_100();
135: if t.count > 0 then
136: a0.extend(t.count);
137: a1.extend(t.count);
138: a2.extend(t.count);

Line 205: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100

201: , x_msg_data out nocopy VARCHAR2
202: , p9_a0 in out nocopy JTF_NUMBER_TABLE
203: , p9_a1 in out nocopy JTF_NUMBER_TABLE
204: , p9_a2 in out nocopy JTF_NUMBER_TABLE
205: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
206: , p9_a4 in out nocopy JTF_NUMBER_TABLE
207: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
208: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_200
209: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_200

Line 207: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100

203: , p9_a1 in out nocopy JTF_NUMBER_TABLE
204: , p9_a2 in out nocopy JTF_NUMBER_TABLE
205: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
206: , p9_a4 in out nocopy JTF_NUMBER_TABLE
207: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
208: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_200
209: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_200
210: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_200
211: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_200

Line 223: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100

219: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_200
220: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_200
221: , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_200
222: , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_200
223: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
224: )
225:
226: as
227: ddp_x_repair_category_tbl ahl_repair_categories_pvt.repair_category_tbl_type;