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,
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: );
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,
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
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
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: );
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,
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
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: );
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: );
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,
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: );
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
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: );