[Home] [Help]
PACKAGE: APPS.BEN_BENMNGLE_PURGE
Source
1 package ben_benmngle_purge AUTHID CURRENT_USER as
2 /* $Header: benpurge.pkh 115.5 2002/12/28 00:57:30 rpillay ship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10
11 Name
12 Purge BENMNGLE related tables.
13 Purpose
14 This package is used to purge BENMNGLE stuff from tables.
15 History
16 Date Who Version What?
17 ---- --- ------- -----
18 10-AUG-98 GPERRY 110.0 Created.
19 06-JAN-99 GPERRY 115.2 Corrected to use concurrent
20 request id.
21 24-FEB-99 GPERRY 115.3 Fixed dates for canonical.
22 26-DEC-02 RPILLAY 115.4 NOCOPY changes
23 27-DEC-02 RPILLAY 115.5 Fixed GSCC errors
24 */
25 -----------------------------------------------------------------------
26 procedure purge_single
27 (p_benefit_action_id in number);
28 -----------------------------------------------------------------------
29 procedure purge_all
30 (errbuf out nocopy varchar2,
31 retcode out nocopy number,
32 p_concurrent_request_id in number default null,
33 p_business_group_id in number default null,
34 p_effective_date in varchar2 default null);
35 -----------------------------------------------------------------------
36 procedure delete_batch_range_rows
37 (p_benefit_action_id in number,
38 p_rows out nocopy number);
39 -----------------------------------------------------------------------
40 procedure delete_reporting_rows
41 (p_benefit_action_id in number,
42 p_rows out nocopy number);
43 -----------------------------------------------------------------------
44 procedure delete_person_action_rows
45 (p_benefit_action_id in number,
46 p_rows out nocopy number);
47 -----------------------------------------------------------------------
48 procedure delete_benefit_action_rows
49 (p_benefit_action_id in number,
50 p_rows out nocopy number);
51 -----------------------------------------------------------------------
52 procedure delete_batch_dpnt_rows
53 (p_benefit_action_id in number,
54 p_rows out nocopy number);
55 -----------------------------------------------------------------------
56 procedure delete_batch_elctbl_rows
57 (p_benefit_action_id in number,
58 p_rows out nocopy number);
59 -----------------------------------------------------------------------
60 procedure delete_batch_elig_rows
61 (p_benefit_action_id in number,
62 p_rows out nocopy number);
63 -----------------------------------------------------------------------
64 procedure delete_batch_proc_rows
65 (p_benefit_action_id in number,
66 p_rows out nocopy number);
67 -----------------------------------------------------------------------
68 procedure delete_batch_rate_rows
69 (p_benefit_action_id in number,
70 p_rows out nocopy number);
71 -----------------------------------------------------------------------
72 procedure delete_batch_ler_rows
73 (p_benefit_action_id in number,
74 p_rows out nocopy number);
75 -----------------------------------------------------------------------
76 end ben_benmngle_purge;