DBA Data[Home] [Help]

APPS.AHL_WARRANTY_UTILS_PVT_W dependencies on JTF_NUMBER_TABLE

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 25: a0 := JTF_NUMBER_TABLE();

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();
26: else
27: a0 := JTF_NUMBER_TABLE();
28: if t.count > 0 then
29: a0.extend(t.count);

Line 27: a0 := JTF_NUMBER_TABLE();

23: begin
24: if t is null or t.count = 0 then
25: a0 := JTF_NUMBER_TABLE();
26: else
27: a0 := JTF_NUMBER_TABLE();
28: if t.count > 0 then
29: a0.extend(t.count);
30: ddindx := t.first;
31: indx := 1;

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 66: a0 := JTF_NUMBER_TABLE();

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();
67: else
68: a0 := JTF_NUMBER_TABLE();
69: if t.count > 0 then
70: a0.extend(t.count);

Line 68: a0 := JTF_NUMBER_TABLE();

64: begin
65: if t is null or t.count = 0 then
66: a0 := JTF_NUMBER_TABLE();
67: else
68: a0 := JTF_NUMBER_TABLE();
69: if t.count > 0 then
70: a0.extend(t.count);
71: ddindx := t.first;
72: indx := 1;

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 86: , a1 JTF_NUMBER_TABLE

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
90: , a5 JTF_VARCHAR2_TABLE_300

Line 89: , a4 JTF_NUMBER_TABLE

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
90: , a5 JTF_VARCHAR2_TABLE_300
91: , a6 JTF_DATE_TABLE
92: ) as
93: ddindx binary_integer; indx binary_integer;

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 117: , a1 out nocopy JTF_NUMBER_TABLE

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
121: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 120: , a4 out nocopy JTF_NUMBER_TABLE

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
121: , a5 out nocopy JTF_VARCHAR2_TABLE_300
122: , a6 out nocopy JTF_DATE_TABLE
123: ) as
124: ddindx binary_integer; indx binary_integer;

Line 127: a0 := JTF_NUMBER_TABLE();

123: ) as
124: ddindx binary_integer; indx binary_integer;
125: begin
126: if t is null or t.count = 0 then
127: a0 := JTF_NUMBER_TABLE();
128: a1 := JTF_NUMBER_TABLE();
129: a2 := JTF_VARCHAR2_TABLE_100();
130: a3 := JTF_VARCHAR2_TABLE_2000();
131: a4 := JTF_NUMBER_TABLE();

Line 128: a1 := JTF_NUMBER_TABLE();

124: ddindx binary_integer; indx binary_integer;
125: begin
126: if t is null or t.count = 0 then
127: a0 := JTF_NUMBER_TABLE();
128: a1 := JTF_NUMBER_TABLE();
129: a2 := JTF_VARCHAR2_TABLE_100();
130: a3 := JTF_VARCHAR2_TABLE_2000();
131: a4 := JTF_NUMBER_TABLE();
132: a5 := JTF_VARCHAR2_TABLE_300();

Line 131: a4 := JTF_NUMBER_TABLE();

127: a0 := JTF_NUMBER_TABLE();
128: a1 := JTF_NUMBER_TABLE();
129: a2 := JTF_VARCHAR2_TABLE_100();
130: a3 := JTF_VARCHAR2_TABLE_2000();
131: a4 := JTF_NUMBER_TABLE();
132: a5 := JTF_VARCHAR2_TABLE_300();
133: a6 := JTF_DATE_TABLE();
134: else
135: a0 := JTF_NUMBER_TABLE();

Line 135: a0 := JTF_NUMBER_TABLE();

131: a4 := JTF_NUMBER_TABLE();
132: a5 := JTF_VARCHAR2_TABLE_300();
133: a6 := JTF_DATE_TABLE();
134: else
135: a0 := JTF_NUMBER_TABLE();
136: a1 := JTF_NUMBER_TABLE();
137: a2 := JTF_VARCHAR2_TABLE_100();
138: a3 := JTF_VARCHAR2_TABLE_2000();
139: a4 := JTF_NUMBER_TABLE();

Line 136: a1 := JTF_NUMBER_TABLE();

132: a5 := JTF_VARCHAR2_TABLE_300();
133: a6 := JTF_DATE_TABLE();
134: else
135: a0 := JTF_NUMBER_TABLE();
136: a1 := JTF_NUMBER_TABLE();
137: a2 := JTF_VARCHAR2_TABLE_100();
138: a3 := JTF_VARCHAR2_TABLE_2000();
139: a4 := JTF_NUMBER_TABLE();
140: a5 := JTF_VARCHAR2_TABLE_300();

Line 139: a4 := JTF_NUMBER_TABLE();

135: a0 := JTF_NUMBER_TABLE();
136: a1 := JTF_NUMBER_TABLE();
137: a2 := JTF_VARCHAR2_TABLE_100();
138: a3 := JTF_VARCHAR2_TABLE_2000();
139: a4 := JTF_NUMBER_TABLE();
140: a5 := JTF_VARCHAR2_TABLE_300();
141: a6 := JTF_DATE_TABLE();
142: if t.count > 0 then
143: a0.extend(t.count);

Line 175: , p_warranty_contract_id_tbl JTF_NUMBER_TABLE

171: , p_init_msg_list VARCHAR2
172: , p_commit VARCHAR2
173: , p_validation_level NUMBER
174: , p_module_type VARCHAR2
175: , p_warranty_contract_id_tbl JTF_NUMBER_TABLE
176: , x_return_status out nocopy VARCHAR2
177: , x_msg_count out nocopy NUMBER
178: , x_msg_data out nocopy VARCHAR2
179: )

Line 224: , p_warranty_vendor_id_tbl JTF_NUMBER_TABLE

220: , p_init_msg_list VARCHAR2
221: , p_commit VARCHAR2
222: , p_validation_level NUMBER
223: , p_module_type VARCHAR2
224: , p_warranty_vendor_id_tbl JTF_NUMBER_TABLE
225: , x_return_status out nocopy VARCHAR2
226: , x_msg_count out nocopy NUMBER
227: , x_msg_data out nocopy VARCHAR2
228: )

Line 277: , p9_a0 in out nocopy JTF_NUMBER_TABLE

273: , p_module_type VARCHAR2
274: , x_return_status out nocopy VARCHAR2
275: , x_msg_count out nocopy NUMBER
276: , x_msg_data out nocopy VARCHAR2
277: , p9_a0 in out nocopy JTF_NUMBER_TABLE
278: , p9_a1 in out nocopy JTF_NUMBER_TABLE
279: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
281: , p9_a4 in out nocopy JTF_NUMBER_TABLE

Line 278: , p9_a1 in out nocopy JTF_NUMBER_TABLE

274: , x_return_status out nocopy VARCHAR2
275: , x_msg_count out nocopy NUMBER
276: , x_msg_data out nocopy VARCHAR2
277: , p9_a0 in out nocopy JTF_NUMBER_TABLE
278: , p9_a1 in out nocopy JTF_NUMBER_TABLE
279: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
281: , p9_a4 in out nocopy JTF_NUMBER_TABLE
282: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_300

Line 281: , p9_a4 in out nocopy JTF_NUMBER_TABLE

277: , p9_a0 in out nocopy JTF_NUMBER_TABLE
278: , p9_a1 in out nocopy JTF_NUMBER_TABLE
279: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
281: , p9_a4 in out nocopy JTF_NUMBER_TABLE
282: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_300
283: , p9_a6 in out nocopy JTF_DATE_TABLE
284: )
285: