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 896: CURSOR csi_ii_relationships_csr(p_csi_item_instance_id IN NUMBER,

892: p_mc_relationship_id IN NUMBER,
893: x_subject_id OUT NOCOPY NUMBER,
894: x_return_val OUT NOCOPY BOOLEAN) IS
895:
896: CURSOR csi_ii_relationships_csr(p_csi_item_instance_id IN NUMBER,
897: p_mc_relationship_id IN NUMBER) IS
898: SELECT subject_id
899: FROM csi_ii_relationships
900: WHERE position_reference = to_char(p_mc_relationship_id)

Line 899: FROM csi_ii_relationships

895:
896: CURSOR csi_ii_relationships_csr(p_csi_item_instance_id IN NUMBER,
897: p_mc_relationship_id IN NUMBER) IS
898: SELECT subject_id
899: FROM csi_ii_relationships
900: WHERE position_reference = to_char(p_mc_relationship_id)
901: START WITH object_id = p_csi_item_instance_id
902: AND relationship_type_code = 'COMPONENT-OF'
903: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 914: OPEN csi_ii_relationships_csr (p_csi_item_instance_id,

910: l_return_val BOOLEAN DEFAULT TRUE;
911:
912: BEGIN
913:
914: OPEN csi_ii_relationships_csr (p_csi_item_instance_id,
915: p_mc_relationship_id);
916: FETCH csi_ii_relationships_csr INTO l_subject_id;
917: IF (csi_ii_relationships_csr%NOTFOUND) THEN
918: l_return_val := FALSE;

Line 916: FETCH csi_ii_relationships_csr INTO l_subject_id;

912: BEGIN
913:
914: OPEN csi_ii_relationships_csr (p_csi_item_instance_id,
915: p_mc_relationship_id);
916: FETCH csi_ii_relationships_csr INTO l_subject_id;
917: IF (csi_ii_relationships_csr%NOTFOUND) THEN
918: l_return_val := FALSE;
919: l_subject_id := null;
920: END IF;

Line 917: IF (csi_ii_relationships_csr%NOTFOUND) THEN

913:
914: OPEN csi_ii_relationships_csr (p_csi_item_instance_id,
915: p_mc_relationship_id);
916: FETCH csi_ii_relationships_csr INTO l_subject_id;
917: IF (csi_ii_relationships_csr%NOTFOUND) THEN
918: l_return_val := FALSE;
919: l_subject_id := null;
920: END IF;
921:

Line 985: FROM csi_ii_relationships

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

Line 1332: FROM csi_ii_relationships reln, csi_item_instances csi

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

Line 1361: FROM csi_ii_relationships

1357: SELECT uc.unit_config_header_id, uc.unit_config_status_code
1358: FROM ahl_unit_config_headers uc
1359: WHERE csi_item_instance_id in
1360: ( SELECT object_id
1361: FROM csi_ii_relationships
1362: START WITH subject_id = p_csi_item_instance_id
1363: AND relationship_type_code = 'COMPONENT-OF'
1364: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
1365: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

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

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

Line 1442: update_csi_ii_relationships(x_return_status =>x_return_status,

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

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

1457: l_instance_tbl(i).inventory_item_id,
1458: l_instance_tbl(i).inventory_org_id)
1459: LOOP
1460:
1461: --update the csi_ii_relationships table and make it an extra node
1462:
1463: update_csi_ii_relationships(x_return_status =>x_return_status,
1464: x_msg_count => x_msg_count,
1465: x_msg_data => x_msg_data,

Line 1463: update_csi_ii_relationships(x_return_status =>x_return_status,

1459: LOOP
1460:
1461: --update the csi_ii_relationships table and make it an extra node
1462:
1463: update_csi_ii_relationships(x_return_status =>x_return_status,
1464: x_msg_count => x_msg_count,
1465: x_msg_data => x_msg_data,
1466: p_subject_id=>item_instance_rec.csi_item_instance_id);
1467: IF x_msg_count > 0 THEN

Line 1550: PROCEDURE update_csi_ii_relationships(

1546: END Invalidate_Instance;
1547:
1548:
1549:
1550: PROCEDURE update_csi_ii_relationships(
1551: x_return_status OUT NOCOPY VARCHAR2,
1552: x_msg_count OUT NOCOPY NUMBER,
1553: x_msg_data OUT NOCOPY VARCHAR2,
1554: p_subject_id IN NUMBER

Line 1560: FROM csi_ii_relationships

1556: IS
1557: --
1558: CURSOR get_csi_record_csr(c_subject_id NUMBER) IS
1559: SELECT relationship_id, object_id, object_version_number
1560: FROM csi_ii_relationships
1561: WHERE subject_id = c_subject_id
1562: AND relationship_type_code = 'COMPONENT-OF'
1563: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
1564: AND trunc(sysdate) > trunc(nvl(active_start_date, sysdate-1));

Line 1601: --Updating the csi_ii_relationships table

1597: l_csi_relationship_rec.relationship_type_code := 'COMPONENT-OF';
1598: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
1599: CLOSE get_csi_record_csr;
1600:
1601: --Updating the csi_ii_relationships table
1602: CSI_II_Relationships_PUB.Update_Relationship(
1603: p_api_version => 1.0,
1604: p_init_msg_list => FND_API.G_TRUE,
1605: p_commit => FND_API.G_FALSE,

Line 1602: CSI_II_Relationships_PUB.Update_Relationship(

1598: l_csi_relationship_tbl(1) := l_csi_relationship_rec;
1599: CLOSE get_csi_record_csr;
1600:
1601: --Updating the csi_ii_relationships table
1602: CSI_II_Relationships_PUB.Update_Relationship(
1603: p_api_version => 1.0,
1604: p_init_msg_list => FND_API.G_TRUE,
1605: p_commit => FND_API.G_FALSE,
1606: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1613: END update_csi_ii_relationships;

1609: x_return_status => x_return_status,
1610: x_msg_count => x_msg_count,
1611: x_msg_data => x_msg_data );
1612:
1613: END update_csi_ii_relationships;
1614:
1615: ----------------------------
1616:
1617:

Line 2130: FROM csi_ii_relationships

2126: IS
2127: l_dummy_num NUMBER;
2128: CURSOR check_extra IS
2129: SELECT subject_id
2130: FROM csi_ii_relationships
2131: WHERE position_reference IS NULL
2132: START WITH subject_id = p_instance_id
2133: AND subject_id <> p_top_instance_id
2134: --And this one more condition just in order to avoid p_instance_id = p_top_instance_id

Line 2265: FROM csi_ii_relationships

2261: l_uc_header_id NUMBER;
2262: l_instance_id NUMBER;
2263: CURSOR get_parent_uc IS
2264: SELECT object_id
2265: FROM csi_ii_relationships
2266: WHERE object_id IN (SELECT csi_item_instance_id
2267: FROM ahl_unit_config_headers
2268: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2269: START WITH subject_id = p_instance_id

Line 2324: FROM csi_ii_relationships

2320: --
2321: CURSOR get_relationship_id (csi_id IN NUMBER)
2322: IS
2323: SELECT TO_NUMBER(position_reference)
2324: FROM csi_ii_relationships
2325: WHERE SUBJECT_ID = csi_id
2326: AND relationship_type_code = 'COMPONENT-OF'
2327: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
2328: --

Line 2355: FROM csi_ii_relationships

2351: l_unit_name VARCHAR2(80);
2352: l_instance_id NUMBER;
2353: CURSOR get_uc_instance_id IS
2354: SELECT object_id
2355: FROM csi_ii_relationships
2356: WHERE object_id IN (SELECT csi_item_instance_id
2357: FROM ahl_unit_config_headers
2358: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2359: START WITH subject_id = p_instance_id

Line 2401: FROM csi_ii_relationships

2397: l_uc_header_id VARCHAR2(80);
2398: l_instance_id NUMBER;
2399: CURSOR get_uc_instance_id IS
2400: SELECT object_id
2401: FROM csi_ii_relationships
2402: WHERE object_id IN (SELECT csi_item_instance_id
2403: FROM ahl_unit_config_headers
2404: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2405: START WITH subject_id = p_instance_id

Line 2447: FROM csi_ii_relationships

2443: l_unit_name VARCHAR2(80);
2444: l_instance_id NUMBER;
2445: CURSOR get_uc_instance_id IS
2446: SELECT object_id
2447: FROM csi_ii_relationships
2448: WHERE object_id IN (SELECT csi_item_instance_id
2449: FROM ahl_unit_config_headers
2450: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2451: START WITH subject_id = p_instance_id

Line 2496: FROM csi_ii_relationships

2492: l_uc_header_id NUMBER;
2493: l_instance_id NUMBER;
2494: CURSOR get_uc_instance_id IS
2495: SELECT object_id
2496: FROM csi_ii_relationships
2497: WHERE object_id IN (SELECT csi_item_instance_id
2498: FROM ahl_unit_config_headers
2499: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2500: START WITH subject_id = p_instance_id

Line 2646: FROM CSI_II_RELATIONSHIPS RELN, CSI_ITEM_INSTANCES CSI

2642: CURSOR c_get_item_instances_csr(c_position_reference VARCHAR2,
2643: c_inventory_item_id NUMBER,
2644: c_inventory_org_id NUMBER) IS
2645: SELECT CSI.instance_id
2646: FROM CSI_II_RELATIONSHIPS RELN, CSI_ITEM_INSTANCES CSI
2647: WHERE RELN.subject_id = CSI.instance_id AND
2648: RELN.relationship_type_code = 'COMPONENT-OF' AND
2649: RELN.position_reference = c_position_reference AND
2650: CSI.inventory_item_id = c_inventory_item_id AND

Line 2681: FROM CSI_II_RELATIONSHIPS

2677: UC.unit_config_header_id
2678: FROM AHL_UNIT_CONFIG_HEADERS UC, CSI_ITEM_INSTANCES CSI
2679: WHERE UC.csi_item_instance_id IN
2680: (SELECT object_id
2681: FROM CSI_II_RELATIONSHIPS
2682: START WITH
2683: subject_id = p_csi_item_instance_id AND
2684: relationship_type_code = 'COMPONENT-OF' AND
2685: TRUNC(NVL(active_start_date,SYSDATE)) <= TRUNC(SYSDATE) AND

Line 2898: FROM csi_ii_relationships

2894: AND reln.parent_relationship_id is null;
2895:
2896: CURSOR get_pos_reference_csr IS
2897: SELECT position_reference
2898: FROM csi_ii_relationships
2899: WHERE subject_id = p_instance_id
2900: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
2901: AND NVL(ACTIVE_START_DATE, sysdate - 1) <= sysdate
2902: AND NVL(ACTIVE_END_DATE, sysdate + 1) > sysdate;

Line 2923: l_pos_reference csi_ii_relationships.position_reference%TYPE;

2919: l_uc_header_id NUMBER;
2920: l_master_config_id NUMBER;
2921: l_node_ig_id NUMBER;
2922: l_mc_root_rel_id NUMBER;
2923: l_pos_reference csi_ii_relationships.position_reference%TYPE;
2924: l_temp_num NUMBER;
2925:
2926: BEGIN
2927: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN