APPS.OZF_ADJ_NEW_PROD_PVT dependencies on OZF_OFFER_ADJUSTMENTS_B

Line 742: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_ADJUSTMENTS_B','OFFER_ADJUSTMENT_ID',to_char(p_adj_new_prod_rec.offer_adjustment_id)) = FND_API.g_false THEN

738: return;
739: END IF;
740: END IF;
741: IF p_adj_new_prod_rec.offer_adjustment_id IS NOT NULL AND p_adj_new_prod_rec.offer_adjustment_id <> FND_API.G_MISS_NUM THEN
742: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_ADJUSTMENTS_B','OFFER_ADJUSTMENT_ID',to_char(p_adj_new_prod_rec.offer_adjustment_id)) = FND_API.g_false THEN
743: OZF_Utility_PVT.Error_Message('OZF_INVALID_OFFER_ADJ_ID' );
744: x_return_status := FND_API.g_ret_sts_error;
745: return;
746: END IF;

Line 777: FROM ozf_offer_adjustments_b a, ozf_offer_adj_new_lines b

773: l_api_name CONSTANT VARCHAR2(30) := 'check_vo_product_Lkup_Items';
774: CURSOR c_listHeaderId(cp_offerAdjNewLineId NUMBER)
775: IS
776: SELECT list_header_id
777: FROM ozf_offer_adjustments_b a, ozf_offer_adj_new_lines b
778: WHERE a.offer_adjustment_id = b.offer_adjustment_id
779: AND b.offer_adj_new_line_id = cp_offerAdjNewLineId;
780:
781: l_listHeaderId NUMBER;