DBA Data[Home] [Help]

APPS.ASO_SERVICE_CONTRACTS_INT_W dependencies on JTF_VARCHAR2_TABLE_2000

Line 66: , a1 JTF_VARCHAR2_TABLE_2000

62: end if;
63: end rosetta_table_copy_out_p2;
64:
65: procedure rosetta_table_copy_in_p4(t OUT NOCOPY aso_service_contracts_int.war_tbl_type, a0 JTF_NUMBER_TABLE
66: , a1 JTF_VARCHAR2_TABLE_2000
67: , a2 JTF_VARCHAR2_TABLE_300
68: , a3 JTF_NUMBER_TABLE
69: , a4 JTF_VARCHAR2_TABLE_100
70: , a5 JTF_NUMBER_TABLE

Line 99: , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_2000

95: end if;
96: end if;
97: end rosetta_table_copy_in_p4;
98: procedure rosetta_table_copy_out_p4(t aso_service_contracts_int.war_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
99: , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
100: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_300
101: , a3 OUT NOCOPY JTF_NUMBER_TABLE
102: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100
103: , a5 OUT NOCOPY JTF_NUMBER_TABLE

Line 111: a1 := JTF_VARCHAR2_TABLE_2000();

107: ddindx binary_integer; indx binary_integer;
108: begin
109: if t is null or t.count = 0 then
110: a0 := JTF_NUMBER_TABLE();
111: a1 := JTF_VARCHAR2_TABLE_2000();
112: a2 := JTF_VARCHAR2_TABLE_300();
113: a3 := JTF_NUMBER_TABLE();
114: a4 := JTF_VARCHAR2_TABLE_100();
115: a5 := JTF_NUMBER_TABLE();

Line 120: a1 := JTF_VARCHAR2_TABLE_2000();

116: a6 := JTF_DATE_TABLE();
117: a7 := JTF_DATE_TABLE();
118: else
119: a0 := JTF_NUMBER_TABLE();
120: a1 := JTF_VARCHAR2_TABLE_2000();
121: a2 := JTF_VARCHAR2_TABLE_300();
122: a3 := JTF_NUMBER_TABLE();
123: a4 := JTF_VARCHAR2_TABLE_100();
124: a5 := JTF_NUMBER_TABLE();

Line 211: , p8_a1 OUT NOCOPY JTF_VARCHAR2_TABLE_2000

207: , p_organization_id NUMBER
208: , p_product_item_id NUMBER
209: , x_return_status OUT NOCOPY VARCHAR2
210: , p8_a0 OUT NOCOPY JTF_NUMBER_TABLE
211: , p8_a1 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
212: , p8_a2 OUT NOCOPY JTF_VARCHAR2_TABLE_300
213: , p8_a3 OUT NOCOPY JTF_NUMBER_TABLE
214: , p8_a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100
215: , p8_a5 OUT NOCOPY JTF_NUMBER_TABLE

Line 257: x_item_number_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

253: end;
254:
255:
256: PROCEDURE GET_SERVICES (
257: x_item_number_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
258: x_item_desc_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
259: x_start_date_tbl OUT NOCOPY JTF_DATE_TABLE,
260: x_duration_tbl OUT NOCOPY JTF_NUMBER_TABLE,
261: x_period_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

Line 258: x_item_desc_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

254:
255:
256: PROCEDURE GET_SERVICES (
257: x_item_number_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
258: x_item_desc_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
259: x_start_date_tbl OUT NOCOPY JTF_DATE_TABLE,
260: x_duration_tbl OUT NOCOPY JTF_NUMBER_TABLE,
261: x_period_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
262: x_warranty_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

Line 327: l_item_number JTF_VARCHAR2_TABLE_2000;

323: l_item_id NUMBER;
324: l_inv_org_id NUMBER;
325: l_warranty_tbl aso_service_contracts_int.war_tbl_type;
326: l_return_status VARCHAR2(5);
327: l_item_number JTF_VARCHAR2_TABLE_2000;
328: l_count NUMBER :=0;
329: l_index NUMBER :=0;
330: l_api_version NUMBER := 1.0;
331: l_api_name VARCHAR2(50) := 'GET_SERVICES';

Line 385: x_item_number_tbl := JTF_VARCHAR2_TABLE_2000();

381: RAISE FND_API.G_EXC_ERROR;
382: END IF;
383:
384:
385: x_item_number_tbl := JTF_VARCHAR2_TABLE_2000();
386: x_item_desc_tbl := JTF_VARCHAR2_TABLE_2000();
387: x_start_date_tbl := JTF_DATE_TABLE();
388: x_duration_tbl := JTF_NUMBER_TABLE();
389: x_period_code_tbl := JTF_VARCHAR2_TABLE_100();

Line 386: x_item_desc_tbl := JTF_VARCHAR2_TABLE_2000();

382: END IF;
383:
384:
385: x_item_number_tbl := JTF_VARCHAR2_TABLE_2000();
386: x_item_desc_tbl := JTF_VARCHAR2_TABLE_2000();
387: x_start_date_tbl := JTF_DATE_TABLE();
388: x_duration_tbl := JTF_NUMBER_TABLE();
389: x_period_code_tbl := JTF_VARCHAR2_TABLE_100();
390: x_warranty_flag_tbl := JTF_VARCHAR2_TABLE_100();