PACKAGE: APPS.OKE_ACTION_VALIDATIONS_PKG

Source

1 PACKAGE OKE_ACTION_VALIDATIONS_PKG AUTHID CURRENT_USER AS
2 /* $Header: OKEVDATS.pls 120.0 2005/05/25 17:30:58 appldev noship $ */
3 
4   FUNCTION Validate_MDS ( P_Action_ID		NUMBER
5 			, P_Deliverable_ID		NUMBER
6 			, P_Task_ID			NUMBER
7 			, P_Ship_From_Org_ID		NUMBER
8 			, P_Ship_From_Location_ID	NUMBER
9 			, P_Ship_To_Org_ID		NUMBER
10 			, P_Ship_To_Location_ID		NUMBER
11 			, P_Schedule_Designator		VARCHAR2
12 			, P_Expected_Date		DATE
13 			, P_Quantity			NUMBER
14 			, P_Uom_Code			VARCHAR2 ) RETURN VARCHAR2;
15 
16   FUNCTION Validate_WSH ( P_Action_ID			NUMBER
17 			, P_Deliverable_ID		NUMBER
18 			, P_Task_ID			NUMBER
19 			, P_Ship_From_Org_ID		NUMBER
20 			, P_Ship_From_Location_ID	NUMBER
21 			, P_Ship_To_Org_ID		NUMBER
22 			, P_Ship_To_Location_ID		NUMBER
23 			, P_Expected_Date		DATE
24 			, P_Volume			NUMBER
25 			, P_Volume_Uom			VARCHAR2
26 			, P_Weight			NUMBER
27 			, P_Weight_Uom			VARCHAR2
28 			, P_Quantity			NUMBER
29 			, P_Uom_Code			VARCHAR2 ) RETURN VARCHAR2;
30 
31   FUNCTION Validate_Req ( P_Action_ID			NUMBER
32 			, P_Deliverable_ID 		NUMBER
33 			, P_Task_ID			NUMBER
34 			, P_Ship_From_Org_ID		NUMBER
35 			, P_Ship_From_Location_ID	NUMBER
36 			, P_Ship_To_Org_ID		NUMBER
37 			, P_Ship_To_Location_ID		NUMBER
38 			, P_Expected_Date		DATE
39 			, P_Destination_Type_Code	VARCHAR2
40 			, P_Requisition_Line_Type_ID	NUMBER
41 			, P_Category_ID			NUMBER
42 			, P_Currency_Code		VARCHAR2
43 			, P_Quantity			NUMBER
44 			, P_UOM_Code			VARCHAR2
45 			, P_Unit_Price			NUMBER
46 			, P_Rate_Type			VARCHAR2
47 			, P_Rate_Date			DATE
48 			, P_Exchange_Rate		NUMBER
49 			, P_Expenditure_Type_Code	VARCHAR2
50 			, P_Expenditure_Organization_Id	NUMBER
51 			, P_Expenditure_Item_Date	DATE )
52 RETURN VARCHAR2;
53 
54 FUNCTION Exchange_Rate ( P_Orig_Code VARCHAR2
55 			, P_Target_Code VARCHAR2
56 			, P_Rate_Type VARCHAR2
57 			, P_Date DATE )
58 RETURN NUMBER;
59 
60 FUNCTION Functional_Currency ( P_Org_ID NUMBER )
61 RETURN VARCHAR2;
62 
63 FUNCTION Get_Location_Description ( P_ID NUMBER )
64 RETURN VARCHAR2;
65 
66 
67 PROCEDURE Add_Msg ( P_Action_ID	NUMBER
68 		, P_Msg	VARCHAR2 );
69 
70 
71 
72 END;
73