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_OFFER_ADJ_PRODUCTS_PVT dependencies on OZF_OFFER_DISCOUNT_LINES

Line 179: IF OZF_UTILITY_PVT.check_fk_exists('OZF_OFFER_DISCOUNT_LINES', 'offer_discount_line_id', to_char(p_adj_prod.offer_discount_line_id)) = FND_API.G_FALSE THEN

175: END IF;
176: END IF;
177: OZF_Offer_Adj_Line_PVT.debug_message('OfferDiscountLineid is: '||p_adj_prod.offer_discount_line_id);
178: IF p_adj_prod.offer_discount_line_id IS NOT NULL AND p_adj_prod.offer_discount_line_id <> FND_API.G_MISS_NUM THEN
179: IF OZF_UTILITY_PVT.check_fk_exists('OZF_OFFER_DISCOUNT_LINES', 'offer_discount_line_id', to_char(p_adj_prod.offer_discount_line_id)) = FND_API.G_FALSE THEN
180: OZF_Utility_PVT.Error_Message('OZF_OFFR_ADJ_PROD_INV_DISC_LINE');
181: x_return_status := FND_API.g_ret_sts_error;
182: return;
183: END IF;

Line 333: FROM ozf_offer_discount_lines a

329: )
330: IS
331: CURSOR C(p_offer_discount_line_id NUMBER, p_off_discount_product_id NUMBER) is
332: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 'X'
333: FROM ozf_offer_discount_lines a
334: , ozf_offer_discount_products b
335: , ozf_offer_adjustments_b c
336: , ozf_offers d
337: WHERE a.offer_discount_line_id = b.offer_discount_line_id

Line 363: IF OZF_UTILITY_PVT.check_fk_exists('OZF_OFFER_DISCOUNT_LINES'

359: END IF;
360: END IF;
361: -- a user can associate a product only to a pbh line
362: IF p_adj_prod.offer_discount_line_id IS NOT NULL AND p_adj_prod.offer_discount_line_id <> FND_API.G_MISS_NUM THEN
363: IF OZF_UTILITY_PVT.check_fk_exists('OZF_OFFER_DISCOUNT_LINES'
364: ,'OFFER_DISCOUNT_LINE_ID'
365: , to_char(p_adj_prod.offer_discount_line_id)
366: , OZF_UTILITY_PVT.g_number
367: , ' TIER_TYPE = ''PBH'''