[Home] [Help]
PACKAGE: APPS.OKE_ACTION_VALIDATIONS_PKG
Source
1 PACKAGE OKE_ACTION_VALIDATIONS_PKG 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