228: CLOSE c_get_start_date;
229: -- end julou
230: --l_offers_rec.last_recal_date := sysdate;
231:
232: -- Invoke table handler(OZF_Promotional_Offers_PKG.Insert_Row)
233: OZF_Promotional_Offers_PKG.Insert_Row(
234: px_offer_id => l_offer_id,
235: p_qp_list_header_id => l_offers_rec.qp_list_header_id,
236: p_offer_type => l_offers_rec.offer_type,
229: -- end julou
230: --l_offers_rec.last_recal_date := sysdate;
231:
232: -- Invoke table handler(OZF_Promotional_Offers_PKG.Insert_Row)
233: OZF_Promotional_Offers_PKG.Insert_Row(
234: px_offer_id => l_offer_id,
235: p_qp_list_header_id => l_offers_rec.qp_list_header_id,
236: p_offer_type => l_offers_rec.offer_type,
237: p_offer_code => l_offers_rec.offer_code,
851: l_start_date := l_start_date_o;
852: END IF;
853: -- end julou
854:
855: -- Invoke table handler(OZF_Promotional_Offers_PKG.Update_Row)
856: OZF_Promotional_Offers_PKG.Update_Row(
857: p_offer_id => l_offers_rec.offer_id,
858: p_qp_list_header_id => l_offers_rec.qp_list_header_id,
859: p_offer_type => l_offers_rec.offer_type,
852: END IF;
853: -- end julou
854:
855: -- Invoke table handler(OZF_Promotional_Offers_PKG.Update_Row)
856: OZF_Promotional_Offers_PKG.Update_Row(
857: p_offer_id => l_offers_rec.offer_id,
858: p_qp_list_header_id => l_offers_rec.qp_list_header_id,
859: p_offer_type => l_offers_rec.offer_type,
860: p_offer_code => l_offers_rec.offer_code,
1012: --
1013: -- Api body
1014: --
1015:
1016: -- Invoke table handler(OZF_Promotional_Offers_PKG.Delete_Row)
1017: OZF_Promotional_Offers_PKG.Delete_Row(
1018: p_OFFER_ID => p_OFFER_ID);
1019: --
1020: -- End of API body
1013: -- Api body
1014: --
1015:
1016: -- Invoke table handler(OZF_Promotional_Offers_PKG.Delete_Row)
1017: OZF_Promotional_Offers_PKG.Delete_Row(
1018: p_OFFER_ID => p_OFFER_ID);
1019: --
1020: -- End of API body
1021: --