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.AHL_PRD_PARTS_CHANGE_PVT dependencies on CSI_II_RELATIONSHIPS

Line 2248: csi_ii_relationships_pub.create_relationship(

2244: END IF;
2245: END IF;
2246:
2247: IF( l_serialized = FND_API.G_TRUE OR p_x_parts_rec.Removed_Instance_Id IS NULL)THEN
2248: csi_ii_relationships_pub.create_relationship(
2249: p_api_version => 1.0
2250: ,p_relationship_tbl => l_csi_relationship_tbl
2251: ,p_txn_rec => p_x_csi_transaction_rec
2252: ,x_return_status => x_return_status

Line 2368: csi_ii_relationships_pub.expire_relationship(

2364: END IF;
2365:
2366: IF( l_serialized = FND_API.G_TRUE OR p_x_parts_rec.Removed_Quantity = l_curr_config_qty)THEN
2367:
2368: csi_ii_relationships_pub.expire_relationship(
2369: p_api_version => 1.0
2370: ,p_relationship_rec => l_csi_relationship_rec
2371: ,p_txn_rec => p_x_csi_transaction_rec
2372: ,x_instance_id_lst=> l_instance_id_lst-- csi_datastructures_pub.id_tbl,

Line 2423: csi_ii_relationships_pub.expire_relationship(

2419: AHL_DEBUG_PUB.debug('l_final_removed_inst_id ' || l_final_removed_inst_id);
2420: END IF;
2421: ELSE -- non-serialized incomplete removal
2422:
2423: csi_ii_relationships_pub.expire_relationship(
2424: p_api_version => 1.0
2425: ,p_relationship_rec => l_csi_relationship_rec
2426: ,p_txn_rec => p_x_csi_transaction_rec
2427: ,x_instance_id_lst=> l_instance_id_lst-- csi_datastructures_pub.id_tbl,

Line 2489: csi_ii_relationships_pub.create_relationship(

2485: l_csi_relationship_rec.object_version_number := NULL;
2486:
2487: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
2488:
2489: csi_ii_relationships_pub.create_relationship(
2490: p_api_version => 1.0
2491: ,p_relationship_tbl => l_csi_relationship_tbl
2492: ,p_txn_rec => p_x_csi_transaction_rec
2493: ,x_return_status => x_return_status

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

2494: ,x_msg_count => l_msg_count
2495: ,x_msg_data => l_msg_data);
2496:
2497: IF G_DEBUG = 'Y' THEN
2498: AHL_DEBUG_PUB.debug('After making a call to csi_ii_relationships_pub.create_relationship.');
2499: END IF;
2500:
2501: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2502: RAISE FND_API.G_EXC_ERROR;

Line 2569: csi_ii_relationships_pub.update_relationship(

2565: end if;
2566: IF G_DEBUG = 'Y' THEN
2567: AHL_DEBUG_PUB.debug('IB Processing- Swap');
2568: END IF;
2569: csi_ii_relationships_pub.update_relationship(
2570: p_api_version => 1.0
2571: ,p_relationship_tbl => l_csi_relationship_tbl
2572:
2573: ,p_txn_rec => p_x_csi_transaction_rec

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

3580: from csi_item_instances CII
3581: where CII.instance_id = p_instance_id
3582: AND CII.ACTIVE_START_DATE <= SYSDATE
3583: AND ((CII.ACTIVE_END_DATE IS NULL) OR (CII.ACTIVE_END_DATE > SYSDATE))
3584: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR
3585: WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID
3586: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
3587: AND ((CIR.ACTIVE_START_DATE IS NULL) OR (CIR.ACTIVE_START_DATE <= SYSDATE))
3588: AND ((CIR.ACTIVE_END_DATE IS NULL) OR (CIR.ACTIVE_END_DATE > SYSDATE)));

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

3592: from csi_item_instances CII
3593: where CII.instance_number = p_instance_number
3594: AND CII.ACTIVE_START_DATE <= SYSDATE
3595: AND ((CII.ACTIVE_END_DATE IS NULL) OR (CII.ACTIVE_END_DATE > SYSDATE))
3596: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR
3597: WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID
3598: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
3599: AND ((CIR.ACTIVE_START_DATE IS NULL) OR (CIR.ACTIVE_START_DATE <= SYSDATE))
3600: AND ((CIR.ACTIVE_END_DATE IS NULL) OR (CIR.ACTIVE_END_DATE > SYSDATE)));

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

3930: AND CI1.INSTANCE_USAGE_CODE = 'IN_WIP'
3931: AND CI1.unit_of_measure = CI2.unit_of_measure
3932: AND CI1.ACTIVE_START_DATE <= SYSDATE
3933: AND (CI1.ACTIVE_END_DATE IS NULL OR CI1.ACTIVE_END_DATE < SYSDATE)
3934: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR
3935: WHERE CIR.SUBJECT_ID = CI1.INSTANCE_ID
3936: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
3937: AND ((CIR.ACTIVE_START_DATE IS NULL) OR (CIR.ACTIVE_START_DATE <= SYSDATE))
3938: AND ((CIR.ACTIVE_END_DATE IS NULL) OR (CIR.ACTIVE_END_DATE > SYSDATE)) );

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

4088: --AND LOCATION_ID= p_location_id
4089: AND unit_of_measure = p_unit_of_measure
4090: AND ACTIVE_START_DATE <= SYSDATE
4091: AND ((ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE > SYSDATE))
4092: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR
4093: WHERE CIR.SUBJECT_ID = CII.INSTANCE_ID
4094: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
4095: AND ((CIR.ACTIVE_START_DATE IS NULL) OR (CIR.ACTIVE_START_DATE <= SYSDATE))
4096: AND ((CIR.ACTIVE_END_DATE IS NULL) OR (CIR.ACTIVE_END_DATE > SYSDATE)) );

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

4115: --AND CI1.quantity = 0
4116: AND CI1.unit_of_measure = CI2.unit_of_measure
4117: AND CI1.ACTIVE_START_DATE <= SYSDATE
4118: AND CI1.ACTIVE_END_DATE IS NOT NULL AND CI1.ACTIVE_END_DATE < SYSDATE
4119: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR
4120: WHERE CIR.SUBJECT_ID = CI1.INSTANCE_ID
4121: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
4122: AND ((CIR.ACTIVE_START_DATE IS NULL) OR (CIR.ACTIVE_START_DATE <= SYSDATE))
4123: AND ((CIR.ACTIVE_END_DATE IS NULL) OR (CIR.ACTIVE_END_DATE > SYSDATE)) );

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

4482: --AND CI1.quantity = 0
4483: AND CI1.unit_of_measure = CI2.unit_of_measure
4484: AND CI1.ACTIVE_START_DATE <= SYSDATE
4485: AND CI1.ACTIVE_END_DATE IS NOT NULL AND CI1.ACTIVE_END_DATE < SYSDATE
4486: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR
4487: WHERE CIR.SUBJECT_ID = CI1.INSTANCE_ID
4488: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
4489: AND ((CIR.ACTIVE_START_DATE IS NULL) OR (CIR.ACTIVE_START_DATE <= SYSDATE))
4490: AND ((CIR.ACTIVE_END_DATE IS NULL) OR (CIR.ACTIVE_END_DATE > SYSDATE)) );

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

4505: --AND CI1.quantity = 0
4506: AND CI1.unit_of_measure = CI2.unit_of_measure
4507: AND CI1.ACTIVE_START_DATE <= SYSDATE
4508: AND CI1.ACTIVE_END_DATE IS NOT NULL AND CI1.ACTIVE_END_DATE < SYSDATE
4509: AND NOT EXISTS (SELECT 'x' FROM CSI_II_RELATIONSHIPS CIR
4510: WHERE CIR.SUBJECT_ID = CI1.INSTANCE_ID
4511: AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
4512: AND ((CIR.ACTIVE_START_DATE IS NULL) OR (CIR.ACTIVE_START_DATE <= SYSDATE))
4513: AND ((CIR.ACTIVE_END_DATE IS NULL) OR (CIR.ACTIVE_END_DATE > SYSDATE)) );