eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_II_RELATIONSHIPS_PVT dependencies on CSI_DATASTRUCTURES_PUB

Line 31: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

27: --
28: PROCEDURE Get_Cyclic_Node
29: ( p_instance_id IN NUMBER,
30: p_cyclic_node OUT NOCOPY NUMBER,
31: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
32: p_stop_at_cyclic IN VARCHAR2 DEFAULT FND_API.G_TRUE,
33: x_return_status OUT NOCOPY VARCHAR2,
34: x_msg_count OUT NOCOPY NUMBER,
35: x_msg_data OUT NOCOPY VARCHAR2 );

Line 41: x_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl) ;

37: PROCEDURE get_rel_for_instance
38: (p_instance_id IN NUMBER,
39: p_time_stamp IN DATE,
40: p_active_relationship_only IN VARCHAR2,
41: x_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl) ;
42:
43: PROCEDURE get_neighbors_for_instance
44: (p_instance_id IN NUMBER ,
45: p_hop IN NUMBER ,

Line 61: x_relationship_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

57: p_instance_id IN NUMBER ,
58: p_depth IN NUMBER,
59: p_time_stamp IN DATE,
60: p_active_relationship_only IN VARCHAR2 := fnd_api.g_false,
61: x_relationship_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2
65: );

Line 75: p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,

71: p_api_version IN NUMBER,
72: p_commit IN VARCHAR2 := fnd_api.g_false,
73: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
74: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
75: p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,
76: p_depth IN NUMBER,
77: p_time_stamp IN DATE,
78: p_active_relationship_only IN VARCHAR2 := fnd_api.g_false,
79: p_recursive_flag IN VARCHAR2 := fnd_api.g_false,

Line 80: x_relationship_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

76: p_depth IN NUMBER,
77: p_time_stamp IN DATE,
78: p_active_relationship_only IN VARCHAR2 := fnd_api.g_false,
79: p_recursive_flag IN VARCHAR2 := fnd_api.g_false,
80: x_relationship_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2
84: );

Line 92: p_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

88: p_api_version IN NUMBER,
89: p_commit IN VARCHAR2 := fnd_api.g_false,
90: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
91: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
92: p_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
93: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
94: x_return_status OUT NOCOPY VARCHAR2,
95: x_msg_count OUT NOCOPY NUMBER,
96: x_msg_data OUT NOCOPY VARCHAR2

Line 93: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

89: p_commit IN VARCHAR2 := fnd_api.g_false,
90: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
91: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
92: p_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
93: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
94: x_return_status OUT NOCOPY VARCHAR2,
95: x_msg_count OUT NOCOPY NUMBER,
96: x_msg_data OUT NOCOPY VARCHAR2
97: );

Line 105: p_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,

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_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,
106: p_replace_flag IN VARCHAR2 := fnd_api.g_false,
107: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,

Line 107: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

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_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,
106: p_replace_flag IN VARCHAR2 := fnd_api.g_false,
107: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2
111: );

Line 119: p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,

115: p_api_version IN NUMBER,
116: p_commit IN VARCHAR2 := fnd_api.g_false,
117: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
118: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
119: p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
120: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
121: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,

Line 120: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

116: p_commit IN VARCHAR2 := fnd_api.g_false,
117: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
118: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
119: p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
120: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
121: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2

Line 121: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,

117: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
118: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
119: p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
120: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
121: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2
125: );

Line 135: p_rel_history_tbl IN OUT NOCOPY csi_datastructures_pub.relationship_history_tbl

131: /*----------------------------------------------------------*/
132:
133: PROCEDURE Resolve_id_columns
134: (
135: p_rel_history_tbl IN OUT NOCOPY csi_datastructures_pub.relationship_history_tbl
136: );
137:
138: /*------------------------------------------------------------*/
139: /* Procedure name: get_inst_relationship_hist */

Line 151: ,x_rel_history_tbl OUT NOCOPY csi_datastructures_pub.relationship_history_tbl

147: ,p_commit IN VARCHAR2 := fnd_api.g_false
148: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
149: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
150: ,p_transaction_id IN NUMBER
151: ,x_rel_history_tbl OUT NOCOPY csi_datastructures_pub.relationship_history_tbl
152: ,x_return_status OUT NOCOPY VARCHAR2
153: ,x_msg_count OUT NOCOPY NUMBER
154: ,x_msg_data OUT NOCOPY VARCHAR2
155: );

Line 162: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

158: PROCEDURE Get_Next_Level
159: (p_object_id IN NUMBER,
160: p_relationship_id IN NUMBER,
161: p_subject_id IN NUMBER,
162: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
163: p_rel_type_code IN VARCHAR2,
164: p_time_stamp IN DATE,
165: p_active_relationship_only IN VARCHAR2,
166: p_active_instances_only IN VARCHAR2 DEFAULT fnd_api.g_true,

Line 172: p_rel_tbl IN csi_datastructures_pub.ii_relationship_tbl

168: );
169: --
170: FUNCTION Parent_of
171: ( p_subject_id IN NUMBER,
172: p_rel_tbl IN csi_datastructures_pub.ii_relationship_tbl
173: ) RETURN NUMBER;
174: --
175:
176: PROCEDURE check_for_object

Line 195: (p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,

191: p_relationship_id IN NUMBER
192: ) RETURN BOOLEAN;
193:
194: PROCEDURE DFS
195: (p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
196: p_active_relationship_only IN VARCHAR2,
197: p_active_instances_only IN VARCHAR2,
198: p_config_only IN VARCHAR2,
199: p_curr_level IN NUMBER := 1, --bug 10321217

Line 204: (p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,

200: p_depth_req IN NUMBER := 9999 --bug 10321217
201: );
202:
203: PROCEDURE Get_Children
204: (p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,
205: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
206: p_depth IN NUMBER,
207: p_active_relationship_only IN VARCHAR2,
208: p_active_instances_only IN VARCHAR2 DEFAULT fnd_api.g_true, -- should be passed as false only when un-expiring

Line 205: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

201: );
202:
203: PROCEDURE Get_Children
204: (p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,
205: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
206: p_depth IN NUMBER,
207: p_active_relationship_only IN VARCHAR2,
208: p_active_instances_only IN VARCHAR2 DEFAULT fnd_api.g_true, -- should be passed as false only when un-expiring
209: p_config_only IN VARCHAR2 DEFAULT fnd_api.g_false, -- if true will retrieve instances with config keys

Line 225: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl

221: p_object_id OUT NOCOPY NUMBER
222: );
223: PROCEDURE Get_Next_Level
224: (p_object_id IN NUMBER,
225: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
226: );
227:
228: PROCEDURE Get_Children
229: (p_object_id IN NUMBER,

Line 230: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl

226: );
227:
228: PROCEDURE Get_Children
229: (p_object_id IN NUMBER,
230: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
231: );
232:
233: PROCEDURE Get_Immediate_Parents
234: ( p_subject_id IN NUMBER,

Line 236: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl

232:
233: PROCEDURE Get_Immediate_Parents
234: ( p_subject_id IN NUMBER,
235: p_rel_type_code IN VARCHAR2,
236: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
237: );
238:
239: TYPE ii_relationship_level_rec IS RECORD
240: (