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_UTIL_UC_PKG dependencies on CSI_II_RELATIONSHIPS

Line 19: PROCEDURE update_csi_ii_relationships(

15: ----------------------------------------
16: -- Begin Local Procedures Declaration--
17: ----------------------------------------
18:
19: PROCEDURE update_csi_ii_relationships(
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2,
23: p_subject_id IN NUMBER

Line 901: CURSOR csi_ii_relationships_csr(p_csi_item_instance_id IN NUMBER,

897: p_mc_relationship_id IN NUMBER,
898: x_subject_id OUT NOCOPY NUMBER,
899: x_return_val OUT NOCOPY BOOLEAN) IS
900:
901: CURSOR csi_ii_relationships_csr(p_csi_item_instance_id IN NUMBER,
902: p_mc_relationship_id IN NUMBER) IS
903: SELECT subject_id
904: FROM csi_ii_relationships
905: WHERE position_reference = to_char(p_mc_relationship_id)

Line 904: FROM csi_ii_relationships

900:
901: CURSOR csi_ii_relationships_csr(p_csi_item_instance_id IN NUMBER,
902: p_mc_relationship_id IN NUMBER) IS
903: SELECT subject_id
904: FROM csi_ii_relationships
905: WHERE position_reference = to_char(p_mc_relationship_id)
906: START WITH object_id = p_csi_item_instance_id
907: AND relationship_type_code = 'COMPONENT-OF'
908: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 919: OPEN csi_ii_relationships_csr (p_csi_item_instance_id,

915: l_return_val BOOLEAN DEFAULT TRUE;
916:
917: BEGIN
918:
919: OPEN csi_ii_relationships_csr (p_csi_item_instance_id,
920: p_mc_relationship_id);
921: FETCH csi_ii_relationships_csr INTO l_subject_id;
922: IF (csi_ii_relationships_csr%NOTFOUND) THEN
923: l_return_val := FALSE;

Line 921: FETCH csi_ii_relationships_csr INTO l_subject_id;

917: BEGIN
918:
919: OPEN csi_ii_relationships_csr (p_csi_item_instance_id,
920: p_mc_relationship_id);
921: FETCH csi_ii_relationships_csr INTO l_subject_id;
922: IF (csi_ii_relationships_csr%NOTFOUND) THEN
923: l_return_val := FALSE;
924: l_subject_id := null;
925: END IF;

Line 922: IF (csi_ii_relationships_csr%NOTFOUND) THEN

918:
919: OPEN csi_ii_relationships_csr (p_csi_item_instance_id,
920: p_mc_relationship_id);
921: FETCH csi_ii_relationships_csr INTO l_subject_id;
922: IF (csi_ii_relationships_csr%NOTFOUND) THEN
923: l_return_val := FALSE;
924: l_subject_id := null;
925: END IF;
926:

Line 990: FROM csi_ii_relationships

986: -- Cursor to read the parts tree from IB.
987: CURSOR csi_part_tree_csr (p_csi_item_instance_id IN NUMBER) IS
988: SELECT object_id, subject_id, position_reference, level, relationship_id csi_ii_relationship_id,
989: object_version_number csi_ii_object_version_number
990: FROM csi_ii_relationships
991: START WITH object_id = p_csi_item_instance_id
992: AND relationship_type_code = 'COMPONENT-OF'
993: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
994: CONNECT BY PRIOR subject_id = object_id

Line 1337: FROM csi_ii_relationships reln, csi_item_instances csi

1333: CURSOR get_item_instances_csr(c_position_reference IN VARCHAR2,
1334: c_inventory_item_id IN NUMBER,
1335: c_inventory_org_id IN NUMBER) IS
1336: SELECT instance_id csi_item_instance_id, csi.object_version_number
1337: FROM csi_ii_relationships reln, csi_item_instances csi
1338: WHERE reln.subject_id = csi.instance_id
1339: AND TRUNC(SYSDATE) < TRUNC(NVL(reln.active_end_date, SYSDATE+1))
1340: AND trunc(nvl(reln.active_start_date,sysdate-1)) < trunc(sysdate)
1341: AND reln.relationship_type_code = 'COMPONENT-OF'

Line 1366: FROM csi_ii_relationships

1362: SELECT uc.unit_config_header_id, uc.unit_config_status_code
1363: FROM ahl_unit_config_headers uc
1364: WHERE csi_item_instance_id in
1365: ( SELECT object_id
1366: FROM csi_ii_relationships
1367: START WITH subject_id = p_csi_item_instance_id
1368: AND relationship_type_code = 'COMPONENT-OF'
1369: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
1370: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 1446: --update the csi_ii_relationships table and make it an extra node

1442:
1443: --check if the unit is a sub-unit
1444: IF ( l_chk_top_node_csr.parent_uc_header_id is not null ) THEN
1445:
1446: --update the csi_ii_relationships table and make it an extra node
1447: update_csi_ii_relationships(x_return_status =>x_return_status,
1448: x_msg_count => x_msg_count,
1449: x_msg_data => x_msg_data,
1450: p_subject_id=>l_chk_top_node_csr.csi_item_instance_id);

Line 1447: update_csi_ii_relationships(x_return_status =>x_return_status,

1443: --check if the unit is a sub-unit
1444: IF ( l_chk_top_node_csr.parent_uc_header_id is not null ) THEN
1445:
1446: --update the csi_ii_relationships table and make it an extra node
1447: update_csi_ii_relationships(x_return_status =>x_return_status,
1448: x_msg_count => x_msg_count,
1449: x_msg_data => x_msg_data,
1450: p_subject_id=>l_chk_top_node_csr.csi_item_instance_id);
1451: IF x_msg_count > 0 THEN

Line 1466: --update the csi_ii_relationships table and make it an extra node

1462: l_instance_tbl(i).inventory_item_id,
1463: l_instance_tbl(i).inventory_org_id)
1464: LOOP
1465:
1466: --update the csi_ii_relationships table and make it an extra node
1467:
1468: update_csi_ii_relationships(x_return_status =>x_return_status,
1469: x_msg_count => x_msg_count,
1470: x_msg_data => x_msg_data,

Line 1468: update_csi_ii_relationships(x_return_status =>x_return_status,

1464: LOOP
1465:
1466: --update the csi_ii_relationships table and make it an extra node
1467:
1468: update_csi_ii_relationships(x_return_status =>x_return_status,
1469: x_msg_count => x_msg_count,
1470: x_msg_data => x_msg_data,
1471: p_subject_id=>item_instance_rec.csi_item_instance_id);
1472: IF x_msg_count > 0 THEN

Line 1555: PROCEDURE update_csi_ii_relationships(

1551: END Invalidate_Instance;
1552:
1553:
1554:
1555: PROCEDURE update_csi_ii_relationships(
1556: x_return_status OUT NOCOPY VARCHAR2,
1557: x_msg_count OUT NOCOPY NUMBER,
1558: x_msg_data OUT NOCOPY VARCHAR2,
1559: p_subject_id IN NUMBER

Line 1565: FROM csi_ii_relationships

1561: IS
1562: --
1563: CURSOR get_csi_record_csr(c_subject_id NUMBER) IS
1564: SELECT relationship_id, object_id, object_version_number
1565: FROM csi_ii_relationships
1566: WHERE subject_id = c_subject_id
1567: AND relationship_type_code = 'COMPONENT-OF'
1568: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
1569: AND trunc(sysdate) > trunc(nvl(active_start_date, sysdate-1));

Line 1606: --Updating the csi_ii_relationships table

1602: l_csi_relationship_rec.relationship_type_code := 'COMPONENT-OF';
1603: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
1604: CLOSE get_csi_record_csr;
1605:
1606: --Updating the csi_ii_relationships table
1607: CSI_II_Relationships_PUB.Update_Relationship(
1608: p_api_version => 1.0,
1609: p_init_msg_list => FND_API.G_TRUE,
1610: p_commit => FND_API.G_FALSE,

Line 1607: CSI_II_Relationships_PUB.Update_Relationship(

1603: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
1604: CLOSE get_csi_record_csr;
1605:
1606: --Updating the csi_ii_relationships table
1607: CSI_II_Relationships_PUB.Update_Relationship(
1608: p_api_version => 1.0,
1609: p_init_msg_list => FND_API.G_TRUE,
1610: p_commit => FND_API.G_FALSE,
1611: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1618: END update_csi_ii_relationships;

1614: x_return_status => x_return_status,
1615: x_msg_count => x_msg_count,
1616: x_msg_data => x_msg_data );
1617:
1618: END update_csi_ii_relationships;
1619:
1620: ----------------------------
1621:
1622:

Line 2135: FROM csi_ii_relationships

2131: IS
2132: l_dummy_num NUMBER;
2133: CURSOR check_extra IS
2134: SELECT subject_id
2135: FROM csi_ii_relationships
2136: WHERE position_reference IS NULL
2137: START WITH subject_id = p_instance_id
2138: AND subject_id <> p_top_instance_id
2139: --And this one more condition just in order to avoid p_instance_id = p_top_instance_id

Line 2270: FROM csi_ii_relationships

2266: l_uc_header_id NUMBER;
2267: l_instance_id NUMBER;
2268: CURSOR get_parent_uc IS
2269: SELECT object_id
2270: FROM csi_ii_relationships
2271: WHERE object_id IN (SELECT csi_item_instance_id
2272: FROM ahl_unit_config_headers
2273: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2274: START WITH subject_id = p_instance_id

Line 2329: FROM csi_ii_relationships

2325: --
2326: CURSOR get_relationship_id (csi_id IN NUMBER)
2327: IS
2328: SELECT TO_NUMBER(position_reference)
2329: FROM csi_ii_relationships
2330: WHERE SUBJECT_ID = csi_id
2331: AND relationship_type_code = 'COMPONENT-OF'
2332: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
2333: --

Line 2360: FROM csi_ii_relationships

2356: l_unit_name VARCHAR2(80);
2357: l_instance_id NUMBER;
2358: CURSOR get_uc_instance_id IS
2359: SELECT object_id
2360: FROM csi_ii_relationships
2361: WHERE object_id IN (SELECT csi_item_instance_id
2362: FROM ahl_unit_config_headers
2363: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2364: START WITH subject_id = p_instance_id

Line 2406: FROM csi_ii_relationships

2402: l_uc_header_id VARCHAR2(80);
2403: l_instance_id NUMBER;
2404: CURSOR get_uc_instance_id IS
2405: SELECT object_id
2406: FROM csi_ii_relationships
2407: WHERE object_id IN (SELECT csi_item_instance_id
2408: FROM ahl_unit_config_headers
2409: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2410: START WITH subject_id = p_instance_id

Line 2452: FROM csi_ii_relationships

2448: l_unit_name VARCHAR2(80);
2449: l_instance_id NUMBER;
2450: CURSOR get_uc_instance_id IS
2451: SELECT object_id
2452: FROM csi_ii_relationships
2453: WHERE object_id IN (SELECT csi_item_instance_id
2454: FROM ahl_unit_config_headers
2455: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2456: START WITH subject_id = p_instance_id

Line 2501: FROM csi_ii_relationships

2497: l_uc_header_id NUMBER;
2498: l_instance_id NUMBER;
2499: CURSOR get_uc_instance_id IS
2500: SELECT object_id
2501: FROM csi_ii_relationships
2502: WHERE object_id IN (SELECT csi_item_instance_id
2503: FROM ahl_unit_config_headers
2504: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2505: START WITH subject_id = p_instance_id

Line 2651: FROM CSI_II_RELATIONSHIPS RELN, CSI_ITEM_INSTANCES CSI

2647: CURSOR c_get_item_instances_csr(c_position_reference VARCHAR2,
2648: c_inventory_item_id NUMBER,
2649: c_inventory_org_id NUMBER) IS
2650: SELECT CSI.instance_id
2651: FROM CSI_II_RELATIONSHIPS RELN, CSI_ITEM_INSTANCES CSI
2652: WHERE RELN.subject_id = CSI.instance_id AND
2653: RELN.relationship_type_code = 'COMPONENT-OF' AND
2654: RELN.position_reference = c_position_reference AND
2655: CSI.inventory_item_id = c_inventory_item_id AND

Line 2686: FROM CSI_II_RELATIONSHIPS

2682: UC.unit_config_header_id
2683: FROM AHL_UNIT_CONFIG_HEADERS UC, CSI_ITEM_INSTANCES CSI
2684: WHERE UC.csi_item_instance_id IN
2685: (SELECT object_id
2686: FROM CSI_II_RELATIONSHIPS
2687: START WITH
2688: subject_id = p_csi_item_instance_id AND
2689: relationship_type_code = 'COMPONENT-OF' AND
2690: TRUNC(NVL(active_start_date,SYSDATE)) <= TRUNC(SYSDATE) AND

Line 2903: FROM csi_ii_relationships

2899: AND reln.parent_relationship_id is null;
2900:
2901: CURSOR get_pos_reference_csr IS
2902: SELECT position_reference
2903: FROM csi_ii_relationships
2904: WHERE subject_id = p_instance_id
2905: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
2906: AND NVL(ACTIVE_START_DATE, sysdate - 1) <= sysdate
2907: AND NVL(ACTIVE_END_DATE, sysdate + 1) > sysdate;

Line 2928: l_pos_reference csi_ii_relationships.position_reference%TYPE;

2924: l_uc_header_id NUMBER;
2925: l_master_config_id NUMBER;
2926: l_node_ig_id NUMBER;
2927: l_mc_root_rel_id NUMBER;
2928: l_pos_reference csi_ii_relationships.position_reference%TYPE;
2929: l_temp_num NUMBER;
2930:
2931: BEGIN
2932: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN