1 Package ben_delete_orphan_rows AUTHID CURRENT_USER as
2 /* $Header: bedeorph.pkh 115.0 2004/07/21 13:04:17 abparekh noship $ */
3 --
4 -- Global type declaration
5 --
6 TYPE Numdata is TABLE OF PER_ALL_PEOPLE_F.PERSON_ID%type;
7 TYPE g_request_table is table of number index by binary_integer;
8 --
9 -- Global varaibles.
10 --
11
12 --
13 -- ----------------------------------------------------------------------------
14 -- |-------------------------------< process >--------------------------------|
15 -- ----------------------------------------------------------------------------
16 -- {Start Of Comments}
17 --
18 -- Description:
19 -- This is the main batch procedure to be called from the concurrent manager.
20 --
21 procedure process
22 ( errbuf out nocopy varchar2
23 ,retcode out nocopy number
24 );
25 --
26 -- -----------------------------------------------------------------------------
27 -- |--------------------------< do_multithread >-------------------------------|
28 -- -----------------------------------------------------------------------------
29 --
30 -- This is the main batch procedure to be called from the concurrent manager
31 --
32 procedure do_multithread
33 (errbuf out nocopy varchar2
34 ,retcode out nocopy number
35 ,p_parent_request_id in number
36 ,p_thread_id in number );
37 --
38 end ben_delete_orphan_rows;