DBA Data[Home] [Help]

APPS.OZF_PROMOTIONAL_OFFERS_PVT dependencies on OZF_PROMOTIONAL_OFFERS_PKG

Line 232: -- Invoke table handler(OZF_Promotional_Offers_PKG.Insert_Row)

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,

Line 233: OZF_Promotional_Offers_PKG.Insert_Row(

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,

Line 855: -- Invoke table handler(OZF_Promotional_Offers_PKG.Update_Row)

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,

Line 856: OZF_Promotional_Offers_PKG.Update_Row(

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,

Line 1016: -- Invoke table handler(OZF_Promotional_Offers_PKG.Delete_Row)

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

Line 1017: OZF_Promotional_Offers_PKG.Delete_Row(

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: --