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 4276: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

4272: l_dummy NUMBER;
4273: l_object_version NUMBER;
4274: l_object_version1 NUMBER;
4275: l_subject_id NUMBER;
4276: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
4277: l_location_tbl csi_item_instance_pvt.location_tbl;
4278: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
4279: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
4280: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

Line 4277: l_location_tbl csi_item_instance_pvt.location_tbl;

4273: l_object_version NUMBER;
4274: l_object_version1 NUMBER;
4275: l_subject_id NUMBER;
4276: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
4277: l_location_tbl csi_item_instance_pvt.location_tbl;
4278: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
4279: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
4280: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
4281: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 4278: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

4274: l_object_version1 NUMBER;
4275: l_subject_id NUMBER;
4276: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
4277: l_location_tbl csi_item_instance_pvt.location_tbl;
4278: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
4279: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
4280: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
4281: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
4282: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;

Line 4279: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

4275: l_subject_id NUMBER;
4276: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
4277: l_location_tbl csi_item_instance_pvt.location_tbl;
4278: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
4279: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
4280: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
4281: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
4282: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
4283: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;

Line 4280: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

4276: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
4277: l_location_tbl csi_item_instance_pvt.location_tbl;
4278: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
4279: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
4280: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
4281: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
4282: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
4283: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
4284: -- Begin Add Code for Siebel Genesis Project

Line 4390: /*csi_item_instance_pvt.update_item_instance

4386: ,x_return_status => x_return_status
4387: ,x_msg_count => x_msg_count
4388: ,x_msg_data => x_msg_data
4389: );
4390: /*csi_item_instance_pvt.update_item_instance
4391: ( p_api_version => p_api_version
4392: ,p_commit => p_commit
4393: ,p_init_msg_list => p_init_msg_list
4394: ,p_validation_level => p_validation_level

Line 4481: csi_item_instance_pvt.update_item_instance

4477: l_instance_rec1.object_version_number:=l_object_version;
4478: l_instance_rec1.instance_id:=l_rel_tbl(j).object_id;
4479: l_instance_rec1.completeness_flag:='Y';
4480:
4481: csi_item_instance_pvt.update_item_instance
4482: ( p_api_version => p_api_version
4483: ,p_commit => p_commit
4484: ,p_init_msg_list => p_init_msg_list
4485: ,p_validation_level => p_validation_level

Line 4757: IF csi_item_instance_pvt.check_item_instance_lock

4753: --Added for MACD lock functionality
4754: IF p_relationship_tbl(l_count).object_id IS NOT NULL AND
4755: p_relationship_tbl(l_count).object_id <> fnd_api.g_miss_num
4756: THEN
4757: IF csi_item_instance_pvt.check_item_instance_lock
4758: ( p_instance_id => p_relationship_tbl(l_count).object_id)
4759: THEN
4760: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
4761: THEN

Line 4772: IF csi_item_instance_pvt.check_item_instance_lock

4768: END IF;
4769: IF p_relationship_tbl(l_count).subject_id IS NOT NULL AND
4770: p_relationship_tbl(l_count).subject_id <> fnd_api.g_miss_num
4771: THEN
4772: IF csi_item_instance_pvt.check_item_instance_lock
4773: ( p_instance_id => p_relationship_tbl(l_count).subject_id)
4774: THEN
4775: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
4776: THEN

Line 5227: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

5223: l_object_id NUMBER;
5224: l_obv_number NUMBER;
5225: l_ins_usage_code VARCHAR2(30);
5226: l_instance_id_lst csi_datastructures_pub.id_tbl;
5227: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
5228: l_location_tbl csi_item_instance_pvt.location_tbl;
5229: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
5230: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
5231: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

Line 5228: l_location_tbl csi_item_instance_pvt.location_tbl;

5224: l_obv_number NUMBER;
5225: l_ins_usage_code VARCHAR2(30);
5226: l_instance_id_lst csi_datastructures_pub.id_tbl;
5227: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
5228: l_location_tbl csi_item_instance_pvt.location_tbl;
5229: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
5230: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
5231: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
5232: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 5229: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

5225: l_ins_usage_code VARCHAR2(30);
5226: l_instance_id_lst csi_datastructures_pub.id_tbl;
5227: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
5228: l_location_tbl csi_item_instance_pvt.location_tbl;
5229: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
5230: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
5231: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
5232: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
5233: l_obj_id NUMBER;

Line 5230: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

5226: l_instance_id_lst csi_datastructures_pub.id_tbl;
5227: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
5228: l_location_tbl csi_item_instance_pvt.location_tbl;
5229: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
5230: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
5231: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
5232: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
5233: l_obj_id NUMBER;
5234: l_sub_id NUMBER;

Line 5231: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

5227: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
5228: l_location_tbl csi_item_instance_pvt.location_tbl;
5229: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
5230: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
5231: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
5232: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
5233: l_obj_id NUMBER;
5234: l_sub_id NUMBER;
5235: l_msg_data VARCHAR2(2000);

Line 5341: IF csi_item_instance_pvt.check_item_instance_lock

5337: --Added for MACD lock functionality
5338: IF p_relationship_tbl(l_count).object_id IS NOT NULL AND
5339: p_relationship_tbl(l_count).object_id <> fnd_api.g_miss_num
5340: THEN
5341: IF csi_item_instance_pvt.check_item_instance_lock
5342: ( p_instance_id => p_relationship_tbl(l_count).object_id)
5343: THEN
5344: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
5345: THEN

Line 5356: IF csi_item_instance_pvt.check_item_instance_lock

5352: END IF;
5353: IF p_relationship_tbl(l_count).subject_id IS NOT NULL AND
5354: p_relationship_tbl(l_count).subject_id <> fnd_api.g_miss_num
5355: THEN
5356: IF csi_item_instance_pvt.check_item_instance_lock
5357: ( p_instance_id => p_relationship_tbl(l_count).subject_id)
5358: THEN
5359: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
5360: THEN

Line 5374: IF csi_item_instance_pvt.check_item_instance_lock

5370: SELECT subject_id
5371: INTO l_subject_lock
5372: FROM csi_ii_relationships
5373: WHERE relationship_id=p_relationship_tbl(l_count).relationship_id;
5374: IF csi_item_instance_pvt.check_item_instance_lock
5375: ( p_instance_id => l_subject_lock)
5376: THEN
5377: IF p_txn_rec.transaction_type_id NOT IN (51,53,54,401)
5378: THEN

Line 5807: csi_item_instance_pvt.update_item_instance

5803: nvl(p_replace_flag,fnd_api.g_false)<> fnd_api.g_true
5804: THEN
5805: csi_gen_utility_pvt.put_line('Calling update_item_instance..');
5806: csi_gen_utility_pvt.put_line('Parameter p_called_from_rel set to true..');
5807: csi_item_instance_pvt.update_item_instance
5808: (p_api_version => p_api_version
5809: ,p_commit => p_commit
5810: ,p_init_msg_list => p_init_msg_list
5811: ,p_validation_level => p_validation_level

Line 6071: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

6067: l_object_id NUMBER;
6068: l_obv_number NUMBER;
6069: l_ins_usage_code VARCHAR2(30);
6070: l_instance_id_lst csi_datastructures_pub.id_tbl;
6071: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6072: l_location_tbl csi_item_instance_pvt.location_tbl;
6073: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
6074: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6075: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

Line 6072: l_location_tbl csi_item_instance_pvt.location_tbl;

6068: l_obv_number NUMBER;
6069: l_ins_usage_code VARCHAR2(30);
6070: l_instance_id_lst csi_datastructures_pub.id_tbl;
6071: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6072: l_location_tbl csi_item_instance_pvt.location_tbl;
6073: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
6074: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6075: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
6076: l_found BOOLEAN;

Line 6073: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;

6069: l_ins_usage_code VARCHAR2(30);
6070: l_instance_id_lst csi_datastructures_pub.id_tbl;
6071: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6072: l_location_tbl csi_item_instance_pvt.location_tbl;
6073: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
6074: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6075: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
6076: l_found BOOLEAN;
6077: l_item_id NUMBER;

Line 6074: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

6070: l_instance_id_lst csi_datastructures_pub.id_tbl;
6071: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6072: l_location_tbl csi_item_instance_pvt.location_tbl;
6073: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
6074: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6075: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
6076: l_found BOOLEAN;
6077: l_item_id NUMBER;
6078: l_vld_org NUMBER;

Line 6075: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;

6071: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
6072: l_location_tbl csi_item_instance_pvt.location_tbl;
6073: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
6074: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
6075: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
6076: l_found BOOLEAN;
6077: l_item_id NUMBER;
6078: l_vld_org NUMBER;
6079: l_srl_ctl NUMBER;

Line 6225: IF csi_item_instance_pvt.check_item_instance_lock

6221: --Added for MACD lock functionality
6222: IF l_relship_csr.object_id IS NOT NULL AND
6223: l_relship_csr.object_id <> fnd_api.g_miss_num
6224: THEN
6225: IF csi_item_instance_pvt.check_item_instance_lock
6226: ( p_instance_id => l_relship_csr.object_id)
6227: THEN
6228: --Added the below if condition for bug 5217556--
6229: IF p_txn_rec.transaction_type_id NOT IN (53,54)

Line 6242: IF csi_item_instance_pvt.check_item_instance_lock

6238:
6239: IF l_relship_csr.subject_id IS NOT NULL AND
6240: l_relship_csr.subject_id <> fnd_api.g_miss_num
6241: THEN
6242: IF csi_item_instance_pvt.check_item_instance_lock
6243: ( p_instance_id => l_relship_csr.subject_id)
6244: THEN
6245: FND_MESSAGE.SET_NAME('CSI','CSI_LOCKED_INSTANCE');
6246: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_relship_csr.subject_id);

Line 6325: csi_item_instance_pvt.update_item_instance

6321: l_instance_rec.object_version_number IS NOT NULL AND
6322: l_found
6323: THEN
6324: csi_gen_utility_pvt.put_line('Calling Update II from Exp Rel...');
6325: csi_item_instance_pvt.update_item_instance
6326: ( p_api_version => p_api_version
6327: ,p_commit => p_commit
6328: ,p_init_msg_list => p_init_msg_list
6329: ,p_validation_level => p_validation_level