[Home] [Help]
PACKAGE: APPS.ASO_SERVICE_CONTRACTS_INT_W
Source
1 package aso_service_contracts_int_w AUTHID CURRENT_USER as
2 /* $Header: asovqwss.pls 120.1 2005/06/29 12:44:40 appldev ship $ */
3 procedure rosetta_table_copy_in_p2(t OUT NOCOPY aso_service_contracts_int.order_service_tbl_type, a0 JTF_NUMBER_TABLE
4 );
5 procedure rosetta_table_copy_out_p2(t aso_service_contracts_int.order_service_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
6 );
7
8 procedure rosetta_table_copy_in_p4(t OUT NOCOPY aso_service_contracts_int.war_tbl_type, a0 JTF_NUMBER_TABLE
9 , a1 JTF_VARCHAR2_TABLE_2000
10 , a2 JTF_VARCHAR2_TABLE_300
11 , a3 JTF_NUMBER_TABLE
12 , a4 JTF_VARCHAR2_TABLE_100
13 , a5 JTF_NUMBER_TABLE
14 , a6 JTF_DATE_TABLE
15 , a7 JTF_DATE_TABLE
16 );
17 procedure rosetta_table_copy_out_p4(t aso_service_contracts_int.war_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
18 , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
19 , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_300
20 , a3 OUT NOCOPY JTF_NUMBER_TABLE
21 , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100
22 , a5 OUT NOCOPY JTF_NUMBER_TABLE
23 , a6 OUT NOCOPY JTF_DATE_TABLE
24 , a7 OUT NOCOPY JTF_DATE_TABLE
25 );
26
27 procedure available_services(p_api_version_number NUMBER
28 , p_init_msg_list VARCHAR2
29 , x_msg_count OUT NOCOPY NUMBER
30 , x_msg_data OUT NOCOPY VARCHAR2
31 , x_return_status OUT NOCOPY VARCHAR2
32 , p6_a0 OUT NOCOPY JTF_NUMBER_TABLE
33 , p5_a0 NUMBER := 0-1962.0724
34 , p5_a1 NUMBER := 0-1962.0724
35 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
36 , p5_a3 DATE := fnd_api.g_miss_date
37 );
38 procedure get_warranty(p_api_version_number NUMBER
39 , p_init_msg_list VARCHAR2
40 , x_msg_count OUT NOCOPY NUMBER
41 , x_msg_data OUT NOCOPY VARCHAR2
42 , p_org_id NUMBER
43 , p_organization_id NUMBER
44 , p_product_item_id NUMBER
45 , x_return_status OUT NOCOPY VARCHAR2
46 , p8_a0 OUT NOCOPY JTF_NUMBER_TABLE
47 , p8_a1 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
48 , p8_a2 OUT NOCOPY JTF_VARCHAR2_TABLE_300
49 , p8_a3 OUT NOCOPY JTF_NUMBER_TABLE
50 , p8_a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100
51 , p8_a5 OUT NOCOPY JTF_NUMBER_TABLE
52 , p8_a6 OUT NOCOPY JTF_DATE_TABLE
53 , p8_a7 OUT NOCOPY JTF_DATE_TABLE
54 );
55
56 procedure GET_SERVICES (
57 x_item_number_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
58 x_item_desc_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
59 x_start_date_tbl OUT NOCOPY JTF_DATE_TABLE,
60 x_duration_tbl OUT NOCOPY JTF_NUMBER_TABLE,
61 x_period_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
62 x_warranty_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
63 p_source IN VARCHAR2,
64 p_source_id IN NUMBER,
65 p_api_version_number IN NUMBER,
66 p_init_msg_list IN VARCHAR2,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2);
70
71 procedure is_service_available (
72 p_api_version_number IN NUMBER
73 , p_init_msg_list IN VARCHAR2
74 , x_return_status OUT NOCOPY VARCHAR2
75 , x_msg_count OUT NOCOPY NUMBER
76 , x_msg_data OUT NOCOPY VARCHAR2
77 , p_product_item_id IN Number
78 , p_service_item_id IN Number
79 , p_customer_id IN Number
80 , p_product_revision IN Varchar2
81 , p_request_date IN Date
82 , X_Available_YN OUT NOCOPY /* file.sql.39 change */ varchar2);
83
84 procedure available_services(
85 x_Inventory_organization_id OUT NOCOPY JTF_NUMBER_TABLE
86 , x_Service_item_id OUT NOCOPY JTF_NUMBER_TABLE
87 , x_Concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_1000
88 , x_Description OUT NOCOPY JTF_VARCHAR2_TABLE_1000
89 , x_Primary_uom_code OUT NOCOPY JTF_VARCHAR2_TABLE_300
90 , x_Serviceable_product_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
91 , x_Service_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
92 , x_Bom_item_type OUT NOCOPY JTF_NUMBER_TABLE
93 , x_Item_type OUT NOCOPY JTF_VARCHAR2_TABLE_1000
94 , x_Service_duration OUT NOCOPY JTF_NUMBER_TABLE
95 , x_Service_duration_period_code OUT NOCOPY JTF_VARCHAR2_TABLE_1000
96 , x_Shippable_item_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
97 , x_Returnable_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100
98 , p_api_version_number IN NUMBER := 1.0
99 , p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR
100 , p_commit IN VARCHAR2:= FND_API.g_false
101 , p_search_input IN VARCHAR2 := FND_API.G_MISS_CHAR
102 , p_product_item_id IN Number := FND_API.G_MISS_NUM
103 , p_customer_id IN Number := FND_API.G_MISS_NUM
104 , p_product_revision IN Varchar2 := FND_API.G_MISS_CHAR
105 , p_request_date IN Date := FND_API.G_MISS_DATE
106 , x_return_status OUT NOCOPY VARCHAR2
107 , x_msg_count OUT NOCOPY NUMBER
108 , x_msg_data OUT NOCOPY VARCHAR2);
109
110
111 end aso_service_contracts_int_w;
112