1 PACKAGE OZF_PRICE_LIST_PVT as
2 /* $Header: ozfvprls.pls 120.0 2005/06/01 03:37:34 appldev noship $ */
3
4 -- Default number of records fetch per call
5 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
6 -- *******************************************************
7 -- Start of Comments
8 -- -------------------------------------------------------
9 -- Record name:OZF_PRICE_LIST_Rec_Type
10 -- -------------------------------------------------------
11 -- Parameters:
12 -- PRICE_LIST_ATTRIBUTE_ID
13 -- USER_STATUS_ID
14 -- STATUS_CODE
15 -- OWNER_ID
16 -- QP_LIST_HEADER_ID
17 -- OBJECT_VERSION_NUMBER
18 -- STATUS_DATE
19 -- WF_ITEM_KEY
20 -- CREATED_BY
21 -- CREATION_DATE
22 -- LAST_UPDATE_DATE
23 -- LAST_UPDATE_LOGIN
24 -- LAST_UPDATED_BY
25 --
26 -- Required:
27 -- Defaults:
28 -- Note: This is automatic generated record definition, it includes all columns
29 -- defined in the table, developer must manually add or delete some of the attributes.
30 --
31 -- End of Comments
32
33 TYPE OZF_PRICE_LIST_Rec_Type IS RECORD
34 (
35 PRICE_LIST_ATTRIBUTE_ID NUMBER ,
36 USER_STATUS_ID NUMBER ,
37 CUSTOM_SETUP_ID NUMBER ,
38 STATUS_CODE VARCHAR2(30) ,
39 OWNER_ID NUMBER ,
40 QP_LIST_HEADER_ID NUMBER ,
41 OBJECT_VERSION_NUMBER NUMBER ,
42 STATUS_DATE DATE ,
43 WF_ITEM_KEY VARCHAR2(100) ,
44 CREATED_BY NUMBER ,
45 CREATION_DATE DATE ,
46 LAST_UPDATE_DATE DATE ,
47 LAST_UPDATE_LOGIN NUMBER ,
48 LAST_UPDATED_BY NUMBER
49 );
50
51 G_MISS_OZF_PRICE_LIST_REC OZF_PRICE_LIST_Rec_Type;
52 TYPE OZF_PRICE_LIST_Tbl_Type IS TABLE OF OZF_PRICE_LIST_Rec_Type
53 INDEX BY BINARY_INTEGER;
54 G_MISS_OZF_PRICE_LIST_TBL OZF_PRICE_LIST_Tbl_Type;
55
56 TYPE OZF_PRICE_LIST_sort_rec_type IS RECORD
57 (
58 -- Please define your own sort by record here.
59 USER_STATUS_ID NUMBER := NULL
60 );
61
62 -- *******************************************************
63 -- Start of Comments
64 -- *******************************************************
65 -- API Name: Create_price_list
66 -- Type : Public
67 -- Pre-Req :
68 -- Parameters:
69 -- IN
70 -- p_api_version_number IN NUMBER Required
71 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
72 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
73 -- P_OZF_PRICE_LIST_Rec IN OZF_PRICE_LIST_Rec_Type Required
74 --
75 -- OUT:
76 -- x_return_status OUT VARCHAR2
77 -- x_msg_count OUT NUMBER
78 -- x_msg_data OUT VARCHAR2
79 -- Version : Current version 1.0
80 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
81 -- and basic operation, developer must manually add parameters and business logic as necessary.
82 --
83 -- End of Comments
84 --
85 PROCEDURE Create_price_list(
86 P_Api_Version_Number IN NUMBER,
87 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
88 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
89 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90 X_Return_Status OUT NOCOPY VARCHAR2,
91 X_Msg_Count OUT NOCOPY NUMBER,
92 X_Msg_Data OUT NOCOPY VARCHAR2,
93 P_OZF_PRICE_LIST_Rec IN OZF_PRICE_LIST_Rec_Type := G_MISS_OZF_PRICE_LIST_REC,
94 X_PRICE_LIST_ATTRIBUTE_ID OUT NOCOPY NUMBER
95 );
96
97 -- *******************************************************
98 -- Start of Comments
99 -- *******************************************************
100 -- API Name: Update_price_list
101 -- Type : Public
102 -- Pre-Req :
103 -- Parameters:
104 -- IN
105 -- p_api_version_number IN NUMBER Required
106 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
107 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
108 -- P_OZF_PRICE_LIST_Rec IN OZF_PRICE_LIST_Rec_Type Required
109 --
110 -- OUT:
111 -- x_return_status OUT VARCHAR2
112 -- x_msg_count OUT NUMBER
113 -- x_msg_data OUT VARCHAR2
114 -- Version : Current version 1.0
115 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
116 -- and basic operation, developer must manually add parameters and business logic as necessary.
117 --
118 -- End of Comments
119 --
120 PROCEDURE Update_price_list(
121 P_Api_Version_Number IN NUMBER,
122 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
123 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
124 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125
126 X_Return_Status OUT NOCOPY VARCHAR2,
127 X_Msg_Count OUT NOCOPY NUMBER,
128 X_Msg_Data OUT NOCOPY VARCHAR2,
129
130 P_OZF_PRICE_LIST_Rec IN OZF_PRICE_LIST_Rec_Type,
131 X_Object_Version_Number OUT NOCOPY NUMBER
132 );
133
134 -- *******************************************************
135 -- Start of Comments
136 -- *******************************************************
137 -- API Name: Delete_price_list
138 -- Type : Public
139 -- Pre-Req :
140 -- Parameters:
141 -- IN
142 -- p_api_version_number IN NUMBER Required
143 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
144 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
145 -- p_PRICE_LIST_ATTRIBUTE_ID IN NUMBER
146 -- p_object_version_number IN NUMBER Optional Default = NULL
147 --
148 -- OUT:
149 -- x_return_status OUT VARCHAR2
150 -- x_msg_count OUT NUMBER
151 -- x_msg_data OUT VARCHAR2
152 -- Version : Current version 1.0
153 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
154 -- and basic operation, developer must manually add parameters and business logic as necessary.
155 --
156 -- End of Comments
157 --
158 PROCEDURE Delete_price_list(
159 P_Api_Version_Number IN NUMBER,
160 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
161 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
162 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
163 X_Return_Status OUT NOCOPY VARCHAR2,
164 X_Msg_Count OUT NOCOPY NUMBER,
165 X_Msg_Data OUT NOCOPY VARCHAR2,
166 P_PRICE_LIST_ATTRIBUTE_ID IN NUMBER,
167 P_Object_Version_Number IN NUMBER
168 );
169
170 FUNCTION get_user_status_name(p_user_status_id IN NUMBER) return VARCHAR2;
171
172 End OZF_PRICE_LIST_PVT;