1 PACKAGE BODY QPR_PN_ENTITIES_PVT AS
2 /* $Header: QPRPNEHB.pls 120.1 2007/12/17 09:08:11 vinnaray noship $ */
3
4 --===================
5 -- PROCEDURES
6 --===================
7
8 --========================================================================
9 -- PROCEDURE : DELETE_DEALS
10 --
11 -- PARAMETERS:
12 -- p_price_plan_id Price plan ID for which deals needs
13 -- to be deleted
14 -- x_return_status Return status
15 --
16 -- COMMENT : This procedure deletes all the requests responses and
17 -- related reports for a given price plan id
18 --========================================================================
19
20 PROCEDURE DELETE_DEALS(
21 p_price_plan_id IN NUMBER,
22 x_return_status OUT NOCOPY VARCHAR2)
23 IS
24
25 l_report_id NUMBER;
26 l_return_status VARCHAR2(1);
27 BEGIN
28 x_return_status := FND_API.G_RET_STS_SUCCESS;
29
30 EXCEPTION
31 WHEN OTHERS
32 THEN
33 x_return_status := FND_API.G_RET_STS_ERROR;
34 END DELETE_DEALS;
35
36 END QPR_PN_ENTITIES_PVT;
37