1 PACKAGE OKE_DEFAULTING_PKG AS
2 /* $Header: OKEVLTDS.pls 120.1.12000000.1 2007/01/17 06:54:20 appldev ship $ */
3
4 G_Api_Type CONSTANT VARCHAR2(4) := '_PKG';
5 G_Pkg_Name CONSTANT VARCHAR2(200) := 'OKE_DEFAULTING';
6 G_App_Name CONSTANT VARCHAR2(200) := OKE_API.G_App_Name;
7 G_False CONSTANT VARCHAR2(1) := 'F';
8
9 SUBTYPE Del_Rec_Type IS OKE_DELIVERABLE_PVT.Del_Rec_Type;
10 SUBTYPE Del_Tbl_Type IS OKE_DELIVERABLE_PVT.Del_Tbl_Type;
11
12 PROCEDURE Default_Deliverables (
13 P_Api_Version IN NUMBER DEFAULT 1
14 , P_Init_Msg_List IN VARCHAR2 DEFAULT G_False
15 , P_Update_Yn IN VARCHAR2 DEFAULT 'N'
16 , P_Header_ID IN NUMBER
17 , P_Line_ID IN NUMBER
18 , X_Return_Status OUT NOCOPY VARCHAR2
19 , X_Msg_Count OUT NOCOPY NUMBER
20 , X_Msg_Data OUT NOCOPY VARCHAR2
21 , X_Counter OUT NOCOPY NUMBER );
22
23 PROCEDURE Create_New_L (
24 P_Initiate_Msg_List IN VARCHAR2 DEFAULT G_False
25 , X_Return_Status OUT NOCOPY VARCHAR2
26 , X_Msg_Count OUT NOCOPY NUMBER
27 , X_Msg_Data OUT NOCOPY VARCHAR2
28 , P_Header_ID IN NUMBER
29 , P_Line_ID IN NUMBER
30 , P_Direction IN VARCHAR2
31 , P_Inventory_Org_ID IN NUMBER
32 , X_Counter OUT NOCOPY NUMBER);
33
34 PROCEDURE Create_New (
35 P_Init_Msg_List VARCHAR2 DEFAULT G_False
36 , X_Return_Status OUT NOCOPY VARCHAR2
37 , X_Msg_Count OUT NOCOPY NUMBER
38 , X_Msg_Data OUT NOCOPY VARCHAR2
39 , P_Header_ID IN NUMBER
40 , P_Direction IN VARCHAR2
41 , P_Inventory_Org_ID IN NUMBER
42 , X_Counter OUT NOCOPY NUMBER);
43
44 PROCEDURE Update_Line(
45 P_Init_Msg_List VARCHAR2 DEFAULT G_False
46 , X_Return_Status OUT NOCOPY VARCHAR2
47 , X_Msg_Count OUT NOCOPY NUMBER
48 , X_Msg_Data OUT NOCOPY VARCHAR2
49 , P_Header_ID IN NUMBER
50 , P_Line_ID IN NUMBER
51 , P_Direction IN VARCHAR2
52 , P_Inventory_Org_ID IN NUMBER
53 , X_Counter OUT NOCOPY NUMBER);
54
55 PROCEDURE Update_Batch (
56 P_Init_Msg_List VARCHAR2 DEFAULT G_False
57 , X_Return_Status OUT NOCOPY VARCHAR2
58 , X_Msg_Count OUT NOCOPY NUMBER
59 , X_Msg_Data OUT NOCOPY VARCHAR2
60 , P_Header_ID IN NUMBER
61 , P_Direction IN VARCHAR2
62 , P_Inventory_Org_ID IN NUMBER
63 , X_Counter OUT NOCOPY NUMBER);
64
65 PROCEDURE Get_Org (
66 P_Header_ID IN NUMBER
67 , P_Line_ID IN NUMBER
68 , X_Ship_To_ID OUT NOCOPY NUMBER
69 , X_Ship_From_ID OUT NOCOPY NUMBER);
70
71 PROCEDURE Verify_Defaults (
72 P_Line_ID IN NUMBER
73 , X_Msg_1 OUT NOCOPY VARCHAR2
74 , X_Msg_2 OUT NOCOPY VARCHAR2
75 , X_Msg_3 OUT NOCOPY VARCHAR2
76 , X_Return_Status OUT NOCOPY VARCHAR2
77 , P_Calling_Level IN VARCHAR2 DEFAULT 'L');
78
79 PROCEDURE Convert_Value(P_Header_ID NUMBER
80 , P_Line_ID NUMBER
81 , P_Direction VARCHAR2
82 , X_Ship_To_Org_ID OUT NOCOPY NUMBER
83 , X_Ship_To_ID OUT NOCOPY NUMBER
84 , X_Ship_From_Org_ID OUT NOCOPY NUMBER
85 , X_Ship_From_ID OUT NOCOPY NUMBER
86 , X_Inv_Org_ID OUT NOCOPY NUMBER);
87
88 FUNCTION Check_Mps_Valid( P_Line_ID NUMBER, X_Mps_S OUT NOCOPY VARCHAR2, X_Mps_F OUT NOCOPY VARCHAR2 ) RETURN BOOLEAN;
89
90 END;
91
[Home] [Help]