1 PACKAGE QPR_REPORT_ENTITIES_PVT AUTHID CURRENT_USER AS
2 /* $Header: QPRRPTES.pls 120.0 2007/10/11 13:20:03 agbennet noship $ */
3
4 --===================
5 -- PROCEDURES
6 --===================
7
8 --========================================================================
9 -- PROCEDURE : DELETE_REPORT_HEADER
10 --
11 -- PARAMETERS:
12 -- p_report_id Id for the Report Header to be deleted
13 -- x_return_status Return status
14 --
15 -- COMMENT : This procedure deletes the record from the Report Header tables
16 --========================================================================
17
18 PROCEDURE DELETE_REPORT_HEADER(
19 p_report_id IN NUMBER,
20 x_return_status OUT NOCOPY VARCHAR2);
21
22
23 --========================================================================
24 -- PROCEDURE : DELETE_REPORT
25 --
26 -- PARAMETERS:
27 -- p_report_id Report Header Id for which Report needs
28 -- to be deleted
29 --
30 -- x_return_status Return status
31 --
32 -- COMMENT : This procedure deletes the report header, lines, relations
33 -- for a given report id
34 --========================================================================
35
36 PROCEDURE DELETE_REPORT(
37 p_report_id IN NUMBER,
38 x_return_status OUT NOCOPY VARCHAR2);
39
40
41
42 --===========================================================
43 -- PROCEDURE : DELETE_RELATED_REPORTS
44 --
45 -- PARAMETERS:
46 -- p_report_id Parent report id for whom related reports
47 -- should be deleted
48 -- x_return_status Return status
49 --
50 -- COMMENT : This procedure deletes all the related report headers, lines
51 -- for a given report id
52 --========================================================================
53
54 PROCEDURE DELETE_RELATED_REPORTS(
55 p_parent_report_id IN NUMBER,
56 x_return_status OUT NOCOPY VARCHAR2);
57
58 --========================================================================
59 -- PROCEDURE : DELETE_REPORTS
60 --
61 -- PARAMETERS:
62 -- p_price_plan_id Price plan ID for which reports needs
63 -- to be deleted
64 -- x_return_status Return status
65 --
66 -- COMMENT : This procedure deletes all the report headers, lines, relations
67 -- for a given price plan id
68 --========================================================================
69
70 PROCEDURE DELETE_REPORTS(
71 p_price_plan_id IN NUMBER,
72 x_return_status OUT NOCOPY VARCHAR2);
73
74 END QPR_REPORT_ENTITIES_PVT;