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.

[Home] [Help]

APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on CSI_II_RELATIONSHIPS

Line 2301: csi_ii_relationships_pub.create_relationship(

2297: END IF;
2298: END IF;
2299:
2300: IF( l_serialized = FND_API.G_TRUE OR p_x_parts_rec.Removed_Instance_Id IS NULL)THEN
2301: csi_ii_relationships_pub.create_relationship(
2302: p_api_version => 1.0
2303: ,p_relationship_tbl => l_csi_relationship_tbl
2304: ,p_txn_rec => p_x_csi_transaction_rec
2305: ,x_return_status => x_return_status

Line 2425: csi_ii_relationships_pub.expire_relationship(

2421: END IF;
2422:
2423: IF( l_serialized = FND_API.G_TRUE OR p_x_parts_rec.Removed_Quantity = l_curr_config_qty)THEN
2424:
2425: csi_ii_relationships_pub.expire_relationship(
2426: p_api_version => 1.0
2427: ,p_relationship_rec => l_csi_relationship_rec
2428: ,p_txn_rec => p_x_csi_transaction_rec
2429: ,x_instance_id_lst=> l_instance_id_lst-- csi_datastructures_pub.id_tbl,

Line 2480: csi_ii_relationships_pub.expire_relationship(

2476: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);
2477: END IF;
2478: ELSE -- non-serialized incomplete removal
2479:
2480: csi_ii_relationships_pub.expire_relationship(
2481: p_api_version => 1.0
2482: ,p_relationship_rec => l_csi_relationship_rec
2483: ,p_txn_rec => p_x_csi_transaction_rec
2484: ,x_instance_id_lst=> l_instance_id_lst-- csi_datastructures_pub.id_tbl,

Line 2546: csi_ii_relationships_pub.create_relationship(

2542: l_csi_relationship_rec.object_version_number := NULL;
2543:
2544: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
2545:
2546: csi_ii_relationships_pub.create_relationship(
2547: p_api_version => 1.0
2548: ,p_relationship_tbl => l_csi_relationship_tbl
2549: ,p_txn_rec => p_x_csi_transaction_rec
2550: ,x_return_status => x_return_status

Line 2555: AHL_DEBUG_PUB.debug('After making a call to csi_ii_relationships_pub.create_relationship.');

2551: ,x_msg_count => l_msg_count
2552: ,x_msg_data => l_msg_data);
2553:
2554: IF G_DEBUG = 'Y' THEN
2555: AHL_DEBUG_PUB.debug('After making a call to csi_ii_relationships_pub.create_relationship.');
2556: END IF;
2557:
2558: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2559: RAISE FND_API.G_EXC_ERROR;

Line 2626: csi_ii_relationships_pub.update_relationship(

2622: end if;
2623: IF G_DEBUG = 'Y' THEN
2624: AHL_DEBUG_PUB.debug('IB Processing- Swap');
2625: END IF;
2626: csi_ii_relationships_pub.update_relationship(
2627: p_api_version => 1.0
2628: ,p_relationship_tbl => l_csi_relationship_tbl
2629:
2630: ,p_txn_rec => p_x_csi_transaction_rec

Line 3641: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR

3637: from csi_item_instances CII
3638: where CII.instance_id = p_instance_id
3639: AND CII.ACTIVE_START_DATE <= SYSDATE
3640: AND ((CII.ACTIVE_END_DATE IS NULL) OR (CII.ACTIVE_END_DATE > SYSDATE))
3641: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR
3642: WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID
3643: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
3644: AND ((CIR.ACTIVE_START_DATE IS NULL) OR (CIR.ACTIVE_START_DATE <= SYSDATE))
3645: AND ((CIR.ACTIVE_END_DATE IS NULL) OR (CIR.ACTIVE_END_DATE > SYSDATE)));

Line 3653: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR

3649: from csi_item_instances CII
3650: where CII.instance_number = p_instance_number
3651: AND CII.ACTIVE_START_DATE <= SYSDATE
3652: AND ((CII.ACTIVE_END_DATE IS NULL) OR (CII.ACTIVE_END_DATE > SYSDATE))
3653: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR
3654: WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID
3655: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
3656: AND ((CIR.ACTIVE_START_DATE IS NULL) OR (CIR.ACTIVE_START_DATE <= SYSDATE))
3657: AND ((CIR.ACTIVE_END_DATE IS NULL) OR (CIR.ACTIVE_END_DATE > SYSDATE)));

Line 3991: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR

3987: AND CI1.INSTANCE_USAGE_CODE = 'IN_WIP'
3988: AND CI1.unit_of_measure = CI2.unit_of_measure
3989: AND CI1.ACTIVE_START_DATE <= SYSDATE
3990: AND (CI1.ACTIVE_END_DATE IS NULL OR CI1.ACTIVE_END_DATE < SYSDATE)
3991: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR
3992: WHERE CIR.SUBJECT_ID = CI1.INSTANCE_ID
3993: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
3994: AND ((CIR.ACTIVE_START_DATE IS NULL) OR (CIR.ACTIVE_START_DATE <= SYSDATE))
3995: AND ((CIR.ACTIVE_END_DATE IS NULL) OR (CIR.ACTIVE_END_DATE > SYSDATE)) );

Line 4149: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR

4145: --AND LOCATION_ID= p_location_id
4146: AND unit_of_measure = p_unit_of_measure
4147: AND ACTIVE_START_DATE <= SYSDATE
4148: AND ((ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE > SYSDATE))
4149: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR
4150: WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID
4151: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
4152: AND ((CIR.ACTIVE_START_DATE IS NULL) OR (CIR.ACTIVE_START_DATE <= SYSDATE))
4153: AND ((CIR.ACTIVE_END_DATE IS NULL) OR (CIR.ACTIVE_END_DATE > SYSDATE)) );

Line 4176: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR

4172: --AND CI1.quantity = 0
4173: AND CI1.unit_of_measure = CI2.unit_of_measure
4174: AND CI1.ACTIVE_START_DATE <= SYSDATE
4175: AND CI1.ACTIVE_END_DATE IS NOT NULL AND CI1.ACTIVE_END_DATE < SYSDATE
4176: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR
4177: WHERE CIR.SUBJECT_ID = CI1.INSTANCE_ID
4178: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
4179: AND ((CIR.ACTIVE_START_DATE IS NULL) OR (CIR.ACTIVE_START_DATE <= SYSDATE))
4180: AND ((CIR.ACTIVE_END_DATE IS NULL) OR (CIR.ACTIVE_END_DATE > SYSDATE)) );

Line 4543: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR

4539: --AND CI1.quantity = 0
4540: AND CI1.unit_of_measure = CI2.unit_of_measure
4541: AND CI1.ACTIVE_START_DATE <= SYSDATE
4542: AND CI1.ACTIVE_END_DATE IS NOT NULL AND CI1.ACTIVE_END_DATE < SYSDATE
4543: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR
4544: WHERE CIR.SUBJECT_ID = CI1.INSTANCE_ID
4545: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
4546: AND ((CIR.ACTIVE_START_DATE IS NULL) OR (CIR.ACTIVE_START_DATE <= SYSDATE))
4547: AND ((CIR.ACTIVE_END_DATE IS NULL) OR (CIR.ACTIVE_END_DATE > SYSDATE)) );

Line 4566: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR

4562: --AND CI1.quantity = 0
4563: AND CI1.unit_of_measure = CI2.unit_of_measure
4564: AND CI1.ACTIVE_START_DATE <= SYSDATE
4565: AND CI1.ACTIVE_END_DATE IS NOT NULL AND CI1.ACTIVE_END_DATE < SYSDATE
4566: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR
4567: WHERE CIR.SUBJECT_ID = CI1.INSTANCE_ID
4568: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
4569: AND ((CIR.ACTIVE_START_DATE IS NULL) OR (CIR.ACTIVE_START_DATE <= SYSDATE))
4570: AND ((CIR.ACTIVE_END_DATE IS NULL) OR (CIR.ACTIVE_END_DATE > SYSDATE)) );