APPS.OZF_QUAL_MARKET_OPTION_PKG dependencies on OZF_QUALIFIER_MARKET_OPTION

Line 57: INSERT INTO ozf_qualifier_market_option(

53: BEGIN
54:
55: px_object_version_number := nvl(px_object_version_number, 1);
56:
57: INSERT INTO ozf_qualifier_market_option(
58: qualifier_market_option_id
59: , offer_market_option_id
60: , qp_qualifier_id
61: , object_version_number

Line 107: Update ozf_qualifier_market_option

103: , p_last_update_login NUMBER
104: )
105: IS
106: BEGIN
107: Update ozf_qualifier_market_option
108: SET
109: qualifier_market_option_id = DECODE(p_qualifier_market_option_id , null, qualifier_market_option_id , FND_API.G_MISS_NUM, null, p_qualifier_market_option_id),
110: 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),
111: qp_qualifier_id = DECODE( p_qp_qualifier_id , null, qp_qualifier_id , FND_API.G_MISS_NUM, null, p_qp_qualifier_id),

Line 144: DELETE FROM ozf_qualifier_market_option

140: p_qualifier_market_option_id NUMBER,
141: p_object_version_number NUMBER)
142: IS
143: BEGIN
144: DELETE FROM ozf_qualifier_market_option
145: WHERE qualifier_market_option_id = p_qualifier_market_option_id
146: AND object_version_number = p_object_version_number;
147: If (SQL%NOTFOUND) then
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 171: FROM ozf_qualifier_market_option

167: p_object_version_number NUMBER)
168: IS
169: CURSOR C IS
170: SELECT *
171: FROM ozf_qualifier_market_option
172: WHERE qualifier_market_option_id = p_qualifier_market_option_id
173: AND object_version_number = p_object_version_number
174: FOR UPDATE OF qualifier_market_option_id NOWAIT;
175: Recinfo C%ROWTYPE;