APPS.AHL_PC_HEADER_PUB SQL Statements

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

Line: 26

                        SELECT LOOKUP_CODE , MEANING
                        FROM  FND_LOOKUP_VALUES_VL
                        WHERE LOOKUP_TYPE = p_lookup_type
                        AND MEANING LIKE NVL(p_lookup_meaning,'%')
                        AND LOOKUP_CODE LIKE NVL(p_lookup_code,'%');

Line: 60

                IF (p_x_pc_header_rec.OPERATION_FLAG <> AHL_PC_HEADER_PVT.G_DML_DELETE)
                THEN
                        p_x_pc_header_rec.NAME := TRIM(p_x_pc_header_rec.NAME);

Line: 121

                select lookup_code, meaning
                from fnd_lookup_values_vl
                where lookup_type = 'ITEM_TYPE' and
                      upper(meaning) = upper(p_pc_item_type_desc) and
                      view_application_id = 3 and
                      enabled_flag = 'Y' and
                      sysdate between nvl(start_date_active, sysdate) and nvl(end_date_active, sysdate);

Line: 131

                select lookup_code, meaning
                from fnd_lookup_values_vl
                where lookup_type = 'ITEM_TYPE' and
                      upper(meaning) = upper(p_pc_item_type_desc) and
                      lookup_code = p_pc_item_type_code and
                      view_application_id = 3 and
                      enabled_flag = 'Y' and
                      sysdate between nvl(start_date_active, sysdate) and nvl(end_date_active, sysdate);

Line: 245

                   ( p_x_pc_header_rec.operation_flag <> AHL_PC_HEADER_PVT.G_DML_DELETE )
                THEN
                        CONVERT_ITEM_TYPE_DESC_TO_CODE (p_x_pc_header_rec);

Line: 286

                ELSIF (p_x_pc_header_rec.operation_flag = AHL_PC_HEADER_PVT.G_DML_UPDATE)
                THEN
                        IF G_DEBUG='Y' THEN
                                AHL_DEBUG_PUB.debug('PCH -- PUB -- Calling UPDATE_PC_HEADER for ID='||p_x_pc_header_rec.PC_HEADER_ID);

Line: 292

                        AHL_PC_HEADER_PVT.UPDATE_PC_HEADER
                        (
                                p_api_version           => 1.0,
                                p_init_msg_list         => FND_API.G_FALSE,
                                p_commit                => FND_API.G_FALSE,
                                p_validation_level      => p_validation_level,
                                p_x_pc_header_rec       => p_x_pc_header_rec,
                                x_return_status         => x_return_status,
                                x_msg_count             => x_msg_count,
                                x_msg_data              => x_msg_data,
                                x_warning_msg_data      => x_warning_msg_data
                        );

Line: 321

                ELSIF (p_x_pc_header_rec.operation_flag = AHL_PC_HEADER_PVT.G_DML_DELETE)
                THEN
                        IF G_DEBUG='Y' THEN
                                AHL_DEBUG_PUB.debug('PCH -- PUB -- Calling DELETE_PC_HEADER for ID='||p_x_pc_header_rec.PC_HEADER_ID);

Line: 327

                        AHL_PC_HEADER_PVT.DELETE_PC_HEADER
                        (
                                p_api_version           => 1.0,
                                p_init_msg_list         => FND_API.G_FALSE,
                                p_commit                => FND_API.G_FALSE,
                                p_validation_level      => p_validation_level,
                                p_x_pc_header_rec       => p_x_pc_header_rec,
                                x_return_status         => x_return_status,
                                x_msg_count             => x_msg_count,
                                x_msg_data              => x_msg_data
                        );