APPS.OZF_ADJ_NEW_PROD_PVT dependencies on OZF_OFFER_ADJ_NEW_LINES

Line 735: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_ADJ_NEW_LINES','OFFER_ADJ_NEW_LINE_ID',to_char(p_adj_new_prod_rec.OFFER_ADJ_NEW_LINE_ID)) = FND_API.g_false THEN

731: BEGIN
732: x_return_status := FND_API.g_ret_sts_success;
733: ozf_utility_pvt.debug_message('Offer Type is :'||p_adj_new_prod_rec.offer_type);
734: IF p_adj_new_prod_rec.offer_type <> 'VOLUME_OFFER' THEN
735: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_ADJ_NEW_LINES','OFFER_ADJ_NEW_LINE_ID',to_char(p_adj_new_prod_rec.OFFER_ADJ_NEW_LINE_ID)) = FND_API.g_false THEN
736: OZF_Utility_PVT.Error_Message('OZF_INVALID_ADJ_LINE_ID' );
737: x_return_status := FND_API.g_ret_sts_error;
738: return;
739: 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;

Line 846: SELECT volume_type , parent_adj_line_id FROM ozf_offer_adj_new_lines

842: )
843: IS
844:
845: CURSOR c_volumeType(cp_offerAdjLineId NUMBER) IS
846: SELECT volume_type , parent_adj_line_id FROM ozf_offer_adj_new_lines
847: WHERE offer_adj_new_line_id = cp_offerAdjLineId;
848: l_volumeType c_volumeType%ROWTYPE;
849: CURSOR c_listLineType(cp_offerAdjLineId NUMBER) IS
850: SELECT tier_type

Line 851: FROM ozf_offer_adj_new_lines

847: WHERE offer_adj_new_line_id = cp_offerAdjLineId;
848: l_volumeType c_volumeType%ROWTYPE;
849: CURSOR c_listLineType(cp_offerAdjLineId NUMBER) IS
850: SELECT tier_type
851: FROM ozf_offer_adj_new_lines
852: WHERE offer_adj_new_line_id = cp_offerAdjLineId;
853: l_listLineType VARCHAR2(30);
854: BEGIN
855: x_return_status := FND_API.G_RET_STS_SUCCESS;