eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_MO_PRESET_TIERS_PVT dependencies on OZF_OFFER_DISCOUNT_LINES

Line 163: WHERE EXISTS( SELECT 'X' FROM ozf_offer_discount_lines WHERE offer_discount_line_id = p_pbh_discount_id AND tier_type = 'PBH');

159: IS
160: CURSOR c_pbh(p_pbh_discount_id NUMBER)
161: IS
162: SELECT 1 FROM DUAL
163: WHERE EXISTS( SELECT 'X' FROM ozf_offer_discount_lines WHERE offer_discount_line_id = p_pbh_discount_id AND tier_type = 'PBH');
164:
165: CURSOR c_dis(p_dis_discount_id NUMBER)
166: IS
167: SELECT 1 FROM dual WHERE EXISTS (SELECT 'X' FROM ozf_offer_discount_lines WHERE offer_discount_line_id = p_dis_discount_id AND tier_type = 'DIS');

Line 167: SELECT 1 FROM dual WHERE EXISTS (SELECT 'X' FROM ozf_offer_discount_lines WHERE offer_discount_line_id = p_dis_discount_id AND tier_type = 'DIS');

163: WHERE EXISTS( SELECT 'X' FROM ozf_offer_discount_lines WHERE offer_discount_line_id = p_pbh_discount_id AND tier_type = 'PBH');
164:
165: CURSOR c_dis(p_dis_discount_id NUMBER)
166: IS
167: SELECT 1 FROM dual WHERE EXISTS (SELECT 'X' FROM ozf_offer_discount_lines WHERE offer_discount_line_id = p_dis_discount_id AND tier_type = 'DIS');
168:
169: l_dummy NUMBER;
170: BEGIN
171: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 181: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES','offer_discount_line_id',to_char(p_preset_tier_rec.pbh_offer_discount_id)) =FND_API.G_FALSE THEN

177: END IF;
178: END IF;
179:
180: IF p_preset_tier_rec.pbh_offer_discount_id IS NOT NULL AND p_preset_tier_rec.pbh_offer_discount_id <> FND_API.G_MISS_NUM THEN
181: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES','offer_discount_line_id',to_char(p_preset_tier_rec.pbh_offer_discount_id)) =FND_API.G_FALSE THEN
182: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIER_INV_PBH_ID');
183: x_return_status := FND_API.g_ret_sts_error;
184: return;
185: END IF;

Line 187: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES', 'OFFER_DISCOUNT_LINE_ID', to_char(p_preset_tier_rec.dis_offer_discount_id)) = FND_API.G_FALSE THEN

183: x_return_status := FND_API.g_ret_sts_error;
184: return;
185: END IF;
186: IF p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM THEN
187: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES', 'OFFER_DISCOUNT_LINE_ID', to_char(p_preset_tier_rec.dis_offer_discount_id)) = FND_API.G_FALSE THEN
188: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIERS_INV_DIS_ID');
189: x_return_status := FND_API.g_ret_sts_error;
190: return;
191: END IF;

Line 219: SELECT 'x' FROM ozf_offer_discount_lines

215: IS
216: CURSOR c_valid(p_dis_discount_id NUMBER, p_pbh_discount_id NUMBER) IS
217: SELECT 1 FROM dual
218: WHERE EXISTS(
219: SELECT 'x' FROM ozf_offer_discount_lines
220: WHERE offer_discount_line_id = p_dis_discount_id
221: AND parent_discount_line_id = p_pbh_discount_id);
222: l_dummy NUMBER;
223: BEGIN