APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 105: AHL_UNIT_CONFIG_HEADERS UC

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:
109: p_unit_header_id NUMBER;

Line 431: SELECT name,csi_item_instance_id,master_config_id FROM AHL_UNIT_CONFIG_HEADERS

427: l_visit_id NUMBER;
428: l_org_id NUMBER;
429:
430: CURSOR uc_header_information(c_unit_header_id IN NUMBER) IS
431: SELECT name,csi_item_instance_id,master_config_id FROM AHL_UNIT_CONFIG_HEADERS
432: WHERE unit_config_header_id = c_unit_header_id;
433:
434: --Cursor to get basic details
435: CURSOR get_visit_details_csr IS

Line 1771: FROM AHL_UNIT_CONFIG_HEADERS

1767:
1768: -- Cursot to find MC header id for the given root instance id
1769: CURSOR get_mc_header_id_csr IS
1770: SELECT master_config_id
1771: FROM AHL_UNIT_CONFIG_HEADERS
1772: WHERE csi_item_instance_id = p_x_uc_details_rec.root_instance_id;
1773:
1774: -- Cursor to find position quantity of parent control position
1775: CURSOR get_control_pos_qty_csr (c_mc_header_id NUMBER,

Line 1972: AHL_UNIT_CONFIG_HEADERS UC

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:
1976: CURSOR get_node_path(c_unit_node_id IN NUMBER) IS

Line 1998: l_sql_cri_str := l_sql_cri_str || ' AND root_instance_id = (SELECT csi_item_instance_id FROM AHL_UNIT_CONFIG_HEADERS ';

1994: p_filter_records_tbl(i).param || ' '||
1995: p_filter_records_tbl(i).param_value);
1996: END IF;
1997: IF p_filter_records_tbl(i).param = 'UnitHeaderId' THEN
1998: l_sql_cri_str := l_sql_cri_str || ' AND root_instance_id = (SELECT csi_item_instance_id FROM AHL_UNIT_CONFIG_HEADERS ';
1999: l_sql_cri_str := l_sql_cri_str || ' WHERE unit_config_header_id = :UNITHEADERID) ';
2000: l_bindvar_tbl(l_bind_index) := p_filter_records_tbl(i).param_value;
2001: l_bind_index := l_bind_index + 1;
2002: l_unit_header_id := p_filter_records_tbl(i).param_value;

Line 2079: WHERE curr_instance_id = (SELECT csi_item_instance_id FROM AHL_UNIT_CONFIG_HEADERS WHERE unit_config_header_id = l_unit_header_id);

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
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);