DBA Data[Home] [Help]

APPS.OZF_PROMOTIONAL_OFFERS_PVT dependencies on OZF_PROMOTIONAL_OFFERS_PVT

Line 1: PACKAGE BODY OZF_Promotional_Offers_PVT as

1: PACKAGE BODY OZF_Promotional_Offers_PVT as
2: /* $Header: ozfvopob.pls 120.7.12020000.2 2013/01/30 08:23:47 apyadav ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- OZF_Promotional_Offers_PVT

2: /* $Header: ozfvopob.pls 120.7.12020000.2 2013/01/30 08:23:47 apyadav ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- OZF_Promotional_Offers_PVT
7: -- Purpose
8: --
9: -- History
10: -- MAY-17-2002 julou modified. See bug 2380113

Line 36: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Promotional_Offers_PVT';

32: -- End of Comments
33: -- ===============================================================
34:
35:
36: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Promotional_Offers_PVT';
37: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvopob.pls';
38:
39: -- ==============================================================
40: -- Procedure

Line 734: l_tar_offers_rec OZF_Promotional_Offers_PVT.offers_rec_type := P_offers_rec;

730: -- Local Variables
731: l_object_version_number NUMBER;
732: l_OFFER_ID NUMBER;
733:
734: l_tar_offers_rec OZF_Promotional_Offers_PVT.offers_rec_type := P_offers_rec;
735: l_rowid ROWID;
736: l_is_owner VARCHAR2(1);
737: l_is_admin BOOLEAN;
738: l_old_owner_id NUMBER;

Line 739: l_offers_rec OZF_Promotional_Offers_PVT.offers_rec_type;

735: l_rowid ROWID;
736: l_is_owner VARCHAR2(1);
737: l_is_admin BOOLEAN;
738: l_old_owner_id NUMBER;
739: l_offers_rec OZF_Promotional_Offers_PVT.offers_rec_type;
740: l_last_recal_date DATE;
741: l_start_date_o DATE;
742: l_start_date DATE;
743:

Line 1799: l_offers_rec OZF_Promotional_Offers_PVT.offers_rec_type;

1795: IS
1796: L_API_NAME CONSTANT VARCHAR2(30) := 'Validate_Offers';
1797: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1798: l_object_version_number NUMBER;
1799: l_offers_rec OZF_Promotional_Offers_PVT.offers_rec_type;
1800:
1801:
1802: BEGIN
1803: -- Standard Start of API savepoint

Line 2008: END OZF_Promotional_Offers_PVT;

2004: x_status_id := l_status_id;
2005:
2006: END handle_status;
2007:
2008: END OZF_Promotional_Offers_PVT;