[Home] [Help]
579: l_exists VARCHAR2(1);
580:
581: CURSOR pc_status_check_up_csr(p_unit_item_id IN NUMBER,p_association_type IN VARCHAR2) IS
582: SELECT a.primary_flag,a.status
583: FROM ahl_pc_headers_b a, ahl_pc_nodes_b b, ahl_pc_associations c
584: WHERE a.pc_header_id = b.pc_header_id AND b.pc_node_id = c.pc_node_id AND
585: a.primary_flag = G_PC_PRIMARY_FLAG AND
586: a.status = G_COMPLETE_STATUS AND
587: c.association_type_flag = p_association_type AND
588: c.unit_item_id = p_unit_item_id;
589:
590: CURSOR pc_status_check_n_csr(p_pc_node_id IN NUMBER) IS
591: SELECT a.primary_flag,a.status
592: FROM ahl_pc_headers_b a, ahl_pc_nodes_b b
593: WHERE a.pc_header_id = b.pc_header_id
594: AND b.pc_node_id = p_pc_node_id;
595:
596: l_pc_primary_flag ahl_pc_headers_b.primary_flag%TYPE;
1970: c_type IN VARCHAR2,
1971: c_primary_flag IN VARCHAR2,
1972: c_complete_status IN VARCHAR2 ) IS
1973: SELECT a.pc_node_id
1974: FROM ahl_pc_associations a, ahl_pc_nodes_b b, ahl_pc_headers_b c
1975: WHERE a.unit_item_id = c_unit_config_header_id
1976: AND a.association_type_flag = c_type
1977: AND a.pc_node_id = b.pc_node_id
1978: AND b.pc_header_id = c.pc_header_id
1988: CURSOR ahl_check_pc_id_csr(p_pc_node_id IN NUMBER,
1989: c_primary_flag IN VARCHAR2,
1990: c_complete_status IN VARCHAR2 ) IS
1991: SELECT 'x'
1992: FROM ahl_pc_nodes_b a, ahl_pc_headers_b b
1993: WHERE a.pc_node_id = p_pc_node_id
1994: AND a.pc_header_id = b.pc_header_id
1995: AND b.primary_flag = c_primary_flag
1996: AND b.status = c_complete_status;
1996: AND b.status = c_complete_status;
1997: --
1998: CURSOR ahl_trav_pc_nodes_csr (c_pc_id IN NUMBER) IS
1999: SELECT pc_node_id
2000: FROM ahl_pc_nodes_b
2001: START WITH pc_node_id = c_pc_id
2002: CONNECT BY pc_node_id = PRIOR parent_node_id;
2003: --
2004: CURSOR ahl_uf_uom_nodes_csr (c_pc_id IN NUMBER) IS