[Home] [Help]
PACKAGE: APPS.ASO_SERVICE_CONTRACTS_INT
Source
1 PACKAGE ASO_service_contracts_INT as
2 /* $Header: asoiokss.pls 120.1 2005/06/29 12:34:20 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_service_contracts_INT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11
12 --
13 --
14 -- Record types
15 --
16 --
17 --
18 --
19 -- API
20 --
21 --
22 --
23
24 TYPE CHECK_SERVICE_REC_TYPE Is RECORD
25 (
26 product_item_id Number
27 ,service_item_id Number
28 ,customer_id Number
29 ,product_revision Varchar2(3)
30 ,request_date Date
31 );
32 TYPE AVAIL_SERVICE_REC_TYPE Is RECORD
33 (
34 product_item_id Number
35 ,customer_id Number
36 ,product_revision Varchar2(3)
37 ,request_date Date
38 );
39 TYPE OKS_ORDER_SERVICE_REC_TYPE Is RECORD
40 (
41 service_item_id Number
42 , name Varchar2(40)
43 , Description Varchar2(240)
44 , Coverage_Template_Id Number
45 );
46 TYPE ORDER_SERVICE_REC_TYPE Is RECORD
47 (
48 service_item_id Number
49 );
50 TYPE order_service_tbl_type Is TABLE OF ORDER_SERVICE_REC_TYPE Index by BINARY_INTEGER;
51
52 TYPE oks_order_service_tbl_type Is TABLE OF OKS_ORDER_SERVICE_REC_TYPE Index by BINARY_INTEGER;
53
54 Type War_rec_type IS RECORD (
55 -- Product_Item_Id Number,
56 Service_item_id Number,
57 service_name VARCHAR2(2000),
58 -- service_name VARCHAR2(240),
59 service_description VARCHAR2(240),
60 -- Organiztion_id Number,
61 -- Status_code Varchar2(20),
62 Duration_Quantity Number,
63 Duration_Period Varchar2(20),
64 Coverage_Schedule_id Number,
65 -- Starting_Delay Varchar2(1)
66 -- Warranty_Flag Varchar2(1),
67 -- Service_Order_number Number,
68 -- Service_Order_Date Date,
69 -- Bill_To_Site_Use_id Number,
70 -- Ship_To_Site_Use_id Number,
71 Warranty_Start_Date Date,
72 -- Customer_Account_Id Number
73 Warranty_End_Date Date
74 );
75 TYPE War_tbl_type IS TABLE OF War_rec_type INDEX BY BINARY_INTEGER;
76
77 Procedure Get_Duration
78 (
79 P_Api_Version_Number IN Number,
80 P_init_msg_list IN Varchar2 Default FND_API.G_FALSE,
81 X_msg_Count OUT NOCOPY /* file.sql.39 change */ Number,
82 X_msg_Data OUT NOCOPY /* file.sql.39 change */ Varchar2,
83 X_Return_Status OUT NOCOPY /* file.sql.39 change */ Varchar2,
84 P_customer_id IN Number,
85 P_system_id IN Number,
86 P_Service_Duration IN Number,
87 P_service_period IN Varchar2,
88 P_coterm_checked_yn IN Varchar2 Default FND_API.G_FALSE,
89 P_start_date IN Date,
90 P_end_date IN Date,
91 X_service_duration OUT NOCOPY /* file.sql.39 change */ Number,
92 X_service_period OUT NOCOPY /* file.sql.39 change */ Varchar2,
93 X_new_end_date OUT NOCOPY /* file.sql.39 change */ Date
94 ) ;
95
96
97 Procedure Is_Service_Available
98 (
99 P_Api_Version_Number IN Number,
100 P_init_msg_list IN Varchar2 Default FND_API.G_FALSE,
101 X_msg_Count OUT NOCOPY /* file.sql.39 change */ Number,
102 X_msg_Data OUT NOCOPY /* file.sql.39 change */ Varchar2,
103 X_Return_Status OUT NOCOPY /* file.sql.39 change */ Varchar2,
104 p_check_service_rec IN CHECK_SERVICE_REC_TYPE,
105 X_Available_YN OUT NOCOPY /* file.sql.39 change */ Varchar2
106 );
107
108
109 Procedure Available_Services(
110 P_Api_Version_Number IN Number,
111 P_init_msg_list IN Varchar2 Default FND_API.G_FALSE,
112 X_msg_Count OUT NOCOPY /* file.sql.39 change */ Number,
113 X_msg_Data OUT NOCOPY /* file.sql.39 change */ Varchar2,
114 X_Return_Status OUT NOCOPY /* file.sql.39 change */ Varchar2,
115 p_avail_service_rec IN AVAIL_SERVICE_REC_TYPE,
116 X_Orderable_Service_tbl OUT NOCOPY /* file.sql.39 change */ order_service_tbl_type
117 );
118
119
120 Procedure Get_Warranty (
121 P_Api_Version_Number IN Number,
122 P_init_msg_list IN Varchar2 Default FND_API.G_FALSE,
123 X_msg_Count OUT NOCOPY /* file.sql.39 change */ Number,
124 X_msg_Data OUT NOCOPY /* file.sql.39 change */ Varchar2,
125 P_Org_id IN Number,
126 P_Organization_id IN NUMBER Default null,
127 P_product_item_id IN Number,
128 x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2,
129 X_Warranty_tbl OUT NOCOPY /* file.sql.39 change */ War_tbl_type );
130
131
132 Procedure Get_service_attributes
133 (
134 P_Api_Version_Number IN Number,
135 P_init_msg_list IN Varchar2 Default FND_API.G_FALSE,
136 P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
137 P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type,
138 X_msg_Count OUT NOCOPY /* file.sql.39 change */ Number,
139 X_msg_Data OUT NOCOPY /* file.sql.39 change */ Varchar2,
140 X_Return_Status OUT NOCOPY /* file.sql.39 change */ Varchar2
141 ) ;
142
143 END ASO_service_contracts_INT;