1 Package POA_PORTAL_POPULATE_C AS
2 /*$Header: poaporss.pls 120.0 2005/06/01 14:08:12 appldev noship $ */
3
4
5 PROCEDURE populate_poa(Errbuf in out NOCOPY Varchar2,
6 Retcode in out NOCOPY Varchar2);
7
8 PROCEDURE populate_poa_fii(Errbuf in out NOCOPY Varchar2,
9 Retcode in out NOCOPY Varchar2);
10
11 PROCEDURE insert_rows_pd(p_start in DATE,
12 p_end in DATE,
13 p_quarter in varchar2,
14 p_count out NOCOPY NUMBER,
15 success out NOCOPY varchar2);
16
17 PROCEDURE insert_rows_sr(p_start in DATE,
18 p_end in DATE,
19 p_count out NOCOPY NUMBER,
20 success out NOCOPY varchar2);
21
22 PROCEDURE insert_rows_cm(p_start in DATE,
23 p_end in DATE,
24 p_count out NOCOPY NUMBER,
25 success out NOCOPY varchar2);
26
27 PROCEDURE truncate_tables (p_type IN NUMBER,
28 success OUT NOCOPY varchar2);
29
30 PROCEDURE insert_rows_sp(p_start in DATE,
31 p_end in DATE,
32 p_count out NOCOPY NUMBER,
33 success out NOCOPY varchar2);
34
35 PROCEDURE insert_rows_rcv(p_start in DATE,
36 p_end in DATE,
37 p_count out NOCOPY NUMBER,
38 success out NOCOPY varchar2);
39
40
41 PROCEDURE insert_rows_cross(p_start in DATE,
42 p_end in DATE,
43 p_count out NOCOPY NUMBER,
44 success out NOCOPY varchar2);
45
46 END POA_PORTAL_POPULATE_C;