APPS.AHL_PC_ASSOCIATION_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 77

        SELECT AHL_PC_ASSOCIATIONS_S.NEXTVAL INTO l_assos_id FROM DUAL;

Line: 79

        INSERT INTO AHL_PC_ASSOCIATIONS (
            PC_ASSOCIATION_ID,
            PC_NODE_ID,
            UNIT_ITEM_ID,
            INVENTORY_ORG_ID,
            ASSOCIATION_TYPE_FLAG,
            LINK_TO_ASSOCIATION_ID,
            DRAFT_FLAG,
            Last_update_date,
            Last_updated_by,
            Creation_date,
            Created_by,
            Last_update_login,
            SECURITY_GROUP_ID,
            OBJECT_VERSION_NUMBER,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15
        )
        VALUES
        (
            l_assos_id,
            p_x_assos_rec.PC_NODE_ID,
            p_x_assos_rec.UNIT_ITEM_ID,
            0,
            G_UNIT,
            nvl(l_link_id,0),
            'N',
            l_sysdate,
            g_user_id,
            l_sysdate,
            g_user_id,
            g_user_id,
            null,
            1,
            p_x_assos_rec.ATTRIBUTE_CATEGORY,
            p_x_assos_rec.ATTRIBUTE1,
            p_x_assos_rec.ATTRIBUTE2,
            p_x_assos_rec.ATTRIBUTE3,
            p_x_assos_rec.ATTRIBUTE4,
            p_x_assos_rec.ATTRIBUTE5,
            p_x_assos_rec.ATTRIBUTE6,
            p_x_assos_rec.ATTRIBUTE7,
            p_x_assos_rec.ATTRIBUTE8,
            p_x_assos_rec.ATTRIBUTE9,
            p_x_assos_rec.ATTRIBUTE10,
            p_x_assos_rec.ATTRIBUTE11,
            p_x_assos_rec.ATTRIBUTE12,
            p_x_assos_rec.ATTRIBUTE13,
            p_x_assos_rec.ATTRIBUTE14,
            p_x_assos_rec.ATTRIBUTE15
        );

Line: 151

        UPDATE ahl_pc_nodes_b
        SET child_count = NVL(child_count, 0) + 1
        WHERE pc_node_id = p_x_assos_rec.pc_node_id;

Line: 228

            SELECT HEAD.PRIMARY_FLAG
            FROM AHL_PC_HEADERS_B HEAD, AHL_PC_NODES_B NODE
            WHERE NODE.PC_HEADER_ID = HEAD.PC_HEADER_ID AND
                  NODE.PC_NODE_ID = p_pc_node_id;

Line: 292

            DELETE FROM AHL_PC_ASSOCIATIONS
            WHERE PC_ASSOCIATION_ID = p_x_assos_rec.PC_ASSOCIATION_ID;

Line: 299

            UPDATE ahl_pc_nodes_b
            SET child_count = NVL(child_count, 1) - 1
            WHERE pc_node_id = p_x_assos_rec.pc_node_id;

Line: 418

        SELECT AHL_PC_ASSOCIATIONS_S.NEXTVAL INTO l_assos_id FROM DUAL;

Line: 420

        INSERT INTO AHL_PC_ASSOCIATIONS (
            PC_ASSOCIATION_ID,
            PC_NODE_ID,
            UNIT_ITEM_ID,
            INVENTORY_ORG_ID,
            ASSOCIATION_TYPE_FLAG,
            LINK_TO_ASSOCIATION_ID,
            DRAFT_FLAG,
            Last_update_date,
            Last_updated_by,
            Creation_date,
            Created_by,
            Last_update_login,
            SECURITY_GROUP_ID,
            OBJECT_VERSION_NUMBER,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15
        )
        VALUES
        (
            l_assos_id,
            p_x_assos_rec.PC_NODE_ID,
            p_x_assos_rec.UNIT_ITEM_ID,
            p_x_assos_rec.INVENTORY_ORG_ID,
            G_PART,
            nvl(l_link_id,0),
            'N',
            l_sysdate,
            g_user_id,
            l_sysdate,
            g_user_id,
            g_user_id,
            null,
            1,
            p_x_assos_rec.ATTRIBUTE_CATEGORY,
            p_x_assos_rec.ATTRIBUTE1,
            p_x_assos_rec.ATTRIBUTE2,
            p_x_assos_rec.ATTRIBUTE3,
            p_x_assos_rec.ATTRIBUTE4,
            p_x_assos_rec.ATTRIBUTE5,
            p_x_assos_rec.ATTRIBUTE6,
            p_x_assos_rec.ATTRIBUTE7,
            p_x_assos_rec.ATTRIBUTE8,
            p_x_assos_rec.ATTRIBUTE9,
            p_x_assos_rec.ATTRIBUTE10,
            p_x_assos_rec.ATTRIBUTE11,
            p_x_assos_rec.ATTRIBUTE12,
            p_x_assos_rec.ATTRIBUTE13,
            p_x_assos_rec.ATTRIBUTE14,
            p_x_assos_rec.ATTRIBUTE15
        );

Line: 492

        UPDATE ahl_pc_nodes_b
        SET child_count = NVL(child_count, 0) + 1
        WHERE pc_node_id = p_x_assos_rec.pc_node_id;

Line: 569

            SELECT HEAD.PRIMARY_FLAG
            FROM AHL_PC_HEADERS_B HEAD, AHL_PC_NODES_B NODE
            WHERE NODE.PC_HEADER_ID = HEAD.PC_HEADER_ID AND
                  NODE.PC_NODE_ID = p_pc_node_id;

Line: 638

            DELETE FROM AHL_PC_ASSOCIATIONS
            WHERE PC_ASSOCIATION_ID = p_x_assos_rec.PC_ASSOCIATION_ID;

Line: 645

            UPDATE ahl_pc_nodes_b
            SET child_count = NVL(child_count, 1) - 1
            WHERE pc_node_id = p_x_assos_rec.pc_node_id;

Line: 726

        SELECT 'X'
        FROM ahl_pc_nodes_b
        WHERE pc_node_id = p_pc_node_id;

Line: 732

        select header.status
        from ahl_pc_headers_b header, ahl_pc_nodes_b node
        where header.pc_header_id = node.pc_header_id and
              node.pc_node_id = p_pc_node_id;

Line: 739

        select 'X'
        from ahl_pc_headers_b header, ahl_pc_nodes_b node
        where header.pc_header_id = node.pc_header_id and
              nvl(node.link_to_node_id,node.pc_node_id) = p_pc_node_id and
              header.status in ('DRAFT', 'APPROVAL_REJECTED');

Line: 920

        select head.status
        from ahl_pc_headers_b head, ahl_pc_nodes_b node
        where head.pc_header_id = node.pc_header_id and
              node.pc_node_id = p_pc_node_id;

Line: 936

            update ahl_pc_headers_b
            set status = 'DRAFT'
            where pc_header_id = (
                select pc_header_id
                from ahl_pc_nodes_b
                where pc_node_id = p_pc_node_id );

Line: 968

        select object_version_number
        from ahl_pc_associations
        where pc_association_id = p_pc_assos_id;

Line: 974

        select 'X'
        from ahl_pc_associations
        where pc_association_id = p_pc_assos_id;

Line: 980

        select head.primary_flag
        from ahl_pc_headers_b head, ahl_pc_nodes_b node
        where node.pc_node_id = p_pc_node_id and
              node.pc_header_id = head.pc_header_id;

Line: 987

        select 'X'
        from ahl_pc_associations ahass, ahl_pc_nodes_b node, ahl_pc_headers_b header
        where ahass.unit_item_id = p_unit_item_id and
              ahass.pc_node_id = node.pc_node_id and
              node.pc_header_id = header.pc_header_id and
              header.pc_header_id = (
            select pc_header_id
            from ahl_pc_nodes_b
            where pc_node_id = p_pc_node_id );

Line: 999

        select 'X'
        from ahl_pc_associations ahass, ahl_pc_nodes_b node
        where ahass.unit_item_id = p_unit_item_id and
              ahass.pc_node_id = node.pc_node_id and
              node.pc_node_id = p_pc_node_id;

Line: 1007

        select 'X'
        from ahl_unit_config_headers
        where unit_config_header_id = p_unit_item_id;

Line: 1013

        select 'X'
        from mtl_system_items_b
        where inventory_item_id = p_unit_item_id;

Line: 1023

        select header.status
        from ahl_pc_headers_b header, ahl_pc_nodes_b node
        where header.pc_header_id = node.pc_header_id and
              node.pc_node_id = p_pc_node_id;

Line: 1030

        select 'X'
        from ahl_pc_nodes_b
        where parent_node_id = p_pc_node_id;

Line: 1036

        select 'X'
        from ahl_unit_config_headers
        where unit_config_header_id = p_unit_item_id and
              trunc(sysdate) between nvl(trunc(active_start_date), trunc(sysdate)) and nvl(trunc(active_end_date), trunc(sysdate)) and
              unit_config_status_code in ('COMPLETE', 'INCOMPLETE');

Line: 1044

        select 'X'
        from mtl_system_items_b
        where inventory_item_id = p_unit_item_id and
              trunc(sysdate) between nvl(trunc(start_date_active), trunc(sysdate)) and nvl(trunc(end_date_active), trunc(sysdate)) and
              inventory_item_status_code not in ('Obsolete','Inactive');

Line: 1053

        select 'X'
        from ahl_unit_config_headers
        where unit_config_header_id = p_unit_item_id and
              unit_config_status_code in ('QUARANTINE', 'DEACTIVATE_QUARANTINE');

Line: 1199

        IF (p_x_assos_rec.operation_flag <> G_DML_DELETE)
        THEN
            OPEN check_child_node_exists (p_x_assos_rec.pc_node_id);