1 PACKAGE QPR_PN_ENTITIES_PVT AUTHID CURRENT_USER AS
2 /* $Header: QPRPNEHS.pls 120.0 2007/10/11 13:20:39 agbennet 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 requests and
13 -- responses needs to be deleted
14 -- x_return_status Return status
15 --
16 -- COMMENT : This procedure deletes all the requests, responses and related
17 -- 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
24 END QPR_PN_ENTITIES_PVT;