230: CLOSE c_get_start_date;
231: -- end julou
232: --l_offers_rec.last_recal_date := sysdate;
233:
234: -- Invoke table handler(OZF_Promotional_Offers_PKG.Insert_Row)
235: OZF_Promotional_Offers_PKG.Insert_Row(
236: px_offer_id => l_offer_id,
237: p_qp_list_header_id => l_offers_rec.qp_list_header_id,
238: p_offer_type => l_offers_rec.offer_type,
231: -- end julou
232: --l_offers_rec.last_recal_date := sysdate;
233:
234: -- Invoke table handler(OZF_Promotional_Offers_PKG.Insert_Row)
235: OZF_Promotional_Offers_PKG.Insert_Row(
236: px_offer_id => l_offer_id,
237: p_qp_list_header_id => l_offers_rec.qp_list_header_id,
238: p_offer_type => l_offers_rec.offer_type,
239: p_offer_code => l_offers_rec.offer_code,
860: l_start_date := l_start_date_o;
861: END IF;
862: -- end julou
863:
864: -- Invoke table handler(OZF_Promotional_Offers_PKG.Update_Row)
865: OZF_Promotional_Offers_PKG.Update_Row(
866: p_offer_id => l_offers_rec.offer_id,
867: p_qp_list_header_id => l_offers_rec.qp_list_header_id,
868: p_offer_type => l_offers_rec.offer_type,
861: END IF;
862: -- end julou
863:
864: -- Invoke table handler(OZF_Promotional_Offers_PKG.Update_Row)
865: OZF_Promotional_Offers_PKG.Update_Row(
866: p_offer_id => l_offers_rec.offer_id,
867: p_qp_list_header_id => l_offers_rec.qp_list_header_id,
868: p_offer_type => l_offers_rec.offer_type,
869: p_offer_code => l_offers_rec.offer_code,
1024: --
1025: -- Api body
1026: --
1027:
1028: -- Invoke table handler(OZF_Promotional_Offers_PKG.Delete_Row)
1029: OZF_Promotional_Offers_PKG.Delete_Row(
1030: p_OFFER_ID => p_OFFER_ID);
1031: --
1032: -- End of API body
1025: -- Api body
1026: --
1027:
1028: -- Invoke table handler(OZF_Promotional_Offers_PKG.Delete_Row)
1029: OZF_Promotional_Offers_PKG.Delete_Row(
1030: p_OFFER_ID => p_OFFER_ID);
1031: --
1032: -- End of API body
1033: --