APPS.AHL_ENIGMA_IPC_PROCS_PVT SQL Statements

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

Line: 81

    SELECT AHL_ENIGMA_PROCESS_LOG_S.NEXTVAL INTO l_log_id FROM DUAL;

Line: 89

    INSERT INTO AHL_ENIGMA_PROCESS_LOG (
        log_id,
        last_update_date,
        last_updated_by,
        creation_date,
        created_by,
        last_update_login,
        process_date_time,
        report_type,
        report_file_name,
        object_name,
        operation_flag,
        process_status,
        process_error
    ) VALUES (
        l_log_id,
        SYSDATE,
        TO_NUMBER(FND_GLOBAL.USER_ID),
        SYSDATE,
        TO_NUMBER(FND_GLOBAL.USER_ID),
        TO_NUMBER(FND_GLOBAL.LOGIN_ID),
        SYSDATE,
        p_report_type,
        p_report_file_name,
        p_object_name,
        p_operation_flag,
        p_process_status,
        l_msg_data
    );

Line: 149

    SELECT item_group_id
    FROM   ahl_item_groups_b
    WHERE  name                               =  NVL(p_ig_name, '-')
    AND    status_code                        <> 'REMOVED'
    AND    NVL(sourced_from_enigma_flag, 'N') =  'Y';

Line: 156

    SELECT 'X'
    FROM   fnd_lookups
    WHERE  lookup_code                              = NVL(p_ig_type_code, 'X')
    AND    lookup_type                              = 'AHL_ITEMGROUP_TYPE'
    AND    TRUNC(NVL(end_date_active, SYSDATE - 1)) < TRUNC(SYSDATE);

Line: 163

    SELECT inventory_item_id
    FROM   mtl_system_items_kfv
    WHERE  concatenated_segments = NVL(p_item_number, '-')
    AND    organization_id       = p_org_id;

Line: 169

    SELECT 'X'
    FROM   fnd_lookups
    WHERE  lookup_code                              = NVL(p_interchg_type_code, 'X')
    AND    lookup_type                              = 'AHL_INTERCHANGE_ITEM_TYPE'
    AND    TRUNC(NVL(end_date_active, SYSDATE - 1)) < TRUNC(SYSDATE);

Line: 176

    SELECT item_association_id
    FROM   ahl_item_associations_b
    WHERE  item_group_id      = p_ig_id
    AND    inventory_item_id  = p_item_id
    AND    NVL(revision, '-') = NVL(p_item_revision, '-')
    AND    inventory_org_id   = p_org_id;

Line: 451

        UPDATE ahl_item_groups_b
        SET    sourced_from_enigma_flag = 'Y'
        WHERE  item_group_id            = l_item_group_rec.item_group_id;

Line: 673

    SELECT 'X'
    FROM   fnd_lookups
    WHERE  lookup_code                              = p_model_code
    AND    lookup_type                              = 'AHL_ENIGMA_MODEL_CODE'
    AND    TRUNC(NVL(end_date_active, SYSDATE - 1)) < TRUNC(SYSDATE);

Line: 680

    SELECT meaning
    FROM   fnd_lookups
    WHERE  lookup_code                              = NVL(p_pos_ref_code, '-')
    AND    lookup_type                              = 'AHL_POSITION_REFERENCE'
    AND    TRUNC(NVL(end_date_active, SYSDATE - 1)) < TRUNC(SYSDATE);

Line: 687

    SELECT item_group_id
    FROM   ahl_item_groups_b
    WHERE  name                               =  NVL(p_ig_name, '-')
    AND    status_code                        <> 'REMOVED'
    AND    NVL(sourced_from_enigma_flag, 'N') =  'Y';

Line: 694

    SELECT 'X'
    FROM   fnd_lookups
    WHERE  lookup_code                              = p_ata_code_code
    AND    lookup_type                              = 'AHL_ATA_CODE'
    AND    TRUNC(NVL(end_date_active, SYSDATE - 1)) < TRUNC(SYSDATE);

Line: 953

    UPDATE ahl_mc_headers_b
    SET    sourced_from_enigma_flag = 'Y'
    WHERE  mc_header_id             = l_mc_header_rec.mc_header_id;

Line: 1052

    SELECT ahl.item_composition_id,
           ahl.object_version_number
    FROM   ahl_item_compositions ahl, mtl_system_items_kfv mtl
    WHERE  mtl.concatenated_segments                       = NVL(p_item_name, '-')
    AND    mtl.organization_id                             = p_org_id
    AND    mtl.inventory_item_id                           = ahl.inventory_item_id
    AND    TRUNC(NVL(ahl.effective_end_date, SYSDATE + 1)) > TRUNC(SYSDATE)
    AND    NVL(ahl.sourced_from_enigma_flag, 'N')          = 'Y';

Line: 1062

    SELECT inventory_item_id
    FROM   mtl_system_items_kfv
    WHERE  concatenated_segments = NVL(p_item_number, '-')
    AND    organization_id       = p_org_id;

Line: 1068

    SELECT item_comp_detail_id
    FROM   ahl_item_comp_details
    WHERE  item_composition_id      = p_ic_id
    AND    inventory_item_id        = p_item_id
    AND    inventory_master_org_id  = p_org_id;

Line: 1169

            FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ENIGMA_CL_NO_ITEMS'); -- At least one composition item is required to create or update the Composition List. (new message)

Line: 1193

                           'Calling private API AHL_MC_ITEM_COMP_PVT.Delete_Item_Composition.');

Line: 1197

        AHL_MC_ITEM_COMP_PVT.Delete_Item_Composition(
            p_api_version           => p_api_version,
            p_init_msg_list         => p_init_msg_list,
            x_return_status         => x_return_status,
            x_msg_count             => x_msg_count,
            x_msg_data              => x_msg_data,
            p_item_composition_id   => l_ic_header_rec.item_composition_id,
            p_object_version_number => l_ic_header_rec.object_version_number
        );

Line: 1209

                           'AHL_MC_ITEM_COMP_PVT.Delete_Item_Composition returned x_return_status as ' || x_return_status);

Line: 1336

        UPDATE ahl_item_compositions
        SET    sourced_from_enigma_flag       = 'Y'
        WHERE  item_composition_id            = l_ic_header_rec.item_composition_id;