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_ITEM_INSTANCE_PVT

Line 4426: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

4422: l_dummy NUMBER;
4423: l_object_version NUMBER;
4424: l_object_version1 NUMBER;
4425: l_subject_id NUMBER;
4426: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
4427: l_location_tbl csi_item_instance_pvt.location_tbl;
4428: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
4429: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
4430: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

Line 4427: l_location_tbl csi_item_instance_pvt.location_tbl;

4423: l_object_version NUMBER;
4424: l_object_version1 NUMBER;
4425: l_subject_id NUMBER;
4426: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
4427: l_location_tbl csi_item_instance_pvt.location_tbl;
4428: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
4429: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
4430: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
4431: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 4428: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

4424: l_object_version1 NUMBER;
4425: l_subject_id NUMBER;
4426: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
4427: l_location_tbl csi_item_instance_pvt.location_tbl;
4428: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
4429: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
4430: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
4431: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
4432: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;

Line 4429: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

4425: l_subject_id NUMBER;
4426: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
4427: l_location_tbl csi_item_instance_pvt.location_tbl;
4428: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
4429: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
4430: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
4431: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
4432: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
4433: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;

Line 4430: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

4426: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
4427: l_location_tbl csi_item_instance_pvt.location_tbl;
4428: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
4429: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
4430: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
4431: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
4432: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
4433: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
4434: -- Begin Add Code for Siebel Genesis Project

Line 4550: /*csi_item_instance_pvt.update_item_instance

4546: ,x_return_status => x_return_status
4547: ,x_msg_count => x_msg_count
4548: ,x_msg_data => x_msg_data
4549: );
4550: /*csi_item_instance_pvt.update_item_instance
4551: ( p_api_version => p_api_version
4552: ,p_commit => p_commit
4553: ,p_init_msg_list => p_init_msg_list
4554: ,p_validation_level => p_validation_level

Line 4641: csi_item_instance_pvt.update_item_instance

4637: l_instance_rec1.object_version_number:=l_object_version;
4638: l_instance_rec1.instance_id:=l_rel_tbl(j).object_id;
4639: l_instance_rec1.completeness_flag:='Y';
4640:
4641: csi_item_instance_pvt.update_item_instance
4642: ( p_api_version => p_api_version
4643: ,p_commit => p_commit
4644: ,p_init_msg_list => p_init_msg_list
4645: ,p_validation_level => p_validation_level

Line 4925: IF csi_item_instance_pvt.check_item_instance_lock

4921: --Added for MACD lock functionality
4922: IF p_relationship_tbl(l_count).object_id IS NOT NULL AND
4923: p_relationship_tbl(l_count).object_id <> fnd_api.g_miss_num
4924: THEN
4925: IF csi_item_instance_pvt.check_item_instance_lock
4926: ( p_instance_id => p_relationship_tbl(l_count).object_id)
4927: THEN
4928: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
4929: THEN

Line 4940: IF csi_item_instance_pvt.check_item_instance_lock

4936: END IF;
4937: IF p_relationship_tbl(l_count).subject_id IS NOT NULL AND
4938: p_relationship_tbl(l_count).subject_id <> fnd_api.g_miss_num
4939: THEN
4940: IF csi_item_instance_pvt.check_item_instance_lock
4941: ( p_instance_id => p_relationship_tbl(l_count).subject_id)
4942: THEN
4943: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
4944: THEN

Line 5399: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

5395: l_object_id NUMBER;
5396: l_obv_number NUMBER;
5397: l_ins_usage_code VARCHAR2(30);
5398: l_instance_id_lst csi_datastructures_pub.id_tbl;
5399: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
5400: l_location_tbl csi_item_instance_pvt.location_tbl;
5401: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
5402: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
5403: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

Line 5400: l_location_tbl csi_item_instance_pvt.location_tbl;

5396: l_obv_number NUMBER;
5397: l_ins_usage_code VARCHAR2(30);
5398: l_instance_id_lst csi_datastructures_pub.id_tbl;
5399: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
5400: l_location_tbl csi_item_instance_pvt.location_tbl;
5401: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
5402: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
5403: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
5404: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 5401: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

5397: l_ins_usage_code VARCHAR2(30);
5398: l_instance_id_lst csi_datastructures_pub.id_tbl;
5399: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
5400: l_location_tbl csi_item_instance_pvt.location_tbl;
5401: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
5402: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
5403: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
5404: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
5405: l_obj_id NUMBER;

Line 5402: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

5398: l_instance_id_lst csi_datastructures_pub.id_tbl;
5399: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
5400: l_location_tbl csi_item_instance_pvt.location_tbl;
5401: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
5402: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
5403: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
5404: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
5405: l_obj_id NUMBER;
5406: l_sub_id NUMBER;

Line 5403: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

5399: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
5400: l_location_tbl csi_item_instance_pvt.location_tbl;
5401: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
5402: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
5403: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
5404: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
5405: l_obj_id NUMBER;
5406: l_sub_id NUMBER;
5407: l_msg_data VARCHAR2(2000);

Line 5518: IF csi_item_instance_pvt.check_item_instance_lock

5514: --Added for MACD lock functionality
5515: IF p_relationship_tbl(l_count).object_id IS NOT NULL AND
5516: p_relationship_tbl(l_count).object_id <> fnd_api.g_miss_num
5517: THEN
5518: IF csi_item_instance_pvt.check_item_instance_lock
5519: ( p_instance_id => p_relationship_tbl(l_count).object_id)
5520: THEN
5521: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
5522: THEN

Line 5533: IF csi_item_instance_pvt.check_item_instance_lock

5529: END IF;
5530: IF p_relationship_tbl(l_count).subject_id IS NOT NULL AND
5531: p_relationship_tbl(l_count).subject_id <> fnd_api.g_miss_num
5532: THEN
5533: IF csi_item_instance_pvt.check_item_instance_lock
5534: ( p_instance_id => p_relationship_tbl(l_count).subject_id)
5535: THEN
5536: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
5537: THEN

Line 5551: IF csi_item_instance_pvt.check_item_instance_lock

5547: SELECT subject_id
5548: INTO l_subject_lock
5549: FROM csi_ii_relationships
5550: WHERE relationship_id=p_relationship_tbl(l_count).relationship_id;
5551: IF csi_item_instance_pvt.check_item_instance_lock
5552: ( p_instance_id => l_subject_lock)
5553: THEN
5554: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
5555: THEN

Line 6008: csi_item_instance_pvt.update_item_instance

6004: nvl(p_replace_flag,fnd_api.g_false)<> fnd_api.g_true
6005: THEN
6006: csi_gen_utility_pvt.put_line('Calling update_item_instance..');
6007: csi_gen_utility_pvt.put_line('Parameter p_called_from_rel set to true..');
6008: csi_item_instance_pvt.update_item_instance
6009: (p_api_version => p_api_version
6010: ,p_commit => p_commit
6011: ,p_init_msg_list => p_init_msg_list
6012: ,p_validation_level => p_validation_level

Line 6277: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

6273: l_obv_number NUMBER;
6274: l_ins_usage_code VARCHAR2(30);
6275: l_instance_status_id NUMBER;
6276: l_instance_id_lst csi_datastructures_pub.id_tbl;
6277: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6278: l_location_tbl csi_item_instance_pvt.location_tbl;
6279: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
6280: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6281: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

Line 6278: l_location_tbl csi_item_instance_pvt.location_tbl;

6274: l_ins_usage_code VARCHAR2(30);
6275: l_instance_status_id NUMBER;
6276: l_instance_id_lst csi_datastructures_pub.id_tbl;
6277: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6278: l_location_tbl csi_item_instance_pvt.location_tbl;
6279: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
6280: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6281: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
6282: l_found BOOLEAN;

Line 6279: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

6275: l_instance_status_id NUMBER;
6276: l_instance_id_lst csi_datastructures_pub.id_tbl;
6277: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6278: l_location_tbl csi_item_instance_pvt.location_tbl;
6279: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
6280: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6281: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
6282: l_found BOOLEAN;
6283: l_item_id NUMBER;

Line 6280: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

6276: l_instance_id_lst csi_datastructures_pub.id_tbl;
6277: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6278: l_location_tbl csi_item_instance_pvt.location_tbl;
6279: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
6280: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6281: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
6282: l_found BOOLEAN;
6283: l_item_id NUMBER;
6284: l_vld_org NUMBER;

Line 6281: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

6277: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6278: l_location_tbl csi_item_instance_pvt.location_tbl;
6279: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
6280: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6281: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
6282: l_found BOOLEAN;
6283: l_item_id NUMBER;
6284: l_vld_org NUMBER;
6285: l_srl_ctl NUMBER;

Line 6456: --IF csi_item_instance_pvt.check_item_instance_lock( p_instance_id => l_relship_csr.object_id)

6452: l_is_locked := TRUE;
6453: END;
6454:
6455: --Changed the IF condition for Bug 12357214
6456: --IF csi_item_instance_pvt.check_item_instance_lock( p_instance_id => l_relship_csr.object_id)
6457: IF (l_is_locked)
6458: THEN
6459: --Added the below if condition for bug 5217556--
6460: IF p_txn_rec.transaction_type_id NOT IN (53,54)

Line 6491: --IF csi_item_instance_pvt.check_item_instance_lock( p_instance_id => l_relship_csr.subject_id)

6487: WHEN TOO_MANY_ROWS THEN
6488: l_is_locked := TRUE;
6489: END;
6490: --Changed the IF condition for Bug 12357214
6491: --IF csi_item_instance_pvt.check_item_instance_lock( p_instance_id => l_relship_csr.subject_id)
6492: IF (l_is_locked)
6493: THEN
6494: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
6495: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_relship_csr.subject_id);

Line 6582: csi_item_instance_pvt.update_item_instance

6578: l_instance_rec.object_version_number IS NOT NULL AND
6579: l_found
6580: THEN
6581: csi_gen_utility_pvt.put_line('Calling Update II from Exp Rel...');
6582: csi_item_instance_pvt.update_item_instance
6583: ( p_api_version => p_api_version
6584: ,p_commit => p_commit
6585: ,p_init_msg_list => p_init_msg_list
6586: ,p_validation_level => p_validation_level