1 PACKAGE BODY CZ_CONFIG_API_PUB AS
2 /* $Header: czcfgapb.pls 120.8 2012/01/24 03:50:35 spitre ship $ */
3
4 --------------------------------------------------------------------------------
5 /* CZ_CONFIG_API_PUB package modified for Bug7673721, Code changes are moved to
6 * new package CZ_CONFIG_API_PVT */
7 PROCEDURE copy_configuration_auto
8 (p_api_version IN NUMBER
9 ,p_config_hdr_id IN NUMBER
10 ,p_config_rev_nbr IN NUMBER
11 ,p_copy_mode IN VARCHAR2
12 ,x_config_hdr_id OUT NOCOPY NUMBER
13 ,x_config_rev_nbr OUT NOCOPY NUMBER
14 ,x_orig_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
15 ,x_new_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
16 ,x_return_status OUT NOCOPY VARCHAR2
17 ,x_msg_count OUT NOCOPY NUMBER
18 ,x_msg_data OUT NOCOPY VARCHAR2
19 ,p_handle_deleted_flag IN VARCHAR2 := NULL
20 ,p_new_name IN VARCHAR2 := NULL
21 )
22 IS
23 BEGIN
24 cz_config_api_pvt.copy_configuration_auto(p_api_version
25 ,p_config_hdr_id
26 ,p_config_rev_nbr
27 ,p_copy_mode
28 ,x_config_hdr_id
29 ,x_config_rev_nbr
30 ,x_orig_item_id_tbl
31 ,x_new_item_id_tbl
32 ,x_return_status
33 ,x_msg_count
34 ,x_msg_data
35 ,p_handle_deleted_flag
36 ,p_new_name);
37 END copy_configuration_auto;
38 --------------------------------------------------------------------------------
39 PROCEDURE copy_configuration(p_api_version IN NUMBER
40 ,p_config_hdr_id IN NUMBER
41 ,p_config_rev_nbr IN NUMBER
42 ,p_copy_mode IN VARCHAR2
43 ,x_config_hdr_id OUT NOCOPY NUMBER
44 ,x_config_rev_nbr OUT NOCOPY NUMBER
45 ,x_orig_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
46 ,x_new_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
47 ,x_return_status OUT NOCOPY VARCHAR2
48 ,x_msg_count OUT NOCOPY NUMBER
49 ,x_msg_data OUT NOCOPY VARCHAR2
50 ,p_handle_deleted_flag IN VARCHAR2 := NULL
51 ,p_new_name IN VARCHAR2 := NULL
52 )
53 IS
54 BEGIN
55 cz_config_api_pvt.copy_configuration(p_api_version
56 ,p_config_hdr_id
57 ,p_config_rev_nbr
58 ,p_copy_mode
59 ,x_config_hdr_id
60 ,x_config_rev_nbr
61 ,x_orig_item_id_tbl
62 ,x_new_item_id_tbl
63 ,x_return_status
64 ,x_msg_count
65 ,x_msg_data
66 ,p_handle_deleted_flag
67 ,p_new_name
68 ,NULL );
69 END copy_configuration;
70
71 --------------------------------------------------------------------------------
72 PROCEDURE verify_configuration(p_api_version IN NUMBER
73 ,p_config_hdr_id IN NUMBER
74 ,p_config_rev_nbr IN NUMBER
75 ,x_exists_flag OUT NOCOPY VARCHAR2
76 ,x_valid_flag OUT NOCOPY VARCHAR2
77 ,x_complete_flag OUT NOCOPY VARCHAR2
78 ,x_return_status OUT NOCOPY VARCHAR2
79 ,x_msg_count OUT NOCOPY NUMBER
80 ,x_msg_data OUT NOCOPY VARCHAR2
81 )
82 IS
83 BEGIN
84 cz_config_api_pvt.verify_configuration(p_api_version
85 ,p_config_hdr_id
86 ,p_config_rev_nbr
87 ,x_exists_flag
88 ,x_valid_flag
89 ,x_complete_flag
90 ,x_return_status
91 ,x_msg_count
92 ,x_msg_data);
93
94 END verify_configuration;
95
96
97 END CZ_CONFIG_API_PUB;