1 PACKAGE csi_systems_pvt AUTHID CURRENT_USER AS
2 /* $Header: csivsyss.pls 115.8 2003/09/04 00:48:51 sguthiva ship $ */
3 -- start of comments
4 -- package name : csi_systems_pvt
5 -- purpose :
6 -- history :
7 -- note :
8 -- end of comments
9
10 -- default NUMBER of records fetch per call
11 g_default_num_rec_fetch NUMBER := 30;
12
13
14
15
16 PROCEDURE get_systems
17 (
18 p_api_version IN NUMBER,
19 p_commit IN VARCHAR2 := fnd_api.g_false,
20 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
21 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
22 p_system_query_rec IN csi_datastructures_pub.system_query_rec,
23 p_time_stamp IN DATE,
24 p_active_systems_only IN VARCHAR2 := fnd_api.g_false,
25 x_systems_tbl OUT NOCOPY csi_datastructures_pub.systems_tbl,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2
29 );
30
31
32 PROCEDURE create_system(
33 p_api_version IN NUMBER,
34 p_commit IN VARCHAR2 := fnd_api.g_false,
35 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
36 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
37 p_system_rec IN csi_datastructures_pub.system_rec,
38 p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
39 x_system_id OUT NOCOPY NUMBER,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2
43 );
44
45 PROCEDURE update_system(
46 p_api_version IN NUMBER,
47 p_commit IN VARCHAR2 := fnd_api.g_false,
48 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
49 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
50 p_system_rec IN csi_datastructures_pub.system_rec,
51 p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2
55 );
56
57 PROCEDURE expire_system
58 (
59 p_api_version IN NUMBER,
60 p_commit IN VARCHAR2 := fnd_api.g_false,
61 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
62 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
63 p_system_rec IN csi_datastructures_pub.system_rec,
64 p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
65 x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2
69 );
70
71 PROCEDURE validate_systems(
72 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
73 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
74 p_validation_mode IN VARCHAR2 ,
75 p_system_rec IN csi_datastructures_pub.system_rec,
76 x_return_status OUT NOCOPY VARCHAR2 ,
77 x_msg_count OUT NOCOPY NUMBER ,
78 x_msg_data OUT NOCOPY VARCHAR2
79 );
80 --
81 PROCEDURE Get_system_details
82 (
83 p_api_version IN NUMBER ,
84 p_commit IN VARCHAR2 := fnd_api.g_false,
85 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
86 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
87 p_system_query_rec IN csi_datastructures_pub.system_query_rec,
88 p_time_stamp IN DATE,
89 p_active_systems_only IN VARCHAR2 := fnd_api.g_false,
90 x_system_header_tbl OUT NOCOPY csi_datastructures_pub.system_header_tbl,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2
94 );
95 --
96 PROCEDURE Resolve_ID_Columns
97 ( p_system_header_tbl IN OUT NOCOPY csi_datastructures_pub.system_header_tbl
98 );
99 --
100 PROCEDURE Get_System_History
101 ( p_api_version IN NUMBER
102 ,p_commit IN VARCHAR2 := fnd_api.g_false
103 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
104 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
105 ,p_transaction_id IN NUMBER
106 ,p_system_id IN NUMBER
107 ,x_system_history_tbl OUT NOCOPY csi_datastructures_pub.systems_history_tbl
108 ,x_return_status OUT NOCOPY VARCHAR2
109 ,x_msg_count OUT NOCOPY NUMBER
110 ,x_msg_data OUT NOCOPY VARCHAR2
111 );
112 END csi_systems_pvt;