[Home] [Help]
PACKAGE: APPS.OZF_ACT_OFFERS_PVT
Source
1 PACKAGE OZF_Act_Offers_PVT AS
2 /* $Header: ozfvoffs.pls 120.0 2005/06/01 00:52:03 appldev noship $ */
3
4 TYPE act_offer_rec_type IS RECORD
5 (
6 ACTIVITY_OFFER_ID NUMBER,
7 LAST_UPDATE_DATE DATE,
8 LAST_UPDATED_BY NUMBER,
9 CREATION_DATE DATE,
10 CREATED_BY NUMBER,
11 LAST_UPDATE_LOGIN NUMBER,
12 OBJECT_VERSION_NUMBER NUMBER,
13 ACT_OFFER_USED_BY_ID NUMBER,
14 ARC_ACT_OFFER_USED_BY VARCHAR2(30),
15 PRIMARY_OFFER_FLAG VARCHAR2(1),
16 ACTIVE_PERIOD_SET VARCHAR2(240),
17 ACTIVE_PERIOD VARCHAR2(30),
18 -- START_DATE DATE,
19 -- END_DATE DATE,
20 -- ORDER_DATE_FROM DATE,
21 -- ORDER_DATE_TO DATE,
22 -- SHIP_DATE_FROM DATE,
23 -- SHIP_DATE_TO DATE,
24 -- PERF_DATE_FROM DATE,
25 -- PERF_DATE_TO DATE,
26 -- STATUS_CODE VARCHAR2(30),
27 -- STATUS_DATE DATE,
28 -- OFFER_TYPE VARCHAR2(30),
29 -- OFFER_CODE VARCHAR2(30),
30 -- OFFER_AMOUNT NUMBER,
31 -- LUMPSUM_PAYMENT_TYPE VARCHAR2(30),
32 QP_LIST_HEADER_ID NUMBER,
33 SECURITY_GROUP_ID NUMBER
34 );
35
36
37 -----------------------------------------------------------
38 -- PROCEDURE
39 -- create_act_offer
40 -- PURPOSE
41 -- create a row in OZF_ACT_OFFES
42 -----------------------------------------------------------
43 PROCEDURE create_act_offer
44 (
45 p_api_version IN NUMBER,
46 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
47 p_commit IN VARCHAR2 := FND_API.g_false,
48 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
49
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2,
53
54 p_act_offer_rec IN act_offer_rec_type,
55 x_act_offer_id OUT NOCOPY NUMBER
56 );
57
58 -----------------------------------------------------------
59 -- PROCEDURE
60 -- update_act_offer
61 -- PURPOSE
62 -- Update a row in OZF_ACT_OFFERS.
63 -----------------------------------------------------------
64 PROCEDURE update_act_offer
65 (
66 p_api_version IN NUMBER,
67 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
68 p_commit IN VARCHAR2 := FND_API.g_false,
69 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
70
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74
75 p_act_offer_rec IN act_offer_rec_type
76 );
77
78 -----------------------------------------------------------
79 -- PROCEDURE
80 -- delete_act_offer
81 -- PURPOSE
82 -- Delete a row from OZF_ACT_OFFERS.
83 -----------------------------------------------------------
84 PROCEDURE delete_act_offer
85 (
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
88 p_commit IN VARCHAR2 := FND_API.g_false,
89
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93
94 p_act_offer_id IN NUMBER,
95 p_object_version IN NUMBER
96 );
97
98 -----------------------------------------------------------
99 -- PROCEDURE
100 -- lock_act_offer
101 -- PURPOSE
102 -- Lock a row form OZF_ACT_OFFERS.
103 -----------------------------------------------------------
104 PROCEDURE lock_act_offer
105 (
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
108
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112
113 p_act_offer_id IN NUMBER,
114 p_object_version IN NUMBER
115 );
116
117 -----------------------------------------------------------
118 -- PROCEDURE
119 -- validate_act_offer
120 -- PURPOSE
121 -- Validate a record before inserting or updating.
122 -----------------------------------------------------------
123 PROCEDURE validate_act_offer
124 (
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
127 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
128
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132
133 p_act_offer_rec IN act_offer_rec_type
134 );
135
136 -----------------------------------------------------------
137 -- PROCEDURE
138 -- check_items
139 -- PURPOSE
140 -- Check the item level business rules.
141 -----------------------------------------------------------
142 PROCEDURE check_items
143 (
144 p_validation_mode IN VARCHAR2,
145 x_return_status OUT NOCOPY VARCHAR2,
146 p_act_offer_rec IN act_offer_rec_type
147 );
148
149 -----------------------------------------------------------
150 -- PROCEDURE
151 -- check_record
152 -- PURPOSE
153 -- Check the record level business rules.
154 -----------------------------------------------------------
155 PROCEDURE check_record
156 (
157 p_act_offer_rec IN act_offer_rec_type,
158 p_complete_rec IN act_offer_rec_type,
159 x_return_status OUT NOCOPY VARCHAR2
160 );
161
162 -----------------------------------------------------------
163 -- PROCEDURE
164 -- complete_rec
165 -- PURPOSE
166 -- Replace g_miss values with current database values.
167 -----------------------------------------------------------
168 PROCEDURE complete_rec
169 (
170 p_act_offer_rec IN act_offer_rec_type,
171 x_complete_rec OUT NOCOPY act_offer_rec_type
172 );
173
174 -----------------------------------------------------------------------
175 -- PROCEDURE
176 -- init_rec
177 -- PURPOSE
178 -- Initialize all attributes to be FND_API.g_miss_char/num/date.
179 -----------------------------------------------------------------------
180 PROCEDURE init_rec
181 (
182 x_act_offer_rec OUT NOCOPY act_offer_rec_type
183 );
184
185
186 END OZF_Act_Offers_PVT;