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_BLK_PARTS_CHANGE_PVT dependencies on AHL_UC_DETAILS_FOR_HGRID

Line 100: SELECT COUNT(1) from AHL_UC_DETAILS_FOR_HGRID;

96: l_full_name CONSTANT VARCHAR2(80) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
97: l_api_version CONSTANT NUMBER := 1.0;
98:
99: CURSOR get_record_count IS
100: SELECT COUNT(1) from AHL_UC_DETAILS_FOR_HGRID;
101:
102: CURSOR is_unit_present(c_unit_header_id IN NUMBER) IS
103: SELECT COUNT(UHC.UNIT_NODE_ID)
104: FROM AHL_UC_DETAILS_FOR_HGRID UHC,

Line 104: FROM AHL_UC_DETAILS_FOR_HGRID UHC,

100: SELECT COUNT(1) from AHL_UC_DETAILS_FOR_HGRID;
101:
102: CURSOR is_unit_present(c_unit_header_id IN NUMBER) IS
103: SELECT COUNT(UHC.UNIT_NODE_ID)
104: FROM AHL_UC_DETAILS_FOR_HGRID UHC,
105: AHL_UNIT_CONFIG_HEADERS UC
106: WHERE UC.unit_config_header_id = c_unit_header_id
107: AND UHC.root_instance_id = UC.csi_item_instance_id;
108:

Line 161: INSERT INTO AHL_UC_DETAILS_FOR_HGRID

157:
158: IF x_uc_details_tbl.FIRST IS NOT NULL THEN
159: FOR i IN x_uc_details_tbl.FIRST..x_uc_details_tbl.LAST LOOP
160:
161: INSERT INTO AHL_UC_DETAILS_FOR_HGRID
162: (
163: unit_node_id,
164: root_instance_id,
165: path_position_id,

Line 450: SELECT (NVL(MAX(unit_node_id),0) + 1) from AHL_UC_DETAILS_FOR_HGRID;

446: AND CSI.inv_master_organization_id = MTL.organization_id
447: AND CSI.unit_of_measure = UOM.uom_code;
448:
449: CURSOR get_max_pk_count IS
450: SELECT (NVL(MAX(unit_node_id),0) + 1) from AHL_UC_DETAILS_FOR_HGRID;
451:
452: CURSOR get_Disposition_Details(c_instance_id NUMBER, c_path_position_id NUMBER) IS
453: SELECT disp.disposition_id ,
454: disp.object_version_number ,

Line 1554: FROM AHL_UC_DETAILS_FOR_HGRID

1550: parent_instance_id,
1551: qty_per_position,
1552: unit_of_measure,
1553: install_quantity
1554: FROM AHL_UC_DETAILS_FOR_HGRID
1555: WHERE root_instance_id = p_root_instance_id
1556: AND is_controlled_position = 'Y';
1557:
1558: -- Cursor to get unit of measure for the given Control position

Line 1569: FROM AHL_UC_DETAILS_FOR_HGRID

1565:
1566: -- Cursor to calculate Install qty for the given Control position
1567: CURSOR calc_inst_qty_for_cntrl_pos (c_relationship_id NUMBER, c_instance_id NUMBER, c_parent_instance_id NUMBER) IS
1568: SELECT NVL(SUM(curr_quantity), 0)
1569: FROM AHL_UC_DETAILS_FOR_HGRID
1570: WHERE root_instance_id = p_root_instance_id
1571: AND parent_rel_id = c_relationship_id
1572: AND NVL(parent_instance_id, -10) = NVL(c_instance_id, NVL(c_parent_instance_id, -10));
1573:

Line 1588: FROM AHL_UC_DETAILS_FOR_HGRID

1584: path_position_id,
1585: curr_instance_id,
1586: operation_sequence_num,
1587: install_date
1588: FROM AHL_UC_DETAILS_FOR_HGRID
1589: WHERE root_instance_id = p_root_instance_id
1590: AND parent_rel_id = c_relationship_id
1591: AND NVL(parent_instance_id, -10) = NVL(c_instance_id, NVL(c_parent_instance_id, -10));
1592:

Line 1657: UPDATE AHL_UC_DETAILS_FOR_HGRID

1653: ' Install Qty = ' || control_pos_rec.install_quantity);
1654: END IF;
1655:
1656: -- update install quantity for control position in HGrid
1657: UPDATE AHL_UC_DETAILS_FOR_HGRID
1658: SET install_quantity = control_pos_rec.install_quantity,
1659: curr_quantity = control_pos_rec.install_quantity,
1660: unit_of_measure = control_pos_rec.unit_of_measure
1661: WHERE unit_node_id = control_pos_rec.unit_node_id;

Line 1714: UPDATE AHL_UC_DETAILS_FOR_HGRID

1710: END IF;
1711:
1712:
1713: -- update quantities for control position's child in HGrid
1714: UPDATE AHL_UC_DETAILS_FOR_HGRID
1715: SET install_quantity = child_pos_rec.install_quantity,
1716: qty_per_position = child_pos_rec.qty_per_position,
1717: select_disable_flag = child_pos_rec.select_disable_flag,
1718: operation_sequence_num = child_pos_rec.operation_sequence_num,

Line 1762: FROM AHL_UC_DETAILS_FOR_HGRID

1758:
1759: -- Cursor to determine whether the given position is a child of control position
1760: CURSOR is_child_control_pos_csr IS
1761: SELECT 'Y', path_position_id
1762: FROM AHL_UC_DETAILS_FOR_HGRID
1763: WHERE root_instance_id = p_x_uc_details_rec.root_instance_id
1764: AND relationship_id = p_x_uc_details_rec.parent_rel_id
1765: AND NVL(curr_instance_id, NVL(parent_instance_id, -10)) = NVL(p_x_uc_details_rec.parent_instance_id, -10)
1766: AND is_controlled_position = 'Y';

Line 1801: FROM AHL_UC_DETAILS_FOR_HGRID

1797:
1798: -- Cursor to find install quantity of parent control position
1799: CURSOR get_cntl_pos_install_qty_csr IS
1800: SELECT NVL(SUM(curr_quantity), 0)
1801: FROM AHL_UC_DETAILS_FOR_HGRID
1802: WHERE root_instance_id = p_x_uc_details_rec.root_instance_id
1803: AND parent_rel_id = p_x_uc_details_rec.parent_rel_id
1804: AND NVL(parent_instance_id, -10) = NVL(p_x_uc_details_rec.parent_instance_id, -10);
1805:

Line 1971: FROM AHL_UC_DETAILS_FOR_HGRID UHC,

1967: l_hGrid_node_path VARCHAR2(240);
1968:
1969: CURSOR get_count(c_unit_header_id IN NUMBER) IS
1970: SELECT COUNT(UHC.unit_node_id)
1971: FROM AHL_UC_DETAILS_FOR_HGRID UHC,
1972: AHL_UNIT_CONFIG_HEADERS UC
1973: WHERE UC.unit_config_header_id = c_unit_header_id
1974: AND UHC.root_instance_id = UC.csi_item_instance_id;
1975:

Line 1978: FROM AHL_UC_DETAILS_FOR_HGRID

1974: AND UHC.root_instance_id = UC.csi_item_instance_id;
1975:
1976: CURSOR get_node_path(c_unit_node_id IN NUMBER) IS
1977: SELECT hgrid_node_path
1978: FROM AHL_UC_DETAILS_FOR_HGRID
1979: WHERE unit_node_id = c_unit_node_id;
1980:
1981: BEGIN
1982:

Line 1984: l_sql_cri_str := ' SELECT unit_node_id FROM AHL_UC_DETAILS_FOR_HGRID WHERE 1 = 1 ';

1980:
1981: BEGIN
1982:
1983: IF p_filter_records_tbl.FIRST IS NOT NULL THEN
1984: l_sql_cri_str := ' SELECT unit_node_id FROM AHL_UC_DETAILS_FOR_HGRID WHERE 1 = 1 ';
1985: l_bind_index := 1;
1986: l_unit_header_id := -1;
1987: l_hGrid_node_path := null;
1988:

Line 2060: UPDATE AHL_UC_DETAILS_FOR_HGRID

2056: ' Filtered count:' || l_uc_node_id_tbl.count);
2057: END IF;
2058:
2059: --clear previous searchs if any
2060: UPDATE AHL_UC_DETAILS_FOR_HGRID
2061: SET search_flag = 'N'
2062: WHERE search_flag = 'Y';
2063:
2064: -- set search flag 'Y' for the position

Line 2077: UPDATE AHL_UC_DETAILS_FOR_HGRID

2073: FETCH get_node_path INTO l_hGrid_node_path;
2074: CLOSE get_node_path;
2075: END IF;
2076: -- only root node will have search flag as 'Y'
2077: UPDATE AHL_UC_DETAILS_FOR_HGRID
2078: SET search_flag = 'Y'
2079: WHERE curr_instance_id = (SELECT csi_item_instance_id FROM AHL_UNIT_CONFIG_HEADERS WHERE unit_config_header_id = l_unit_header_id);
2080: ELSE
2081: IF l_uc_node_id_tbl.FIRST IS NOT NULL THEN

Line 2084: UPDATE AHL_UC_DETAILS_FOR_HGRID

2080: ELSE
2081: IF l_uc_node_id_tbl.FIRST IS NOT NULL THEN
2082: FOR j IN l_uc_node_id_tbl.FIRST..l_uc_node_id_tbl.LAST LOOP
2083: l_current_unit_node_id := l_uc_node_id_tbl(j);
2084: UPDATE AHL_UC_DETAILS_FOR_HGRID
2085: SET search_flag = 'Y'
2086: WHERE unit_node_id = l_current_unit_node_id;
2087: END LOOP;
2088: END IF;