1 PACKAGE AHL_RA_ANALYSER_PVT AS
2 /* $Header: AHLVRAAS.pls 120.1 2005/07/07 05:19 sagarwal noship $*/
3
4 Type Num15TabType is table of NUMBER(15) index by binary_integer ;
5 Type NumTabType is table of NUMBER index by binary_integer ;
6 Type Varchar1TabType is table of VARCHAR2(1) index by binary_integer ;
7 Type Varchar3TabType is table of VARCHAR2(3) index by binary_integer ;
8 Type Varchar10TabType is table of VARCHAR2(10) index by binary_integer ;
9 Type Varchar30TabType is table of VARCHAR2(30) index by binary_integer ;
10 Type Varchar40TabType is table of VARCHAR2(40) index by binary_integer ;
11 Type Varchar80TabType is table of VARCHAR2(80) index by binary_integer ;
12 Type Varchar150TabType is table of VARCHAR2(150) index by binary_integer ;
13 Type Varchar240TabType is table of VARCHAR2(240) index by binary_integer ;
14 Type DateTabType is table of DATE index by binary_integer ;
15
16 PROCEDURE PROCESS_RA_DATA (
17 p_api_version IN NUMBER,
18 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19 p_commit IN VARCHAR2 := FND_API.G_FALSE,
20 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21 p_module_type IN VARCHAR2,
22 x_return_status OUT NOCOPY VARCHAR2,
23 x_msg_count OUT NOCOPY NUMBER,
24 x_msg_data OUT NOCOPY VARCHAR2,
25 p_start_date IN DATE,
26 p_end_date IN DATE,
27 p_concurrent_flag IN VARCHAR2 := 'N',
28 x_xml_data OUT NOCOPY CLOB);
29
30 PROCEDURE RA_ANALYSER_PROCESS (
31 errbuf OUT NOCOPY VARCHAR2,
32 retcode OUT NOCOPY NUMBER,
33 p_api_version IN NUMBER,
34 p_start_date IN VARCHAR2,
35 p_end_date IN VARCHAR2);
36
37 END AHL_RA_ANALYSER_PVT;