18: p_api_version IN NUMBER,
19: p_commit IN VARCHAR2,
20: p_init_msg_list IN VARCHAR2,
21: p_validation_level IN NUMBER,
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,
25: x_systems_tbl OUT NOCOPY csi_datastructures_pub.systems_tbl,
26: x_return_status OUT NOCOPY VARCHAR2,
21: p_validation_level IN NUMBER,
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,
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: )
169: p_api_version IN NUMBER,
170: p_commit IN VARCHAR2,
171: p_init_msg_list IN VARCHAR2,
172: p_validation_level IN NUMBER,
173: p_system_rec IN csi_datastructures_pub.system_rec,
174: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
175: x_system_id OUT NOCOPY NUMBER,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
170: p_commit IN VARCHAR2,
171: p_init_msg_list IN VARCHAR2,
172: p_validation_level IN NUMBER,
173: p_system_rec IN csi_datastructures_pub.system_rec,
174: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
175: x_system_id OUT NOCOPY NUMBER,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2
329: p_api_version IN NUMBER,
330: p_commit IN VARCHAR2,
331: p_init_msg_list IN VARCHAR2,
332: p_validation_level IN NUMBER,
333: p_system_rec IN csi_datastructures_pub.system_rec,
334: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
335: x_return_status OUT NOCOPY VARCHAR2,
336: x_msg_count OUT NOCOPY NUMBER,
337: x_msg_data OUT NOCOPY VARCHAR2
330: p_commit IN VARCHAR2,
331: p_init_msg_list IN VARCHAR2,
332: p_validation_level IN NUMBER,
333: p_system_rec IN csi_datastructures_pub.system_rec,
334: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
335: x_return_status OUT NOCOPY VARCHAR2,
336: x_msg_count OUT NOCOPY NUMBER,
337: x_msg_data OUT NOCOPY VARCHAR2
338: )
344: l_flag VARCHAR2(1) :='N';
345: l_debug_level NUMBER;
346:
347: l_parent_system_id NUMBER;
348: l_child_system_rec csi_datastructures_pub.system_rec;
349:
350: -- Bug 6675862
351: CURSOR CHILD_SYSTEM_CUR (p_parent_system_id NUMBER) IS
352: SELECT SYSTEM_ID child_system_id
706: p_api_version IN NUMBER,
707: p_commit IN VARCHAR2,
708: p_init_msg_list IN VARCHAR2,
709: p_validation_level IN NUMBER,
710: p_system_rec IN csi_datastructures_pub.system_rec,
711: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
712: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
713: x_return_status OUT NOCOPY VARCHAR2,
714: x_msg_count OUT NOCOPY NUMBER,
707: p_commit IN VARCHAR2,
708: p_init_msg_list IN VARCHAR2,
709: p_validation_level IN NUMBER,
710: p_system_rec IN csi_datastructures_pub.system_rec,
711: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
712: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
713: x_return_status OUT NOCOPY VARCHAR2,
714: x_msg_count OUT NOCOPY NUMBER,
715: x_msg_data OUT NOCOPY VARCHAR2
708: p_init_msg_list IN VARCHAR2,
709: p_validation_level IN NUMBER,
710: p_system_rec IN csi_datastructures_pub.system_rec,
711: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
712: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
713: x_return_status OUT NOCOPY VARCHAR2,
714: x_msg_count OUT NOCOPY NUMBER,
715: x_msg_data OUT NOCOPY VARCHAR2
716: )