DBA Data[Home] [Help]

APPS.CSI_SYSTEMS_PVT 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 := 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,

Line 25: x_systems_tbl OUT NOCOPY csi_datastructures_pub.systems_tbl,

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

Line 37: p_system_rec IN csi_datastructures_pub.system_rec,

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,

Line 38: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

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

Line 50: p_system_rec IN csi_datastructures_pub.system_rec,

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

Line 51: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

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

Line 63: p_system_rec IN csi_datastructures_pub.system_rec,

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,

Line 64: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

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

Line 65: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,

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

Line 75: p_system_rec IN csi_datastructures_pub.system_rec,

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

Line 87: p_system_query_rec IN csi_datastructures_pub.system_query_rec,

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,

Line 90: x_system_header_tbl OUT NOCOPY csi_datastructures_pub.system_header_tbl,

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

Line 97: ( p_system_header_tbl IN OUT NOCOPY csi_datastructures_pub.system_header_tbl

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

Line 107: ,x_system_history_tbl OUT NOCOPY csi_datastructures_pub.systems_history_tbl

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