1 PACKAGE EAM_CONSTRUCTION_UNIT_PVT as
2 /* $Header: EAMVCUS.pls 120.0.12010000.3 2008/11/20 10:18:11 dsingire noship $*/
3
4 g_debug_flag VARCHAR2(1) := 'N';
5
6 PROCEDURE create_construction_unit(
7 p_api_version IN NUMBER
8 ,p_commit IN VARCHAR2
9 ,p_cu_rec IN EAM_CONSTRUCTION_UNIT_PUB.CU_rec
10 ,p_cu_activity_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl
11 ,x_cu_id OUT NOCOPY NUMBER
12 ,x_return_status OUT NOCOPY VARCHAR2
13 ,x_msg_count OUT NOCOPY NUMBER
14 ,x_msg_data OUT NOCOPY VARCHAR2
15 );
16
17 PROCEDURE update_construction_unit(
18 p_api_version IN NUMBER
19 ,p_commit IN VARCHAR2
20 ,p_cu_rec IN EAM_CONSTRUCTION_UNIT_PUB.CU_rec
21 ,p_cu_activity_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl
22 ,x_cu_id OUT NOCOPY NUMBER
23 ,x_return_status OUT NOCOPY VARCHAR2
24 ,x_msg_count OUT NOCOPY NUMBER
25 ,x_msg_data OUT NOCOPY VARCHAR2
26 );
27
28 PROCEDURE copy_construction_unit(
29 p_api_version IN NUMBER
30 ,p_commit IN VARCHAR2
31 ,p_cu_rec IN EAM_CONSTRUCTION_UNIT_PUB.CU_rec
32 ,p_cu_activity_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl
33 ,p_source_cu_id_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_ID_tbl
34 ,x_cu_id OUT NOCOPY NUMBER
35 ,x_return_status OUT NOCOPY VARCHAR2
36 ,x_msg_count OUT NOCOPY NUMBER
37 ,x_msg_data OUT NOCOPY VARCHAR2
38 );
39
40 PROCEDURE validate_cu_details(
41 p_api_version IN NUMBER
42 ,p_commit IN VARCHAR2
43 ,p_cu_rec IN EAM_CONSTRUCTION_UNIT_PUB.CU_rec
44 ,p_cu_activity_tbl IN EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl
45 ,p_action IN VARCHAR2
46 ,x_return_status OUT NOCOPY VARCHAR2
47 ,x_msg_count OUT NOCOPY NUMBER
48 ,x_msg_data OUT NOCOPY VARCHAR2
49 );
50
51 --Procedures and functions used for debug purpose
52 PROCEDURE set_debug;
53 FUNCTION get_debug RETURN VARCHAR2;
54 PROCEDURE debug(p_message IN varchar2);
55
56 FUNCTION dump_error_stack RETURN VARCHAR2;
57
58 End EAM_CONSTRUCTION_UNIT_PVT;
[Home] [Help]