DBA Data[Home] [Help]

APPS.CSI_SYSTEMS_PUB dependencies on CSI_DATASTRUCTURES_PUB

Line 22: p_system_query_rec IN csi_datastructures_pub.system_query_rec,

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,

Line 25: x_systems_tbl OUT NOCOPY csi_datastructures_pub.systems_tbl,

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

Line 173: p_system_rec IN csi_datastructures_pub.system_rec,

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,

Line 174: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

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

Line 333: p_system_rec IN csi_datastructures_pub.system_rec,

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

Line 334: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

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

Line 348: l_child_system_rec csi_datastructures_pub.system_rec;

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

Line 710: p_system_rec IN csi_datastructures_pub.system_rec,

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,

Line 711: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

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

Line 712: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,

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