APPS.OZF_OFFR_MARKET_OPTION_PKG dependencies on OZF_OFFR_MARKET_OPTIONS

Line 66: INSERT INTO ozf_offr_market_options(

62:
63: px_object_version_number := nvl(px_object_version_number, 1);
64:
65:
66: INSERT INTO ozf_offr_market_options(
67: offer_market_option_id
68: , offer_id
69: , qp_list_header_id
70: , group_number

Line 140: Update ozf_offr_market_options

136: )
137:
138: IS
139: BEGIN
140: Update ozf_offr_market_options
141: SET
142: offer_market_option_id = DECODE( p_offer_market_option_id, null, offer_market_option_id, FND_API.G_MISS_NUM, null, p_offer_market_option_id),
143: offer_id = DECODE( p_offer_id, null, offer_id, FND_API.G_MISS_NUM, null, p_offer_id),
144: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),

Line 184: DELETE FROM ozf_offr_market_options

180: p_offer_market_option_id NUMBER,
181: p_object_version_number NUMBER)
182: IS
183: BEGIN
184: DELETE FROM ozf_offr_market_options
185: WHERE offer_market_option_id = p_offer_market_option_id
186: AND object_version_number = p_object_version_number;
187: If (SQL%NOTFOUND) then
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 211: FROM ozf_offr_market_options

207: p_object_version_number NUMBER)
208: IS
209: CURSOR C IS
210: SELECT *
211: FROM ozf_offr_market_options
212: WHERE offer_market_option_id = p_offer_market_option_id
213: AND object_version_number = p_object_version_number
214: FOR UPDATE OF offer_market_option_id NOWAIT;
215: Recinfo C%ROWTYPE;