[Home] [Help]
PACKAGE: APPS.PAY_BALANCE_FEED_DEL_PKG
Source
1 PACKAGE PAY_BALANCE_FEED_DEL_PKG AUTHID CURRENT_USER as
2 /* $Header: pyscd.pkh 120.0.12010000.2 2009/08/21 17:00:53 priupadh noship $ */
3 /*
4 Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved
5 --
6 /*
7 --
8 Name : PAY_BALANCE_FEED_DEL_PKG
9 Author : $Author: priupadh $
10 Synopsis : Purging Process - Balance Feeds.
11 Contents : sub_class_del_proc
12 bal_feed_main_proc
13
14 Change List
15 -----------
16 Date Name Vers Bug No Description
17 ==================================================================================
18 05-Aug-08 salogana 115.1 6595092 Corrected the dbdrv hint.
19 26-Nov-08 salogana 115.2 7556805 Added balance feed deletion
20 functionality with the sub
21 classification deletion.
22 18-Mar-09 priupadh 115.3 7611838 Added procedures for multi threading
23 07-May-09 priupadh 115.4 8493517 Added parameters to Bal_feed_main_proc
24 -----------+-------------+-------+----------+-------------------------------------+
25 */
26 PROCEDURE Bal_feed_main_proc(
27 errbuf out nocopy varchar2,
28 retcode out nocopy varchar2,
29 c_element_type_id in number,
30 c_pur_mode in varchar2,
31 c_dummy_param in varchar2 default null,
32 c_dummy_param_1 in varchar2 default null,
33 c_bal_feed_id in number default null,
34 c_sub_class_id in number default null,
35 c_batch_size in number default null);
36
37 PROCEDURE Trash_latest_balances_threaded(X_errbuf out nocopy varchar2,
38 X_retcode out nocopy varchar2,
39 l_balance_type_id number,
40 l_input_value_id number,
41 l_trash_date date,
42 l_batch_size number);
43
44 PROCEDURE Delete_Proc_PAY_MGR (
45 X_errbuf out nocopy varchar2,
46 X_retcode out nocopy varchar2,
47 p_cursor in varchar2,
48 p_balance_type_id in varchar2,
49 p_input_value_id in varchar2 default null,
50 X_batch_size in number default 1000,
51 X_Num_Workers in number default 5);
52
53 PROCEDURE Delete_Proc_PAY_WKR (
54 X_errbuf out nocopy varchar2,
55 X_retcode out nocopy varchar2,
56 X_batch_size in number,
57 X_Worker_Id in number,
58 X_Num_Workers in number,
59 X_Argument4 in varchar2 default null,
60 X_Argument5 in varchar2 default null,
61 X_Argument6 in varchar2 default null,
62 X_Argument7 in varchar2 default null,
63 X_Argument8 in varchar2 default null,
64 X_Argument9 in varchar2 default null,
65 X_Argument10 in varchar2 default null);
66
67 PROCEDURE Delete_assnmnt_lat_bal(
68 x_errbuf out nocopy varchar2,
69 x_retcode out nocopy varchar2,
70 x_assnmnt_start_id in number,
71 x_assnmnt_end_id in number,
72 p_cursor in varchar2,
73 p_balance_type_id in varchar2,
74 p_input_value_id in varchar2);
75
76
77 end PAY_BALANCE_FEED_DEL_PKG;
78
79