DBA Data[Home] [Help]

PACKAGE: APPS.CS_CSXSVODS_CHECK_PKG

Source


1 PACKAGE Cs_Csxsvods_Check_pkg AUTHID CURRENT_USER AS
2 /*$Header: cssvcces.pls 115.1 99/07/16 09:02:33 porting shi $*/
3 
4 PROCEDURE Service_Check_Overlap (p_overlap_flag IN OUT VARCHAR2,
5                                                    p_inventory_item_id NUMBER,
6                                                    p_manu_org_id  NUMBER,
7 					           p_customer_product_id NUMBER,
8                                                    p_start_date   DATE,
9                                                    p_end_date     DATE) ;
10 
11 /* Procedure to check whether the current service is being processed in Order Entry */
12 PROCEDURE Service_Check_Duplicate(p_duplicate_flag IN OUT VARCHAR2,
13                                   p_inventory_item_id NUMBER,
14                                   p_customer_product_id NUMBER);
15 
16 
17 
18 PROCEDURE Service_Check_Duplicate_Soline(p_duplicate_flag IN OUT VARCHAR2,
19                                    p_inventory_item_id NUMBER,
20                                    p_customer_product_id NUMBER);
21 
22 
23 
24 
25 PROCEDURE CS_Check_Service_ELigibility (
26                             p_cp_eligibility                IN OUT VARCHAR2,
27                             p_ord_serv_inv_item_id          IN     NUMBER,
28                             p_control_manu_org_id           IN     NUMBER,
29                             p_cp_inventory_item_id	    IN     NUMBER,
30                             p_cp_customer_id	            IN     NUMBER,
31                             p_cp_revision	            IN     VARCHAR2,
32                             p_order_renew_date		    IN     DATE) ;
33 
34 PROCEDURE Check_Price_List(check_value IN OUT VARCHAR2,
35 			   p_price_list_id       IN NUMBER,
36                            service_inv_item_id IN NUMBER,
37                            uom_code            IN VARCHAR2) ;
38 
39 PROCEDURE Calculate_service_duration (Service_duration   IN OUT NUMBER,
40                                       Service_Start_Date IN DATE,
41                                       Service_End_Date   IN DATE,
42                                       Inventory_Item_ID  IN NUMBER,
43                                       Period_Code        IN VARCHAR2,
44                                       Day_UOM_Code       IN VARCHAR2 ,
45                                       Rounded_Flag       IN OUT VARCHAR2,
46 				      Order_Duration     IN NUMBER);
47 PROCEDURE create_cust_interact_new_ord(control_user_id       NUMBER,
48 							    parent_interaction_id VARCHAR2,
49 							    cp_last_update_login  NUMBER,
50 							    cp_bill_to_contact_id NUMBER,
51 							    order_customer_id     NUMBER,
52 					 		    return_status         OUT VARCHAR2,
53 							    return_msg            OUT VARCHAR2);
54 
55 PROCEDURE create_cust_interact_renew(control_user_id       NUMBER,
56   							  cp_cp_service_id      NUMBER,
57 							  parent_interaction_id VARCHAR2,
58 							  cp_last_update_login  NUMBER,
59 							  cp_bill_to_contact_id NUMBER,
60 							  cp_customer_id        IN  NUMBER,
61 						       return_status         OUT VARCHAR2,
62 						   	  return_msg            OUT VARCHAR2);
63 
64 End CS_CSXSVODS_Check_Pkg;