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_PUB dependencies on CSI_DATASTRUCTURES_PUB

Line 21: p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,

17: p_api_version IN NUMBER,
18: p_commit IN VARCHAR2,
19: p_init_msg_list IN VARCHAR2,
20: p_validation_level IN NUMBER,
21: p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,
22: p_depth IN NUMBER,
23: p_time_stamp IN DATE,
24: p_active_relationship_only IN VARCHAR2,
25: x_relationship_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

Line 25: x_relationship_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

21: p_relationship_query_rec IN csi_datastructures_pub.relationship_query_rec,
22: p_depth IN NUMBER,
23: p_time_stamp IN DATE,
24: p_active_relationship_only IN VARCHAR2,
25: x_relationship_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_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_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

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_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
174: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2

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_relationship_tbl IN OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
174: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2
178: )

Line 184: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;

180: l_api_name CONSTANT VARCHAR2(30) := 'create_relationship';
181: l_api_version CONSTANT NUMBER := 1.0;
182: l_return_status_full VARCHAR2(1);
183: l_access_flag VARCHAR2(1);
184: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
185: l_line_count NUMBER;
186: l_relationship_id NUMBER;
187: l_object_version_number NUMBER;
188: l_transaction_rec csi_datastructures_pub.transaction_rec :=p_txn_rec;

Line 188: l_transaction_rec csi_datastructures_pub.transaction_rec :=p_txn_rec;

184: l_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
185: l_line_count NUMBER;
186: l_relationship_id NUMBER;
187: l_object_version_number NUMBER;
188: l_transaction_rec csi_datastructures_pub.transaction_rec :=p_txn_rec;
189: l_flag VARCHAR2(1) :='N';
190: l_debug_level NUMBER;
191: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
192: l_dummy_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 191: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

187: l_object_version_number NUMBER;
188: l_transaction_rec csi_datastructures_pub.transaction_rec :=p_txn_rec;
189: l_flag VARCHAR2(1) :='N';
190: l_debug_level NUMBER;
191: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
192: l_dummy_tbl csi_datastructures_pub.ii_relationship_tbl;
193: l_msg_count NUMBER;
194: l_msg_data VARCHAR2(2000);
195: l_msg_index NUMBER;

Line 192: l_dummy_tbl csi_datastructures_pub.ii_relationship_tbl;

188: l_transaction_rec csi_datastructures_pub.transaction_rec :=p_txn_rec;
189: l_flag VARCHAR2(1) :='N';
190: l_debug_level NUMBER;
191: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
192: l_dummy_tbl csi_datastructures_pub.ii_relationship_tbl;
193: l_msg_count NUMBER;
194: l_msg_data VARCHAR2(2000);
195: l_msg_index NUMBER;
196: -- Begin Add Code for Siebel Genesis Project

Line 527: p_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,

523: p_api_version IN NUMBER,
524: p_commit IN VARCHAR2,
525: p_init_msg_list IN VARCHAR2,
526: p_validation_level IN NUMBER,
527: p_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,
528: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
529: x_return_status OUT NOCOPY VARCHAR2,
530: x_msg_count OUT NOCOPY NUMBER,
531: x_msg_data OUT NOCOPY VARCHAR2

Line 528: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

524: p_commit IN VARCHAR2,
525: p_init_msg_list IN VARCHAR2,
526: p_validation_level IN NUMBER,
527: p_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl,
528: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
529: x_return_status OUT NOCOPY VARCHAR2,
530: x_msg_count OUT NOCOPY NUMBER,
531: x_msg_data OUT NOCOPY VARCHAR2
532: )

Line 544: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl:=p_relationship_tbl;

540: l_msg_count NUMBER;
541: l_msg_data VARCHAR2(2000);
542: l_msg_index NUMBER;
543: l_line_count NUMBER; -- Added for replacement bug.
544: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl:=p_relationship_tbl;
545: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl:=p_relationship_tbl;
546: l_replace_flag VARCHAR2(1);
547: BEGIN
548: -- standard start of api savepoint

Line 545: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl:=p_relationship_tbl;

541: l_msg_data VARCHAR2(2000);
542: l_msg_index NUMBER;
543: l_line_count NUMBER; -- Added for replacement bug.
544: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl:=p_relationship_tbl;
545: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl:=p_relationship_tbl;
546: l_replace_flag VARCHAR2(1);
547: BEGIN
548: -- standard start of api savepoint
549: SAVEPOINT update_relationship_pub;

Line 807: p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,

803: p_api_version IN NUMBER,
804: p_commit IN VARCHAR2,
805: p_init_msg_list IN VARCHAR2,
806: p_validation_level IN NUMBER,
807: p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
808: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
809: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
810: x_return_status OUT NOCOPY VARCHAR2,
811: x_msg_count OUT NOCOPY NUMBER,

Line 808: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

804: p_commit IN VARCHAR2,
805: p_init_msg_list IN VARCHAR2,
806: p_validation_level IN NUMBER,
807: p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
808: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
809: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
810: x_return_status OUT NOCOPY VARCHAR2,
811: x_msg_count OUT NOCOPY NUMBER,
812: x_msg_data OUT NOCOPY VARCHAR2

Line 809: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,

805: p_init_msg_list IN VARCHAR2,
806: p_validation_level IN NUMBER,
807: p_relationship_rec IN csi_datastructures_pub.ii_relationship_rec,
808: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
809: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
810: x_return_status OUT NOCOPY VARCHAR2,
811: x_msg_count OUT NOCOPY NUMBER,
812: x_msg_data OUT NOCOPY VARCHAR2
813: )