1 PACKAGE bim_programs_denorm_pkg AUTHID CURRENT_USER AS
2 /*$Header: bimprgds.pls 120.1 2005/10/11 05:38:14 sbassi noship $*/
3
4 PROCEDURE POPULATE
5 (ERRBUF OUT NOCOPY VARCHAR2,
6 RETCODE OUT NOCOPY NUMBER,
7 p_api_version_number IN NUMBER,
8 p_proc_num IN NUMBER,
9 p_load_type IN VARCHAR2
10 );
11
12 PROCEDURE POPULATE_SOURCE_DENORM
13 (p_api_version_number IN NUMBER
14 ,p_init_msg_list IN VARCHAR2
15 ,p_validation_level IN NUMBER
16 ,p_commit IN VARCHAR2
17 ,x_msg_Count OUT NOCOPY NUMBER
18 ,x_msg_Data OUT NOCOPY VARCHAR2
19 ,x_return_status OUT NOCOPY VARCHAR2
20 ,p_proc_num IN NUMBER
21 ,p_load_type IN VARCHAR2
22 );
23
24 PROCEDURE LOAD_ADMIN_RECORDS(
25 p_api_version_number IN NUMBER := 1.0
26 ,p_init_msg_list IN VARCHAR2
27 ,p_commit IN VARCHAR2
28 ,p_validation_level IN NUMBER
29 ,x_return_status OUT NOCOPY VARCHAR2
30 ,x_msg_count OUT NOCOPY NUMBER
31 ,x_msg_data OUT NOCOPY VARCHAR2
32 );
33
34 PROCEDURE LOAD_TOP_LEVEL_OBJECTS(
35 p_api_version_number IN NUMBER := 1.0
36 ,p_init_msg_list IN VARCHAR2
37 ,p_commit IN VARCHAR2
38 ,p_validation_level IN NUMBER
39 ,x_return_status OUT NOCOPY VARCHAR2
40 ,x_msg_count OUT NOCOPY NUMBER
41 ,x_msg_data OUT NOCOPY VARCHAR2
42 );
43
44 END bim_programs_denorm_pkg;